Crosstab - parameter query

rbuser

Hi,
I have a crosstab report that uses a parameterised query and takes
TimesheetID as parameter. It works fine the first time, but when I select
another Timesheet(meaning another TimesheetID), the report is the same as
the first one.
I checked whether it passes the correct TimesheetID each time and I close
and open the query also so I'm not sure what I'm doing wrong here....

RB 6.03
Delphi 6

nicocizik

Hi Shanil,

How are you refreshing the report output? Do you close the report before
you select a new TimesheetID. As a test, try attaching a DBGrid to your
query and see if the data is actually changing as expected when you change
the TimesheetID. Then be sure you are completely regenerating the report
once the query changes. You will need to call Report.Reset if you are
changing the data.

--

rbuser

ok, I wasn't resetting the report....works fine now.