473,624 Members | 2,216 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report Viewer and ObjectDataSourc e changing in asp.net rdlc

I have a simple report viewer in on one of my web pages and I have a
specific report chosen to view, not a crystal report but the built in
reports that are .rdlc files. I want to be able to send parameters to
this report to change the data shown. I initially want to pull the
report up based on one parameter (Users ID), then give the user the
option to fill in other text boxes on the screen for the rest of the
criteria. So some how i have to be ablet o change the GetData select
method to another select method that handles these parameters. Here
is teh code I used to try and change that but it didnt work. Any help
is appreciated...

ObjectDataSourc e1.SelectMethod = "GetDataByDateR ange";
ObjectDataSourc e1.SelectParame ters.Clear();
ObjectDataSourc e1.SelectParame ters.Add("@Begi nDate",
Convert.ToDateT ime(txtBeginDat e.Text).ToStrin g());
ObjectDataSourc e1.SelectParame ters.Add("@EndD ate",
Convert.ToDateT ime(txtEndDate. Text).ToString( ));
ObjectDataSourc e1.SelectParame ters.Add("@BUMN ewTechID",
Session["ID"].ToString());

ObjectDataSourc e1.DataBind();
ReportViewer1.D ataBind();
Jun 27 '08 #1
0 1448

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
6952
by: Susan H | last post by:
I have Visual Studio 2005, trying to properly bind to a nested object tree. I can bind to the top level object just fine, but can't seem to "hook" my nested object in. I have a ShoppingCart object, which has 1+ Shipment objects, which each have 1+ LineItem objects. Pretty standard. I'm looking to print a report that prints out the header for the shopping cart, and then sections for each shipment, and so on. I am floundering on how...
7
27646
by: steve | last post by:
Hi All I need to change text in a Report Viewer document at runtime It is just the heading I want to change to match what the user has chosen as the Report to view How do I access the textbox in "GymMaster.Memberships.rdlc" (below) to change the text sql = "select * from members order by surname"
7
21728
by: steve | last post by:
Hi All I have created rdlc files and when I load them into Report Viewer at run time they appear OK If I click on 'Print layout' button on Report Viewer the view again appears acceptable If I click on 'Page setup' button the margins left & right are not what I set on the rdlc file at design time (1.5cm) they are 5.9mm
5
3350
by: David L. | last post by:
I'm running into a frustrating problem. ASP.NET 2.0 web application, against SQL'05, I'm trying to run a report against a 'table provider' (query) that excutes well within SQL MGT studio, and within the data environment. However, when the report is executed in a web report viewer, the report engine comes back with: An error has occurred during report processing.
3
5541
by: steve | last post by:
Hi All I have a VB.net 2005 app which uses MS Report Viewer to create reports Occassionally I get the following error when changing to a different report User code running on thread 196 has attempted to abort thread 3560. This may result in a corrupt state or resource leaks if the thread being aborted was in the middle of an operation that modifies global state or uses native resources. Aborting threads other than the currently...
0
1180
by: =?Utf-8?B?QW5nZWw=?= | last post by:
I am using the MS Report Viewer. I created a report (.rdlc) in my website. I set the report up using a datasource. I have the following code: Dim dta As New dsReportLoanBatchTableAdapters.FARReportLoanBatchTableAdapter Dim dt As New dsReportLoanBatch.FARReportLoanBatchDataTable dt = dta.GetFullData() ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("dsReportLoanBatch_FARReportLoanBatch", dt))
0
1783
jgroos
by: jgroos | last post by:
Here is my scenario: I have two different reports processed LOCALLY, lets say Report1.rdlc and Report2.rdlc. They both are populated with data from a database, and they both also take a list of parameters. Each report has a button the user clicks to view them, AND, they both WORK. HOWEVER, when the user clicks the button a second time, the table on the report is displayed AGAIN, right below table from the last load. I'm talking the WHOLE...
1
10377
by: Larry Bud | last post by:
I have a reportviewer control. I programmatically set the local report path based on a drop down on a page. This allows the user to choose which format (RDLC file) to use when generating the report. The first request, the report processes properly, however if I choose a different report format, the old report still renders. I'm doing a .refresh for the report... I tried turning off Viewstate for the report, but it says that...
0
4254
by: =?Utf-8?B?WmVk?= | last post by:
Good Day, I been looking for a day now and I couldn't find a good source of information. I have a one of a kind report wherein the RDLC file including all controls are programmatically generated (system generated) by one of my asp.net page. All fields and its values to be displayed on the RDLC file are coming a stored procedure. On my stored procedure I'm using a temp table for example #MyTable and its columns can adjust...
0
8234
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8172
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8677
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8620
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7158
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5563
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4174
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1784
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1482
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.