This is a migrated thread and some comments may be shown as answers.

Group Headers By Multivalue Parameter

1 Answer 11 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Gabriel
Top achievements
Rank 1
Gabriel asked on 13 May 2013, 02:50 PM
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

1 Answer, 1 is accepted

Sort by
0
IvanY
Telerik team
answered on 16 May 2013, 01:30 PM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Tags
General Discussions
Asked by
Gabriel
Top achievements
Rank 1
Answers by
IvanY
Telerik team
Share this question
or