Inserting a prompt using VBSA and a table

[funkmonsteruk]

This is a general query, but one that i've been wondering about for ages.

Basically i want BO to use each item in a table (possibly generated by another report) as a prompt to a query.

So say for example my query has a prompt, and i want each item in column1 of table1 to be used as a prompt.. eg column values are 1, 2, 3, 4, and 5 - i want a report based on 1, a report based on 2, a report based on 3 and so on...

Any ideas???

 

[funkmonsteruk]

Sorry title should read VBA not VBSA - getting carried away!!!

 

[Sridharan]

Hi,

I cannot think of another report but maybe you can have a single document with the report1 with all the values and using VBA you can take one value from Col1 and then Apply a filter and create separate reports based on Col1 values.

What do you say ???

Sri

 

[funkmonsteruk]

Hmm, interesting approach - I'm gonna give it a go, I'll let you know....