dynamic reports

[mikela]

HEllo!

I create dynamically a query, that changes de select fields according to what the user selects.

How can i create then a dynamic report, to display that data... If i delete and create the query everytime, it keeps on asking for the parameter that i put first (the parametera that i selected when creating the report with the wizard), so i need this parameters to change everytime as well.

Will I need to create them dynamically?? How can i do it?

Thank you in advance

 

[pbaldy]

I suppose you could adapt the code used for dynamic crosstab reports. I use code from the ADH, but there's also this:

http://support.microsoft.com/kb/328320

 

[mikela]

Hey!

Thanks.... that is what i'm doing, but then i don't know how to create the textboxes dinamically and assign them the datasource correctly.... or how to change the control source for the textbox dynamically, according to the query.

 

[pbaldy]

Well, the way I do it (and I think the way that link works) is to create as many fields as might be needed, and populate or hide them as appropriate when the report runs. You should see the code in that link doing that. Frankly I think the ADH code is simpler, so if you have access to the book I'd start with that.

 

[mikela]

yeah...

it works, but the problem is that i don't know in advance the number of fields i'm gonna have. I know the columns, but don't know the rows.... and it's driving me NUTS

and don't know what else to try....

Any suggeriment would be veeeery nice

thank you

 

[pbaldy]

Why do you need to know how many rows (records)? It should be irrelevant to the process. What is your process?