Recent content by giggles7840

I was able to get my subtotal another way by creating two variables... Subtotal: whileprinitingrecords; numbervar SubTotal:= SubTotal +{@Bonus w/o Exchange05} Reset: whileprinitingrecords; numbervar SubTotal:=0 I am still struggling to get the Grand Total for the Report Footer. Any Ideas?

Correction SumFormula: sum(field1, group field) - sum(field2, group field)

Oracle 11g CR 2008 SP5 I created a formula for my Detail line which is SumFormula: sum(field1) - sum(field2) Now i need a subtotal of this number in the Group Footer and one in the report footer. I have been out of CR for a while and need a refresher on how I have done this in the past. I...

BOE 3.1 SP5 CR 2008 I've never found a way to do this but I figure I should ask the question just in case someone else has figured out how to do it.... I have a user who wants me to identify all reports using a specific table. Is there an easy way to do this other than manually opening alllll...

Cognos 8 I have 2 framework files and I need to have all elments in one framework file rather than 2. Is there a way to merge or link or import the smaller framework into the large framework file? I really dont want to have to do this manually. I know this can be done in BO Universes but I...

This was perfect!

cr xi r2/ oracle 11 ------------------- i have 6 subreports that are built from command text. each one has parameters in the command text to speed the processing up. each of the sub reports have the exact same parameters. these 6 parameters are in 1 main rpt file. what is the best way with...

yup worked. i had to do a formula: if id is not null then 1 else 0. then i used that as a group. then i could pull my distinct group into GF1 and the running total which is sum on id, eval on field id and reset on new formula group.

oh i think i just got it to work..... testing now

i misread what you had and then i mistyped what i did. i did put it in the GF. Although even doing that it still didnt work as needed. Let me try to explain again what the user is asking for. The user wants to see: # of distinct ID's distinct $ paid Total 40...

sorry i should have explained that they only want to see a grand total summary upon first look and then drill into that. If i put the running total into the group header it will give the breakdown by each group rather than showing only the last number of the running total.

I did that just after I posted this. Although the numbers come out correctly, I need to actually have the formulas in the header because the user will want to drill into the details of those numbers. :( any ideas?

oracle 11g/xir2 how do i: sum(distinct field, group)

ok im wrong its still not working. I changed it to: =RunningValue(Fields!TargetDate.Value,Count,"TargetDate") It is counting however, on the change of Fields!TargetDate.Value it is not moving to the next increment. What do i do?

duh. cant sum a date. totally overlooked that. nvrmind.