Search Results

Can’t use Sub Reports and Shared Datasets in BIDS - Data Retrieval failed for the subreport '###', located at ### Please check the log files

SQL Server 2008 R2 brings us a great new feature of shared data sets. This allows datasets used by parameters and multiple reports to be defined in one place and used in multiple reports. I’ve been developing a report for SQLBits that required use of sub reports. They all use a shared data set for the...
Posted by simonsabin

SSMS Custom reports - Drill through reports

If you intend using the new custom reports feature of Management Studio and develop a set of reports that you can navigate between then be aware of a feature where by if you refresh a drill through report the some of the parameters are not maintained. For a full explanation have a look at the bug submission...
Posted by simonsabin

Hyperlinks in custom reports

One feature introduced in SQL Server 2005 is reporting in management studio. You have a set of standard reports that allow you to see in a nice report format output from dmvs and the default system background trace. Whats neat is that you can write your own custom reports. For those that long after the...
Posted by simonsabin

Custom reports in SQL 2005 SP2

You may have come across the fact that in SP2 you can deploy custom reports that are accessible in management studio. This reports can be run from any context in the object explorer tree. Whilst I think this is really interesting, I haven't played with it much, but Anthony has read his blog post...
Posted by simonsabin

Enabling SSIS packages in Reporting Services Reports

I hadn't tried writing a report based on an SSIS package on the RTM build until tonight. I couldn't understand why the SSIS options where not in the datasource builder. After a bit on investigation I found the following article in BOL " Configuring Reporting Services to Use Integration Services Package...
Posted by simonsabin

How to get the disk usage report working

If you've downloaded the SSMS reports and want to get the Disk Usage report working. Follow these steps. Remove all comments from the data sources, it seems that RS ignores CRs when the SQL is specified as an expression. This means that anything that appears after the comment is treated as part of the...
Posted by simonsabin

Whats the problem with reporting ?

Its the reports.   Take this for example, it is a report generated during a demo of Report Builder 3.0 by someone in MS marketing. She says things like “..and you can see easily how my divisions are doing”. No you can’t you’ve just got a bunch of numbers. This is really the issue with reporting...
Posted by simonsabin

Writing c# in custom code or reports

This bugs me everytime I use reporting services custom code. Why do I have to use VB.Net to write my custom code. Why can’t I use c# So I raised a connect item https://connect.microsoft.com/SQLServer/feedback/details/613957/need-to-be-able-to-use-c-in-reporting-services-custom-code If you feel the same...
Posted by simonsabin

Do you want custom reports to run against SQL2000

I personally get realy annoyed that I have to go back to Enterprise manager to be able to run the taskpad report. If you agree then make sure you vote on it here https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=240476 Then you will be able to use the taskpad custom report...
Posted by simonsabin

What I would like changed about Reporting Services. What would you like changed?

I recently asked a few questions about some features I was surprised weren’t in reporting services. The response I got from the team was,”raise them in connect and get them voted for”. So thats what I’ve done. Here is a list of the items I’ve raised as well as items I’ve found that I think should be...
Posted by simonsabin
More Posts Next page »