Post reply

Run report directly from report manager

  • March 30, 2011 at 9:35 am

    #237731

    Hi,

    How can I run report directly from report manager?

    Thanks.

  • March 30, 2011 at 9:42 am

    #1305515

    http://YourServerNameHere/Reports

  • March 30, 2011 at 9:51 am

    #1305524

    If I go to the report manager and right-click on the report and click on Open, it only shows XML version of the report and there is no data there.

  • March 30, 2011 at 10:31 am

    #1305548

    My guess is that there is something wrong with the way your report server is configured. I believe that available formats is part of the config file, perhaps yours is set only to XML. Unfortunately I don't know the specific configuration items you need to review.

  • March 30, 2011 at 10:42 am

    #1305558

    I am new to reporting services. I uploaded the report in rdlc format. I see other reports on the report manager but I do not see the extension of the reports. These reports are working and they were developed by developers that are no longer working here. Any help I can get from all of you will be greatly appreciated.

    Thanks.

  • March 30, 2011 at 10:46 am

    #1305564

    Try rdl (without the C at the end).

  • March 30, 2011 at 11:46 am

    #1305584

    Because this report manager must be v. 2005, changing the file to RDL worked. Now how do I add the datasource to it?

  • March 30, 2011 at 11:48 am

    #1305586

    How did you develop the report?

    In visual studio you have a very handy "deploy" function that handles all those pesky little details for you. I'd have a serious look into that if I were you.

  • March 30, 2011 at 11:50 am

    #1305588

    I added dataset to the VS project, but when I try to preview data, it give me the error "timeout expired"

  • March 30, 2011 at 11:52 am

    #1305590

    How long to run the query straight from management studio?

  • March 30, 2011 at 11:52 am

    #1305591

    about 10 minutes

  • March 30, 2011 at 11:56 am

    #1305598

    Try using a dataset that runs instantly to make sure that part works.

    Next step is to speed up that query. I'm pretty sure you can change the timeout for the query exec, but I don't know where from the top of my head.

  • March 30, 2011 at 11:58 am

    #1305601

    Have already added the dataset, but it is timing out.

  • March 30, 2011 at 5:46 pm

    #1305748

    I meant make A NEW dataset. Make sure it runs in only a few seconds and see if you have other problems besides the timeout.

    From there on out you need to tune the query or extend the timeout period for report execution.

    As far as I know it might be different between VS and the real report server's rendering. So you may want to test it out on the real server. Also AFAIK, the default timeout there is 30 minutes so it should run.

Viewing 14 posts - 1 through 13 (of 13 total)

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