Creating reports and dashboards | Stimulsoft community forum

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?

Hello,

Please send us your report with test data for analysis.

Thank you.

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.

Hello,

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

Thank you.