Conditional Report Opening

[rob_andy]

Hi all,

I have a db app that creates requisition forms, it basically looks at a table of requisitions and creates reports depending on a supplied req number. Each req has a line and I need to basically produce a separate report if a line has a unique supplier. E.g. if a req has 3 lines, each line has a separate supplier a,b,c I would need 3 reports producing. Ideally I would like to save these reports to a directory structure dependant on date.

Any ideas?

Thanks in advance for any help.

[Andrew Fergus]

Hi
I don't understand 100% so can you please clarify a couple of points? I take it there are multiple items per requisition and each item has a supplier - is that correct? If so, what tables and fields do you have to support this structure? If not, then what information is recorded for each requisition?

If I understand your question correctly, you want to be able to select a requisition, and where that requisition has more than one supplier then you want a separate report (order perhaps?) per supplier, possibly with one or more items on it - is that correct?

Lastly, if we can re-create these reports at will, then will you need to store a copy of each report?
Andrew

[rob_andy]

Hi there,

Yes there are multiple items per req, and potentially each item can have a different supplier, each line for the req contains a supplier ID to support the structure.

If I understand your question correctly, you want to be able to select a requisition, and where that requisition has more than one supplier then you want a separate report (order perhaps?) per supplier, possibly with one or more items on it - is that correct?

Yes this is correct

And yes I would like to store copies of the reports with unique meaningful names that we can attach to a call logging system.

Thanks

[Andrew Fergus]

Hi
Have you looked at using the 'sorting and grouping' options in the report design? Go into the report design, click View -> Sorting and Grouping. In there you can group and sort on any field. In your case you would set up a group based on the supplier, turn on the group header and footer by setting the relevant properties to Yes, close the grouping and sorting box, right click the supplier footer, click Properties and set the 'Force New Page' property to 'After Section'. This will give you (per your example) a 3 page report. Make sure you put your requisition numbers and other fields into the page header and not the report header, so they will be visible for each supplier. I can't help with saving the reports sorry, it's not something I ever do.
HTH, Andrew

[rob_andy]

Thanks a lot, that has worked a treat, I think there is some vba commands to save the actual reports to a file and generate a filename based on a table value.