Data Everywhere - Step 3 in the Stairway to Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jessica M. Moss » Data Everywhere - Step 3 in the Stairway to...

15 posts, Page 2 of 2

««1 2

Data Everywhere - Step 3 in the Stairway to Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

Junglee_George

Posted Wednesday, March 09, 2011 11:59 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, April 05, 2013 1:04 AM
Points: 471, Visits: 547

Hi

Very Useful article series...Thank You

Eagerly waiting for your 'Charting the Unknown' article & 'Designing a Dashboard'.

Please publish it soon....Thanks a lot once again..

Post #1076027

Brett Phipps

Posted Tuesday, June 07, 2011 8:19 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:38 AM
Points: 93, Visits: 207

We are in the midst of upgrading from SSRS 2005 to SSRS 2008 R2, so I took note when you mentioned shared datasets. It seems like this is just a built in method of using stored procedures, though. We took the approach that everything had to be done via stored procedure so that everything was always available. Is there any advantage to the shared datasets, now that they are available?

Post #1121050

Jessica M. Moss

Posted Sunday, June 12, 2011 10:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 2:10 PM
Points: 8, Visits: 332

Hi bphipps,

Shared datasets are searchable and versionable through SSRS. In addition, shared datasets can be used to access information from sources other than SQL Server.

For more information on shared datasets, I would recommend looking here: http://msdn.microsoft.com/en-us/library/ee636147.aspx

Best,
Jessica

Post #1124026

mary.wright

Posted Friday, January 18, 2013 7:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 1:45 PM
Points: 1, Visits: 30

Jessica, I've been using Reporting Services for years but I'm still on 2008 (not R2).

I have heard that when you use a shared dataset, the query for the dataset cannot be changed after it has been used in a report. Do you know if this is true? This seems to defeat the purpose of having a shared dataset!

Thanks for a great article!

Post #1408891

jfitzsimmons 10774

Posted Tuesday, January 22, 2013 3:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 14, 2013 6:00 PM
Points: 1, Visits: 20

Shared datasets are easy and useful. I had scenario where I needed a report to have a variable connection string so that it could connect to more than one database. The only way to get it to work is having no credentials embedded in the report, and using the SSRS un-atteneded account. That can only be done using an embedded data set.

Post #1410285

« Prev Topic | Next Topic »

15 posts, Page 2 of 2

««1 2

Permissions