SSRS Report Rendering Different In VS2005 And In Report Viewer Via URL Access

I'm using Reporting Services to render a text (stored in sql as varchar(max)). The text is all plain text, with some lines having trailing spaces.

Source text file i've imported to SQL via SSIS:
CLIENT: 10055

*Note the trailing spaces on the line before 'STATEMENT 2007'.

I've designed a report using the Report Project in VS2005 to retrieve this text via a stored procedure. When I test the report using the 'Preview' tab in the IDE, it looks good
CLIENT: 10055

But when I deploy the report and run it using URL Access:

CLIENT: 10055



On all lines with trailing spaces, they (the trailing spaces) have been removed. This is affecting my formatting of some reports and statements. We really want to use the report viewer as it has built in paging, print and export capabilities.

Why does it look okay in VS2005 but different in Report Viewer via URL Access and Report Manager?

Note: When I export as PDF, it looks okay.

The stored procedure I use to return the data is a CLR Hosted assembly as below:

Code Snippet
Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _

Public Shared Sub GetPagedDocument(ByVal inText As SqlString)
Dim dr As SqlDataReader
Dim row As New SqlDataRecord(New SqlMetaData("RowText", SqlDbType.Text))
Dim cmd As New SqlCommand("select cast(doc as varchar(max)) as 'DOCTEXT' from testdoc WHERE id='" + inText + "'")
Dim cn As New SqlConnection("context connection=true")
cmd.Connection = cn
SqlContext.Pipe.SendResultsStart(row) 'initialise the resultset to be returned
dr = cmd.ExecuteReader
'If no records in result set, return.
If Not dr.HasRows Then

row.SetString(0, "There is no document to display or you do not have permission to view the document.")
' SqlContext.Pipe.Send("There is no document to display.")
End If
'Read rows in the result set

'Get the entire text
Dim docText As String = dr.Item("DOCTEXT")
row.SetString(0, docText)
'end debug

End Sub
End Class

Any help will be appreciated.

View Replies


Viewing Ssrs Reports In Report Viewer Web Part(report Manager Url?)

i m using SQL Server 2005 Reporting services, sharepoint 2007, SQL Server SP2 and Sharepoint technologies ADD-IN tool.

i hav configured the reporting services to sharepoint integration mode. Also i hav deployed my SSRS reports to sharepoint report library.

now i want to show these reports in the report viewer and report explorer web parts. These web parts are successfully deployed.

Can someone tell me what should be the report manager url and start path in the properties of these web parts?

View Replies View Related

Setting The Report Dataset Parameter In Report Viewer VS2008/SSRS

1- I have a dataset with a SQL query statement that has a single parameter.
2- The dataset (and associated table adapter) are used in a local SQL Server report
3- The report is published using a web form and a Microsoft Report Viewer control
2- Somewhere in the VB code of the Report Viewer I want to set the value of the parameter based on program logic. It appears that the data set (and associated components, i.e. tableadapter) are not visible in the Report Viewer code>

How does everyone set the parameters in the Where clause of their query at run time? i.e.:

where parm_a is a vlaue generated inside the VB code. Except I can't make this work!

View Replies View Related

Using Report Viewer With VS2005

I'm using the report viewer control in visual studio to display my report.

When running the program locally it look good but when I deploy it to my server I got an error "The request failed with HTTP status 401: Ynauthorized".

How can I add my program to the security of my RS?


View Replies View Related

Running A SSRS Report In A Report Viewer Control In .net

Do I need the report server running in order view a SSRS report in a report viewer control? I've created my report in .net and it works great when I'm viewing it in visual studio, but can I run it my web app without the report server.

View Replies View Related

Report Viewer Control In VS2005

I'm using the report viewer control in visual studio to display my report.

When running the program locally it look good but when I deploy it to my server I got an error "The request failed with HTTP status 401: Ynauthorized".

How can I add my program to the security of my RS?


View Replies View Related

Either Rendering Tiff Images In SRS Report Viewer Or Converting Tiff To Jpg Or Gif And Then Rendering

First of all, this is not in reference to using SRS (SQL Reporting Services) to render a report and then use one of the extensions to render the complete report as a pdf, tiff, excel etc. We have an opportunity to render a list of claims and then embed the supporting docs for each of the claims within the report. We don't have an issue referencing jpg and gif images via URLs and then rendering them within the report after the grid information. We do have an issue rendering tiff images within the report.

You can insert an image object into SRS at design time and have it render and you can convert a complete report to a tiff image but I cannot find a way to be able to render a tiff image when running the report. All you get is the red "x".

My question is has anyone encountered the same issue and, if so, what did you do to resolve the issue?

Thank you,


View Replies View Related

ASP.NET Report Viewer, Slow Rendering, Image Broken


I have been using the report viewer to render my reports on a webpage. All worked fine for a time and now nothing is working correctly.

I have about ~8 report viewer on one page, all in an individual IFRAME. What happen is, sometimes I'm getting an error from IE (Internet Explorer cannot display the webpage) or the report starts loading (I see the title) but where the chart should be I have an X (broken image) icon.

Sometimes when I click on the image and choose "Display Image" the image will display.


Reports loads correctly on the report manager site (the Reporting Services webpage)
Once those errors starts appearing, the session seems to act funny and I can't even refresh the webpage (F5)
I have the latest report viewer patch installed
I have the SP2 for SQL Server 2005 installed
Running Windows 2000 Server
Running IIS 6
The website was developped using IIS 5, but was tested on IIS 6 for about 3 weeks and we started to have problems today.
The reports are linked with Analysis Services to get the data from cubes.
I'm really out of ideas right now. Maybe I should just restart the IIS server, but the thing is live and I can't do it right now. However, if I need to restart it, will the problem occurs another time? Will it become a solution to restart the server?

I already restarted Reporting Services and nothing has changed.


View Replies View Related

Possible To Access A Textbox Value On A Report Throught The Report Viewer Control?

I am trying to find a way to get the value of textbox from one of my reports after it has rendered. I am using the Report Viewer control in ASP.NET.

A little background on what I am trying to accomplish. I am capturing the Dataset commandtext in a hidden textbox to get the MDX query that is getting executed. I want to get the MDX query so that I can pass it to another ASP.NET page to be used with a pivot control by storing it in session or to a database.

I have been able to successfully use a hyperlink on a field and pass the MDX query to a page as a URL parameter for testing purposes.

1. I don't want to pass it the MDX query as a URL parameter as it is not safe.

2. Even if it was safe to do, in the event of large MDX queries, I would not be able to send the entire contents of it due to size limitations in the URL.

I have been thinking that I may be able to access a custom class in a hidden textbox that will save the MDX query and return an ID that I could then use to pass in the URL.

Any advice on how I may be able to accomplish this would be appreciated.

Thanks in Advance,


View Replies View Related

Error Rendering A SSRS Report Using ReportExecutionService Class

Hi all,

I am trying to render a report using the ReportExecutionService class render method. The report has a parameter ( Combo Box) which gets populated when the report is opened in report server. there are other parameters also. I am passing all the parameters in an array ParameterValue[] .

But the execution throws an error . I tried to catch the error using SoapException and the Error Code was "

rsReportParameterValueNotSet" for that parameter.

What i get is that i will have to paa all the parameters after opening the report so that the parameter (Combo box) get populated with the values and after that if I pass the parameters it should work.

For Example on the report server , when i open the link to the report that time it populates the data for parameter. Then i get the list of values gor the parameter.I am not able to find a way how to get this done through code.

I am not able to find any help regarding this. Please help at earliest.

Girija Shankar

View Replies View Related

Integrate SSRS With Report Viewer

Hi All,

I'm going to use report viewer to view the SSRS reports that I create. I have created bunch of reports. But I can publish only one report on report viewer. How can I publish more than one reports there just like on report manager. Can I view those reports just clicking links of each reports? How can I make links?
When I use reportview in visual studio it allows me to create only one report and when I dploy it straightaway it brings up the report in web form, but not the link like we see on report manager.
Is there anyway I can create links for each reports?

Or in other words, I want to integrate report server and report viewer. But I dont have a very good idea about report viewer.
So please can anyone explain the basic steps?


View Replies View Related

Integrating SSRS With Report Viewer

Hi All,

I'm going to use report viewer to view the SSRS reports that I create. I have created bunch of reports. But I can publish only one report on report viewer. How can I publish more than one reports there just like on report manager. Can I view those reports just clicking links of each reports? How can I make links?
When I use reportview in visual studio it allows me to create only one report and when I dploy it straightaway it brings up the report in web form, but not the link like we see on report manager.
Is there anyway I can create links for each reports?

Or in other words, I want to integrate report server and report viewer. But I dont have a very good idea about report viewer.
So please can anyone explain the basic steps?


View Replies View Related

SSRS And ASP.NET Multiple Reports Within One Report Viewer


I am writing an app that will allow a user to select various information for displaying in a report. The sql is dynamically generated when the user clicks on "Get Report". Currently, I am using a gridview with a datasource and I pass the query to the datasource and it displays in the grid view. However, our company has expressed a need to migrate reporting to SSRS.

Is there any way that I can use dynamic sql with a template report and feed the dynamic sql to it so that all I would have to do is write a single rdl or rdlc and pass it the sql?

Alternatively, is there a way to have One ReportViewer show multiple parameterized reports. Ie. User selects the report from a dropdown and then selects the parameter options from other dropdowns and when they click "get report" it loads the chosen report with the parameters?

Thanks in advance.

View Replies View Related

How To Figure Out If The Dataset Returned Any Data Or Not While Rendering The Report Through The SSRS Web Service

In one of my projects, i have been using the SSRS web service to render a report as pdf and then manually emailing it out.

I need to know whether the data set for the report returned any data or not (so that i can avoid emailing the report with a blank report body).

Ofcource this can be done by executing the same query (same as the query for the report) from C# code and checking the count of the resultset, before calling the SSRS Render method. But it might not be an efficient method.

Was wondering the the SSRS Web Service provides an property or method that can let me figure out whether the resultset was empty or not (after the report execution).


View Replies View Related

Help Needed: Export From Report Viewer &&amp; RDLC From SSRS Server

I'm have two issues I need to work out.

1) - I need to get the RDL (the RDL format merged with the data, like a rendered report in RDL format) - to pass back to the client Report Viewer. Is there a way to do that? I do not see that as an optional output types.

2) - I need to export to a specific file/path from the client side Reportviewer.. Is this possible? Is there a lower level API for this?

Thank you,

View Replies View Related

Questions On SSRS Server RDLC XML &&amp; Report Viewer Export

I have a couple of quick questions on the SSRS server and getting the RDLC file (compiled Report file) from the server and how to programmatically control the print functions from the report viewer.

What we are trying to do is limit the functionality to the front end user, have an audit of what action were that were taken place, and lastly to export to a PDF/Tiff file, if any doc is printed or emailed.

To do this our app calls our web service with the report data, the web service works the server to render the report, then I would like to have the RDLC XML to pass back to the client to render on the local report viewer.

We want to allow them to print, email, or save a PDF of the report - but we have to control that so that we can keep an audit log of each action that has taken place.

The print dialog was easy, but now I am working on exporting the report to just a PDF file so that it can not be altered via the local viewer.

Any help would be greatly appreciated.

Thank you,

View Replies View Related

SSRS Report Viewer Execution ' ' Cannot Be Found (rsExecutionNotFound) Reserved.ReportViewerWebControl.axd

Re: SSRS report viewer Execution ' ' cannot be found
(rsExecutionNotFound) Reserved.ReportViewerWebControl.axd

Every now and then, my users get this error while in the Reportviewer.

Usually, they have to close the window where the report was rendered
and pull it open again. Attempting to open the report again does not

What is this?

I run the report viewer like this:

<rsweb:ReportViewer BackColor="Transparent" ZoomMode="Percent"
width="100%" ProcessingMode="Remote" ID="ReportViewer1"
<ServerReport ReportPath="/myfolder/myreport"
ReportServerUrl="http://myserverr/reportserver" />

In my web config:

<compilation debug="true" strict="false" explicit="true">
<add assembly="System.Data.OracleClient, Version=,
Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="Microsoft.ReportViewer.Common, Version=,
Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="Microsoft.ReportViewer.WebForms, Version=,
Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider,
Microsoft.ReportViewer.Common, Version=, Culture=neutral,

<add path="Reserved.ReportViewerWebControl.axd" verb="*"
Microsoft.ReportViewer.WebForms, Version=, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>

Thanks for any help or information.

View Replies View Related

Exact Datetype Not There In Number Fromat In Format Cells At The Time Of Rendering Ssrs Report Into Excel

i have ssrs report with contains 3 fields like start date, end date, percentage value, for these fields i given date and percentage fromats in format tab of the textbox, i export this report into excel sheet,

what is problem is , in the excel sheet i select the date or percentage column and select the format cells option and selected the number format,but here i did not seen any format like date or percenatge format what ever i given datatype in report and it shows general format only for all columns.

here i need solution like when clicking the number format in format cells it shows defaultly appropriate dateformat like date or percentage format at the time of rendering into excel.

i think it is bug in ssrs , any guy please help me

View Replies View Related

VS 2005 Default Report Viewer Vs. Report Manager Viewer

I have designed a few SSRS reports in VS 2005 and gotten them to render correctly in the VS report viewer (Preview pane, including Full Screen) as well as in PDF and TIFF export from there. However, when I launch them from the web-based Report Manager, the default viewer floats all the lines and rectangles after the text, making the output unusable for client verification (although PDF and TIFF exports are fine).

Can anyone tell me why these are different? Is there a way to set the default viewer in Report Manager? I am using Express edition, but a co-worker uses full SQL and gets the same bad results.

View Replies View Related

Rendering A Report On SQL Server 2005 In An Access Application Using VBA


I would like to use ReportExecution2005.asmx to render a report stored on a SQL Server 2005.

How may I code this VisualBasic source example in Access VBA?

Private Sub renderReport(ByVal sReportname as string, ByVal sOutputfilename as string)

rs.LoadReport(sReportname, Nothing)

Dim results() as [Byte]

results = rs.Render("PDF", "", "", "", "", Nothing, Nothing)

Dim stream as = System.IO.File.OpenWrite(sOutputfilename)

stream.Write(results, 0, results.Length)


End Sub

Thank you for any help.


View Replies View Related

How Do I Provide Anonymous Access To The Report Viewer

In remote processing mode, I am receiving the following error when I view a report in the browser: HTTP status 401: Unauthorized.

I have SQL server 2005, Microsoft Internet Information Services (IIS) 6.0 , Windows Server 2003 running on a virtual PC.

I am using Visual Studio 2008 to create a webpage with a reportviewer.

We are using Windows Integrated Security. How do I provide anonymous access to the report viewer?

View Replies View Related

SoapException While Rendering Report Through WebService - Error During Processing Of ‘ReportParameterTime’ Report Parameter

I am extracting RS reports through a WebService:
report = execService.Render("EXCEL", null, out extension, out mimeType, out encoding, out warnings, out streamIds);

Some works fine but some are generating the following SoapException:

Error during processing of ReportParameterTime report parameter. ---> Error during processing of ReportParameterTime report parameter. ---> Error during processing of ReportParameterTime report parameter.
I set required parameters to their default values. In this specific report I have two required parameters:
1: ReportParameterTime, String
2: ReportParameter1, String

I set them to their default values (ReportParameterTime to "[Czas].[Kalendarzowy].[Rok].&[2007]" - means
Time Calendar Year 2007) but I am getting the exception above. I set parameters using this code:

execService.SetExecutionParameters(parameterValues.ToArray(), CultureInfo.CurrentCulture.Name);

Where parameterValues is a List<ReportExecution2005.ParameterValue>.

When I am using Microsoft.Reporting.WinForms.ReportViewer the report is generated without
any problems. I can see one parameter to choose: "Kalendarzowy" (means adj. Calendar) and can
select years, the default value is "2007".

What am I doing wrong and how can I fix this error ? Does anybody know ?


View Replies View Related

'Dynamic Time(year,month,date)' Report Template (rdl) Using Report Designer VS2005

I have three types of specific reports that i have to create with the input parameters (range) either

1: By date (rdl 1)

2.By Month (rdl 2)

3.By Year (rdl 3)

Is it possible ( or how do I ) to create just one report template ( one rdl) with the three sets of parameters ( hiding/invisible which ever two sets base on user selection) and the output of the report will display the desired type( either by year, month or date).

I ask this because its possible to create a drill down report from year down to date etc in report designer (vs 2005). Not sure if I can create one instead of three rdls and with the 'logic' built within that template.




View Replies View Related

Reporting Services Report Viewer Versus Report Server Problem

Hi I have several reports that I have imported from Access into SQLReporting Services 2005. They are multi-level grouping reports and SQLServer Reporting Services generates rectangles and lists within lists tomake them work. I then go in and set the visibility conditionally on thevarious rectangles to hide them where there is no data in a group.The problem is that the reports work fine when they are on a report serverin particular all the white space for hidden rectangles etc. shrinks up andleaves no gaps.However when I import them into my Visual Studio 2005 project and changetheir extension to rdlc to make them work with the Report Viewer the whitespace for hidden controls does not shrink up and leaves up to 3cm verticalgaps between rows so the reports are unusable.The internal controls in the rectangles are quire close together and is thisanything to do with controls that overlap in the Report Viewer but not onthe Report Server?Oh Gurus, are the engines the same or does it have anything to do with theInteractive setting for example?Any help would be most gratefully appreciated !(You can always tell the pioneers because they are the ones that ride offinto the sunset with the arrows in their backs)

View Replies View Related

Report Viewer Jump To Issues With Relative Intra-report URLs


Very strange phenomenon with the "Jump to report:" Hyerlink Actions when I deployed my reports to the production servers:

The Actions no longer funcioned properly when attempting to go to one report to another. Sometimes, the same report would come up and sometimes a different report. It appeared that whatever mechanism Report Server uses to construct the proper URL when using "Jump to report:" is unreliable(or the URL is not being honored by the web-server).

All this is happening under the Report Viewer control. I have had to do a painful fix of manually constructing the entire absolute URL and including the reportviewer control in the url.

Any way to get back relative Jump to report: URL's?

Thanks JS

View Replies View Related

Passing Parameter To The Sql Server Report Using Report Viewer Control


I want to give filtering criteria in my SSRS report.

I have drop down list control having list of Email's of clients.

So, how can i pass the value of the particular Email id in my SSRS report using Report Viewer control?

How can i pass user input as parameter in my report using visula studio 2005?



View Replies View Related

Problem With Report Viewer , No Data Is Displayed And Report Comes Out As Empty

Hi ,

I have a problem using Report Viewer With SQL Reporting Services 2005.

I had a really weird issue with a ReportViewer. It would show the little green Loading progress bar image but it wouldnt show any data, just a white background where the output should be. I knew the data was there because exporting to Excel or PDF showed the data just fine.

The problem is report toolbar is display but NO DATA is displayed and the report comes out as EMPTY .

Thanks in advance..

Can you please help me out in resolving this problem.

View Replies View Related

Report Explorer And Report Viewer Webparts Not Working With New WSS 3.0

I just installed a fresh lab machine with WSS 3.0 and SQL 2005 SP1. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.



View Replies View Related

How To Pass Parameters From Report Viewer To Report Server


I am having hard time in sending parameters to the report server through reportviewer control from my application. Could anybody help me on this issue?. Is there any way to send the parameters and also what kind of configuration do i need on my report project so that it can accept parameters from my application.


View Replies View Related

SSRS - Import Access Report

I am running the November Katmai CTP and am attempting to import an access report in the Business Development Studio. I am running vista ultimate and office 2007 professional. However, when i attempt to load the report i get there error 'Could not load file or assembly Interop.Access....'

Has anyone else come across this? do i need a specific version of Access installed locally in order to use the import mechanism?
Thank you

View Replies View Related

Convert Access Report To SSRS


I'm using this query to generate a report. When I preview the report I should be able to select values from parameter drop down list for the following fields.
frmMain( is access form type. wonder how do I get this as a parameter to my ssrs report. how do I make available data set for this one?. I can not see available data set for this one when i click drop down menu in report parameter box)

But when I run the query I can see only date parameters. I can not see anyotehr parameters. I can add parameter and select fields like officerName, OfficerId etc. But it does not work when i preview it.

Actually one of the developers has created a stored proceedure for this report. He already created an Access report, What I really want to do is recreate it in SSRS or convert into SSRS. But in either way, this parameter thing does not work.

Here is the code;

Code Snippet
(@FromDate DateTime, @ToDate DateTime)



b.Title AS BorrowerName,
0 AS TReimbursement,

INNER JOIN .adBorrowerObligation bo on m.Borrower_Obligation_ID = bo.BorrowerObligationID
INNER JOIN .entity_to_obligation eto on bo.BorrowerObligationID = eto.Borrower_Obligation_ID and eto.entity_type_id = 1
INNER JOIN .adEntity b on eto.Entity_ID = b.EntityID


b.Title AS BorrowerName,
0 AS TExpense,
INNER JOIN adBorrowerObligation bo on r.Borrower_Obligation_ID = bo.BorrowerObligationID
INNER JOIN entity_to_obligation eto on bo.BorrowerObligationID = eto.Borrower_Obligation_ID and eto.entity_type_id = 1
INNER JOIN adEntity b on eto.Entity_ID = b.EntityID
WHERE (r.CREATE_BY_DT >= @FromDate)
AND (r.CREATE_BY_DT <= @ToDate)


can anyone help me out to design this report?

Thanks in advance

View Replies View Related

SSRS Report Access From A Network Machine


I have created and deployed an SSRS report, which I am able to access from the same machine using the URL. But I am not able to access the URL from a another machine in the same network.

What could be the problem, do I need to make some configuration changes to the reporting server?

View Replies View Related

View Report From Report Viewer Control

I have created several reports using report builder. I can view these reports from the report server homepage but i can't view them from my windows forms app. The structure is such that my report url should be


however if i browse to my report in the report server home page the url looks more like


if i type the first url into a browser, I see a directory listing.

Setting the ReportPath property for my report viewer control to either




does not result in my report being displayed. Can anybody tell me what is wrong with my setup.

View Replies View Related

Copyrights 2005-15, All rights reserved