Alright, I'm going to try my best to explain the situation with an example...
Let's say my report is a list of people. I have 3 tables in the database: PEOPLE (list of all people), FRUITS (...
How do I change a currency field to a number field in a formula?
Crystal reports XI
the report which i am creating, has a group on 'States' . I have assigned Ascending order for this Group. In the Details section, there are Month Values, eg. Jan 2007, Feb 2007 etc. But these ...
I am wrtiing a crystal report where the user can "check" or "select" up to 5 boolean parameter fields as true. The user has the option to check all 5 boxed or none of them. If the boxes are ...
i have 10 graphs spread out over 5 pages. I need to leave exact same top and bottom margin for all the pages..how do i achieve that.
graphs are in RH
I'm new with Crystal so bare with me. I'm storing JPG images into a field of type "image" in a MS SQL database. In my report I dragged that column onto the report. In the image properties I ...
My company had ordered a Crystal XI's Professional Edition. My question is which is more better, Developer or Professional? Can I design the same quality reports with Professional Edition simi...
hi there
in the report i have 2 colums that hold a sum
sum 1 sum 2 total
1000 100 formula Col that return the sum of Sum1 + Sum2 = total
the problem is if in the Sum2 is...
I am trying to do the formula for a conditional format whereby the color must display RED and BOLD if the currentfieldvalue = 0. This is my formula but it keeps on telling em that a boolean is...
Hi Experts,
I just some clarification about CR versions and releases.
At present, I'm running CR XI. There are also CR XI Release 1 and patches available for this version and CR XI Relea...
Hi,
I have crystal report with one parameter field (range value).
I'd like put values in Report Page Header.
How can I do that ?
I mean if parameter field are dates: 01-01-2008 - 03-31-20...
Is there an easy way to write a formular to say if Any report value or any of these "1,2,3,4,5," values are <0 then crred.
Basically i want to show any negative value on my report, anyfield...
I need to sum up a formula in my main report of values passed from the subreport. My sub report is linked to the main report for each patient id. Patient 1 has a charge of $5,000 (pulled fro...
I need to mask all but the right-most digits of a customer's bank account number that is printed on a report.
I have a formula field I created using the wizard to SUM with one condition. I'd like to expand this feature so that it SUM in a different way. Currently it will sum my charges field if the ...
Hi Experts,
I have created a specific report for a particular user to run on a daily basis.
All I want for this user is to fresh her report with updates, then EXPORT the data from the CR...
I have developed an application in Visual Basic 6 and I am using Crystal Reports IX for the reporting. On one of the reports I want to print three copies of the report and on each copy I want...
I have a report that contains a parameter field - ?Report Period
I want to delete that parameter field. I removed all instances of it in the selection formula. I then exported the report ...
Dear Experts,
I need to create a formula field in Crystal Reports X whose value depends on the result of a bitwise operation on some field from my database. E.g., say the field from the dat...
I am new to c# and have never worked with Crystal reports before. I have a datagridview in my application that is populated in runtime using sql queries based on the request from the user. I w...
I hope this doesn't come across too confusing.
I have a Accounts Receivable Statement Report that I am having an issue with. The report is grouped by a common Code say 'BELL'. This common c...
Need to buld a report from one Foxpro table with multiple columns, columns represent earnings, deductions and taxes, how do I suppress items in columns that do not fit formula criteria that sh...
Part A: In two places on the main menu, file/options/reporting and file/report_options, Crystal refers to "default" values for nulls and gives me the option to convert null values to defaults...
I have a report which has records like this:
ID Number Gross Earnings Salary Sacrifice Salary Sacrifice Type
001234 100,000 200.00 ...
I have a report for which Crystal says that a certain field object exists but I suspect it doesn't and doesn't appear anywhere on my designer screen. Is there a way or a utility that will help...
