Showing posts with label written. Show all posts
Showing posts with label written. Show all posts

Monday, March 26, 2012

ReportViewer - problems with deploying

I have a web application that was written in Visual Studio 2005, ASP.Net. I am using ReportViewer and it runs correctly and quickly in "local" setting. I have installed the ReportViewer.exe from my local machine's harddrive onto the web server and copied my web application to the web server. The aspx page opens fine, I see the reportviewer frame, but I do not see my report. I have tried changing the "ServerReport" and "LocalReport" ReportPath to "http://localhost/test" where the RDLC file is located but still no report shows up on the web server.

Could someone please instruct me how to deploy an ASP.Net web site that is using ReportViewer? I have installed, uninstalled and reinstalled the ReportViewer.exe file. I have downloaded it directly from Microsoft and restarted IIS, as I have seen in other posts. I am running out of options that I can try to get this to work, and I'd hate to have to scrap it and start over using tables and repeaters.

Thanks in advance.

Hi,

From your description, it seems that you want to connect to your report which existed on your remote web server, right?

To deploy reports in an Internet application, you can embed the ReportViewer Web server control in a custom Internet-ready application that you create and deploy. The ReportViewer Web server control is included in Visual Studio 2005 and can be distributed freely with your application. You can configure the control to display reports that run on a report server. The connection between your application and the report server is handled by the control, through the Web service programming interface. All authentication and authorization is handled by your application, which connects to the report server through a single, user-trusted connection.

For more information see:http://technet.microsoft.com/en-us/library/ms159272.aspx
More information on deploying see:http://technet.microsoft.com/en-us/library/ms159868.aspx

Thanks.

sql

Wednesday, March 21, 2012

ReportSelectionFormula To bring Null Values

Hello

Can anyone help me how to View the CR with ReportSelectionFormula with Particular field having Null Values

I have written like this

rpt1.RecordSelectionFormula = "{Dpled.Match} IS NULL"

or

rpt1.RecordSelectionFormula = "{Dpled.Match}='' "

but it gives blank reportUse isnull() function

rpt1.RecordSelectionFormula = isnull({Dpled.Match})

it will report only those records which has match field as null|||I tried out this

rpt1.RecordSelectionFormula = " IsNull({Dpled.Match})"

Still did not work out to bring Report with Null Values|||try this

rpt1.RecordSelectionFormula = " if IsNull({Dpled.Match}) then true"

Tuesday, March 20, 2012

Reports rows written but they aren't

I have a 3 data flows with an oledb source, a script component and a sql server destination that reports success and that it wrote the rows to the table in question. However, the rows are not written to the SQL Server 2005 table that is the destination. I have many other data flows in the same package that work exactly the same way that insert the rows they should insert in the destination table.

An example of the message I get indicating success is as follows:

[DTS.Pipeline] Information: "component "SQL Server Destination" (75)" wrote 289 rows.

Has anyone else seen this behavior or have an idea what might be wrong? Why would the data flow report success when the rows were not, in fact, inserted in the destination table?

I deleted the 3 data flows that were exhibiting the problem behaviour and re-created them from scratch. The problem went away after I did this. Don't know what the problem was but the three I deleted had worked previously.|||

swells wrote:

I deleted the 3 data flows that were exhibiting the problem behaviour and re-created them from scratch. The problem went away after I did this. Don't know what the problem was but the three I deleted had worked previously.

Do you have an old copy of the package? It'd be interesting to compare and see what the differences were.

-Jamie