Creating reports and dashboards | Stimulsoft community forum

Posted: **Fri Apr 10, 2020 4:37 pm**

Hello,
I have a query this example:

SELECT xyz,                                                                            
        SUM(CASE WHEN FieldA BETWEEN 100 AND 200 THEN (Field3+Field3)-(Field4+Field4) ELSE 0 END)
FROM MyTable
GROUP BY xyz

In Sql server I view the data, in Dashboard I view the data but in Preview or runtine the data is empty.
If I delete group by of the query I can view the data but this is a problem because I need to group by the data and then apply a filter
Help Me.

Posted: **Fri Apr 10, 2020 4:58 pm**

If in Dashboard Value I write Sum(Name field) it's work.

The problem is I have the combobox in Page and I have two datasource and two chart one for each datasource, the combobox filter only the first datasource, but I do not know if I delete the combox I can view all data in both chart else I can view only first chart data.
This is possible ?

Posted: **Tue Apr 14, 2020 8:23 am**

Hello,

You can use the 'Group' property of each element to combine elements in one data source group.

Thank you.

Posted: **Thu Apr 16, 2020 6:14 pm**

ok thank

Posted: **Fri Apr 17, 2020 10:54 am**

You are welcome!

Creating reports and dashboards | Stimulsoft community forum

Problem with GroupBY

Problem with GroupBY

Re: Problem with GroupBY

Re: Problem with GroupBY

Re: Problem with GroupBY

Re: Problem with GroupBY