Group Headers By Multivalue Parameter

[Gabriel]

Hello, 

I'm trying to display group headers even though the group is "Empty".  

My example setup:
Two data sources: GroupDataSource and FieldDataSource
Parameter GroupCodes: DataSource:= GroupDataSource, Value:= AllValues(Fields.GroupCode)
FiedDataSource contains SQL:
"WHERE  table.GroupCode in @GroupCodes"

Suppose I select group codes 1, 2, and 3, but there are only fields with groupCodes 1 and 2.  There will only be groups for 1 and 2, obviously, but I would like to make a header for the "empty" group (non-existant, in a way...) 3.  Is this possible?

Thanks,
Gabriel

[IvanY]

Hello Gabriel,

In general you will need to have fields since the creation of groups is based on them. If you do not have real row with fields you can add fake rows in your sql query like this:

SELECT *
FROM Person.Person
WHERE Person.BusinessEntityID < 10
UNION ALL
SELECT TOP 1 1, null, null, null, null, null, null, null, null, null, null, null, null
FROM Person.Person

However if this is not your scenario please elaborate so that we are able to advise you more accordingly.

Kind regards,
IvanY
the Telerik team