Crystal Reports XI

one field not printing Crystal Reports XI

Report has been working for several months. Now field does not show data on preview, but if I browse the field it's there. Thanks

More than one level nesting in crystal reports

Hi, **************** Using: Crystal reports XI release 2 Database - DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen B...

Find hidden subreport

How do I quickly find a hidden subreport in Crystal Reports.

Crystal Reports to SSRS

There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in...

Crystal New Connection

When trying to create a new connection to a different database receive the following message "Crystal Reports has encountered a problem and needs to close" then cystral closes.

Crystal reports XI formula window not appearing on screen and main CR page losing focus

While running CR, when I try to use the formula editor either in the formula fields or selection areas, the window does not appear and the main CR page looses focus. It seems to me that the editor screen is someplace, but it is not visable. Any ideas?

Crystal reports formula - equal or less than 60 days

Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.

security privilege

When report was query error appear as "A request was cancelled. The necessary security privileges could not be verified. This indicate a problem with the security server"

Field in crystal reports duplicating lines from quote

Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database. This is hard to describe accurately but here goes... I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes. QUOTE_Binary_to_notes is...

Suppress duplicate subreport data

Using Crystal Reports 11, I have a report with 2 subreports A and B. Sometimes the two subreports will show the same data. Is there a way to suppress data in subreport B if it already exists in subreport A? My report is laid out as such: Group 1 Header Group 2 Header Details Group 2 Footer...

Crystal Reports exporting issue

Hi, I am using crystal reports XI Release 2 to develop reports and I will deploy the reports in Crystal reports server using Central management console at client location. My requirment - I have developed a report and it consists of 4 ondemand subreports. I have to export the reports( main and...

Crystal Report XI authentication

Please help on implementing the authentication feature to open the Crystal report XI. Every time user opens the report it should prompt for user name and password

Date Conversion In Crystal Reports 11

I have a datafield {artrans.invdte} thats is a string lenght of 8 formated "MM/DD/YY" trying to check this date against ToText(currentdate, "MM/DD/YY") to select records not working . Tried a pramater field @date StringVar DT := {artrans.invdte}; NumberVar YR := Val (Split (DT , '/')[3]); if...

crystal report 11 and subtotal

If you have 1 file and in that file you have multiple records by date. so if this was the file year 2008 $100.00 Year 2009 $150.00 and you want a subtotal or difference in year 2008 and year 2009, can this be done without defining the file twice?

How to set fixed number of records in details section in Crystal Reports XI

how to set fixed number of records in details section in crystal report XI

Font problems when exporting the crystal reports into pdf

I usedArial Fonts in Crystal Report.When i export the report into PDF format, some of the Characters in the report contents are displayed like chinese. Please help.

Crystal Reports Calculations & Formulas

I want to do the following in a Crystal Report and I'm not sure where to start. Raw Data Points: Admit Date/Time Patient Seq Number (Same number follows then through all hospitals in our system) Patient ID (a new number assigned at each new visit) Facility ID Department The report needs to give a...

create event

how do I create an event in CE XI R2?

Domino and crystal report 11

How can I get the domino connection to show up in crystal report 11? yes lotus is installed.

A report that works in Crystal Reports client does not work in CMC

Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week's data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record....