Line chart with data from group header and footer.

Stimulsoft Reports.WPF discussion
Post Reply
TestBoy
Posts: 46
Joined: Tue Oct 23, 2018 8:14 pm

Line chart with data from group header and footer.

Post by TestBoy »

Only posting this here because I am using the WPF viewer to look at these but I guess it would not matter?
And onward...

This one eludes me and it's certainly a Crystal growing pain.
Report has one group.
The group header uses an expression, something like dataset.field.ToString("yyyyMM")
The databand is empty. nothing is printed here. it's set to "calc invisible"
The group footer has ~10 values that are sums with conditions.
The footer band has more sums that are running totals - the expressions are the same as the group footer with the exception that SumIfRunning is used instead of SumIf.

What I need is for the X axis on my line chart to be the same as my group header, that happens to be the expression above.
So, my X axis would have like 201801, 201802, 201803, etc
My Y axis needs to have one of the values from the group footer band.

I have seen the charts in examples using a datasource to drive them, but in this case that's not going to work unless there is a trick I have not discovered.

What can I do to pull this magic act off?
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Line chart with data from group header and footer.

Post by Lech Kulikowski »

Hello,

Please send us your report with test data for analysis.

Thank you.
TestBoy
Posts: 46
Joined: Tue Oct 23, 2018 8:14 pm

Re: Line chart with data from group header and footer.

Post by TestBoy »

Any idea how I could do that since the datasource is SQL?
I have had no luck trying to change a datasource to something else. It just breaks.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Line chart with data from group header and footer.

Post by Lech Kulikowski »

Hello,

You can prepare the necessary data in a necessary format directly in the query.

Thank you.
Post Reply