SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS reportsolution file


SSRS reportsolution file

Author
Message
sql_novice_2007
sql_novice_2007
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 726
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27517 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
sql_novice_2007
sql_novice_2007
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 726
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27517 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
sql_novice_2007
sql_novice_2007
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 726
Thanks. It is a big help.
sql_novice_2007
sql_novice_2007
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 726
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.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27517 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
sql Sarah
sql Sarah
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 Visits: 590
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search