I have added special field Page N of M in the crystal report, I want to suppress this field when it is last page and when only one page is there. for eg., Total Page 1 Page n of m not be displayed. 5 Pages then for first 4 pages it has to be displayed. what should I give in the suppress condition to suppress this field? Please help m...
Im using Crystal report in asp.net how can i give my sql squery to the crystal report without passing dataset values to crystal report. ...
Let's say I have a logo that I want to appear in the same place on a set of reports (many files). Is there a way for me to put that logo into the equivalent of a master page and apply that master page to all the pages of my reports? I'd like the logo to appear in the same place on a variety of documents without having to mess around with...
I have an asp.net web application. When I try to export a report via crystal report I get following error : Error in File C:\DOCUME~1\User\LOCALS~1\Temp\MainReport {7F8A9E9E-DD47-4D17-A44D-68D9478A792C}.rpt: Operation not yet implemented. I use this code to export report : ReportDocument reportDocument = reportSource.ReportDocumen...
I was wondering if someone had a suggestion on how to best do composite reporting. I have tried to accomplish this with Crystal Reports [CR] (The one that comes with VS2k8) but for a codemonkey like me, it's hard to grasp the design part... I have found that CR works nicely for reporting on tabular and repeatable data, but I can't grasp...
Im using crystal report in asp.net....I have create parameter fields to get input....Consider if i create numeric parametere field then i have to validate that particular field if user enter other than numbers how? ...
how to change the color of bar chart in crystal report vs2005?? ...
I am having trouble with Crystal Reports when using charts and images which use CrystalImageHandler.aspx. The image cannot display and I suspect this is due to a problem with MVC routing. The path image path is similar to this: src="/CrystalImageHandler.aspx?dynamicimage=cr_tmp_image_a8301f51-26de-4869-be9f-c3c9ad9cc85e.png" With...
In asp.net crystal report how can i show message to user if records not found in particular values using parameter value field? ...
I'm currently running Crystal Reports XI R2 on SQL 2000. I need to migrate to SQL Server 2008 asap, but am no longer on Crystal Support. Can anyone tell me if CR XI R2 Server is compatible with SQL Server 2008? I Googled it but came up empty. ...
Hi, I have the report with lots of sub-reports within. How can I walk through the collection of sub-reports in main report? I need this to change the data source for each sub report. TIA ...
I have a complex report printing on pre-print stationary, first page needs a short footer, second page a larger footer, subsequent pages no footer at all. My suppression rules are working fine but the short footer is being incorrectly positioned at the same start point as the larger footer. In Crystall 11, it appears the footers take th...
In our project We made reports with the method that return as a datatable from a class with dynamic sql. Nowadays, we think to migrate to more professional technic for our reports. For this purpose I examine crystal report and devexpress' XtraReport components. However, I Couldn't decide which component and method(dynamic sql, stored...
Hi, I have report with subreports. Part of them are using OBDC database type. I want to set all subreports to OLE DB with new connection parameters I've tried the following but as I understand this isn't enough. for (int i = 0; i <= rd.DataSourceConnections.Count - 1; i++) { rd.DataSourceConnections[i].SetConnection(logonProps["Data S...
Im using asp.net crystal report(not in crystal report XI) i just create parameter field datatype(string) and add some default values from the table If user didint select any value and press submit then nothing record(s) has been fetched... so if user press submit without selecting any record i have to show message to user to select ...
I have a crystal report file for print check values on check paper (cheque paper) at sometimes printer pass check paper but report remind for next page. how can I remove remind page ? how can I print a report only for one page passed without checking end of report or page size. ...
When I run the following: left({_v_kap.cpudesc}, (instr({_v_kap.cpudesc},",") )) the function outputs : ¤¤Y¤ and other variations however if I just run left({_v_kap.cpudesc}, 48) it returns the string correctly up to character 48 and if I just run instr({_v_kap.cpudesc},",") it returns 48 If I combine them, shouldn...
I have MS Access reports that needs to be displayed in a crystal report in .net windows application. Is there any way to do it or some alternatives? I am not sure about the right approach to complete this, can anybody help here? ...
im using query in crystal report like if({?User Name}) <>"ALL" then {COMN_USER_RESP_LINK_T.APPL_USER_NAME}={?User Name} else {COMN_USER_RESP_LINK_T.APPL_USER_NAME} ={COMN_USER_RESP_LINK_T.APPL_USER_NAME} and {COMN_USER_RESP_LINK_T.ENABLED}="Y" this is actual query in sql: SELECT C.APPL_USER_NAME, A.RESP_NAME,...
OpenConnect(); OleDbDataAdapter olda = new OleDbDataAdapter("Select * from RECORD where LIC_PLATE='GE 320'", con); DataSet dataset = new DataSet(); olda.Fill(dataset); cr1.SetDataSource(dataset.Tables[0]); crystalReportViewer1.ReportSource = cr1; crystalR...