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
Cross tab and parameters
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Cross tab and parameters
Hello,
You can add your parameters in Filter for the Cross-Tab.
Thank you.
You can add your parameters in Filter for the Cross-Tab.
Thank you.
Re: Cross tab and parameters
Hi Lech,
I solved the problem i was missing a date filter in the sql query.
Warm Regards,
Daniel
I solved the problem i was missing a date filter in the sql query.
Warm Regards,
Daniel
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Cross tab and parameters
Hello
We are always glad to help you!
Thank you.
We are always glad to help you!
Thank you.