Search results for query: *

I am using CR v10. I have a mapping table in MS Excel that I would like to use within Crystal. I need to create a table (report) of running totals in the footer section. Each running total uses a different company(s), accounting unit(s), account(s) mapping combination. Each running total is...

I have an SQL formula ((LAWSON.PAYMASTR.CHECK_DATE)={d '2012-07-19'}) that is not working. I am using Crystal 10. Can I create an SQL statement that would run the select statement with the check date = 7/19/2012? Thank You.

I have an SQL formula ((LAWSON.PAYMASTR.CHECK_DATE)={d '2012-07-19'}) that is not working. I am using Crystal 10. Can I create an SQL statement that would run the select statement with the check date = 7/19/2012? Thank You.

Can the user name and password be saved within a crystal report version 10? The refrenced closed post (thread766-458406) referred to Crystal 8.5. Thank You.

I want to use shared variables on charts. The shared variables are available to the report but are not displayed on the charts. Any suggestions would be greatly appreciated.

I have a report (CR version 10) that uses shared variables. The shared variable appears to be available to the chart but noting is showing on the chart. The shared variable does have data. How can I get the chart to display the value in the shared variable? The On change of is displayed on...

I need to chart the cost per full time employee. A running total is used for the cost while a formula is used for the full time employee. The full time employee formula uses both a running total and fomulas. How can I make the cost per employee FTE available to chart? FTE formula: ({#13 GF2...

The sub will return a string. The string is a concatanation of deparments. For example the department string returned is 11111,22222,33333. The running total needs to use a formula like department in [11111,22222,33333].

This was very helpful. I need to use the returned value in running totals in the main report but it is not available in the (use a formula) of the running total. How can I make it available to use? Thank You.

I am using an external MS Access translation table that maps a code to many departments and many accounts used in each department to the exiting ERP system. For example, the code is 6020-7010. The 6020 maps to more than one department and the 7010 maps to more than one account. I want to send...

I use CR 10. I need to identify the data contained in each of 5 columns of the report. There is data (formulas and/or running totals) contained in all row sections of the report. I need to know all of the data that is in column 1, column 2, column 3, etc. This is similar to MS Excel, Column...

I am using Crystal 10. Is there a simple way to find ever reference to a parameter used within a formula ? Do I need to go through every formula to find each reference ?

LB, Thank You. Thank You. Thank You. EXCELLENT.

LB, Thank You. I missed one additional thing. I want to get the percentage of a subset of the totals in each group (Count of item count for user where item_type='X') : Group 3 is user user 1 TOTAL count 200 'X' Count 100 Percentage = 100/400 25% Group 2 is Company company...

I need to calculate a percentage count for each user within a group 'user' of the total count for a company that each user is within. Group 3 is user user 1 count 200 Percentage = 200 / 600 33.33% user 2 count 400 Percentage = 400 / 600 66.66% Group 2 is Company...