Sign In| Join
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
Member
2 Points
12 Posts
Mar 04, 2010 05:15 AM|LINK
HI
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
=IIF(Parameters!Parameter.Value=1,Fields!Age>50,"")
For Tablix 2
=IIF(Parameters!Parameter.Value=2,Fields!Age>50,"")
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
SSRS Report Builder 2.0 report services Grouping Expression
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 Return "NoGrouping" Else If field.Value = 100 Then Return "Group A" Else Return "Group B" End If End If End Function
It worked fine .........
Vijay Arunra...
Member
2 Points
12 Posts
Grouping in SSRS using report builder 2.0
Mar 04, 2010 05:15 AM|LINK
HI
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
=IIF(Parameters!Parameter.Value=1,Fields!Age>50,"")
For Tablix 2
=IIF(Parameters!Parameter.Value=2,Fields!Age>50,"")
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
SSRS Report Builder 2.0 report services Grouping Expression
Vijay Arunra...
Member
2 Points
12 Posts
Re: Grouping in SSRS using 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
Return "NoGrouping"
Else
If field.Value = 100 Then
Return "Group A"
Else
Return "Group B"
End If
End If
End Function
It worked fine .........