Press PREVIEW button, hourglass then nothing

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I just added a new report to this system.
The form has 2 buttons PRINT and PREVIEW which open the
report (fed off a crosstab query).

Well when I click the buttons, I see an hourglass and then
nothing else. How do I debug from here? How do I check if
the report is opening or the query is returning data since
it refers to global functions that test the forms date
controls so I cant just open the report or run the query
manually. If the query returned no data, would the report
still display?
 
yes the report will display even if query returns null
records. a good way to debug would be to see how much time
ur query takes to run if u run ur query directly. ur
report should take almost the same time to open as ur
query takes to run. since u say u cannot run ur query
manually, i think try to run atleast the part u can.
functions which check for validity etc. should not take
much time. Try debugging thru preview button, and then
after that u can try the print button.
Hope this info helps.

-Ketaki
 
Back
Top