Press PREVIEW button, hourglass then nothing

[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?

 

[Ketaki]

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