Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Multiple Reports

edited May 2004 in General
Hi,
I have a report designed in RB 6.03(which works well). Thing is, its takes
parameters, say JobID. I pass the parameter at runtime from the value of a
combo box, call using ppReport1.Print and it works perfectly .
Now, I changed the combobox to a listbox so the user can select multiple
JobIDs. what I did was get all the ID's into an array and just iterate the
array and pass each JobID in succession.
Problem is it prints the report for each JobID separately. Is it possible
to have all the jobs print in one report on successive pages? Eg, for each
JobID, the report is 2 pages and user selected 3 ID's...so after looping
through my array I end up with a report of 6 pages....

I don't even know if having the array is the best idea...

Cheers
-Shanil.

Comments

  • edited May 2004
    Hi Shanil,

    Have you tried using the TppParameter.PickList feature yet? This allows you
    to populate a StringList with multiple values that can all be sent to a
    report at once. You could populate the PickList with the values that your
    users select from the ListBox, then use the values from that list in the
    report formatted the way you need.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2004
    Sorry about my naivety...I couldn't find a TppParameter - can you point me
    in the right direction?
    Also, while I'm at it - my report has sub-reports that take the JobID
    parameter, so it shows records relevant to that JobID. What I'm trying to
    achieve is that the report prints everything relevant to the particular
    JobID and then moves on to generate same data for a different Job(loop),
    with the new JobID being the parameter...hope my explanation's clear...

    Thanks

  • edited May 2004
    Actually, the users just want to preview the first report and te rest gets
    send to the printer straight, so I don't think I'll need the functionality I
    have mention below...

  • edited May 2004
    Hi Nico,
    will having Section style subreports work in this situation?

This discussion has been closed.