Cross tab and parameters

[bahiapt]

Hi all,

I am new to Stimulsoft but have been tasked to do a report that will need the functionality of a pivot, now the problem i have inserted the cross tab in the page for a data source that has already two parameters set (from and to date), the report rows are a category, the columns Year and month, when i run the report i am prompted to choose a range but the cross tab will show all the months and years (column fields) placing a blank on the ones not chosen in the range, what i want is the cross tab just to show the year(s) and month(s) selected in the prompts.

Really appreciate assistance and hope the message above is clear

Warm Regards,
Daniel

[Lech Kulikowski]

Hello,

You can add your parameters in Filter for the Cross-Tab.

Thank you.

[bahiapt]

Hi Lech,

I solved the problem i was missing a date filter in the sql query.

Warm Regards,
Daniel

[Lech Kulikowski]

Hello

We are always glad to help you!

Thank you.