Stimulsoft Business Intelligence System | Forum

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

Hello,

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

Thank you.