Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Winforms ReportViewer VS2005 - Report Margin Problems


 

Hi,
 
This link describes my problem exactly:
 
http://blogs.msdn.com/mattweber/archive/2006/07/11/correcting-the-printed-margin-calculation-of-the-windows-forms-reportviewer-control.aspx
 
It says the solution is in VS2008 but does anyone know if any of the updated ReportViewer redists include a fix for this problem?
 
As a workaround I am using the webforms version to PDF but it is not ideal.
 
Thanks
 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Multiple Rdlc Files In One Winforms ReportViewer Control
 
How can I add multiple rdlc report definitions to a single Winforms ReportViewer control? I would like to start with the first rdlc and concatenate subsequent rdlc files after that. I want the user to be able to scroll through several different rdlc report definitions as if they were all just one report.

View Replies !   View Related
Invalid/blank PDF Created On Export From WinForms ReportViewer
I have a VS2005 C# winforms application that reads a SSRS request from a table and using the ReportViewer control produces a report and then exports in one of a number of formats via a specified path to a share on another server. This normally works without issue, however today I have had three instances of invalid or blank PDF's being produced. A sample error from the Acrobat Viewer is "There was an error processing the page. There was a problem reading this document (109)."

The software version are as follows:

Host Server: Windows Server 2003 with Sp1.

SQL 2005 with Sp1.

Acrobat reader: Version 7.0

By deleting the PDF file, resetting the processed flag to un-processed, the report was run again, and this time a perfectly readable PDF file was produced. As neither the source data nor the report definition file was updated during this time period, how it works at one time but not previously is currently inexplicable. I have run the report manually with the same input parameters using Internet Explorer and exported it successfully to another location.

Any ideas as to what is going on?

A fix to the winforms application will be to delete any existing file before exporting a new one.

View Replies !   View Related
Problem Using Visual Studio 2008 Winforms ReportViewer
I have an application built using VS 2008 (3.5 fx). I build a series of
reports (using VS 2005 (sigh)) and am now tryiing to render them using a
Windows form and the ReportViewer control in the VS 2008 app. However I
always get the error message "The source of the report definition has not
been specified" when I execute the line

   m_reportViewer.RefreshReport();

When I try to view the very same report in a VS 2005 app it renders without
error.  I can also view the report using Report Manager and preview it in the
VS 2005 app I use to build it. Any suggestions?

Thx

Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com

View Replies !   View Related
Really Weird Problem: WinForms.ReportViewer Slow Down The Whole Application
Hi,
 
I'm developing a desktop application using CAB and DevExpress 6.3 controls. I use ReportViewer control to render .rdlc reports under local mode.
I loaded data source from a dataset, template definition from a string, called the Refresh method of ReportViewer.LocalReport, so far, all are OK. But once I call the RefreshReport method of ReportViewer, the whole Application slows down, even after I closed the report viewer form. Operations like switch between menu items, open a new form and resize the main form become double or triple slow, CPU usage is keeping in 100% while doing those operations... I've no clue how refreshing report affects all those UI drawing...
However, if I break down and jump over the RefreshReport method, an empty report form shows and every thing keeps OK.
After all, all the reports can be rendered and shown correctly finally...
 
And seems there is nothing to do with the templates and data source, the templates are very simple, and event if I render the reports with empty data tables, it also slows down my application.
I tried to create and run the form in a new thread, tried to upgrade to ReportViewer 9.0, but both seem useless.
 
Could any body help me on this problem? 
Thanks in advance.
 
 
 
 

View Replies !   View Related
Localization Web ReportViewer Control In VS2005
Hi everyone,I followed the steps below to localize the report viewer control accoring to http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx"
Deploying Localized Versions of ReportViewer ControlsThe ReportViewer control includes language packs for eight languages: Chinese-Simplified, Chinese-Traditional, French, German, Italian, Japanese, Korean, and Spanish. To use a localized version of the control, you must do the following:1.      Run ReportViewer.exe.2.      Navigate to the folder that contains the language pack you want to use. Language pack folders are located at <drive>:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesReportViewer<lang>.3.   Run ReportViewerLP.exe."
But I could not find the ReportViewerLP.exe in the step 3. Could anyone please tell me why?Thanks a lot.Danny

View Replies !   View Related
VS2005 ReportViewer HTTP ERROR 401 Unauthorized
Hi, can anyone help with this pls - it's getting very fustrating! there seems to be some messages and text on this issue (looks like a common problem that MS haven't published anything about yet!) but nothing I could make heads or tails off... so any help here would be very useful!

I'm using VS2005 (release, NOT beta), the new reportviewer web control and an ASP.NET page - really basic, nothing fancy. I've set the reportviewer properties to:

ReportServerURL= http://mytestserver/reportserver

ReportPath = /AdventureWorks Sample Reports/Company Sales

I'm testing the ASP.NET page is on my local machine - and the reportviewer is connecting to a remote test server (W2k3 SP1). When I view the page, then I get

HTTP ERROR 401 Unauthorized

Directory Security on the report server is Windows Authentication - W2K3 with SP1 and Reporting Services 2005 (release, NOT beta)

Directory Security on my local machine is Windows Authentication - XP SP2 and VS2005 (release, NOT beta)

Any ideas pls?

 

 

View Replies !   View Related
VS2005 Reportviewer - Documentmap - Collapse/Expand All Items
Is there a way to expand/collapse all items in the documentmap ?

I know there is an option DocumentMapCollapsed but this is to collapse/expand the documentmap panel. I would like to control the collapse state of the items into the document map ...

 

 

thanks in advane

View Replies !   View Related
Localize Web ReportViewer Control In VS2005 / SSRS 2005 / ASP.net 2.0???
Is it possible to translate the web report viewer control to another language (german, french...)? I need to integrate the control in a multilingula website.

I need also to change the messages from the report during the rendering "Report is being created".

And is it possible to change the little green animated icon during the process of creating a report?

Thanks,
Dirk

View Replies !   View Related
The Margin Width Between A Report And Subreport
Hi,

I have a report which includes a subreport. I would like to position them in a vertical position so that they like like just one report.

I have placed them within a rectangle but there is still quite a vertical distance between them and I cannot find any margin properities to fix this.

Would appreciate any hints,tip & advice.

Thanks,
John

View Replies !   View Related
2005 Report - Margin Issue
When working on this report on my local machine, the left and right margins are set to .25. The fields and fieldheaders were not wrapping. After I deploy it, the margins are increased or the tables are resized and this causes the fields and field headers to wrap again.
 
What could be causing this. Is it Setting on the server?
 
 
 
 
 
 

View Replies !   View Related
1 Inch Added To Bottom Margin Of Report
I'm having a relatively big issue with printing my check report. The report continues, time after time, and regardless of the margins I choose for the report, to be displaced an additional 1" up from the bottom of the page. The printing method is through our newly designed application which sends the emf rendering to the printer. We have gone through the liberty of modifying the actual print document in VB with margins set at 0,0,0,0 (L, R, T, B) and have paid close attention to the printer's maximum printing area. We have come to the conclusion that the problem is coming from reporting services. In addition to the extra margin space on the bottom of the page, there is also a slight yet noticeable shrinking of the page. Despite the fact that those are trade symptoms of another issue after the emf rendering we have modified every possible function of the printdocument and printer settings. So we continue to push the question, is this reporting services? We are fairly certain. I'm asssuming this is a bug in SSRS 2005, yet, I have yet to hear of any similiar case. This is our VS version info just incase:

Microsoft Visual Studio 2005
Version 8.0.50727.762  (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: Enterprise
Microsoft Visual Basic 2005   77642-113-3000004-41917
Microsoft Visual Basic 2005
Microsoft Visual C# 2005   77642-113-3000004-41917
Microsoft Visual C# 2005
Microsoft Visual C++ 2005   77642-113-3000004-41917
Microsoft Visual C++ 2005
Microsoft Visual J# 2005   77642-113-3000004-41917
Microsoft Visual J# 2005
Microsoft Visual Studio Tools for Office   77642-113-3000004-41917
Microsoft Visual Studio Tools for the Microsoft Office System
Microsoft Visual Web Developer 2005   77642-113-3000004-41917
Microsoft Visual Web Developer 2005
Visual Studio 2005 Team Edition for Developers   77642-113-3000004-41917
Microsoft Visual Studio 2005 Team Edition for Software Developers
Crystal Reports    AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005

Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service Pack 1 (KB926601)  
This service pack is for Microsoft Visual Studio 2005 Premier Partner Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/926601
SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 9.00.1399.00
SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00
SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00


 I'm planning to talk to MS if nobody recognizes these symptoms. Any ideas would be greatly appreciated! Thanks!
 
 
 
UPDATE (12/20/2007 1:43:07 pm):
We have made a small break-through discovery. We found that that if we convert our report using a pdf rendering that the additional 1 inch added to the bottom margin is no longer there. So, pdf rendering would be an option if we became more desperate.  However, this is too time consuming and we would much rather have the report directly sent to the print spooler instead of loading then spooling. Does anybody know what is going on with this apparent conflict between SSRS 2005 and our emf renderer?
 
 

View Replies !   View Related
Best Way To Launch Report From A C# Winforms App?
I'm new to SSRS.  I would like to launch a report from a C# desktop application, supplying parameters programatically.  I was able to do this using System.Diagnostics.Process p ... then p.Start(@"(path)iexplore.exe","(reportURL)");  I'm betting there's a much better way to do this.

Ideally I would like to create an IE window that shows only the report, that is, only the report viewer toolbar is visible, the IE toolbars and menus are hidden.  I want to specify IE as the browser in case some other browser is installed as the default web browser.

Can anyone link me to a tutorial or provide a code snip?  Thanks.

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.

Thanks

Regards

Alu

View Replies !   View Related
SSRS Report Rendering Different In VS2005 And In Report Viewer Via URL Access
Hello,
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
                               STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1       COLUMN2          COLUMN 3
TRY THIS


*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
                               STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1       COLUMN2          COLUMN 3
TRY THIS


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

CLIENT: 10055
STATEMENT 2007
DATE:1002993

THIS IS THE OTHER STATEMENT

COLUMN1 COLUMN2 COLUMN 3
TRY THIS
 
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")
cn.Open()
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.SendResultsRow(row)
SqlContext.Pipe.SendResultsEnd()
' SqlContext.Pipe.Send("There is no document to display.")
Return
End If
'Read rows in the result set
dr.Read()
 
'Get the entire text
Dim docText As String = dr.Item("DOCTEXT")
'debug
row.SetString(0, docText)
SqlContext.Pipe.SendResultsRow(row)
SqlContext.Pipe.SendResultsEnd()
Return
'end debug
 
End Sub
End Class
 
 


Any help will be appreciated.

View Replies !   View Related
Require Help In Reportviewer ....My Report Is More Thn 10 Mb Unable To Export Report
 

Hi,

Im displaying reports in reportviewer.This is a Webapplication.My report consists of 100 grpahs.Total size of report .rdl is 15mb.ZSince it is 15 mb.Im Unable to export to PDf format r download report.Even it is not wrking in report manager.Possibly any solution for this..

 

With regards,

Mahender

View Replies !   View Related
Using Report Viewer With VS2005
Hi,
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?

Thanks.

View Replies !   View Related
Report Template In The VS2005 Is Gone!
I have installed VS2005 professional with SP1 and SQL Server 2005. Also installed are Web Application Projects 2005 and Microsoft Visual Web Developer 2005.  Somewhere along the line I lost my Report Templates. There is no Report template in the New Item choices for the project and clicking the New Report in report viewer control smart tag does nothing. They are nowhere to be found. Has anyone else had this problem and been able to resolve it.  How. Thanks Zulu

View Replies !   View Related
Calling RS Report From VS2005 C#
Hello,

From a web application written in Visual Studio 2003 or Visual Studio 2005, C#, is there any way to send a SQL 2005 report directly to a local printer, while bypassing the standard Windows Print dialog box and printing 3 copies of the report(we could just loop the call 3 times if specifying a number is not possible)?

Perhaps there is some kind of api we can use??

Thanks

Sam

View Replies !   View Related
Report Viewer Control In VS2005
Hi,
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?

Thanks.

View Replies !   View Related
Report In MemeoryStream And ReportViewer
Hi All,

Is it possible to display a rdlc file stored in MemoryStream using Report Viewer control?

Regards

Stan

View Replies !   View Related
Report Render In VS2005 Slower Than Stored Proc
I have searched many forums and found some cases of people also reporting slower rendering in RS than in Management Studio / Query Analyzer.  However, none of the other solution suggestions seem to make a difference for me.
 
I'm a VS/VB developer and have got multiple reports built -- all using stored procedures on the backend -- that all take many times longer to run than if executed via Management Studio (SSMS).  My simplest proc takes a couple of parameters (no defaults included) and does a simple select against one table with a few joins.  Nothing complicated.  It runs in 8 secs for 6867 rows via SSMS.  Through RS (running locally through Visual Studio 2005 at this point) it takes around 25-28 secs.  Yet, when I'm in the report on the DATA tab (not the PREVIEW tab) the run takes the expected 8 secs ?!?!
 
All reports are behaving this way.
 
I am not using cursors.
I have no default values on parameters.
I have added the "WITH RECOMPILE" to the proc statement.
I have "SET NOCOUNT ON" as the first line of the proc.
I hate to say this, but I even connected the proc to Crystal Reports to see how it behaved.  It ran in the expected 8 secs.
 
I've seen some mention by someone that perhaps this is a known issue of RS that it reads the proc twice.  Any truth to this?
 
Also a couple posts have traced and demonstrated that the report is generating significantly more data "reads" via RS than through SSMS.
 
We're a shop that is considering a switch from Crystal to RS, but we do everything through stored procedures.  I need to clear up this issue before I can go forward recommending a switch.  I'm including a copy of a typical proc below for review...  What am I missing?  What's the deal here with RS?
 
 

IF OBJECT_ID('dbo.rpt_InactiveAccounts') IS NOT NULL

DROP PROCEDURE dbo.rpt_InactiveAccounts

GO

 
CREATE PROCEDURE dbo.rpt_InactiveAccounts

(@pRunDate datetime

,@pSalesperson varchar(5000)

,@pIncludeOpen char(1)

)

WITH RECOMPILE

AS
 

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

 

-- CREATE/SETUP TEMP TABLE FOR USE IN PARSING MULTI-VALUED STRING INPUTS

DECLARE @NumberPivot TABLE (NumberID INT PRIMARY KEY)

DECLARE @intLoopCounter INT

SELECT @intLoopCounter =0

WHILE @intLoopCounter <=4999 BEGIN

INSERT INTO @NumberPivot

VALUES (@intLoopCounter)

SELECT @intLoopCounter = @intLoopCounter +1

END

 

-- CREATE TEMP TABLES TO HOLD PARSED VALUES FROM MULTI-VALUE STRING INPUT PARAMETERS

DECLARE @SalespersonTable TABLE

(tmpSalesperson varchar(30))

 

-- PARSE OUT @pSALESPERSON PARAMETER AND STORE VALUES IN TEMP TABLE

INSERT INTO @SalespersonTable

SELECT SUBSTRING(',' + @pSalesperson + ',', NumberID + 1,

CHARINDEX(',', ',' + @pSalesperson + ',', NumberID + 1) - NumberID -1)

FROM @NumberPivot

WHERE NumberID <= LEN(',' + @pSalesperson + ',') - 1

AND SUBSTRING(',' + @pSalesperson + ',', NumberID, 1) = ','

 

SELECT DISTINCT

CASE

WHEN s.Name IS NULL THEN '<< OPEN >>'

ELSE s.Name

END As SalespersonName

,c.ClassId

,c.CustId

,c.Name

,c.Addr1

,c.Addr2

,c.Addr3

,c.City

,State

,CASE

WHEN Len(c.Zip) = 9 And CharIndex(' ', c.Zip, 0) = 0 THEN Left(c.Zip, 5) + '-' + Right(c.Zip, 4)

ELSE c.Zip

END As Zip

,ac1.descr As Terms

,ac2.descr As Status

FROM

ACTCustomer c (NOLOCK)

LEFT OUTER JOIN CustSales cs ON c.CustId = cs.CustId

LEFT OUTER JOIN ACTSalesperson s ON cs.SlsId = s.SalesId

INNER JOIN @SalespersonTable st ON s.Name = st.tmpSalesperson OR (s.Name IS NULL AND @pIncludeOpen = 'Y')

INNER JOIN ACTCode ac1 ON ac1.Code = c.Terms And ac1.FieldId = 'CustTerms'

INNER JOIN ACTCode ac2 ON ac2.Code = c.Status And ac2.FieldId = 'Status'

WHERE

c.LastInvcDate <= @pRunDate

And c.ClassId <> 'TR'

ORDER BY

SalespersonName, Name, CustId

View Replies !   View Related
Accessing RS2000 Report URL From VS2005 Aspx File
Hi Friends,

 

We have developed one report in RS2000 which is developed in VS2003 environment.

When we are accessing the hosted report URL from an aspx page of a project created in VS2005, it says incompatible version. Is it possible to access reports this way?  Please help.

 

Thanks in Advance,

Ravi Kota

 

 

View Replies !   View Related
Multi-table DataSets In VS2005 SRS Report Designer
Hi all,

 

I need to use a multi-table dataset as a datasource for my report items in a SRS2005 report.

But from designer, I can only see the first table.

 

Can any one tell me if it is possible to use multiple tables in a dataset for SRS report?

 

Thanks,

 

Samson

View Replies !   View Related
Change Query Of Report In Reportviewer
Hi,

 

I have a reporting services report that i show in an asp.net page by a reportviewer control.

Is there a property that i can set in my asp.net page, to change the query for changing the data in my report.

The number and names of the columns will be the same.

 

I should work with parameters, but the query changes more than just a few where-clauses. So i think working with parameters looks impossible.

 

 

Thanks,

Dennis

 

 

 

 

 

 

View Replies !   View Related
ReportViewer Not Correctly Rendering Report
Hi,
 
I have a report viewer control within a web user control which i am using to display the report. The report has been designed within a Visual Studio Report Server project and it looks fine when previewed here but when i deploy the report to the reporting server the table rows within my report become stretched and there are other formatting issues, the formatting issues occur when the report is viewed from both reporting services server and my webpage. When the report is exported to a pdf  from my website it looks fine why is the report not rendering correctly.
 
Has anyone else had this issue?
 
NOTE: I am using IE7

View Replies !   View Related
Fields Of Form In The ReportViewer Report
Hi,

 

I have a report (rdlc) in my WinForm project that the data are filtered in accordance with two dates: Initial and End. These two dates, the user inform in a Form of the project. Well, what I need I am to inform in the report these two dates. How that I make to pass these two dates of form for the report?

 

Thank you!

View Replies !   View Related
Printing Report Directly Without Using Reportviewer
 

Hi,
 
My Requirement is to dirctly Print the SSRS Report without using Reportviewer.
If anybody know How to Print Report without using Reportviewer, please let me know asap.
 
Thanks in advance.

View Replies !   View Related
Exporting A Drillthrough Report Via The ReportViewer
Hi All,
 
I am working with a report that is viewed on the web via the ReportViewer web control.  The report contains a drillthrough field (A "Jump To" report) so that when a field is clicked a new report is run in the reportviewer.  This works wonderfully, however when I click the Export button (the bulit in ReportViewer export) the original report is exported instead of the new drilled to report. 
 
Is this normal?
Is there anything I can do to fix it?
 
Please let me know if there is any information I have left out!
 
 
Thank you all in advance!

View Replies !   View Related
Probleam With ReportViewer Jumping To Report
Hi,

We have an ASP.NET application using a ReportViewer to show reports. I have two reports (both with logo - image - in yours headers):

    - Report A: with action to jump to Report B.

    - Report B: with action to jump to Report A.

This work fine into BID and into Report Manager, but into our application, when I click in first link into Report A, show me the Report B, but our logo isn't visible. If I try to return to Report B (clicking in action), show me this error:

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

May I need to configure something into my web.config to work fine too?

Thanks.

View Replies !   View Related
VS2005/SSR2005 Report Controlling Field Visibility By Code
VS2005/SSR2005 Reporting: How can one control an individual report fields visibility (toggle on/off) at run time, based on data values (of the same field or another field) in the report. Without user having to sit there and "Click".

Thanks

Zulu5255

View Replies !   View Related
Deleting More Then 1 Column At A Time (in Report Builder) Crashes VS2005
 

fairly simple, just look at the title.
 
Create a table with several columns.  shift click to select more then one. right click press delete, and watch VS crash.

View Replies !   View Related
Open Reporting Services Report Using ReportViewer
I tried to open a SQL Server 2005 Reporting Service report in ASP.Net 2.0 using ReportViewer. The following is my code.


Dim param(2) As Microsoft.Reporting.WebForms.ReportParameter
param(0) = New Microsoft.Reporting.WebForms.ReportParameter("ProjectID", Me.cboProject.SelectedValue)
param(1) = New Microsoft.Reporting.WebForms.ReportParameter("RunBy", Session("strEmployeeName"))
Me.ReportViewer1.ServerReport.SetParameters(param)

Me.ReportViewer1.ServerReport.ReportServerCredentials = New _
clsReportServerCredential(System.Configuration.ConfigurationManager.AppSettings("strReportViewUser"), _
System.Configuration.ConfigurationManager.AppSettings("strReportViewPassword")

Me.ReportViewer1.ServerReport.ReportServerUrl = New Uri(http://SQL2005/ReportServer/)
Me.ReportViewer1.ServerReport.ReportPath = "/nsPortalReports/rptIssuesByRole"
Me.ReportViewer1.ServerReport.Refresh()


I need help with passing multiple parameters. I got an erron on the second parameter (parm(1)). The error was

"Overload resolution failed because no accessible 'New' can be called without a narrowing conversion:
'Public Sub New(name As String, values() As String)': Argument matching parameter 'values' narrows from 'Object' to '1-dimensional array of String'.
'Public sub New(name As String, value As String)': Argument matching parameter 'value' narrow from 'Object' to 'String' "


How can I pass the parameters?

Thanks.
DanYeung

View Replies !   View Related
ReportViewer Does Not Show Report In Aspx Page
I created a report with a parameter.  The parameter was created using a dataset in the report designer.  This works fine.  I deployed the report (webhost4life) and the report runs fine in the report manager.  I am able to select my casenumber click on the default view report button and it works. 

Problem:  I embedd the report into an aspx page frmReports1.aspx.  I call this page from another page (form).  the frmReports.aspx page comes up and displays the default drop down list box with the casenumbers (fine).  I select the  casenumber and click on the view report button and NOTHING.  I here the postbacks taking place but all that happens is the default value appears in the drop down list box and the toolbar shows.  I checked permissions and everything is fine.  I searched the forum and thought i found the solution with the inLine HTML and Async (still nothing) I can only think that something is not going right with the parameter.  Here is my html, and code behind code.  any help would be greatly apprcieated.

 

Zachary

 

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="frmReports1.aspx.vb" Inherits="frmReports1" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>



<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

 

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

<style>html,body,form {height:100%}</style>

</head>

<body>

<form id="form1" runat="server">

<div>

<rsweb:ReportViewer ID="rvTest" runat="server" Width="600px" ProcessingMode="Remote" AsyncRendering="false" Height="75%" >

<ServerReport

DisplayName="Billable Hours"

ReportPath="/sddmtech/SnowandIce/rptHoursWorked"

ReportServerUrl="http://sqlreport01.mysite4now.com/Reportserver" />

</rsweb:ReportViewer>

&nbsp;



</div>

</form>

</body>

</html>

 

aspx code behind

Imports System.Net

Imports System.Security.Principal

Imports Microsoft.Reporting.WebForms

Partial Class frmReports1

Inherits System.Web.UI.Page

Protected Sub rvTest_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles rvTest.Init

End Sub

<Serializable()> _

Public NotInheritable Class MyReportServerCredentials

Implements IReportServerCredentials

 

Public ReadOnly Property ImpersonationUser() As WindowsIdentity _

Implements IReportServerCredentials.ImpersonationUser

Get

Return Nothing

End Get

End Property

Public ReadOnly Property NetworkCredentials() As ICredentials _

Implements IReportServerCredentials.NetworkCredentials

Get

' Put your login and password here this works fine

Dim userName As String = ""

Dim password As String = ""

Dim domain As String = ""

Return New NetworkCredential(userName, password, domain)

'********************************************************************************

End Get

End Property

Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials

End Function

End Class

Public Function GetFormsCredentials(ByRef authCookie As Cookie, _

ByRef userName As String, _

ByRef password As String, _

ByRef authority As String) _

As Boolean

authCookie = Nothing

userName = Nothing

password = Nothing

authority = Nothing

'Not using form credentials

Return False

End Function



Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load

'ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()

'rvTest.ServerReport.Refresh()

End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

rvTest.ServerReport.ReportServerCredentials = New MyReportServerCredentials()

End Sub

End Class

View Replies !   View Related
Report Parameters Are Not Enabled In ReportViewer Control
Hi All,

I am developing Reports using RS 2005.

I have designed my reports using Business Inetlligence Development Studio and deployed them on report server.

Some of these reports have parameters and they are set to default values. When I view these reports through HTML  report is being rendered properly.

But when I developed ASP.net application to view these reports through ReportViewer control, parameters having default values are disabled always. Others are enabled. There is no choice of selection of these parameters. When I remove default values, parameters are enabled. I have even set ShowParameterPrompts to true.

Below is code snippet :

reportviewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;

reportviewer1.ServerReport.ReportServerUrl = reportURL;

reportviewer1.ServerReport.ReportPath = reportPath;

reportviewer1.ShowParameterPrompts = true;

reportviewer1.ServerReport.Refresh();

reportviewer1.Width = System.Web.UI.WebControls.Unit.Pixel(900);

reportviewer1.Height = System.Web.UI.WebControls.Unit.Pixel(600);

reportviewer1.ZoomPercent = 100;

All parameters are defined in rdl file.

How to enable those parameters which I have default values set?

Appreciate your help.

Regards,

View Replies !   View Related
Local Report - How To Display Parameter In ReportViewer
 

Hi All,
I have configured the ReportParameter as following, but it is not visible on RunTime ? Any idea why ?
 
 

LocalReport oLocalReport = ReportViewer.LocalReport;

List<ReportParameter> oParmList = new List<ReportParameter>();

String sResidentID = "";

sResidentID = "RES100";

ReportParameter oReportParameter = new ReportParameter("ResidentID",sResidentID, true);

oParmList.Add(oReportParameter);

oLocalReport.SetParameters(oParmList);
 
Appreciate any help,

View Replies !   View Related
Help! Jump To Report: Error With Web Reportviewer Control
Hello everyone,
I have a report that has a "Jump to report:" link in it and in the report it jumps to there is another "Jump to report:" link. When I click on this link I get the following error.
 
The path of the item '(null)' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
 

I have tried moving the link from the header to the body of the report with the same results.
 
This is only happening in the web reportviewer control as our windows app works flawlessly.
 
We are running SQL SERVER 2005 SP2.

 
Does anyone have a fix, workaround or idea how to resolve this issue?
 
Thanks in advance
 
-JW

View Replies !   View Related
Opening A Saved Report In Forms ReportViewer?
I'm wanting the ability to save a rendered report in a native file format that I can re-open in the Forms ReportViewer at a later date, potentially with no access to the original report definition or DataSets.  Is this possible?  There's all the options of saving to PDF, HTML, XML, etc.  But I don't see any means to save a report and then re-open it in the ReportViewer.

View Replies !   View Related
How Print Report In Page With Reportviewer Web And Localmode
¨That
How Print Report in Page with reportviewer web and localmode
 
I have a asp.net page with the reportviewer control .. i set the localreport property
and render the control ... i need to print this report to local print
 
 
thanks

View Replies !   View Related
ReportViewer Not Displaying Report In Remote Mode
 

I'm able to see reports hosted on my Win 2003 server with browser but when I'm trying to display same reports through reportviewer in winforms then nothing is getting displayed.
 
Report URL, Path and processing mode, all are set up correctly, can somebody help on this..

View Replies !   View Related
ReportViewer, Server Report Locks Network Account
I have a WinForms application deployed through ClickOnce which includes a ReportViewer control. This ReportViewer is configured to run a Server Report from the ReportingServer on a nearby machine. This has all been working fine.

 

Recently my windows logon required me to change my password and now since this change using the report viewer causes my account to be locked out. The Viewer gives me a "401" error.

 

I have checked the construction of the report on the server and the Data Source is definately using Integrated Security. While my account is unlocked I can happily run the report through IE on any machine that I'm logged in on. But as soon as I run the report through the ReportViewer control in the application then my account locks out.

 

This doesn't appear to be affecting my colleagues who also run the application, but I can't comment on if/when their passwords have changed.

 

It's as though my ReportViewer is not using my latest security details to contact the ReportServer.

 

Can anybody help? It's getting embarassing having to call my Network Administrators every 5 minutes to get my account unlocked while I work out what's going on.

 

Best Regards,

Kevin Prendergast.

View Replies !   View Related
Possible To Use ReportViewer To Change Connection Strings Of A Report's Datasources?
Is it possible to use a ReportViewer control (or something in .net) to change connection strings of a report's datasources?
The connection string comes from a shared data source, so using an expression for the connection string in the actual report is out.

 
Essentially, I'm looking to tack on Analysis Services cube role(s) to the connection string to change data permissions.  If there's another way to do this with a RS report, I'm all ears.

View Replies !   View Related
Reporting Services ReportViewer Page Is Not Displaying The Report
Hi
 
I had a problem accessing our report manager via the web front...
We deleted the virtual directories in IIS and then recreated them... this required us to make a change in the rsWebApplication.config file to include the URL in the ReportServerUrl tag before we could access the site again.
Now we have access to the site but when we attempt to view a report that we deployed to it - the report fails to render and returns a rsReportNotReady error, even though the report doesnt use a snapshot.
 
Furthermore, the strange thing is that the filters for the report don't display in their own collapsable bar as they used to before... they just display on the white part of the page. Neither does the reportviewer toolbar display properly. It appears as labels and textboxes going down the page and not in a toolbar as you might expect...
 
any help is appreciated... we suspect that it is some kind of configuration issue, but we have no clue where to begin...

View Replies !   View Related
ReportViewer Control Doesnt Show 100% Of Report When Included In .Net Web Form With Other Controls
 

I created some controls for filtering the report that will be displayed on the same page, but below these controls.  The controls take about 200px of the top of the form, while the report will be displayed in the rest of the page.
 
I'm using the ReportViewer control in Async mode, so it's being rendered as an Iframe, and this is necessary because some reports will take up to a couple minutes, so I want the loading animation.
 
As many of you know, this type of scenario will cause two scrollbars to be shown on this Web form:  one for the main form, and the other for the Iframe containing the report.  To prevent this, I have html,body set to overflow:hidden.  This works great at preventing the outer scrollbar from showing, and only the report has a scrollbar.
 
The problem is that the bottom 200px (see first paragraph above) of the report doesnt show and cant be scrolled to.  Has anyone come across a solution for this situation?
 
I'm basically stuck either having a report with two side by side scrollbars, or a report with 1 scrollbar that cuts off the last portion of each page of a report.

View Replies !   View Related
Reporting Services 2005 - Problems Displaying A Report Via A ReportViewer Control.
I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems and no errors are returned to the page when the "View Report" button is clicked.

Anyone out there have a clue? I certainly don't.

Mike

View Replies !   View Related
How To Show The Report Exporting Date Only In The Exported PDF/Excel File (ReportViewer Control)?
 

Hello everyone,
 
Our customer wants to display the exporting date only in the exported file when exports a report to PDF/Excel (we are using ReportViewer Control in ASP.NET). Can anybody tell me how to achieve this?
 
Thanks a lot.
 
Danny Li
 

View Replies !   View Related
Margin Issue
When working on this report on my local machine, the left and right margins are set to .25. The fields and fieldheaders were not wrapping. After I deploy it, the margins are increased or the tables are resized and this causes the fields and field headers to wrap.
What could be causing this. Is it Setting on the server?

View Replies !   View Related
Margin Rendering
 

When running a SSRS 2005 Report on local machines (running Windows XP) A certain Textbox Label is not wrapping and is sized with .25 inch blank spacing at the end of the text. When running thru  a datadriven Subscription this label is wrapping to next line on the PDF file that is produced.
 
We went to the SSRS 2005 server( Windows server 2003) and opened the report and it shows this label wrapping and the text is not fitting in the label box. But on every client box that we open this report on it shows it not wrapping. Is there a setting on the Server that we need to set for this report to render correctly.
 
 
 
 
 

View Replies !   View Related
Weird Margin WhiteSpace
I am hoping there is an easy way to fix this. I have a report defined 8.5" x 11.0" with .5" Margin's all around. I am using the WinForms Report Viewer Control (doing Server side reports). It looks like the viewer is taking the left margin and adding it to the right margin. So you get large amounts of white space on the right of the viewer. This requires me to make the viewer way larger than it needs to be to get rid of the ugly Horizontal Scroll bar.
 
 
 
What I want is either don't show the margins until you print (removing the margins from the RDLC file does nothing), or have the left margin white space belong on the left side.
 
 
 
Why is this happening? And how can I fix it? Thanks!

View Replies !   View Related
Margin And Paper Orientation Programmatically
Hello.
I have a report but by default it prints Portrait and 1.0inch Margin. I would like to programmatically set the values of my report to 0.2 inch margin and Landscape. I am using RDLC (Local Report).
Does anyone has an idea how to achieve this?
 
Jose

View Replies !   View Related
Urgent! Left Margin Problem
A problem has cropped up where my reports that I set with a .5 inch margin (all around) for an 8.5x11 layout are shifting the left margin by .25 to .75 in leaving a .25 inch margin on the right.  This happends using mutiple reports printed to variuos printers on mutiple machines.  I'm fairly certain that at one point the margins were beging honored.  I found the following link that addresses this problem and claims visual studio 2005 sp1 fixed it.
 
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=131345&SiteID=1
 
I'm also having another problem in report designer when I use the previewer.  I need to tell it to print twice before it prints.  This also was supposed to be fixed on SP1. 
 
I've check visual studio and it does state that it has SP1 installed.  Any thoughts? 

View Replies !   View Related
Installing VS2005 And Business Intelligence Report Projects On A Vista Business Workstation
Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?
 
I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.
 
Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.

 
Thank you
 

View Replies !   View Related
Test Deploying WinForms App With SQL/e
Hi all,

Am I right in my understanding that I cannot deploy SQL/e to a machine that isn't running Visual Studio 2005, if I'm trying to ship within a winforms app?

Is this being fixed in the final release, or RC1?

What timeline is there for the release of SQL/e?

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved