Sladescross's Blog

Blogging about Sharepoint related stuff

SYSSSISLOG Squeeze the Asset for Reporting April 9, 2014

Filed under: Logging,SSRS,SYSSSISLOG — sladescross @ 4:08 pm

http://troywitthoeft.com/simple-ssis-package-monitoring-for-sql-server-2008/#more-790

http://troywitthoeft.com/simple-ssis-package-monitoring-for-sql-server-2008/

http://blogs.msdn.com/b/mattm/archive/2008/06/23/reporting-on-execution-logs-using-reporting-services.aspx

http://www.sqlservercentral.com/blogs/toddmcdermid/2011/04/26/transforming-ssis_2700_-sysssislog-entries-into-something-more-readable/

 

SSRS Master Detail February 2, 2014

Filed under: Master Detail,SSRS — sladescross @ 10:41 pm

http://gotreportviewer.com/masterdetail/index.html

 

SSRS Data Source for Excel 2013 January 23, 2014

Filed under: Data Source,Excel 2013,PowerPivot,SSRS — sladescross @ 2:48 pm

https://www.simple-talk.com/sql/reporting-services/ssrs-reports-as-a-data-source-in-excel-2013/

Figure 1 – Data from Other Sources in PowerPivot

Of course this is not a new idea. Data feeds like this use Open Data Protocol or OData to access data via a standard format, in the case of SSRS, XML-based Atom. You can learn more about OData, Atom and JSON here:

http://www.odata.org/documentation/odata-v3-documentation/atom-format/#12_Collections_of_Primitive_or_Complex_Scalar_Values

 

SSRS Visual Studio and Report Builder Tutorials January 14, 2014

Filed under: SSRS,Tutorial — sladescross @ 6:29 pm

http://technet.microsoft.com/en-us/library/dd239338.aspx

Report Builder tutorial.

http://technet.microsoft.com/en-us/library/bb522859.aspx

SSRS aka BIDS

 

 

SSRS and QR Codes

Filed under: Bar Code,QR Code,SSRS — sladescross @ 5:10 pm

http://www.sqlservercentral.com/articles/QR+Code/105388/

 

SSRS Filter and Parameters January 12, 2014

Filed under: Filter,Parameter,SSRS — sladescross @ 7:56 pm

http://www.sqlchick.com/entries/2012/1/8/relating-parameters-filters-in-sql-server-reporting-services.html

Dataset query filters auto-create a Report Parameter –>

Don’t forget!  It is up to you to go visit the Report Parameter properties to validate them, and finish setting them up (for example, default values).  Also, if you delete a parameter from the dataset, SSRS isn’t going to and delete it from the Parameters for you – you’ll need to do that manually.

Report Filter.  This includes filtering after the source query has come back – on a data region (like the Tablix), or a data grouping.  When you implement a filter within the report, when the report is re-executed again with different parameter choices, the Report Server uses cached data rather than returning to the database server.  This is a viable option if you intentionally want to return all possible data from the database server in the initial query.

E.G. Associate the Report Filter (such as a Group property shown below) to a Report Parameter.  Following is an example using @Country:

 

 

SSRS Drilldown Whitespace

Filed under: Hidden,SSRS,Toggle,Whitespace — sladescross @ 5:45 pm

http://stackoverflow.com/questions/3214326/hide-row-and-remove-whitespace-placeholder-of-tablix-in-reporting-services-200

From the sqldev.org post: Try to set the Hidden property of the Static Row Group under the Details Group, in this case the whole row will disappear instead of the content of the textboxes.If you are using Report Builder, you need to switch to Advanced Mode (make sure that the Properties and the Grouping windows are displayed, go to the upper right side of the Grouping window and press the black triangle), click on the second “Static” item under the “(Details)” group and you can set the Hidden property on the Properties window. [Krisztian Bocso]

 

 

SSRS and ATOM is Data Feed January 11, 2014

Filed under: ATOM,Data Feed,SSRS — sladescross @ 9:19 pm

http://social.technet.microsoft.com/wiki/contents/articles/1702.ssrs-2008-r2-atom-data-feeds-for-powerpivot.aspx

 

SSRS and SharePoint Setup

Filed under: Azure,BI,Business Intelligence,Setup,SSRS,SSRS and SharePoint — sladescross @ 9:00 pm

http://msdn.microsoft.com/en-us/library/ms157231.aspx

Windows Azure: For information on using Reporting Services with Windows Azure Virtual Machines, see the following:

 

 

SSRS Tutorial

Filed under: Jump Start,Quick Start,SSRS,Tutorial — sladescross @ 2:14 pm

https://www.simple-talk.com/sql/reporting-services

https://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/

https://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/

 

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers