Well to me anyway.
1. When using the latest version of Crystal Reports, save yourself the 2 hours I wasted today learning not to put multiple datatables in my report data schema. This caused great confusion for the report tool, even though one of the overloads to the SetDataSource() function is with a DataSet parameter [by definition means can have many tables]. My day went better after simply joining the parent and child tables on the SQL Server and letting the report tool clean up the mess of grouping at the proper levels and computing subtotals.
2. When upgrading a website on an IIS Server from the .Net Framework 1.x to 2.x, remember that if the site is only a Virtual Directory, not a full Site, then its Framework version MUST match that of the other Virtual Directories. UNLESS, you go to the trouble of creating Application Pools for the different Virtual's which allows you to upgrade in the chaotic fashion I have unwittingly employed.
3. Remember to check @@ERROR in your stored procedures on SQL Server. This can be helpful for say, when you want to know if you should COMMIT or ROLLBACK a transaction. I am quite embarassed about forgetting this, but luckily in only one small place in my current app.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment