Dataset-Controlling with inside tables
Hello everyone,
1.) is there a Start- and a While/End-Condition in the Main-Dataset possible (as in other Reportgenerators) ? I only see RangeBegin First;Current. I need a value-parameter for Start and in RangeEnd-Property a while-condition like "FieldValues <= cArtNr".
Following situation: The User type in from which item to which item he wants to get his item-List. Therefor i open a window in the main-application(i can also do this in FR), ask for the two parameters and then i call the report, fill the frx-variables and want to start with the table at the first parameters value (so i have to locate to the first parameters value in the table). I use ADS an use my own frxADSTable-components and inside Datasets.
I think there must be an event like:
procedure ReportOnStartReport(Sender: TfrxComponent);
begin
tblItems.Locate('ITEMNR',cArtNr,[]); // error: Expression expected
tblItems.Next; // works, but the Report nevertheless starts at the first item !
end;
I do not want to use Filters! In some situations they migth be very slow.
......or do all of you use SQL-Querys?
2.) i have a wish to the FR-Team. Can you add a new Property to TfrxGroupHeader
frxGroupHeader.ResetPage True/False (reset to 1 at group-changing)
3.) to the FR-Team: you made a great job, thanks.
Thanks for your reading
and Merry Christmas
1.) is there a Start- and a While/End-Condition in the Main-Dataset possible (as in other Reportgenerators) ? I only see RangeBegin First;Current. I need a value-parameter for Start and in RangeEnd-Property a while-condition like "FieldValues <= cArtNr".
Following situation: The User type in from which item to which item he wants to get his item-List. Therefor i open a window in the main-application(i can also do this in FR), ask for the two parameters and then i call the report, fill the frx-variables and want to start with the table at the first parameters value (so i have to locate to the first parameters value in the table). I use ADS an use my own frxADSTable-components and inside Datasets.
I think there must be an event like:
procedure ReportOnStartReport(Sender: TfrxComponent);
begin
tblItems.Locate('ITEMNR',cArtNr,[]); // error: Expression expected
tblItems.Next; // works, but the Report nevertheless starts at the first item !
end;
I do not want to use Filters! In some situations they migth be very slow.
......or do all of you use SQL-Querys?
2.) i have a wish to the FR-Team. Can you add a new Property to TfrxGroupHeader
frxGroupHeader.ResetPage True/False (reset to 1 at group-changing)
3.) to the FR-Team: you made a great job, thanks.
Thanks for your reading
and Merry Christmas
Comments
now i know the resolution for my question:
the event must stay AFTER the begin of the Script-Program, then it works!
begin
tblItems.Locate('ITEMNR',cArtNr,loPartial);
// works fine; the Report starts at this record!
end;
best http://www.fast-report.com/en/forum/style_...con1.gifregards
Bernd