Plz how can i use a shared data source between all reports, because every time I change the data source name i need to edit each report before redeploy it.
View Complete Post
Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.
1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.
2) The reports use a shared data source with name ‘Test Center’
3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!
4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.
5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.
6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.
I've seen this answer for Reporting Services several times: "You cannot use a data source expression in a shared data source".
My question is: Is there any chance to use data source expressions in a shared data source at Sharepoint (Report Builder 2.0)?
Thanks in advance,
If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.
MSDN Magazine August 2009
ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls. The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.
MSDN Magazine January 2005
With over 9,000 files, and including some 1300 public classes to pore through, the Shared Source CLI can teach you quite a bit about the internal workings of the CLR. But the sheer amount of source code included can make just starting your exploration a monumental task. This article discusses some of the things you can learn from the source code facsimile of the CLR, like how JIT compilation works. It will also help you understand how to control execution along with debugging and loading classes. A walk through the steps involved in setting up the runtime will let you become familiar with the process.
MSDN Magazine July 2002
I am Visual Web Developer user and facing a problem when I am creating a local report (.rdlc) file.
I am using Business objects as the Data Source for this report. It was working perfectly until all the items in the Website Data Source window suddenly "disappeared". The "Add New Data Source" button on this window is also disabled. Now the window is just like a blank box only. And I can't continue working with the report file like this...
I have tried undoing what I did before but it does not help at all...
Any reason for this to happen? There is no sign or something at least indicating what is wrong.
ps: found a similar thread in this forum but not solved
I am binding my gridview without using a datasource control and instead doing it in the code behind. However, I would like to use the inline editing features of the gridview. Could someone please point me to an example that does gridview editing/updating 'manually' in the code behind?