.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS Datasource is linkedserver issue?

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

I have 2 SQL 2005 servers with separate SSRS installs.  Using SSRS on Server 1, I am trying to save a report that I built using Report Builder.  The report is being built from a report model on Server 2.  When I try to save the report, I get an error....Unable to bind datasource to report.


The data source may might not be accessible from the location where the report was saved.
The report was saved to "...folder/Report2".
The data source is "/Models/xxxxx".

You will no longer be able to run the report until this problem is fixed

The item '/Models/xxxxx' cannot be found. ---> The item '/Models/xxxxx' cannot be found..


Thoughts on how to get around this?



View Complete Post

More Related Resource Links

ssrs space issue

Can anyone please explain how to reduce the blank space between two rows in ssrs report, I tried with adjustingthe row hight but it does not help meJeeva Jacob

Printing Issue in SSRS reports

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

Issue with Enable and Disable Parameters in SSRS 2005

Hi Guys, I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005. Here is my scenario. I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled. When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled. I have done google search on this issue and found out that this is not possible at run time. Is there any alternative for this issue? If the above is not possible, I would like to get atleast in this way : When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL. When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL. I am not sure whether this is possible or not....but just trying to get in some way. Here is the query used in MonthDataSet : Select Month_Code, Month_Name from MonthTable. Thanks

Character spacing issue SSRS 2005 custom font

Hello together, we are facing a strange character spacing issue in SSRS 2005 SP3 (Version 9.00.4035.00). As we export the report to a pdf file, we get unwanted spaces between each character. The report uses custom fonts. Is there any known issue related to this? I appreciate your help. Thanks!  Kind regards Moritz Mars

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

SSRS 2008 Paging Issue 0 of 0

I have several reports that are many pages long when rendered in visual studio, but when rendered on the web client it show pages 0 of 0 with the next and last buttons disabled. Only the first page is displayed but if I export to any format it renders all the pages correctly. Please help!

SSRS page break issue

Hi, I am using SSRS 2005. I have developed a SSRS report which prints multiple invoices, having invoice numbers and the parameters. The report is printing multiple invoices having page break after each invoice ends. But there is a header and body section. The body section contains the line items. The issue is after the header part the body part is moving to the next page for some invoices. When the line items are less, it is printing contineously after the header. If the line items are more the whole body is moving to the next page. When I try to fix this issue, some records are printing in the same page of the header and only last record is printing in the next page leaving a long blank in the first page of the invoice. I appreciate any one can solve this issue and it will be really helpful in solving this issue. Thanks , Mahalingam

SSRS 2008 web portal issue, urgent!!

I created a report using reporting services 2008, now I want to upload the report into the web portal so that users can start running the report from the web browser. When I opened the http://server1/ReportServer url from the browser, I just see the below, I installed full version of reporting services 2008, so I am trying to figure out what piece is missing from the installation. Please advice. Thanks. server1/ReportServer - / --------------------------------------------------------------------------------       Friday, January 02, 2009 4:15 PM        <dir> Data Sources    Tuesday, January 20, 2009 10:13 PM        <dir> HR      Friday, January 02, 2009 4:15 PM        <dir> Accounting --------------------------------------------------------------------------------Microsoft SQL Server Reporting Services Version 10.0.1600.22 sqldev

SSRS Report issue blank page is coming

I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS Issue with reloading Report

Dear all, I have developed a couple of reports and could deploy them to different servers. All reports are working fine at all servers and test computers, however I cannot reload any of the reports on my own PC. I tried with IE7 and IE8 but nothing. Scenario: 1. Go to the report 2. Run the report 3. Change any of the paramters 4. Press View Report Button 5. No reloading nothing changes.   It seems like the system could not pass the new parameter value.   Could you please help me out? Thanks in advanc, Zoltan

SSRS DataSource as XML (Using WebService) Error: Credentials

Hello all, I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source. This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML. My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine. However when this is used in my DataSource in SSRS, i get the following error: "You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials." :( In the credentials tab, i am using the "Windows Authenticated"   Any help is highly appreciated. :)

SSRS IIS Permissions issue

SETUP: We have a server that runs SSRS and is also our webserver. Our reports are set up in two ways, one so that everyone can see some of the reports and a few are locked down so only admins and specific users can see and run the reports. These are set on the http://server/reports site under the security task on the report.  Issue: Some bright spark decided to change the permissions in IIS since then users can only see the "one to all reports" and not even admins could see the "locked down" reports. So not knowing much about IIS i tried to get the sites back to how they were by fiddling around with the Anonymous access and the windows authentication  on the properties on the default website, the reports site and the reports server site. I finally managed to get the users access though the reports server site but not the reports site as it has a better interface. I suddenly though of what i thought was a good idea and copped a backup to oversight the files within the sites forgetting that copy paste dosnt overwrite the permissions and now I dont have access to any site. Is there an easy way to set the permissions back to where they were and to get the sites back up.  Thanks

SSRS Report rendering issue


Hi All,

i have a chart report and deployed in server and created a subscription for sending email with webarchive type. I can see the chart in out look and it is perfect. when i see the same report in blackberry the fonts are not showing properly(blured).

I have tested via attachement as a pdf file then i can see the clear report in both outlook and blackberry but when make a mode as webarchive i getting the font problem in blackberry.

I am looking for the solution.





- Thiru

SSRS in place upgrade from 2005 to 2008 issue


I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

2008 SSRS (R2) Oracle Client issue



We have installed SSRS 2008 R2 on 64 bit windows 2003 server, and the 64 bit oracle client to connect to oracle databases.  The tnsping, and SQL plus are working from the server.  But when we trying to access the same database from report manager using new Datasource, we will get the below error.

"Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."

We have installed only the 64 bit oracle client, and the Oracle folders are given with proper permissions to access it for SQL serving account which is used to run SSRS.

Any help greatly apprciated.  Thank you.

SSRS 2005 to 2008R2 custom code migration issue


We have an SSRS 2005 report that we upgraded to 2008R2 with custom code in the report properties code tab that no longer works.  We checked permission setting in the report server config files, checked if the data set was passig nulls and it is not, looked to see if we ignored the error if the report would render the correct value anyway despite the error and it did not, tried different code variations and referencing different system libraries without luck....we are truly baffled.  The only thing that does work is setting the total to 0 and removing the loop through the jsColl to compute the total.  Here is the code that used to work on 2005.  Any ideas why it does not work on 2008R2?  We call it in an expression =Code.getTotal()



jsColl As Microsoft.VisualBasic.Collection


SSRS 2005 Render Format Excel Issue with Time Field


I have a report that uses a datetime field but gets populated only with the time. So, in SQL db, it gets stored with a default date value of 1899-12-30 12:01:01 with the correct time filled in. Report in SSRS Preview mode displays the value just fine when I use the Time format in Layout mode. I build and deploy and able to view the report in a web browser with no problem displaying the time field. But when I subscribe to the report and choose Excel render format, when I open up the Excel file from the email that was sent, I get negative decimal values. I have tried every possible Time format in SSRS but I get the same result. I also tried just the default and still gives me negative decimal values that show up as ####### in Excel.

Any help will be greatly appreciated. Thanks

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend