Search results for query: *

When I use the formula in running toal. I get the following error: "A Running total cannot refer to a print time formula details:@suppress_NonConsecutive

Here is the contents: Suppress formula: ---------------------- {@Suppress_NonConsecutive}=1 Content of {@Suppress_NonConsecutive}: ----------------------------- if {?Consecutive}= 'Consecutive'and {@Consecutive}= 0 then 1 else 0 content of {@Consecutive} ------------------ If ( (Not...

This is my suppression formula: {@Suppress_NonConsecutive}=1

I have a report that suppress the records in detail section based on the parameter value. When I suppress the records in detail section, I should get total in the group header only the for the records that are displayed. But, I am getting total for all the records including that are...

Thanks, It worked.

<<Insert a sum on this. If you are summing a value, then replace 1 with that number field.>> I don't understand this. can you please be more specific? Thanks,

I working CR 2008. I have a chart to show the number of records by "Pending Reason". I dont want to show count in the chart if there is null for the pending reason. But, Still I want to show all the records(both with null and not null) in the report(detail section) Can anyone help me...

I am Using CR2008. I am trying to export report into Xcel sheet. Here is the steps I follow: 1. Click on Export 2. Choose "Microsoft Excel(97-2003) Data-Only" option in Format 3. Choose "Application" in Destination 4. Then I Click OK. Then I Get Excel Format Options Window where "Simplify...

I have Parameter called "Grouping" which will have list of possible items(like location,dept,prov...etc). This parameter is multiple selection parameter. So, User can select the order the items to be grouped. If the user selects location and dept then it would grouped by location and dept. for...

It is not one single formual that i am using for dynamic grouping. The first 5 groups are dynamic. If user selects only 2 the other groups(3,4,5) would be suppressed and so on. The 6th group is static and always grouped by diagnostic code and displays top N. for example,, If user wants to...

I ran the report with 2 dynamic group and 1 static group(that lists top 10). Had first formula in GH6.(Where the top 10 lists). The 2nd formula in GF1 and the 3rd in GH1. Getting some weired count. I actually want the total in GH of the immediate prior group of GH6.(That could be GH1...GH5 as...

Thanks LB. Actually I am using total of 6 groups. First 5 groups are dynamic grouping. User can select any number of groups(1 to 5). The 6th one is the static group where the top N is displays. Just for an example i gave 2 groups in by post. So, it is not working as i expected.

I have to find the count for TOP N. N is any number. For example, If I have to find the top 10 diagnosis used by doctor, I know how to find the top 10 diag by using the Group sort expert. But, I want to count the total of top 10 diag used. GH1: Dr.Smith GH2. Dx1 count: 80 GH2. Dx2...

I have five groups and using the drill down. First 3 groups are working good when on drill down. but When I double click on group 4 and group5 then the drill down preview page shows empty page. If I browse to next page of the drill down preview then i get the data on all pages. or If I go...

Thanks LB for your suggestions. I had to change the formula like below. It does not check the null for {Command.Alert_Action}=" in the else part . It has to be checked explicitly. ( If not isNull({Command.ORDERING_DATE}) then 1 Else If IsNull(If{Command.Alert_Action}) then 0...

This is the formula I have: formula name is Count_Fulfill ( If not isNull({Command.ORDERING_DATE}) then 1 Else If{Command.Alert_Action}="Acknowledge/Override Alert" then 1 Else 0 ) Then I use the summary function to sum that above formula. I have NOT checked...

No. I get other records/fields for the same group. only the sum field is not appearing when the sum is zero. It displayes only whenenver sum is greater than zero.

This will sum the field1 based on field2. fields2 is a field used to group the values in field1

I want to find the sum of the filed in grouping. Whenever, there is zero, it should display zero otherwise the sum value. Ex:1 1 0 1 --- 2 Ex:2 ---- 0 0 --- 0 --- I am using the sum function but it does not display anything when the sum value is zero. can anyone help.???

Can any one help me on this???