Recent content by stoopers

Sample data: Cust code Order# Warehouse Proj Rev Cos Freight Depr JAMA005JA 9888 Gulb 990FT 500 150 75 JAMA005JA 9889 Gulb 990FT 650 150 75 S/T Gulb 1150 300 150 S/T JAMA005JA 1150...

Altho' my message is not "techy" - I am very familiar with the methods you described above. I do have summary level formulas for the revenue and costs are each level mentioned above. My problem lies in the fact that the depreciaiton costs do not have a warehouse or order# affialiated with...

I have tried the summary formulas and the shared variables. I have summary formulas at the customer code, warehouse, and order # levels on all of the Revenue and Cost fields. My problem lies in the fact that the cost does not have warehouse or order# field types associated with it.

Can you allocate costs from group level to another? I am creating a margin analysis report where I am combining revenue and cost data by cust code, warehouse, and order#. I currently have the following groups: Customer Code Warehouse Order # I need to allocate costs summarized at the...

How can I convert a 10-digit order number to a 6 digit string? The 10-digit number startswith 4-6 zeroes and ends with the order #. (ie. 0000040000 or 000094451 or 0000009499). We need to access the last 6 digits - but need to eliminate all zeroes (ie. order #= 40000, or 94451, or 9499)...

What is the best way to link Budget and Actual data? Using Crystal 11 Actual data is coming from Iscala; table/view in Crystal Budget data is coming from Access DB. Customer code is common field between the 2 tables. Budget data may contain new customer codes that will not appear in...

Thank you so much - I was finally able to bring in the labor$$.. One last issue - I have the subreport in Group Footer 1A, the formula for the total expense in Group Footer 1B...I have tried to "display" the shared variable in Group Footer 1B to no avail.....I used the following formula...

I am using Crystal 11.0 and iScala 2.02 (financial system) and an external access DB. I have created a report in Crystal using project information from the iscala system to get total rev and expenses by project: Project number account number dept number amount transaction date From the access...

I am attempting to write a report to categorize our revenue data. I have 2 tables: Revenue Data & Customer File, which are linked by the Customer Code. Revenue Data: Customer Code Transaction Text (Customer Code + Invoice#) Invoice# Amount Account Dept Customer File: Customer Code Customer...

I believe I may have a date issue as well. This issue occurs when we make a journal entry to accrue Revenue that occured during the month but the invoice was generated after the month end. The invoice date does not match my record selection date.

Can you link tables based upon a formula result? I have 2 tables: FINA_ALL and AR. I need to link the two tables based upon Invoice #. AR contains the field Invoice#. FINA_ALL has a field TRANS_TEXT which is a combination of the customer code and invoice#. I can extract the invoice# by...

Using Crystal 7.0 & Scala 5.0. I am combining revenue & cost data into 1 report. I need to combine the details by sales order # and use the customer code from the revenue source. Unfortunately, the data tables are not linked by sales order#. Customer Code SO# ACCT Rev$$ COS...

I was on the boards yesterday attempting to identify new customers (no orders for the same product in the last 12 months). I was able to get the correct data using the formula below but I only need to summarize the '05 orders by month. Crystal 7.0 Scala 5.1 2005 AMOUNT = IF...

Formulas for summarizing Dollar amounts by specific month cannot be subtotalled. What would be causing this? I am attemptig to create a report which contains the months for 2005 across the top... Product Sales Jan05 Feb05 Mar05 8263 $100 $100 $100

Thanks for the help! One more question - I also need to group by the product as well as customer and date....can I add an extra variable?