So Dev
Monday, July 24, 2006
Configure a VMWare instance on server from my workstation
We have a VMWare machine running on VMPlayer installed on the server . There are some situations which I need to configure the VMWare instance and yet I don't want to install VMWare Workstation on the production machine. Luckily there's a simple solution: simply point the VMWare Workstation on my workstation to the VMWare instance file on the server, and configure accordingly. The changes will be apply on that instance running on the server.Wednesday, July 12, 2006
Gave up the "Run VMWare instance on our Xeon server" plan
My cancelled my "Run VMWare instance on our Xeon server" plan. ACtually, all went well so far, but the problem was that I had problem accessing our VSS Server, and that defeat my whole purpose of setting the system up.Run VMWare instance on our Xeon server
I installed VMWare on a Xeon server and try to remotely access the VMWAre Windows Server 2003 machine thru Windows Remote Desktop. However, there's a one huge catach that made this set up not workable: I have problem login the Windows Server 2003 since I have problem sending Ctrl-Alt-Ins to the the VMWare machine, and the stupid free VMWare Player does NOT have ahot key to send CTrl-Alt-Del from dropdown.Eventually, I found the solution by reading this and this : On the Windows Remote Desktop, click the VMPlayer the get focus, and then press Ctrl-Alt-End on the host machine.
It worked :> . Not the perfect solution but at least it works.
Friday, July 07, 2006
Create SubReport in Crystal Report
It's been while since I add a subreport in Crystal Report 10, so I better write some quick notes here to remind myself brief how to create a subreport:1. Create Store Proc to fill data into the corresponding table. In our system, a specific stored proc is being called when the report queue tries to generate that report. So I have to update that store proc to populate data into the proper table.
2. Open the Crystal Report document. Select [Insert][Subreport...] to open up a subreport dialog box.
3. Enter the subreport name and click [Next]
4. Select data source. In my case I select Oracle ADO driver.
5. Once you done with selecting driver, you can actually click [Finish] button. But you can also continue using the Wizard to select fields to be put on the screen. I used this feature so that the two field I want to list out was automatically added to the resultant subreport.
6. Once finished you need do one critical part: update the Field Linkage. In my case the input field of the report is the Queue_ID, so I need to join the Queue_ID Of the report and the report_queue_number field on the table.
After all these steps, the sub-report is basically done.
After the report was sub reported was created, I need to fine tune the following items:
- Adjust font size and font type.
- Remove borders on the subreport region. By default it gives me a single line border.
- Need to format the number values. By default the number was displayed as decimal.
