Post reply

Having problem in SSRS 2008 report refresh using parameters

  • February 24, 2010 at 6:23 am

    #211561

    I developed SSRS 2008 report using SSAS 2008 as data source in BIDS. This report is using some parameters. When I used preview in BIDS, the report refreshes fine whenever I change the value for the parameters by selecting different values from the dropdown list of these parameters.

    When I deployed the report to Report server (native mode), the report works fine for the first selection of parameters in the report manager. When I select new parameter values from the dropdown list and then click on view report, report still shows the result of the first parameter selection. If I go back to folder containing this report and then try to see the report with my second selection of parameter, the report works shows the correct values.

    When I deployed the same report to SharePoint site to use SSRS integrated mode, the reports are showing the correct values for every selection of parameters without the need to go back to report library each time.

    Refresh works fine in SSRS native mode when the data source is SQL Server. Is the MDX query causing this problem. SSRS and its data source SSAS are running in the same windows 2003 server.

    Parameters used are simple dimension attributes. They are having 'automatically determine when to refresh' selected which is the default setting.

    Any help to understand why this happens and how to fix this is greatly appreciated.

  • February 24, 2010 at 12:29 pm

    #1124502

    Hi,

    I dnt know exactly ,try to change the advanced parameter settings to "always refresh the data"

    Thanks

    Veeren.

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • February 24, 2010 at 12:36 pm

    #1124505

    I tried that too. That didn't help.

  • February 24, 2010 at 12:43 pm

    #1124513

    Did u r MDx query as data source is working on u r native environment?

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • February 24, 2010 at 1:01 pm

    #1124538

    When I select what parameter and what fields I want to use in query designer, MDX query is built automatically for the SSAS data source. Since the report works fine in the native mode for the first set of parameters selected, I think MDX query works fine in the native mode. Somehow when I change the parameter without closing the report, it does not seem to see the change in the parameter values.

    I don't know whether I understand your question correctly. If I didn't, please let me know.

  • March 3, 2010 at 11:41 am

    #1127992

    Hi,

    I have no idea i am also looking for some ideas from our forum...

    Thanks

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • November 24, 2010 at 6:59 am

    #1255058

    This issue is resolved when I reset the internet options. Sorry for the delay in updating.

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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