Search results for query: *

It's nothing to do with the SQL. The stored procs are returning the correct data and only what is necessary for each sub-report. It is the length of time that Crystal is taking to format the report.

Thanks tonnes, worked like a charm!!

Hello, I have created a Payroll Register that is run for a company with about 6000 employees and 40 pay elements per employee. Built a report in Crystal to represent each employee's pay information. The report has a report header containing employee/payroll information. And then there is a...

Hello Folks, I am opening up an instance of Access and creating a table from a text file (Phoo.txt) from within VB6. However, when I go to shut down the Access Application from within MS Access itself, the database closes but the instance of Access remains open and will not close without...

Hello, I am attempting to go through ODBC views, re-attach the with a new name and creating the same index that I have placed on the original table. The following is the code that I am using. I keep getting an error: Run-time error '3039' Could not create index; Too many indexes already...

Hello,<br><br>I am wondering if it is possible to switch the datasource of a report from a combination of tables to the dataset returned from a stored procedure.&nbsp;&nbsp;When I change the data source, I have to be able to pass the proc 2 parameters.&nbsp;&nbsp;If I can switch the source to a...