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


Post New Web Links

WPF 4 with SSRS Report Viewer and long running Background Worker Dispatch task.

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :WPF
 

Hello,

I've recently run into an issue with with WPF 4 and the SSRS viewer control with a batch emailing application. See http://www.jenasysdesign.com.au/dnn/Blogs/tabid/71/EntryId/5/WPF-4-SQL-Server-Reporting-Services-processing-application-Memory-Leak.aspx for details of some performance profiling issues I found with this technology stack.

I've got two issues.

Firstly, I implemented a background worker process to handling looping through the 2,800 reports. I found to run the SSRS report viewer to export the report results in a slow memory leak. See Red-gate Ants memory profiler 6 image in the link above. I'm not sure what I need to do to remove weak references with this combination of technology. Any ideas?

Secondly, the following code runs on the background worker process, designed so the user can monitor the progress of the a large batch of report files getting generated.  The catch here is involves using the SSRS viewer to export a reports results requires the Dispatcher.Invoke method to ensure that ReportViewer.xaml screen gets a UI thread, but in the process it interferes with the background workers report progress methods, so the UI doesn't see the progress.  


View Complete Post


More Related Resource Links

WPF 4 with SSRS Report Viewer and long running Background Worker Dispatch task.

  

Hello,

I've recently run into an issue with with WPF 4 and the SSRS viewer control with a batch emailing application. See http://www.jenasysdesign.com.au/dnn/Blogs/tabid/71/EntryId/5/WPF-4-SQL-Server-Reporting-Services-processing-application-Memory-Leak.aspx for details of some performance profiling issues I found with this technology stack.

I've got two issues.

Firstly, I implemented a background worker process to handling looping through the 2,800 reports. I found to run the SSRS report viewer to export the report results in a slow memory leak. See Red-gate Ants memory profiler 6 image in the link above. I'm not sure what I need to do to remove weak references with this combination of technology. Any ideas?

Secondly, the following code runs on the background worker process, designed so the user can monitor the progress of the a large batch of report files getting generated.  The catch here is involves using the SSRS viewer to export a reports results requires the Dispatcher.Invoke method to ensure that ReportViewer.xaml screen gets a UI thread, but in the process it interferes with the background workers report progress methods, so the UI doesn't see the progress.  

SSRS Report viewer + Remove

  

I am running the report from SSRS report server in the view i am finding that the window title is Report Viewer - Windows Internet Explorer.

How to remove this name and get the name of the report over there.

I am using java at the back end to call the repot through url.

Please help me .

Thanks ,

Kamal.


Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

  
Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Graphs stop displaying in Report Viewer Control after upgrade to SSRS 2008 R2

  
We are seeing an issue where certain graphs and guages are not being displayed within a report rendered in the report viewer control after we upgraded from SSRS 2008 to SSRS 2008R2.  You can see the graphs and guages render and then disappear from the screen when two other graphs are rendered.  When I export the report to Excel or PDF then all of the graphs and guages are rendered properly. There are a total of 3 graphs and 2 guages on the report - when it completes the rendering process, you can only see two of the graphs displayed in the report viewer control - as I said before, you can see all 3 graphs and 2 guages when exporting to Excel or PDF.  Using Internet Explorer v8.  This problem manifest itself right after the upgrade. Has anyone seen a similar issue? 

help need for long running task

  
i have wcf service and method which runs very long running task and i have subscription service which let's out all the notifications. From asp.net web page i subscribe for the notifications and call the async method..notifications are being recived by the page (kept a debug and can see). On the web page i kept ajax timer, update panel with a label which refreshes every 10 sec. But asp.net seems to be waiting for async completed even to be fired and then update panels shows me all the notification (no use of notifications as the activity is over). I feel because both are in the same thread, that's why asp.net s behaving this way. Any help you guys can offer?

Handling Long running task in Asp.net ???

  
Hi ,  i am working on Asp.net application with database sqlserver. I have a long running task which takes 50 minutes processing time now in this scenario user cannot wait for this much of time and my web page will also gets expired. basically of long running task does data shifting from one database to another database. In my application multi users can works at the same time this means that users can put multiple requests at the same time. Now my problem is that i want to complete this long running task totally offline which would trigger when user put any request, but what happened when another user put a request at same time this means first request would override by second one. FOR EXAMPLE GOOGLE  mail importing task. if you seen google mail importing task . google provides import your mail from yahoo or others servers when you click on import button then an import task is started and show importing. this importing task runs for one or two days which can be stop by users at any point of time.  this indicates that importing task is totally offline.  I want to implement same functionality in my application. please suggest any way to implement above scenario. Every suggestion would be appreciated. 

I'm getting exception while running Report builder 2.0 for SSRS Reports

  
Hi,
I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.

sunmoon_1411

Report Viewer control: Print crashes if subreport is too long

  

Hi,

I have a report and a .NET 3.5 Winforms application which displays the report in local mode, passing the required datasets to the report as it is supposed to do. It takes about 2 seconds before the report is displayed.

However, when I click on Print Layout, the "Loading..." box appears and does not disappear any more. If I want to print the report, a window appears telling me that the first page is being sent to the printer and... that's it, all I can do is kill my application via task manager.

After playing around with various elements in my report, I was able to reproduce this behaviour if one of my subreport returns too many rows (the subreport contains only a list element, listing all records).

I believe it has something to do with the subreport spanning more than one page. I played with the KeepTogether property on various elements, but to no avail. Has anybody experienced something like this before? Is there a workaround?

Thanks,

Roland


Best Practice for connect SSRS Report Viewer Web part with custom filter web part (With Dropdown\Lis

  

To make a filter provider web part, I implemented the interface ITransformableFilterValues.
Implemented the various properties of the ITransformableFilterValues interface
and method that creates an instance of our filter provider.

[aspnetwebparts.ConnectionProvider("AccountFilter", "ITransformableFilterValues", AllowsMultipleConnections = true)]
public ITransformableFilterValues SetConnectionInterface()
{
return this;
}

Is this a best practice .Please share your suggestion.

Regards,
Prashob


SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010

  

dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion


Best Practice for connect SSRS Report Viewer Web part with custom filter web part (With Dropdown\Lis

  

To make a filter provider web part, I implemented the interface ITransformableFilterValues.
Implemented the various properties of the ITransformableFilterValues interface
and method that creates an instance of our filter provider.

[aspnetwebparts.ConnectionProvider("AccountFilter", "ITransformableFilterValues", AllowsMultipleConnections = true)]
public ITransformableFilterValues SetConnectionInterface()
{
return this;
}

Is this a best practice .Please share your suggestion.

Regards,
Prashob


Use modal dialog for long running task (SPLongOperation?)

  

I have created a ribbon button which downloads selected files from a document library to a temporary folder on the server.  I have created a aspx page with code behind that downloads the items upon clicking the ribbon button using ModalDialog.ShowModalDialog(options) from javascript.

What I would like to do is implement the below javascript to call my aspx page which does the actual work, and to use the ShowWaitScreenWithNoClose dialog to provide an indicator ot the user.

1.  How do I close the showWaitScreenWithNoClose dialog from the download.aspx page code behind?

2.  Is there a way to update the message text of ShowWaitScreenWithNoClose dialog so that I can indicate the name of the document being downloaded?

3.  Is there a better way of calling vb/c# code that downloads files (or other processes) while showing the waitscreen dialog?

var options = {

 url: '/_layouts/myRibbonButton/download.aspx?itemIds=' + ids + '&sourceUrl=' + location.href,

 tite: 'Download Documents',

 allowMaximize: false,

 showClose: true,

 width: 1,

 height: 1,

 

SSRS 2008 crashng when running a report with huge amount of data

  

We have a huge amount data that is loaded (using flat files, upto 80GB in size) from the mainframe on a daily basis after which our users use SSRS to view the results using predeployed reports. One of the report query brings back a huge amount of data but when rendering the reports, it dies and restarts the service.

library!ReportServer_0-12!1310!10/14/2010-17:49:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database., ;
session!ReportServer_0-12!1310!10/14/2010-17:49:45:: e ERROR: Sql Error in GetSnapshotData: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
ui!ReportManager_0-11!1b34!10/14/2010-17:49:45:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the dat

SSRS working fine in Report builder and manager but not in Report viewer

  

HI I have a report that worked fine until we upgraded the SQL server from 2008 to 2008 R2 and the report viewer to latest version as well.
This report has a pie display, NOW instead of showing one pie, it is showing 20 pies!

I am trrying to learn how to resolve and what is causing this. 


Report Viewer/Explorer webpart for SSRS Native Mode

  

Guys,

I have created a simple report with BIDS and have deployed to my SSRS server. Works fine... when I use the Report Viewer/Explorer webparts it works fine only on my PC. Really only displays on my computer. When others access the page the webpart does not load... it states "Navigation to the webpage has been cancelled." I have added all necessary permission to the report. the report displays if users access it directly from the report server, just not when viewing from the Sharepoint site. I even logged into another computer with my domain credentials and it did not work only on my computer that i used to create/deploy the report with BIDS...

any help would be great I'm stumped....


Table rendering Bug: Setting Background color for SSRS report (RDLC)

  

Hi,

I am facing the issue while trying to create a Report Definition Language Client-side (RDLC) report. I want to set background color to the textbox (used in table) depending on the value. I have used conditional formatting to achieve this. But i am facing issue in setting background color for Some of  the fields like

  1. EnduranceYoYo
  2. Endurance5MinRun

The General Format of the Conditional format is

=iif(<Varchar Field>.value="NA",Gray.iif(<Integer Field> < 600,"Red",iif(<Integer Field> >=800,"Green","Gold")))

I have used this conditional formatting in Textbox (Properties) --> Background (Expressions)


 I have tried the following options to rectify the issue

Option 1 :

This is the format i have used in Conditional formatting in Expression (In Textbox properties -- background -- Expressio

how to use Report viewer and report Explorer web part in sharepont 2007 for ssrs

  

i have to show ssrs report in the sharepoint 2007 using report viewer and report explorer how to user this two web part to get the ssrs report in sharepoint 2007.

i am new to the ssrs with sharepoint 2007.

 


Categories: 
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