I defined a report with a parameter (ID_Aluno) in Crystal Reports to show it in an .aspx page. The page is called by another page passing it a query string with the value I need as a parameter in the report. In the code behind file I tryed three different approches without success. What happen is that the report is showed without data, but when I open the parameter panel I see that the parameter is there (If I don't set the parameter value actually it complains that the parameter is missing, giving an arror).
Here is the code I used to set the parameter:
[Code]....
The First try (code not commented) is the one I would like to use because it is the shorter and simpler one.
Here is the mark up for the report source and report viewer:
[Code]....
Have I to declare or define something special in Crystal Reports for the parameter to be received and applied?
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report using CrystalDecisions.ReportSource; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?
I am trying to use crystal report for my project. I have made .rpt file as instructions in the tutorials now the problem is with crystal report viewer control... i hav set its its report source to the one that i have made using its properties.. but still its not working..I am using professional edition of visual studio 2008 with .net frameowrk 3.5
I am using MVC for a reporting website for our company. I figured out that MVC doesn't support Crystal Reports but Asp.net webforms can be added to it and then there is a workout.
1) I have 25 Crystal reports to add to the website. Is it a good idea to add webforms and make crystal reports.
2) Is there a way that I can use one Report viewer and 25 Crystal reports display according to the condition?
We would like to have an option to print a report directly from Crystal Report Viewer (from an APSX page).
When the user hits the print button on the report viewer, this brings up the preview in PDF and then the user has make an additional click on PDF file which inturn brings up the print settings window where we have the print option.
Is there a way to eliminate the steps in between so that when the user clicks the "Print Button" on the Crystal report viewer, it somehow directly brings up the print settings window. (Does not matter even if Acrobat Reader opens in background if the print settings window opens along with it)
i have maked a form which is saving used detail . how we can print the same record after saving. i have maked a report viewer which is print the data when we give the date and name. but i want print report currenty which saved.
i need i have a print button in form so i need when i click them it should print the current record which is i saved currently.
Am using northwind sql server database to do a test. Using customer, order table to show master detail report. Customerid is the reference. After Create a Parameter to run the subreport. Some how i cant able to refernce the master, detail. so it will show all the records in the detail section instead of showing relevant customer id details from the orders table. pls see the picture belowMainreport - > call the subreport parameter. but i miss with one more step to finish the report "Filter Expression", i guess. how to pass the parameter value subreport filter.
I am developing we application using Csharp on Visual studio 2008.How can I pass values from Page or GridView to a Crystal Report? For example I want some details on a Default.aspx want to appear on the Crystal report when I click on it. How do I pass theses values from Page to crystal report at Runtime?
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure. In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.
2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.
I am developing a web application and I am using a crystal report for my project, how can I pass the query string to the crystal report using the database.
I have an ASP.Net (.Net 2.0) application that creates Crystal Reports (version 11.5) and shows them with CrystalReportViewer control. For some reason the control isn't showing the logo image in the header of the report. It renders the following html
I am using the following code to pass parameter from VB to crystal report but getting the error messgae "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))" while it trying to add the first parameter. This chunk of coding works in another VB perfectly. The only diffferent is the working one takes the parameter to stored procedure where the failed one I added parameter during crystal report design time.
I am trying to pass date as parameter from my asp application to crystal reports.
If I pass 1 jan 2010 to 16 Jun 2010 it will not get me some of the records which are on dates like 11 april 2010. And If i select dates between 1 Jan 2010 and 30 Nov 2010 then system will get me the records. Here I understood that system is not understanding the date format the problem is in date format of "dd/mm/yyyy" and "mm/dd/yyyy".
protected void btn_showReport_Click(object sender, EventArgs e) { //ReportViewer1.Visible is set to false in design mode ReportViewer1.Visible = true;
[Code].....
Parameter 'Comp_Name' does not exist on this report
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: Parameter 'Comp_Name' does not exist on this reportSource Error:
I have a crystal report which accepts a parameter and gets displayed on a webpage abc.aspx
On another webpage i have a grid displaying columns from a table loan_request.
When I click a row in gridview I want to get the report of that corresponding row.
I used rowcommand on gridview to get the value that uniquely identifies the row in a gridview, now I need to pass this value as parameter to the crystal report.
for this i think two possibilities
1. pass the value as querystring.
2. store it session and use it on the page that display the report.
I am working with crystal reports. I created a button on crystal report viewer toolbar using the following code protected void Page_Init(object sender,
EventArgs e) { Control ts = CrystalReportViewer1.Controls[2]; if (ts.ToString().Contains("ViewerToolbar")) { ImageButton BtnExport = new ImageButton(); BtnExport.ID = "BtnExport"; BtnExport.ImageUrl = "images/pdf.png"; BtnExport.Click += BtnExport_Click; ts.Controls.Add(BtnExport); } UpdatePanel UpdatePanel1 = new UpdatePanel (); System.Web.UI PostBackTrigger trigger = new System.Web.UI.PostBackTrigger (); trigger.ControlID = "BtnExport"; UpdatePanel1.Triggers.Add(trigger); }
My problem is whenever I click the button to export the report, it shows an error like below: Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near .....
