index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: asp report writer merge output data :: (1) Post a New Message | Post a Reply
May 24 2006, 10:50 AM	asp report writer merge output data Post a Reply
dstbny2 since: May 24, 2006 from: IL	Just have a question maybe someone can answer.  I currently use MS Access as my underlying database.  In order to accommodate my clients ability to enter unlimited records I had to set up certain tables to hold 1 record line per entry.  My question is, within the ASP Report Writer (we use version 2.0) is there a way for me to combine my individual record lines from the database table into 1 line record in the asp report? (example: my client entered 5 fee records into the system.  all of the records entered store the same permit number.  the only thing different is the fee type and fee amount.   looks like this:           permitid      feecategory      fee            12345                   1                1.00            12345                   2              10.00   etc... this created 5 seperate record lines within the database which is what we need it to do. when i go into the asp report writer and select the fee table from the tables list and run the report for permit 12345 i get 5 seperate report lines.  one for each record in the system so my report looks like this: Permit ID     Fee Cat     Fee 12345                 1           1.00 12345                 2          10.00 etc... Can the asp report writer system merge the records to look like this: Permit ID       Fee Cat     Fee         Fee Cat       Fee     etc 12345                 1             1.00            2             10.00 If anyone has any suggestions as to how I can get my report to look like the above example without having to modify the structure of my access database it would be greatly appreciated!  Thanks!
Pages: (1)   [1]

search this forum: