i have successfully deploy my reports to our SQL reportserver and i was able to display it in a reportviewer in my site. but my problem is my reports is requiring a parameter to display the report, at first the parameterPrompt is were i manually
encode the parameter value, but i need to dynamically pass the parameter value without manually encoding it in the parameterPrompt.
I am getting this error that is related to ReportsViewer. I need to eliminate all references to this library. So where do I need to start deleting the references?
Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
I just migrated myDocuments folder to a new laptop (windows 7, 64 bit). The visual studio project WAS working on my desktop computer (windows XP pro).
Runtime error is:
ASP.NET runtime error: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f
It references the config file, so I am looking to see if I need to add something in there or what?
I have ajax control toolkit in bin folder ,i have win 7 inmy system but still i m getting this error ..
Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Using the Asp.net Report Viewer in VS2010 in Remote mode we need to allow the user to use the default controls on the report viewer for entering in the parameters before running the report.
As permissions need to be set on the data we have a UserId hidden parameter on all the reports and the plan was to allow the user to enter in the parameters as normal and then we would add [programmatically] the userId parameter before the report is run.
The data in the report would then return the data that the user had permission to view. [We use the SSRS web service to populate a treeview with a list of available reports for the user to select.]
I guess I'm having trouble with whats the best approach for this. I need to pass the userId parameter value to the ReportViewer and not to the server report. I'm aware that you can use the web service to manage the parameters completely outside of the control but its not an option for us at the minute.
So in summary:
User Selects Parameters in the Report Viewer. Code behind adds the UserId parameter value either as the report is run or initially when its loaded and the viewer passes all the parameters to the server.
I have created an ASP.NET page and included a ReportViewer on the page.
I have created a report with a parameter for an item ID for a row from the database.
After generating a multivalue parameter, I send it to the report, but only the first item in the list is displaying.
In my included code, I am using a FOR loop to generate a list of ID's I want to print a detail for (one detail per page), but eventually I am going to allow a user to select the ID's from a GridView, generate the reports and then print.
Here is the parameter definition from the report:
<ReportParameters>
<ReportParameter Name="ParmWorkOrderID">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
---------
Here is the code that build the multivalue parameter:
List<ReportParameter> paramList = new List<ReportParameter>();
ReportParameter param = new ReportParameter("ParmWorkOrderID");
// Create the ArrayList of values to pass
ArrayList values = new ArrayList();
for (int i = 19; i < 50; i++)
{
param.Values.Add(i.ToString());
}
// Add the parameter to the list of ReportParameters
paramList.Add(param);
// Set the reports parameters
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] {param});
-------------------------------------------
Finally, here is the filter I have on the report:
<Filters>
<Filter>
<FilterExpression>=Fields!WorkOrderID.Value.ToString</FilterExpression>
<Operator>In</Operator>
<FilterValues>
<FilterValue>Parameters!ParmWorkOrderID.Value</FilterValue>
</FilterValues>
</Filter>
</Filters>
So, why won't the reporting engine pump out one page or row (if I use a table on the report) for each of the ID's sent over as parameters?
I have built visual basic windows forms application with Visual Studio 2010. I want to be able to create a report with a yes/no parameter that show either a detail list or a summary only.I built such a report with a windows form and reportviewer.I used View Report Data in the report design mde to create a "ShowAll" parameter but I am now unable to provide this parameter at runtime because the reportviewer does not prompt for a parameter. I found no visual basic code to set "ShowAll" parameter from a report form checkbox placed on the report form to the reportviewer.
View 2 RepliesI am having two tables in a database linked each other by means of primary and foreign key. In my report I'm having parameters but itzz not workin.
When I use just two tables I can able to view my report, when I deploy parameter in my report it didnt affect my report in any form it showing normal report without parameter. How to pass parameter in it.
I have a requirement whereby my users need to be able to select the options in the 'departments' dropdown list (multi-valued parameter) of the report based on his designation. For instance, normal users should only see his own department while the administrator could see all the departments in the organization etc...The departments that the users could select are already retrieved in my code (asp.net). Now I need to know how to pass those values over to the reportviewer to populate the departments dropdown list in there. Any idea how to come about doing that?
View 8 RepliesI have a website that I am trying to configure the ReportViewer for. I need to be able to pass the parameter by way of a querystring. I have setup the report, the datasource and everything functions as it should when I hard code the parameter value. However, when I create a querystring on a separate page, the report displays the error:
The 'OrderID' parameter is missing a value
Binding the image as the report paramater in rdlc. I am using report viewer.
View 1 RepliesUsing ReportViewer control v9 in .aspx page - When displaying date type parameter field in my report nothing happens when calendar icon is clicked (no calendar page, no error) in ie 8. FoxFire works.Same report works fine when viewed directly on the report server in ie8.
Report Server is SQL 2005
My app is an ASP.NET 2.0 website. I use UpdatePanel to contain all UserControls. I also use ReportViewer control (local mode) for report function. When user click on "View Report" button, a javascript will be executed to open a new window which contains the ReportViewer control. Everything works well in my pc (Windows XP, IIS 5.1).
However, when I deploy the code to app server (Windows 2k3, IIS 6), I encounter a critical issue. After the report window is opened, whenever I click a button or change value of a DropDownList (UpdatePanel will be reloaded after these actions), an exception "Failed to load viewstate" is thrown.
I've tried to update the Report Viewer Redistributable 2005
(http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e7d661ba-dc95-4eb3-8916-3e31340ddc2c) in the server to SP1 (assembly version: 8.0.50727.817),
I created a tabcontainer that contains initially 1 tab, but when the user clicks on a button, it will create a new tab and make this one active.
The newley created tab contains a reportviewer where i should load the report from the sql server. But I'm getting this error in jscript --> this.m_clientController = null in OnReportLoaded
Tried to add a new button on this tab2, and it works so I'm not sure what's wrong... can someone give me some indication?
m_tabContainer.Tabs[1].Controls.Add(ReportViewer1);
I am getting an error : Unable to load Print control with the defalt print option of the report viewer
there is a RSClient.cab which we would need to install to get the print control running in every client but then all the clients in the organization would not have a the admin rights to install it.
I am developing a .NET 3.5 web application. We are using some of the Microsoft Reporting tools, which are a pain but a digress, and when I deploy, I get errors when trying to load the site.
This is the error:
[Code]....
However, my web config reads:
[Code]....
I specify 9.0.0.0 in everything. The only concern I have is that the build server uses .NET 4.0 but I have specified to build with 3.5 and on my deployed server I have the 9.0.0.0 dll files for the report viewer. why the server is looking for 10 when everything says 9?
in my gridview item template filed i am calling an method CheckValue
<asp:Label ID="Label1" runat="server" Text='<%# CheckValue(Eval("Imagespath")+","+Eval("Imagesname")%>'>
</asp:Label>
protected string CheckValue(string strValue1,string strValue2)
{
if (strValue1=="1")
{
return "No Record Found";
}
else
{
return "No Record Found";
}
}
when i run my page i get errorin my .aspx page Text='<%# CheckValue(Eval("Imagespath")+","+Eval("Imagesname")%>'> is there any way i can send my value CheckValue method which isa .cs file how can i send 2 paremeter from.aspx page can anu one tell me the syntax for it
I have made an application where I am displaying the .pdf , .doc , .docx files. These files are uploading from an Admin Panel.When user place a mouse pointer on download icon provided in front of every file, it shows the complete path where it’s get saved.I want to avoid this path visibility even when user place mouse on download icon and even if it Inspect an element (as most modern browser will have this functionality).
View 1 RepliesA page with a email button and PDF file loaded.
User fills the form and clicks to email button
and local smtp engine creates the email with this pdf file attached.
Is it possible when a page loads to set the visibility of a LI tag?
View 4 RepliesI have a virtual web folder that has large number of PDF Files (Leave Forms) submitted over the past 5 years.
The users and other applications have direct references to such files and on some cases, the PDF is referenced as embedded object.
Here is a snapshot of where the PDFs are stored:
So, the direct link to the PDF will look like the following:
[URL]
Becuase the PDFs are stored under a folder under the ASP.NET Web Application, it was a bad idea.
Now, I have to move them all to another location which is simply a virtual folder outside the Web Application.
All Leave PDF Forms have Unique URLs which is:
"SessionID" + "/" + "Leave-userid-start-date.pdf"
So, I need to replace the above link with the following after I move the PDF Files. I want the replacement to happen at the time it is requested from the Client Browser. The new URL will look like the following:
[URL]
So, whether it is requester from IE from any other Object Tag or similar, then the input URL should be replaced with the new URL as shown above.
When I run the code below, nothing happens.
protected void Page_Load(object sender, EventArgs e)
{
System.IO.FileInfo file = new System.IO.FileInfo(Server.MapPath(Request.QueryString["path"].ToString()));
Response.Clear();
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.WriteFile(file.FullName);
Response.End();
}
The url of the page, is:
http://mysite.com/Lib/Rs/Download.aspx?path=/uploadedFiles/110210_CS_ADM-Coaching_SG_Final.pdf
If I add a param to the url and refresh, the file will load.
http://mysite.com/Lib/Rs/Download.aspx?path=/uploadedFiles/110210_CS_ADM-Coaching_SG_Final.pdf&ur=1223
Why wont the file load on the initial page load, or how do I get it to?
I am building master page in the wwwroot directory and also i have AboutUs folder in wwwroot directory.
I have default.aspx file in AboutUs folder, and it is using master page , but when i run default.aspx file then it does not load header image, which is part of master page.
can someone tell me why header image does not get load? and everything else from master pages gets load?
I am sure this is something to do with file path?
I want to download a file from database using asp.net c# code in page load event.My table design as below
Table Name: tblFiledownload
Id - int
Data - varbinary(MAX)
FileName - varchar(50)
FileExtension - varchar(50)
I am using Visual Studio 2010 and I want to make some reports dynamically. I want to display in the reports viewer my own created dataSet and table adapter. Is this possible? Or it is possible to change the connection string from the dataset at runtime? I have different connections strings which are defined in the settings.xml file and i want to use this strings at connection.
View 1 Replies