September 18, 2013 at 4:50 am
Hi,
I have a report URL and I can see some of the reports on the URL. But where can I see the visual studio solution file to edit the report. Is there a way/option to find the solution file part from the report URL?
Thanks.
September 18, 2013 at 4:54 am
The Visual Studio reporting solution belongs to Visual Studio, the development environment. It is not deployed to the server.
You can however download the .rdl file, and add it to a Visual Studio solution.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 18, 2013 at 12:28 pm
I have created a report and deployed it. But when I try to create subscription I am getting the following error.
Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.
I have 8 reports in the project.
I am able to manually run the report in the report manager/browser.
I tried to find a solution by searching it on couple of forums, but still not able to fix this. I created the report on my machine with a sql server login credentials for the datasource. Now I am trying to create subsription through IE on my machine.
any thoughts?
Thanks.
September 18, 2013 at 1:36 pm
In Report Manager, right click on the report and choose Manage.
Go to data source and verify if credentials are entered.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 18, 2013 at 2:39 pm
Thanks. It is a big help.
September 18, 2013 at 6:58 pm
I need one more help with this task.I have a solution with 8 reports.
Can I run all the 8 reports as one job instead of running 8 reports as 8 subscriptions and can all the reports go into one excel sheet with 8 diff tabs?
How can I do this?
Thanks.
September 19, 2013 at 12:42 am
That's a bit out of my expertise.
You better start a new question for that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2013 at 8:45 am
To run the 8 reports at once and export it all to one Excel file, create a main report with Subreports.
Here are some sites that show how to create subreports:
http://www.katieandemil.com/ssrs-create-subreport-with-parameter-example-tutorial-
ssrs-2008-r2
Create the main report
- add a table
- remove 2 right columns
- Create 8 detail rows - right click Details Row, Insert Row, Inside Group - Below
- Set page breaks (will create separate tabs when Exporting to Excel)
- Right click on a Detail row
- Choose Row Group, Group Properties
- go to Page Breaks, check Between each instance of a group
- Add a subreport to each Detail row of the table and configure it for each report
*if there are parameters on the subreports, you will have to add them to the Main Report and pass them to the appropriate subreports
In SSRS 2008 R2, you can configure each Excel tab name.
To set the tab name when exporting to Excel -
- click on the Row Group name in the box below (can be on a group you create or use Details group)
- In the Properties window, expand the Group section
- put the field in the PageName property - for example: =Fields!TerritoryName.Value or use text - type it in
See website:
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply