Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS reportsolution file Expand / Collapse
Author
Message
Posted Wednesday, September 18, 2013 4:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:12 PM
Points: 189, Visits: 684
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.
Post #1495842
Posted Wednesday, September 18, 2013 4:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:55 PM
Points: 13,357, Visits: 10,222
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1495843
Posted Wednesday, September 18, 2013 12:28 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:12 PM
Points: 189, Visits: 684
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.


Post #1496067
Posted Wednesday, September 18, 2013 1:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:55 PM
Points: 13,357, Visits: 10,222
In Report Manager, right click on the report and choose Manage.
Go to data source and verify if credentials are entered.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1496102
Posted Wednesday, September 18, 2013 2:39 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:12 PM
Points: 189, Visits: 684
Thanks. It is a big help.
Post #1496138
Posted Wednesday, September 18, 2013 6:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:12 PM
Points: 189, Visits: 684
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.
Post #1496188
Posted Thursday, September 19, 2013 12:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:55 PM
Points: 13,357, Visits: 10,222
That's a bit out of my expertise.
You better start a new question for that.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1496232
Posted Friday, September 20, 2013 8:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:27 AM
Points: 38, Visits: 238
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
http://ssrstutorials.blogspot.com/2012/10/lesson-17-ssrs-subreports.html#!/2012/10/lesson-17-ssrs-subreports.html

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:
http://bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports
Post #1496921
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse