Recent content by dancar

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...

Interesting.... Yes, the Section Expert does suppress the detail section when an account name isnull or = "". This is to prevent blank lines from the spreadsheet from appearing in the report. When I turn that off, I see a 1 in the affect column at the bottom of the data that doesn't appear...

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...

That was it. THANKS!

I took your suggestions, but no change My ShowValue (named ShowProjected in this report) is ToNumber(Split({?Pm-@ShowProjected},"^")[RecordNumber])

I've been through the steps in the linked document, but all I get is a blank white space where the chart should be. Here's what I am doing that differs from the document. First of all, I'm using Crystal Designed 2008. Next, the main report is grouped by a date summarized by each day. Because...

I found another solution. I did a Save As on the original report making a new version with the Report Header, Page Header and Report Footer suppressed. I'm using a 3rd Party schedule/export tool to export the report to an Excel file. A 3rd Crystal report uses this Excel file as it's data...

The SQL Expression option (Crystal 2008) is greyed out. This may be because my source data is a CSV text file and not a formal SQL or Access file. Am I out of luck?

Are you saying that essentially the entire report must be written as a SQL query?

//CreateDate Create_On added to source data only recently, // so Due_on is used on older records. If isnull({WORKORDER_CSV.CREATED_ON}) or {WORKORDER_CSV.CREATED_ON} = "" then {WORKORDER_CSV.DUE_ON} Else date({WORKORDER_CSV.CREATED_ON}) //BusDaysLastMonth Local numbervar i := 0; Local...

This formula creates the value I want to sort by: //@Projected If {@BusDaysThisMonth}>0 Then ({#MTD}/{@BusDaysThisMonth}) * 21.75 Else ({#MTD}/{@BusDaysLastMonth}) * 21.75 Formulas referred to: //BusDaysThisMonth // Determine number of business days so far this month (excluding...

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...