Search results for query: *

CR Version 9.0. I have a report with data in the PAGE HEADER and data in the GROUP HEADER. In the PAGE HEADER I have the company name. I want this to appear at the top of every page. This part works fine. When I export the report into Excel, the company name appears on every page (Page...

Crystal Reports Version 9.0 I have a report, which uses an Add Command to generate data for the report. This report run in about 30 seconds. Now taking that same report, I added a second Add Command to generate the 1st day in the month based upon the current date. This date field is placed...

I have a report that currently prints on an 8.5 x 14 size paper. This report has a total of 300 rows (100 rows per page or 3 pages). The report currently has 15 columns per page. This report need to be modified to add 15 more columns totaling 30 columns. However, the final output still needs...

I downloaded the SQL Designer. I need version 9 to have the ability to create sql statements as a formula. Under Crystal help, it says click Field Explorer then click new, then select "SQL Expression Fields". I do see this. How do I make this work?

Version 9. I have a report that currently has 4 columns on an 8.5 x 14 paper. I need to add 2 more columns to this report making a total of 6 columns. I then need to make 3 columns on page 1 of an 8.5 x 14 paper and then the 3 remaining columns on page 2 of an 8.5 x 14 paper. Does anyone know...

Version 10 I need to create a loop that would Show the number 1 on page 1 Show the number 2 on page 2 Show the number 1 on page 3 Show the number 2 on page 4 Show the number 1 on page 5 Show the number 2 on page 6 Etc.. How do i do this?

I need to create a report with subtotals based upon a certain condition existing. The format is below. The text and sub-total for the warehouse (WH) should ONLY display and calcuate the sub-total if the warehouse exist in that dept. How do I do this? Dept VEND WH UNITS 17 123...

CR 10 I somehow deleted the tool bar in the Formula Editor with the Save and Save and Close buttons. How do I bring it back to normal or default?

I have the following forumla below. The goal is to have Cost_XX display in the report. I'm getting zero in the report. What am I doing wrong? What steps am I missing? NumberVar Disc_Amt_V; NumberVar Discount_V; NumberVar Int_Cost_V; NumberVar XCost_V; NumberVar Cost_X; NumberVar Cost_XX; if...

I created a parameter and place it into my report. {?dept} There are three values entered for the parameter. (3,4,5) However, only one value displays on the report (3). How do I display all the values on the report I entered into the prompt?

I have a main report with the columns COL-A COL-C COL-D 34 $450 $500 Each row has a unique value. When I drill down I would like for the data to show as COL-A COL-B COL-C COL-D 34 34-A $200 $250 34 34-B $250 $250 In the drill down, COL-B will have...

I am using the IN statement as parameter in SQL using the (Add command). How do I pass these values as parameters? where A.SELL_STORE = {? Division} and A.FILL_STORE in (001,002,004,035)

In the database I have the values for a dept of 01, 03, 04, 06, 07. When the user is prompted and enters the value "DROP", the records retrieve will reflect dept 01, 03 and 06. How do I do this? Do I create this as formula in the Select Expert?

How do I create a link for summary report to a sub-report in a grouped column? (See Example below). I want to be able to click a value in the division column (say Division - A) and it provide the detailed sub-report. Then I want the ability to click another value in the summary report (say...

I need to run a pre-created SQL statement using the 'Add Command'. The SQL statement uses tables from two different databases. Is there a way to connection to a DB2 AND an Oracle database in Crystal 10?

I need help with counting numbers in a column after running total is calculated. How would I get the results to show like (C ) below? A) DATA Dept Color 10 Blue 10 Blue 10 Blue 10 Red 11 Blue 11 Blue 11 Green 12 Green B) Running Total on Number of Orders...