Report sort order

I am a new user of FastReport and I have a little problem with a report.
I create a report to show some information about articles grouped by groups and subgroups and I have an index at the end; this index contain only article code and the page that article appear.

I have two group header bands (for article group and subgroup) and a master data band. Of course, records are ordered by group, subgroup and article.
My problem is that I want to have records ordered only by article for the index at the end and i want to have correct page number for articles.
Please let me know if it is possible to have different order for records when index is created and this index will have correct page number for articles.
Please help me if someone knows!

Thanks in advance.

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 5:42PM
    Hi you will need to create some arrays to hold values
    like page no and article name and store the record count in a variable
    on the summary page set the mdband datasource to virtual record count to the no of records in record count variable then in obp event of this band write code to
    sub the values stored in the arrays to the display variables used in the memos in the band.

    if finalpass then
    begin
    myvarname1 :=arr1([line#]);
    myvarname2 :=arr2([line#]);

    in obpevents of group header set index values fo arrays to something usefull
    in obp event of mdband on main design page
    use if not finalpass blocks of code to add values to indexed arrays
    regards ;)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.