I created a crosstab query with the dates as row headings which has a Start Date and End Date Parameter. When I created a report from it, everytime I switch to the Design View of the Report, the Parameter Pops-Up like 3 times so I had to either click Cancel Start Date and End Date Pop-Ups 3 times or Fill up the Parameter 3 times which is annoying. It pops up when I click something on the Report(in Design View), or even when I encode a Formula on a textbox(it pops up everytime I press a letter on my keyboard).
i can't remove the parameters from the query because I need it in producing the data for report (say from August 1 to 31 data only)
please help me solve this problem. thanks
i can't remove the parameters from the query because I need it in producing the data for report (say from August 1 to 31 data only)
please help me solve this problem. thanks