Recent content by ij76

Cancel the last post...I figured out how to suppress in the details section format. I didn't know about that oen before.

I didn't think the @USD formula was necessary, but it is: if {ExpensesCharged_Fact.CurrencyCode}="USD" then ({ExpensesCharged_Fact.UnitPrice}*{ExpensesCharged_Fact.Quantity})*1.00 else {ExpensesCharged_Fact.UnitPrice}*{ExpensesCharged_Fact.Quantity}*{@Exchange rate} I thought about doing what...

In CR v9 I have a report where I list expenses. I have groups which consist of Employee Name (gr 1) and date of expenses (gr 2). In the details I have the expense type, the expense description and a formula to apply a currency rate to the expense amount. The way I need the details to diplay...

In CR V9.0 I have a report with a whack of variables all coming a datetime field. I need a formula for the datetime values which says if the hour is between 8:00pm and 7:59am change it to the following day (I guess it is 8:00 am the same day if the hour is from midnight to 7:59 am). I then...

In CR v9 I have a report with a chart showign the number of incidents per client per month. I used the select expert to remove any with a monthly count less than 5. It filters them out in the report, but not in the chart and I can understand why. Can anyone explain, or let me know how I can...

I am in version 9, and don't see this option...si there another way in version 9?

I have a stacked bar chart in which I am showing the values. The values are running totals though, which I don't want, I just wnat the actual values of each section, is this possible to do, or because it's stacked having the runnign total is the only option?

In Crystal v 9, I have a report where in Group#2 (which is grouped by severity) I have 6 varibles in this group, 2 for each sveerity level (high, medium and low), the two for each severity calculate the average of two other variables (open to close, and open to first). A couple of examples of...

In Cyrstal v.9: I have a report with groups of customers. For each customer I have a summary of total hours. I would like to sort my report from highest to lowest hours, not by customer name. Of course, I can't remove the group in the sort expert and can't move the summary ahead of the group...

I actually need to avg, not sum. I need to average the OpenToResponse and the OpenToClose for each severity level per client. My {@variables} formula is (placed in RH): whileprintingrecords; datetimevar Open; datetimevar Response; datetimevar Closed; Open:=NthSmallest (1...

The above is giving me a 0.00, let me give you more details of my report (I have just been given a couple of changes anyway). Group#1 - Client Group#2 - Severity Level Can have up to 3 groups for each client; high, medium and low Group#3 - Incident# Here I have 2 formulas per incident#...

I am trying to get a sum of a formula which contains variables. The formula field does not show up as an option to be able to summarize. When I tried doing it mannualy, I got an error saying the filed can't be summarized. Is there a workaround?

Thanks for the link. I went through the steps and adjusted them a bit to suit my report, but it does not create a chart. I'm not sure if it's because I have 2 OnChange formulas and 2 ShowValue formulas. Also, I need one chart per Group One (I have 3 groups), so I adjusted the steps to match...

I am trying to create a chart and in that chart is the summary of variables. When I go to my preview page I get the message "A print time formula that modifies variables in used in a chart or map". I assume I am getting this sine I have formulas with variables calculating whileafterprinting as...

Wow! That's awesome, it worked. Thank you so much!!