Search results for query: *

I have created a Crystal Report using a Microsoft SQL Server OLAP Cube. The cube has three measures; two are plain numeric values and the thrid column is a currency column. I would like to format the currency column with a dollar ($) and Decimal point (.) for only those columns that are for a...

I have developed a report in CR 8.5. It consists of a group and detail lines. I have the group heading overlaying the detail lines since the group header is about 7 lines long. The report looks something like the following: Customer Number Invoice Number Current Amt Due Customer...

I have a Crystal Report (v8.5) that suppresses rows if all the quantities and dollar values for that row equal zero. For each column that contains a dollar value, I have checked the box 'One Symbol Per Page' so that only one currency symbol is displayed per page. Problem is that the first row on...

I am creating a cross-tab report. The column headings are "Inventory Family" and the Rows are "Reason Code". The summarized field is the count/total of the data where Inventory Family and Reason Code equal the column and row heading. I need to include with the summarized...

I am creating a Cross-tab report in CR8.5. The data column that is used to create the column headings can be up 50 characters long but most of the time it is 15 - 20 characters. It seems that in order for long titles to be readable, I need to make the column wide enough to accomodate the...

I removed all hard codes to the tables but I can't remove the hard code for the server. Even though I removed the hard code to the tables, we still had to go through the rigmarole of resetting/changing the location when we moved the report to another server. We are developing reports on our...

We are developing and teting reports on Server 1 and then when they are ready for production use moving them to a different server, i.e. Server 2. After we move the reports to Server 2, we have to go back into the report and reset the Location. This is done by clicking on Database, Set...

I am working with CR7. I am creating a Cost of Goods Sold report that has sections and a subtotal after each section except for Direct Labor which does not have a subtotal. I need to total the subtotals plus the direct labor detail line at the end of the report but before another detail line...

That works like a champ!! Thanks!!!

I am creating report to list account numbers by summary account numbers. I'm grouping by summary accounts and the detail data is the account numbers. I have created a stored procedure to strip off the data from the tables. The output looks something like this... SummaryAcct SummaryDesc...

Malcolm, What is SCR? I understand what you are trying to do and I really like the idea of the user "designing" the layout of the report but I lost you after you said "When they have got the format right then you can duplicate in SCR". Either I haven't had enough...

I do have the paper orientation to landscape and it needs to be printed on 11" x 8.5". So I guess I need the more complicated approach! Holly

I am creating an income statement by location for the company that has approximately 10 columns across the top of the report. How do I get all these columns on the report without reducing the font to noseeum font. Currently I'm using a font of Arial 9. I have 6 columns across the top but need...

I am creating an expanded Income Statement that totals accounts by different criteria. For example, I am breaking out the selling and admin expenses by department for more detail. The purpose is to show where the expenses are coming from - warehousing, manufacturing, marketing, finance, etc. I...