Filter the crosstab data

[g.congnos]

Hi all,

Can i set a filter directly in the crosstab?

I think I can't use 2 different queries. My report is structured as follow:

-Set Page (I need to show the same report in different pages depending on the value set in the prompt page)
  -Page report
     -two crosstabs. They are the same with an exception: i need to filter the data of one crosstab.

any suggestions?

Thanks

[Lynn]

Ok, now I suggest you don't double post  ;)

You can try using a query reference. Drag a new query into your query explorer and then drag the original query to the right of this new query. Drag the desired elements from the base query into the new query and apply a filter as desired. Associate one crosstab to the base and the second crosstab to the query reference.

[g.congnos]

I don't know how move the post  ;)

Thanks, I'll try!!

[MFGF]

I don't know how move the post  ;)

All sorted for you! :)