Creating reports and dashboards | Stimulsoft community forum

Hello,

I am using Stimulsoft reports.
Actually we are making table by making two groupHeaders, one dataBand and one footer.
But grouped data from sql procedure shows different values
when placed in header or in footer, it used as recapitulation of actual rows.
It looks like this: if placed in header it returns first row and otherwise last row.
I have an idea of solving this with textbox reference, which worked in ssrs like =ReportItems!("textbox1"),
how can I use it in Stimulsoft?

Thanks,

to be more accurate:
lets say I am grouping models of cars. We have brand Ford (grouping by brand in first header) and car model (grouped in second header) followed by Databand which returns all models and we have data which shows all these models for each brand separately, in the end is footer which displays the brand name "Ford" and Fuel category. The problem is that procedure returns all these data: Ford, Taurus, Diesel; Ford, Thunderbird, Gas; Ford, Mustang, Gas etc.. So in the summary in footer I will see Ford, Gas; When I place summary in GroupHeader I will see Ford, Diesel..
Please make note that I placed these Brand and fuel recapitulation directly in HeaderBand, the only databand is for models.

Hope its understandable,
Thanks

Hello,

As a way, you can put additional data band on a Footer. Set filtration for the data band by brand, and output the Fuel category information on it.

Thank you.

Aleksey thanks for your reply, I provide sample data below:



-You can see sample data which procedure returns- We need to group by FGText and then group by F5. There is shown case where all data for FGText is the same so its a little simplier.

The table with FGText Grouping in header below, and its OK:



I have also make screen of designer where you can see how this table is arranged:



- The databand1 isnt showing really, its placed here with 0 height and used only for summary in the last column which is linked to
headers and footers.

But we need to place FGText grouping row below, so when placed in footer final table looks like:



and designer:



You can notice that text changed from "O/N - Plastové obaly znecistene skodlivinami" to "O - Plastove obaly"
Which in fact isnt anything else than changing order of column F5 (although its grouping for FGText) and I think it happend because of
changing position from header to footer. And it happens in every case.
We have tried different methods using databand instead of footer, filtering, sorting, condition, cloning of panels but there is usually problem
that in case of more rows and more FGText groups we need this summary being placed below every group of F5 items, so it works only when placed in
header or footer because databand will output all FGText summaries together under table.
We have find no way how to sort data when placed in footer and no argument why its sorted differently in header/footer case.
Thanks for your time and we will be glad to hear any suggestions,

Hello,

Please send us your report with test data for analysis. Also please a sample how this should look like.

Thank you.