Search results for query: *

This is on the main page of the Form where it has like over 10 different Subreports. I click on Section Expert and select the SubReport....I tried 'New Page Before' and 'New Page' After to print the details of the subreport on each and every page. where Somehow it still prints on 1 page for 2...

From within Crystal itself it looks and runs fine but from outside of crystal. Business Objects renders the report as a PDF, it does not look right... the widths are not completely used up, but wraps into the next line after 5 1/2 instead of at least 6-7

if isNUll({?ADDITIONAL_WORKERS})=true then {?ADDITIONAL_WORKERS} = 0 else {?ADDITIONAL_WORKERS} = {?ADDITIONAL_WORKERS} What I am trying to do is... in the prompt if the user or system finds no Additional workers then it will still return the default data of the person or what values is listed...

I am fixing some crystal reports which has a few parameter prompts for certain case numbers and data ranges. If the user does not fill in any data it will crash crystal reports. How do I allow no values or no data in the parameters and insert a sysdate if no value is entered in the prompt? Thanks

How to create a footer page XXXX of XXXX [the XXXX represents space] instead of page 1 of 20, then 2 of 20,etc... Thanks

Individual Crystal reports are being launch by any user using a Java application. They use the Java web application and then goes through different screens, sets different radio buttons, etc and clicks on submit. That launches Crystal reports and the user is able to view the report, save it as...

I have a report with many subreports. All are working well but one of the newly created subreport is not displaying at all. The development side shows the subreport fine but not on the main report. There is no suppression, code or formula that prevents the subreport from showing. The main report...

Front End is a JAVA application and using crystal report enterprise.. database is Oracle 10g. Errors are below org.apache.jasper.JasperException: java.lang.IllegalStateException: getOutputStream() has already been called for this response at...

I have a SQL on a report which populates a report. The query basically is a command and just drag and drop those individual values onto the report. The first 2 name values will always be a Doctor and the second a Therapist. As the values will populate the form through command, I am not sure how...

How to add case statement to this: Replace({Command.ROLE}, "_", " ") Like if {Command.ROLE} = 'test' then {Command.ROLE} = 'ANALYZE' else 'NA' .... there are like 100s of them...

Case when trim(a.DOMESTIC_ADDRESS_LINE1) is null then a.DOMESTIC_ADDRESS_LINE1 else 'Not Available' End Address I want to also incl if the address has an '' [Empty Set]... but tried different ways and did not work. As I pull data which is null but some are blanks which are '' I believe

Name: Jane Bell Role: Supervisor Phone: 712-419-2031 Address: 123 Main Street Armadillo Texas Name: Jane Bell Role: Therapist Phone: janebell@gmail.com Address: 234 North Hill St, Armadillo Texas Name: Jane Bell Role: Primary Worker Phone...

An employee can have one or more roles [sometimes even up to 4-5 roles] sometimes a dozen more. The data comes in a tremendous amount. I tried to use Group expert to remove the duplicates but it still shows. I am trying to 'Show' only if the employee is a Supervisor and a Primary Worker. name...

Any ideas what can be done to save as a Template Report. I have a regular report now with date connections.

The main report has many subreports but the subreports are all using the same parameter prompts. As the report was outsourced to India the job/ project was distributed piece by piece to do certain parts and them reassembled here in the US. As they are all subreports.. the parameters are all the...

Is there a fast way to create padding in crystal reports? or do I need to redo all those subreports? As some of the words are touching the lines of the reports.

I use the Format/ Common Suppress if duplicated. But somehow the data still shows the duplicated data. Is there a way to show only one instead of all... There are just 4 fields.. like Phone no, person name, Person role [in here the person can sometimes be the buyer, the seller or the approver]...

The database has all the fields as telephone nos.. like (702)223-2222, somehow a few has email address instead of phone nos. How do I show like if it is not a phone no then show it as NA or 'Not Available'. Thanks

I am not exactly sure on how to do this. A main report has dozen of subreports with dozens of parameters with each subreport focusing on a particular area like finance, last purchase, what was purchased, etc. But it seems data is passed using 1 or 2 primary data through a Command query. It seems...

In the Commandtext box shows Wellbeing. I want it to say Well Being instead. Tried several things I am not sure why it still does not say... tried Select Expert like this if {Command.INITCAP(MISSION)} = "Wellbeing" then {Command.INITCAP(MISSION)} = "Well Being" does not work