Search results for query: *

We have a report grouped and summarized by date. Detail is supressed, footer with Running Totals is displayed. The way Crystal Reports works, when no records come in for a particular date then no summary is printed for that date. The boss wants to see ALL dates, regardless of whether there...

This should be a simple Crystal Reports 101 task but it's not working for me. This is a simple report that uses an Excel file as it's source and does not use grouping. There is a number column and I want a sum at the bottom. Right now there's a simple running total that sums the column for...

In Crystal 2008, when a report is viewed and then refreshed, the user is prompted to use exiting parameter values or enter new ones. If the user selects No to enter new values, the Parameter window appears containing the previously selected values. Is there a way to CLEAR the previously...

I have a report in Crystal 2008 with several parameters. Is there a way to make the Enter Parameters window larger so users don't have to scroll?

I'm using a Date Parameter in Crystal 2008 set up for ranges. I like the convenience of one parameter field instead of two, and it makes for a better screen design. Is it possible to set defaults for the start & end date, such as say... 3/1/2010 for the start date and the current date or "No...

I have a report which lists customers and displays a value that is the result of a number of formulas within the report. The boss wants to sort the report by this value descending. I'm not aware of how Crystal can sort by values which are not available in the source data. Is there a way to...

I have a report which produces a chart based on a formula which I would normally do as a running total. As I understand it, charts can't be based on running totals, so I've added a global variable which is initiated in the report header as Global NumberVar var := 0 Then in the detail section...

Is there a way to use a thicker or heavier line on a line chard?

All: I have a report grouped by a date field, grouping by date. On each section footer is a formula that calculates a value based on a running total and another formula. The boss wants a line chart that shows the value of this formula field for each day. Now, I understand that charts can't...

I have a optional parameter field in Crystal 2008 which allows multiple values. If the user doesn't want to filter by this field, they should leave it blank and see records regardless of what is in this field. I've tried the following in the Record Selection Formula: (if {?PARAMETER} <> ""...

We have a report that needs to be exported to PDF and emailed at 5 am each morning. The 3rd Party "Schedule-Export & Send" aps I've tested don't seem to work when there is no logged in session on the computer. Is there a free or low cost solution that will export & send on a schedule that...

I will be building a Crystal Report (2008) which will read an Excel file which will contain linked to a second Excel file. When opening an Excel file of this type, one must initiate a refresh of the linked data. Is there way to make the refresh happening when using a 3rd party tool to Export...

I have installed MySQL 4.1.9 and MyOCDB 3.5.1 on Windows XP SP2. I copied a database into it and can see the DBs using MySQL Administrator and MySQL Query Browser I have created a Machine DSN in ODBC using the MySQL ODBC 3.5.1 driver and the test button produces the "Success; Connection was...

All: My company lables customers as Green/Yellow/Red depending on how happy they are with our service. I'm trying to do a pie chart in Crystal 8 Pro illustrating the percentage of clients with each rating. The best I can do is show Red as red and Yellow as yellow, but Green is shown in the...

All: I need a report of all clients who have purchased Product A who have NOT purchased Product B. Writing a selection forumula to find out who has Product A is simple enough, but how do I exclude clients who have both Products A and B? Dan

All: I'm using Crystal Report 8 to write reoports that will be launched by a SQL 7 front-end that uses Crystal 5 runtime files. Some of my reports work fine when open from the database client ap on machines with the full version of crystal installed, but when opened by the db client on a...