Virtual DataSource_Grouping

Stimulsoft Ultimate discussion
Post Reply
reportingnoodles
Posts: 1
Joined: Thu Aug 05, 2021 9:41 am

Virtual DataSource_Grouping

Post by reportingnoodles »

Hello dear support team,

I have formed a relationship with two columns.
Here's an example:

Parent Column: food groups
(includes food_ID, date, food group_ID, food group name)

Child Column: Food Value (includes food_ID, Date, Value)

My connection between Parent and Child Column is Food_ID and Date.
The relationship is called R_foodgroup.

Then I created a new virtual data source. My goal is to count the number of foods for each food group and to sum up the food values.
The virtual data source is structured as follows:
Data Source: Food Value
Groups: RL_foodgroup.foodgroupname
Results: countdistict (Food_ID) and sum (value)

When I then display the data, I get the results - but unfortunately not the grouping (in the example RL_food group.food group name). It cannot be seen in the preview either. Why doesn’t it work? Is it because my grouping is based on a relationship? Is there a solution for this?

Thanks in advance,
Greetings from Germany
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Virtual DataSource_Grouping

Post by HighAley »

Hello,

Sorry, we can't reproduce the issue.
How did you set the grouping in the report?

Thank you.
Post Reply