I have a reportviewer (Microsoft.ReportViewer.WebForms) control on my page. All my reports use one data source. I want to be able to let my reports run on a different database when started from my UAT enviroment. So the location of the reports is the same, but the data comes from a different db. I cannot seem to find how this is done, is it even possible?
EDIT: They are server reports on SQL Server . I know you can set the dataset programmaticaly but I just want the reports to point to a different db and leave the rest of the report intact.
How can I use a web service (WCF) as the data source for a reportviewer . I create web application in that i want use .rdlc ( dont want .rdl) so i write wcf service . How to link wcf service into reportviewer to display data in rdlc.
I think I'm getting mad here...I thought this should be super simple, but I just can't figure out how to do that.This is what I'm trying to do:I want to create an rdlc report using the ReportViewer control in ASP.NET 4 (VS 2010), and, as its datasource, use a class with some properties.I tried everything I can think of, but I just can't figure this out. All the docs I found state that the object should appear in the DataSource pane of the website, but I can't make it appear there.I would like the fields of the class to appear in the report desiger so I can use them - but I can't do that either.Using the designer, I can only define new dataset - I don't want to use dataset, but business objects!So - how can I do that? Do I have to use some kind of DataSource control? How can I make the report designer know about the business object?
I have a ASp:Menu control in my Master Page . I want to change DataSource of my Asp:Menu on Login depending upon the role of the user (as if admin/user/staff etc) so when i tried to change the data source of asp:menu by
menu1.DataSource= ds_director; menu1.DataBind();
it is giving error like u can't user two dataSources..
this is the first time I have tried this so I am probably missing something that is staring me right in the face.
I have an ASP.NET page where the user fills in a request which then emails a PDF rendered from a ReportViewer instance.
It all works fine when I run it locally through the ASP.NET localhost but when I try and run it of the webserver it fails with the following message:
An error has occurred during report processing.Cannot create a connection to data source 'DataSource1'.
I can preview the report via the web based report manager via http://servername/reports which works without any problem and using the report editor in VS2005.
I suspect it is something to do with the credentials but I am at a loss. The data source is set with a username and password but this is saved within the datasource.
I have a reportViewer control and I dynamically setting the report path and dataset in the page load event if it is not a post back. This first report displays without issue. However, when I attempt to change the report path / dataset via the onChange event from a dropdown list I get the following error:
A data source instance has not been supplied for the data source "Summary_DataTable1".
This code works fine and the summary report is displayed the first time the page is loaded.
i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"
There are several reports in the reportserver which are using a single dataSource. I am now using the asp.net reportviewer to view the reports on the report server. I now would like to change the datasource in the reportviewer so that depending on the passed in datasource, then the reports point to the correct datasource.
I couldn't decide where would be the most apprioate. I looking for an online source control site, if such a thing exists? I've checked out codeplex and thats really for open source projects ? which this isn't. does anyone have a recommendations?
I don't know it happen just to me or Others have the same situation too . All the time when i bind a DataControl to an ObjectDataSource in "Configure Data Source" wizard of ObjectDataSource,when i set parameter source as "Control" in "ControlId" DropdownList there are TWO Item of every control in the WebForm , while it make sense be one.
I now have a ReportViewer control on asp.net page with datasource select Country, Product, Value from Table1. This reportviewer is associated with Report1.rdlc and currently Report1.rdlc has this matrix layout
Country as row field, Product as column field and value as Calculate field (Sum)
I want on button1click on asp.net, the report change to this layout:
Product as row field, Country as column field, value remains as Calculate field.
How should I proceed with this ? I know pointing to Report2.rdlc would be an option but I have more than 20 scenario and I want to keep doing it in same Report1.rdlc. Is there way to programmatically change the layout of Report1.rdlc when buttonclick is fired ?
I have a ReportViewer on page linked to Report1.rdlc. I want on buttonclick it link to Report2.rdlc and display new result accordingly. I tried below it refreshes but it does not change into Report2. Just stay as it was with Report1.rdlc.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) ReportViewer1.LocalReport.ReportPath = "Report2.rdlc" ReportViewer1.DataBind() End Sub
How to change the values in gridview on text change of templated control without databind again?the value of templated text boxes should change If i change the value of one of the templated textbox then accordingly(By mathematical calculations) the vlaues of all tempated textboxes should also change.
When using the Telerik ReportViewer control from inside a user control, the control bar (bar with navigation & exports buttons etc) doesn't appear to display correctly. Only the navigation buttons appear in the control bar itself. The other buttons (Export, Refresh, Print, & Close Parameters) all appear below the control bar, each on a new line.
If I do the exact same in a normal page (rather than user contorl), it appears fine.
P.S. I'm using IE 7 and the Telerik 2009 Q3 ASP.NET AJAX suite.
I've been using the Item Inserted event for my data controls, such as details view. I'm wondering if there are advantages to doing this with the data sources instead of the data control. There is a lot of overlap in the events provided by these two types of controls. Are there advantages to using the events raised by the data source instead of the ones raised by the data control itself. Should I be using the events raised by the data source instead of the control used to enter the data?
I have a Reportviewer with Objectdatasource as default datasource.
However I want the report to have a datasource with parameter depending on the label.text value so sqldatasource is ideal for this. However I dunno how to set the reportviewer datasource as sqldatasource control.
I know this sounds odd. I have a SQL DB that I am pulling data from. I have to some math functions to get a percentage. So I am pulling all the data in my code and building a data table with the results. I am then trying to pass this into a chart control that I have, but it fails because the data source is not correct for the chart control. I know that the chart control will accept a SQLDataSource control as a data source because a built a example with it before using it in my project.So my question is how can I use the Data Table as a data source for a SQLDataSource Control? Or is there a way I can pull the data from my DB andapply the math needed in a stored procedure or something similar that I could create the procedure on my SQL server then add a SQLDataSource control to my page and use the stored procedure as the source for the SQLDataSource Control.
I have a grid with an template column and in that column I have text and icon, on icon mousehover (on mode) and mousehoverout (off mode) I am changing the icon.
Now when the user click on icon it opens a popup and the icon must be in "On" mode but if the user without closing clicks another row's icon then previous must be in off and current should be in on mode.
