Search results for query: *

I need for the company name to repeat in the PAGE HEADER for each page.

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

Thanks a million!!! The subreport worked perfect.

The date I need will not always be the first day of each month. The sql statement selected a certain date based upon the companies billing cycle. Therefore it has to be an sql statement because the begining bill cycle date will change each month. The data is based upon a field in a table based...

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

The report column NAME is all the data from the field first_name in a table called address. The main problem is getting the additional new columns to con't on page 2 for the same values in column NAME and have both on 8.5 x 14 paper.

SV you stated "LB certainly grasps the theory, fairly simple cheat, but grouping will complicate it a tad, but you can use groupnumbers". I'm not familar with groupnumbers. Can you walk me through this? Is there a way I can send a sample of the print out in the forum?

synapsevampire & lbass I did mean to make you feel I was wasting your time. I just did know how to explain the change I need in words. Very sorry. You and all the others who reply to post provide a GREAT service to the IT community. Thanks so much. I'll do better next time.

Page 2 needs to be a continuation of page 1. Then page 4 needs to be a continuation of page 3. Then page 6 needs to be a continuation of page 5. SV - Relating to the group footer, where would I place the formula? LBass - When I say column, I mean a 30 formulas created. I'm not using cross...

Sorry lbass. And thanks. Ok-- The page header basic needs to continue from page 1 to page 2 on and 8.5 x 14. There is no formulas in the detail. Only the group header and group footer. 1) How would I handle this? 2) Is there a way to customize the page size or cut the report up into vertical...

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

How do I get the SQL Expression to work. Not Add Command

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?

Group by warehouse will leave blank lines when the warehouse is not in that particular dept. This is not what I need. Say if I have 10 warehouses within dept 17 then only 3 warehouses in dept 18, I need to see the sub-totals for all 10 warhouses under dept 17 then in the next break see all the...

Ok. There is not sub reports. I am pasting sql created by another developer in the Add Command. Then I need to replace the multiple values from the IN statement that Crystal will understand. This is what I need. Using A.FILL_STORE IN {?Store} will not work. Can anyone help. select A.FILL_QTY...

The problem is not with printing out the number for the warehouse and the associated text, it is printing one row or two rows or three rows depending upon whether the warehouse exist in a particular dept (dynamic rows). Look at the example again. Can you help?

I looed at yuor suggestion. My regedit file does not have the folder Business View Manager in the directory HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Business View Manager What should I do?

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