I have a Crystal report that is based on a parameterized stored procedure. The report displays the value of each parameter as well as the data. In normal use, everything works well. I now need to add some extra functionality to my reporting application, to do some extra processing on the data returned from the stored procedure. To achie...
Hello , Can a crystal report be scaled to fit page? I'm hoping to achieve something similar to Microsoft Excel's Scale To Fit feature wherein a large spreadsheet can be scaled to fit a 8.5"x 11" page. (On MS Excel 2007 goto Page Layout > Scale To Fit). Im searching of a way to make a large report fit into a smaller page during print....
Problem in crystal report After excecuting the bellow code,In my report page it ask like "The report you requested requires further information" server= user= password= databse= protected void Page_Load(object sender, EventArgs e) { MySqlConnection sqlcom = new MySqlConnection("server=localhost;userid=root;password=root;database=he...
I have some reports developed using Crystal Reports 12 and I want to version it using Visual Source Safe but I don't use Visual Studio. Is there a way I can do this without VS or do I have to install VS in order to version my CR reports? ...
Hi folks, what's the proper way to display an image (bitmap) stored in sqlserver 2008 database as an varbinary(max) datatype in CrystalReports for .NET? I have added a 'blobfieldobject' item in crystal reports & it is bound to a datatable with the column of type 'varbinary(max)' but the image won't show up instead a dark background is ...
I've got an asp.net application running on a windows 2008 64 bit server that gives an error after printing a crystal report. The server has CR 2008 runtime sp2 installed and views fine. When printing from the print button of the CR viewer the print dialog appears and prints correctly but throws the following error message after printin...
how to connect asp.net Crystal report with mysql database. like sql server database connection .is there any connector available to do this.. ...
I have a single crystal report that usually ends up about 150 pages long. The single .rpt, through the use of clever grouping, actually includes records with little individual header and footer sections for each customer. Think of it as a sales report for 100 customers, each with their own section. Each customer section is 2 to 7 pages ...
Hi all , I want to print a set of invoice for my application. So I need to display all invoices in report viewer before they print. are there any methods to bind multiple reports to same report viewer using crystal reports or rdlc. I try rdlc but I couldn't find any way to do that. please any one can provide code sample or instruction...
how to get the sum of the particular column value in crystal report? ...
I have a winforms project which I keep in different versions, each version having its own project folder. All these projects use the same database file, which is copied in each project folder too. So if I run a project, let's say 0.34, and then I try to run 0.35, all the database functions don't work, unless I detach the database in SQL...
Hi, we have Crystal Reports 2008 on the Tomcat 5.5 server, and use the Java SDK to display reports and convert them to PDF. Since the server has its own database, we have to set the data source on the DatabaseController to make CR connect to this database. We do it like specified in the docs, and tried the functions in CRJavaHelper, bu...
Is that possible to bind two dataset at a same time. in asp.net crystal report? i tried bellow code.But it ask..server details. Invoice inv = new Invoice(); inv.OrgId = Session["org_id"].ToString(); inv.InvoiceId = invoiceId.ToString(); ds = _reportController.ReportPrintBi...
My team member not supporting to use Crystal report in asp.net web application. specially Crystal report with mysql database. Is there any other report available? ...
I have a formula which is working; the formula uses an array. I tried to extract the formula to create a custom formula but now get an error in the syntax. I am wondering if the array is causing the problem as the error is on the line: last_element_current:=val(sc_array[1]) + 1; and the error is: the ) is missing and highlights the va...
Hello, I have a Crystal Report Viewer on my ASP.net page that operates on parameters. When I pull a report and click the "Back" button, then click the "forward" button, it pulls the same report/parameters. I need a way to make it RE-PROMPT me for my parameters. The "ReuseParametersonRefresh", button is set to FALSE. Anyone know of an...
I wanna make a crystal report in my c# windows application, the point is I want to use .net objects as my report datasource, I found its sample code as below in internet and use them and it works fine: ArrayList Mainlst = new ArrayList(); Mainlst.Add(new testOBJ { Firstname = "test1", Lastname = "test11" }); Main...
I made a crystal report using c#.net, we can add only the objects that exist on the project that contains crystal report, is there any way to add .net objects from my business layer to my report and how? ...
We're upgrading from VS2005 to VS2010. We are almost there but there is a problem with Crystal Reports. We use the RDC (COM-based) component within our C++ application. On Windows 7 or on VISTA, I can't get the viewer nor the designer controls working. I get Access Violations when the control is activated: // from atlhost.h (line 2208)...
I have a dataset with a single group. I have written a custom suppression formula to suppress the Field1 value where Field1 = previous(Field1). However, it continues to suppress when a new page starts. Is there a way to accomplish the following: --p1-- Value1 Value2 Value3 Value4 Value5 Value6 V...