Creating reports and dashboards | Stimulsoft community forum

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

Hello,

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

Thank you.

Hi Lech,

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

Warm Regards,
Daniel

Hello

We are always glad to help you!

Thank you.