Post reply

data filter issue using jump to url in SSRS

  • April 22, 2009 at 6:48 pm

    #220582

    hi all,

    I need help to finding the issue on ssrs i have never encountered with this issue before.

    in ssrs we have link for exporting data to excel by using jump to url. which pass the parameter to another RDL and both rdl use same stored proc. I found the data has been filtered ( not accurate data) when i see them from the exported link but when i do direct export from ssrs those data are perfect. any one have idea about this issue. even paramater on the url that has been generated was the same which i used on the main report.

    I will really appreciate for the answer.

    thanks

    Sagar

  • April 23, 2009 at 6:35 am

    #982810

    Is there any possibility that the source data was changed during the time the report is being looked at and then the "new" report is run? How major is the change?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • April 23, 2009 at 8:45 am

    #982971

    it is not data change, some of the data will not show up in export link but when we do from the direct export from ssrs it does.

    below the script that use in jumped to url

    =Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/ExcelExportActvsPLC&rs:Command=Render&rs:ClearSession=true&DivisionId=" & Parameters!DivisionId.Value &

    "&StartQuarter=" & Parameters!StartQuarter.Value &

    "&EndQuarter=" & Parameters!EndQuarter.Value &

    "&ReportView=" & Parameters!ReportView.Value &

    "&View=" & Parameters!View.Value &

    "&ProductLineId=" & iif(Count(Fields!ProductLineName.Value, "dsProductLine")= Parameters!ProductLineId.Count,"%",Join(Parameters!ProductLineId.Value, ",")) &

    "&ProgramId=" & iif(count(Fields!ProgramName.Value, "dsProgram") = Parameters!ProgramId.Count,"%",Join(Parameters!ProgramId.Value, ",")) &

    "&DepartmentId=" & iif(count(Fields!DepartmentId.Value, "dsDept")= Parameters!DepartmentId.Count, "%",join(Parameters!DepartmentId.Value, ",")) &

    "&JobTypeId=" & iif(count(Fields!JobTypeId.Value, "dsJobType")= Parameters!JobTypeId.Count, "%",join(Parameters!JobTypeId.Value, ",")) &

    "&Projectid=" & iif(count(Fields!ProjectId.Value, "dsProject")= Parameters!Projectid.Count, "%",join(Parameters!Projectid.Value, ",")) &

    "&SubJobTypeId=" & iif(count(Fields!SubJobTypeId.Value, "dsSubJobType")= Parameters!SubJobTypeId.Count, "%",join(Parameters!SubJobTypeId.Value, ",")) &

    "&GlfunctionId=" & iif(count(Fields!GLFunctionId.Value, "dsGL")= Parameters!GlfunctionId.Count, "%",join(Parameters!GlfunctionId.Value, ",")) &

    "&Phase=" & iif(count(Fields!PhaseId.Value, "dsPhase")= Parameters!Phase.Count, "%",join(Parameters!Phase.Value, ",")) &

    "&Version=" & iif(count(Fields!VersionId.Value, "dsVersion")= Parameters!Version.Count, "%",join(Parameters!Version.Value, ",")) &

    "&Show=" & Join(Parameters!Show.Label,",") &

    "&QuarterlyBreakOut=" & Parameters!QuarterlyBreakOut.Value &

    "&rs:Format=EXCEL"

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

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