Post reply

taking off grouping when parameter selected

  • July 24, 2006 at 12:14 pm

    #169416

    I am trying to get rid of grouping depending on a parameter they choose for instance ...

    I right click and Edit the first group and in the Group on expression box this is what i got...

    =IIF(Parameters!FilterByOrganizationID.Value = "DEALER","", Fields!OrganizationName.Value)

    But when i try running the report i get this error...

    w3wp!processing!15c!7/24/2006-10:51:43:: e ERROR: Data source 'AAA': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The group expression expression for the grouping ‘table1_Group1’ contains an error: Input string was not in a correct format.

    w3wp!processing!15c!7/24/2006-10:51:43:: w WARN: Data source 'AAA': Report processing has been aborted.

    w3wp!processing!15c!7/24/2006-10:51:43:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;

     Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The group expression expression for the grouping ‘table1_Group1’ contains an error: Input string was not in a correct format.

    Is there something i missed... the IIF stament looks correct... please help.. thanks


    Moe C

  • July 25, 2006 at 9:25 am

    #651364

    Are you trying to make a report that will be Detailed or Summarized, toggled by a user's parameter?.

    What we did was setup the report with all the groupings, and then use the value of the parameter to set the Visibility/Hidden attribute (to either true or false) of all the rows for the proper grouping. There is a catch: it works, but up to three levels. If you hide 4 levels or more, the page contents get out of wack (at least on the reports I tried it :crazy

     

    Let us know if this is what you're looking for.

     

    Cesar M.

  • July 25, 2006 at 10:39 am

    #651405

    humm maybe your on to something there... im trying to take a report from being detailed to being summarized by the parameter the user has chosen ... so by removing the grouping's is what i am trying to do... but keep one grouping and thats by the dealer name....


    Moe C

  • July 25, 2006 at 10:49 am

    #651412

    No, I think you cannot remove dinalycally the groups. Otherwise you'll get the exception you did.

    But sure you can hide them. All you got to do is make the group's footer look the proper way (names, totals, etc.) , so no matter detailed or summarized, the report looks good.

    Hope it helps.

    Cesar M

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply