Search results for query: *

Unfortunately, this subreport is actually one of three subreports in the detail of the main report. The task table (tableB) can also have sub-assemblies (sort of like a task within a task), and we also list any materials needed for this task. Rewriting this will be a major undertaking. I was...

I wish I could provide more detail, but this is sensitive data (client is a bank) and I can't post it here. I can elaborate on my description somewhat: TableA is a master plan of work to be done. TableB is the individual tasks within that workplan. TableC is the person or people that will...

I am experiencing some major performance problems on a report I have written in Crystal 10. It will require a little explanation. I have a CR10 report that has a header section based on a MajorKey, a detail section based on a MinorKey within the MajorKey, and a subreport based on a SubKey...

I would appreciate any recommendations on a database comparison tool. My situation: I have two databases which are supposedly from the same version of my software product. However, a casual examination of a few tables has revealed that some of the tables in database A are missing fields or are...

I am examining the execution plan for several different SQL queries to find the best one for optimizecd performance. My test queries return 70 records out of a 38,000 record table. Query A is the fastest and has a cost of 0.584 Query B takes 4 times as long and has a cost of 0.150 Query C is...