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

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

clearing reportviewer and reload of dynamic report

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :ASP.Net

I have an application that builds the SQL Select statement and creates the report in ReportViewer.   The trouble is this, it will not reset the data that is already loading in the report.  I have to close out of the ReportViewer screen and come back in to make new selection options.  What am I missing?. 

ReportViewer.ProcessingMode = ProcessingMode.Local
Dim rView As LocalReport = ReportViewer.LocalReport
rView.ReportPath = "myReport.rdlc"
Dim ds As DataSet = GetDonorData()       '<-- This executes my sql query
Dim dsDonor As New ReportDataSource()
dsDonor.Name = "dsDonor_Data"
dsDonor.Value = ds.Tables("dsDonor")

Private Function GetDonorData()
Dim dsDisp As New DataSet
Dim sqlDonorData As String =

View Complete Post

More Related Resource Links

Dynamic Report in reportviewer


HI I m sorry to say this But this task too urgent.

 Ex- i have two tables in my db name called Comdetails, deptdetails.

TCS is a one company name stored in ComDetails and Company_ID took as primany key,

TCS having 10 department stored in deptdetails and Company_ID as foreign key.

so now in DB we have available one company with 10 departments.

so now i need to generate report , i m using report.rdlc and reportviewer.

i hope upto now its clear.

my task-

1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re

Make dynamic changes to ReportViewer Report design InteractiveSize property


Hello all,

Could someone share with me how to dynamically change the Report design InteractiveSize property?  I want to use a radiobutton list which has two options (complete list, paginated list) which changes the height of the Report display.  I wonder if I need to use the Report Parameters but how do I change and refresh to display the selected option.  Thank you.


Include a Crystal Report in .NET Web Service for Dynamic In-Memory-Only DataSet



I would like to use Crystal Reports in a .NET web service.  Ultimately I would like to convert my report document to a PDF and then return the PDF as a byte array. 

My .NET DataSet is generated dynamically at run-time.  It consists of four related tables.  Since my DataSet does not have a physical datasource, I created an XML Schema file.  I then added the XML Schema file to the web service project with Add Existing Item. 

A solution for working with a dynamic in-memory DataSet exists for ASP.NET web sites and client-based forms.  I tried to use this method as it is published.  When that didn't work I tried creating the report and XML Schema directly in the web service project, but that also didn't work.


The problem is apparent when you try to set the datasource.......the code bombs on the call to SetDataSource(DataSet) with the message
ex = {"The data source object is invalid."}

Crystal Reports would save me a lot

Dynamic SQL statement for a multilevel hierarchy report

Basically I have a requirement from the functional team that need to show a multilevel hierarchy report.   ID ParentID A NULL B A C A D B E C F C G F   The above is the sample of the table.   I need to show the cascading relationship dynamically base on the available level. The issue was we would not know how deep the relationship in the table.   Target Result:   ID Parent Level 1 Parent Level 2 Parent Level 3 A NULL NULL NULL B A NULL NULL C A NULL NULL D B A NULL E C A NULL F C A NULL G F C A

Dynamic Columns Using Report Viewer Control

Hi,, I'm using Report viewer Control to generate reports.Currently i have static columns..I need to have columns created  based on the DB Query  results i.e., DB query will return more columns under certain conditions and less columns in another...In Short,Headers and column data will be known only at runtime.how can i bind the data dynamically...what can i do to accomplish this..

Creating Dynamic Group Fields for a Crystal Report?

I have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it. Thanks, Blake

Dynamic or Expression-based Report Page Properties

Hello, I have a tablix(table) with column grouping making the number of columns dynamic. Although our customers have been warned that this could lead to the columns going beyond the edge of the normal landscape 8.5x11 inch page, they have asked for alternate solutions. Beyond rotating the column labels and reducing fontsizes, the issue is not so much that it goes off the page, but the fact that in print preview mode the data is broken up requiring that you go to the next page to get the remaining data. What I am investigating is whether the Page Properties of the report body, either the pagesize property and/or the interactivesize property, can be manipulated at run time? This way if a user, based on their experience with the parameters they usually select and pass into the report, knows that the results will span the length of the page onto a second page, could choose a new parameter such as pagesize/interactivesize so that it changes from 8.5/11 to perhaps the next standard page size of 8.5/14 inches? This does not mean the contents would change during the course of rendering the report, just a new input that could decide at run time what paper size to use in print preview mode.   Thanks.

Multiple Rdlc report in one reportviewer.

Hi, I have multiple reports that take the same parameters. Need to create a master report with all the reports merged together. I dont want to copy paste the rdlc files into one large file. found a control by Telerik called ReportBook but it costs money!! http://www.telerik.com/help/reporting/designing-reports-general-explanation.html anyone knows something similar? or am i missing something very obvious? using visual studio 2005... Cheers will subreports solve my problem? not sure how these work. so say i have a report that lists employers and i create a subreport that lists all employees for a particular empoyer. is it then possible on one rdlc to have the list of employers and a bunch of subreports for each employer's employees?

Using Sub reports and dynamic crystal report generation

Hi..........friends,         I am working on crystal reports to generate Ration card details.My form  consists of the fields like Address details of the ration card owner,existing ration card details and family members details.in these Family Details i have to generate dynamically according to the count of the family members.I am new to crystal reports.I am confusingabout whether i have to use sub reports or formula fields.................               Plz help me                                                                    Thanks in advance      

dynamic Dataset-Crystal Report

Hello everybody, i'm developing a C# application in which i'm using crystal reports to display data from database. i'm trying to create a dynamic dataset since it's going to be filled from multiple classes i'm not able to fill these dataset unless i add to my sql query the "column AS columName" for example:"select nmClient as Name from customer " ; if i write down "select nmClient  from customer", it won't work   please let me know if there any ulternative solution in order to solve my problem   thank you in advance  

generate dynamic fields crystal report

  I want to add a Dynamic column in Crystal report at run time. Because I dont know about the columns in design time. The columns will come based on the user selection. So i want to Add a column to Crustal report at run time. I am using Crystal report. If it is not support to add column in Crystal report at runtime. Please kindly give the other solution or other third party tool like. Which version will support to add dynamic column in Crystal report? i already used the crosstab report but thats not work for my scenario.becoz i want to add another colums at right side ( after total of each row ) , which is crosstab report not supported 

Corrupt thai characters when report is exported in ReportViewer



I am facing problem while exporting report to PDF using report viewer. The problem is that I have Thai character in the report, which I am able to view perfectly, but when export to PDF functionality of the report viewer is used, the thai characters are not displayed correctly.

Below is the attached RDCL with embedded thai characters.

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
      <Textbox Name="Thai">

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

Dynamic file name in File based report delivery


I am trying to implement a report delivery mechanism which is file based. So the report will be generated in pdf or excel and placed in file share location.  The name of the file needs to be dynamic.  For e.g. : if the report I am running is Daily sales for store 101 with a sales amount of $150 and for the date 03/22. I need to generate a pdf with file name dailysales_101_150_032210.pdf

There are some parameterized report generation scenarios as well. In that case the report name should include the parameters provided. In the above example itself if all the values above are provided as parameter, the report should be generated for the given parameter and the name should contain the parameter.

Has anyone had this requirement and implemented a solution before ? Can this be implemented in a standard subscription & data driven subscription. any custom code is required in order to implement this or can this be done by configuration in SSRS ?

thanks for your help.


Generate a dynamic number of custom report item instances in a report


Are there any solid examples/tutorials/demos of how to dynamically generate custom report item instances in a report based on the amount of rows in a data set?

Additionally I would like to insert these custom report items in a particular order based on a field in the data set.

Any help/pointers/articles would be appreciated!

Cross tab dynamic report


Hi i have the following scenario we have a table named property with intPropertyId as pk

we have two more tables 1 is custom_tables custom_columns

custom_tables have table names

custom_columns columns have column names which are user defined column with property

and finally we have a custom_columns_values table as mapped table with custom_columns

so we have intPropertyid incolumnid varValue column as column value sql_variant against every property

now i have to create report which shows column names as column names and their values as values

i have tried pivot but its not working is there any way i can print dynamic or user defined columns as columns and their values as rows

How do I create a dynamic image in report server


I have two questions about report server.

Question 1: Is it wise to 1300 users to make use of reporter server order forms to print / view? or are better solutions?

Question 2: In a report to a dynamic image. The picture is on the Internet. http://www.domainname.com/images/12500.jpg
How can I display dynamic image in the report?
The filename can be retrieved from the database with the order number.

I was thinking something like: http://www.domainname.com/images/ (Fields! Article.Value)
This work, unfortunately.

Does anyone have an idea?

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