Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 14, 2010 06:04 AM by vijay arunraj
Mar 04, 2010 05:15 AM|LINK
I just had a problem with the grouping in the SSRS
For Example I am using Two Datasets DataSet1 And DataSet 2
Two Tablix Tablix1 and Tablix 2
I used Dataset1 for Tablix1 and Dataset 2 For Tablix 2
So just had a criteria that i have to group the records in tablix based on the Age ...
So There is a parameter required if i pass parameter 1 Tablix 1 must be visible and if i pass
parameter 2 Tablix 2 must be visible.This works fine
When comes to the grouping i used the following expression for the grouping
For Tablix 1
For Tablix 2
When i pass Parameter 1 it shows invalid return datatype in Tablix 2
When i pass Parameter 2 it shows invalid return datatype in Tablix 1
Also note that when i remove grouping for tablix 1 , parameter 2 works fine with grouping
When i give parameter 1 it makes same error as stated above
Can u please help in fixing the expression or Issue
Report Builder 2.0
Apr 14, 2010 06:04 AM|LINK
i found the solution for this problem by myself
I used Following function for group expression to resolve it
The Input for this function is the field by which the grouping needs to be made
Public Function IsFieldMissing(field As Field) As String
If (field.IsMissing) Then
If field.Value = 100 Then
Return "Group A"
Return "Group B"
It worked fine .........