Search results for query: *

sorry, there is a sub report, but this was to replace the Sums in the footer and has speed up to report. there is also page in the footer, removing this does speed it up a lot but we need page numbering on the report. no sections which keep together. I have removed all of the formating the...

hi and thanks for the reply. I have spent all morning play around with a report that I know is the slowest to try to identify the bottleneck. There was a footer that has a lot of Sums on I have removed this and linked it to a sub report that get SQL server to do the calculations for it, this...

hi, i have tried a pass through but it is not quicker. opening a report with about 200K lines it it on hte linked tabel version takes 2 Mins, Pass Through is about the same. ADP takes more than 5 minuets. Open is the linked table / Query that feeds to report takes 7 to 10 seconds so it seems...

Hi i have an issue with an MDB and an ADP that links to a SQl DB. I have migrated an access application so that the data is now stored in a MS SQL DB, over all the application runs much better but i have a set of reports that are in a separate MDB that run slower than the once connedted to an...

turns out the Fromat in the VBA code was not the one it was complaining about, it was in a select string behind a control on the report. this needed to the T-SQL syntax not access syntax.

Hi, I have a mdb file that talks to a SQL DB that contains a set of reports, this run slow I am assuming this is because it runs though an ODBC link. So I tried to create a ADP that connects directly to the SQL DB this works much faster but behind some of the reports I have VBA code and it...

Ok thanks that worked, why the hell do they use different measurements between the formula and the manual screen that's just complicates it. :)

Hi, I am trying to change the width of a column with a formula, but it's not working. i have added code to the width formula under size and position but does not have any effct. i tried the following booleanvat testWidth; testWidth = True; if testWidth = true then 5.000 else 0 this...

Hi, i trying to develop a set of crystal reports that i can display and export though Ms Access using VBA, i got the basic working fine but know i needed to control elements of the reports like column width or even make some column invisible and controlling images loaded in to the report. I...