Within Crystal Reports XI I'm trying to have a SQL Expression Field with Oracle 10g function wm_concat(column_name). It appears that Crystal Reports XI is not handling this function properly. If I execute the function wm_concat() within the database, it works fine, however, when trying to use it in Crystal Reports it displays a blank p...
I have crystal report with 2 page headers (PHa and PHb) when i export this report to excel by selecting Excel (Data Only ) option the PHa is missing the exported excel.I tried to suppress the PHb to display PHa when it is exported to excel but by doing so the output excel has not heading displayed. ...
I have a crystal report in my application and it works fine but I want to ask if there's a way that the user can manipulate the report that he/she wants? For example, the user wants to create his/her own report. in my application, there are already reports available. They just need to click the link and it will show immediately the speci...
I ve many columns in my dataset to display in Crystal report ...... but i cant extend the page of crystal report....how can i? is it possible to display records from dataset without design the crystal report desingning? ...
Hi, We have an application which uses VS.NET 2003 and Crystal Reports version 9.1.5000.0 We are migrating this application into a different server. We had reconfigured each and every report with the new connection details and in the process of reconfiguration we had changed all the SQL Server DB connection details to new server. But wh...
Question: In the Crystal Reports report creation wizard there is the option of changing the order which more than two two tables are linked. The link between Table A and Table B could be made before Table C is linked, or vice versa. It says "The order may affect the resulting data set." How could that be true? I could see it affecting pe...
Does anybody know how to improve the performance of a Crystal Report that has a subreport? The subreport uses ADO.NET objects...and takes FOREVER to generate. ...
This page I use crystal report to generate a report, but if 10 user or more request this page at the same time, some of the user will get a runtime error. But if normal use, everything is all right. Sample code: report.Load(Request.PhysicalApplicationPath + "reports\\test.rpt"); report.FileName = Request.Ph...
Hi, I had to show multiple columns in the detail section for which i followed the following instructions: Right click in the details section, select Section Expert. Check the tick box "Format with multiple Columns". A new tab named 'Layout' appears. I set the Detail Size to half of the page width and selected the direction 'Across The...
Hello all, I wonder if there is a way in crystal reports to do something like the following: I have a table with data like this: ID MeshName RetainedWeight 654 3.3 inches 20.00 789 3.0 inches 20.00 321 1.4 inches 20.00 ... And I need to show them in crystal reports like this: ...
i use a program written in VB6 that uses crystal reports 7 for reporting. my machine crashed recently. i managed to copy the program files to a new system. when i try run the program, a file related to crystal reports is said to be missing. i was advised to install crystal reports 7 runtime. but i don't have the setup. anybody know where...
select CAST(T.GLTR_PSTNG_TYPE AS VARCHAR) + CAST(T.GLTR_PSTNG_NO AS VARCHAR) REF_NO, CAST(T.GLTR_DOC_CODE AS VARCHAR) + CAST(T.GLTR_OUR_DOC_NO AS VARCHAR) GLTR_OUR_DOC_NO from dom I have these two fields in dataset. How can I concatenate these in cryatal report to display as alise name(REF_NO)? send me solution pls ...
{GLAS_GL_TRANSACTIONS.GLTR_PSTNG_TYPE} + {GLAS_GL_TRANSACTIONS.GLTR_PSTNG_NO} I JUST invoke these two fields from database and concatenate(+) by usin string(concatenate) when i save this i got error like string is required....... what should i do? provide info...... ...
suppose if i have a few hundred thousand records in dataset how can i show this in Crystal report by allow multiple page... can u provide some valuable solution? ...
How to use the parameter field to get values from dataset in Crystal Reports? How can I assign a SQL query to the parameter field? ...
My report Groups by two fields, the second being a date field. If I go to 'Group Expert', select the second field (the date field), and click Options, I get the 'Change Group Options' dialog. There are two tabs (Common and Options), on the Common tab we now see three comboboxes. Combobox1: The Date field Combobox2: in ascending order...
I have 25 columns im my table and i have to show all columns in Asp.net Cryatal report ... But the header and details fields in crystal is not sufficient....... how can i....Awaiting for ur valuable Response ...
In my table I have values as: 5 6 12.06 15.933 I need to display in Crystal Reports as 5 6 12.1 15.9 Can anyone get me formula to do above? I tried this formula: tonumber({table.field}) But I get the result as below which I don't want. 5.0 6.0 12.06 15.93 ...
why add new cached file for each crystalreport files in .net project? In my win app project there are 15 crystal report files (rpt) and in my toolbox there are 15 cached file for each of them. how can I remove them? visual studio .net 2008 ...
suppose if i have many locations like L!,L2,L3 etc each location hasAmount column with many records how can i totl the amount of each location in Crystal report ...