Little Tidbit about SubReport
Seems like I keep forgetting how to add the linkage between main report and subreport, so I better write it down here:
- On the main report, right click on the SubReport rectangle area on the report, and select [Change SubReport Link]
- On the Available Field area, select a field on the main report that yoiu want to link with by clicking right arrow [->].
- At the lower part right, select the field in the subreport that you want to link to the field selected in last step.
- Click OK to commit.
Crazy Strange Problem with scheduler and Crystal Report
For some mysterious reason, the report queue at work stopped working. Turns out that it was because some process stuck opinion. I tried killing the process but it didn't really resolved the problem. It was my another partner who eventually got the problem solved.
And then the problem becomes "The database DLL crdb_oracle.dll could not be loaded" written in the log. Eventually I found the answer: some DLL is missing. I had to run Crystal Report, load that particular report, which trigger Crystal Report UI to ask for loading the Crystal Report installation disk. Loaded, installed, and then finally save the Crystal Report. And after then the report smoothly being generated.
Very puzzled about a Unicode problem on MySQL 5.0.18
I encounted something very strange about MySQL 5.0.18 when dealing with Unicode. I use a Unicode capable client called NaviCat to enter Unicode data into a table. I access the same database using my home computer and my office computer. In fact that whole database (including all bin and everything) are on the exact same removable harddisk. The character of a test table is in "utf8 - UTF-8 UNicode" and Collation is "utf8-general-ci".
Since I access the same database with the same engine on the same harddisk both at my home and in office, I should see the exact same data, right? Well, turns out something wasn't right.
And I kind of suspect that it could have something to do with NaviCat.
Well, let me explain the problem first. In order to test Unicode, I entered Traditioanl Chinese, Japanese and Simplified Chinese character on a testing table I mentioned before. Here's the strange result: I can see all three kinds of character at home for the data I entered at home. I can see all three kinds of character in the office for the data I entered in the office. But I CANNOT see the data I entered at home in the office, and vice verse. Very strange.
I way I see it, since I use everything exactly maybe the OS environment, so maybe there's somethig to do with the OS, but... they are both XP...
Oh well, I have other junk to do. Guess I'll mess with this when I have time later.
command prompt for Shceduled Task
In Windows, to check what scheduled task is running, simply run "schtasks" at command prompt.
