Is there any way to hide the 'Enter Parameter Values' dialog box from within settings of Crystal XI?
or is this only possible from the .net code reporting engine?
-----------------------...
I need to convert a julian date from odbc connected AS400 worldvision to regular format using SQL expression in crystal report. I use the formula below which works but for certain dates it gi...
Hi Gurus,
I have a main report with multiple drill down
For example 3 level drill down report
Country -> State -> City
So after 1st level drill down I get state details in that I need ...
I'm trying to remove a double quote from a string using the following formula:
replace({mydatabase.field}, """, "")
but I get the following error:
The matching " for this string is mi...
I am using Crystal reports to design and run reports through an ODBC connection to a Progress/Openedge database. Generally it works well. However whenever I increase the size of a character fi...
Hi, I have been searching for my solution on EE, but can't find an exact match. I am using Crystal Reports XI to write a report and developed the SQL statement to display all of the data that...
I have a report where i have 2 weight values grouped together so in the group footer i have those 2 values added together. I was wondering what the best method would be to know how many of th...
I have a CR file using SQL 2000.
This CR report has a field that doesn't display its contents, it keeps displaying "0.00".
I went into SQL analyzer and ran the scripts of CR and the file...
I have a field that i need averaged but cannot seem to find a way to do so using running total fields. I s there a way? Maybe using a formula?
Is it possible to generate multicolumn report where there will be only two columns in the report not more than two. I know in detail section you can select "Multiple Column" option but this wi...
I am using C# to display a crystal report in a browser on a web page, the problem is that I get an error that is listed below. Now i know it is some sort of version problem with the Visual St...
We have a Crystal XI report that has one parameter value that is a "static" rather than "dynamic". It works fine and, when you type in a value upon refreshing the report, the data is correct....
I have a data like this:
Date of service name service
I want to find duplicates when the date, name, and service are the same.
The report can either flag the row in bold or color OR do ...
We use crystal report 11.0 for generating reports. Application is developed using VB6.0. We have used CrystalActiveXReportViewer(crviewer.dll), to generate the reports.
At one of our client p...
I have a formula field and i want the output to be this
( 3 @ 96 )
I am using a formula field with this code
If (table.No_of_Cables) Then
"(" & Truncate(Table.No_of_Cables) & " @ " ...
I get the above error within CR XI Developer when I try to connect an ODBC link to a Visual FoxPro database (.DBC).
The full messsage is:
Database Connection Error: '42S02:MicrosoftODBC ...
I have a report that prints our packing list and it has totals for number of packages and pallet count that are calculated in my stored procedure when I gather the data. I need these to print...
I have about 30 crystal reports that will work on certain workstations, but not on others and I am trying to figure out why. The first thing I found was that the machines that don't work have...
i want to have two sub reports on a drill down level
both these reports should be displayed together on 1 page
currently i am facing a number of problems
the subreports overlap on o...
I am stuck here very badly and need your help desperately.
I have a VB.Net Desktop Application(visual studio 2005) which uses Crystal reports XI release 2.
When I run the application on my ...
Am I missing something?
How do you see/set the height of a section.
Yes, I know you can drag the section height bar with the mouse, but suppose you want the detail section to be exactly ...
I created a Cross Tab Report in Crystal Reports with a group. I placed the cross tab in the Group header and all the data is fine sorts are fine. The question is how do I get the cross tab t...
I am modifying an existing Crystal Report with Crystal Reports 9, which is being called from Visual Basic 6.0.
It contains one subreport and works fine before my modifications. I made the f...
I have a Crystal Report that has a crosstab. The rows are grouped first by Classification and then within each Classification are a list of corresponding Projects.
What I'd like to be able...
Hi,
In Crystal Reports 2008, when I choose a parameter in the Select Expert, the following error ocurrs and Crystal Shuts Down.
"Unhandled win32 exception occurred in crw32.exe"
Any i...