Search results for query: *

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.

Im new to SSRS 2008. I am using SQL Server 2008. I am trying to create a column that has a running total based on the change of an existing column (date). An example would look like this: 1 8/5 1 8/5 1 8/5 1 8/5 2 8/6 3 8/9 3 8/9 Right now i am trying tyhis...

in the detail section i see the dates. in the group header i get the first date displayed and the other 2 dates are blank even though they do show up in the detail section. I tried placing the new formulas in all 4 of the group headers and that did not make a difference. none of the formulas...

right, but with the way that the data lays out, it will only see the first formula and then ignores the rest. Just like the way the data behaved in thread767-1565197: Turning data on its side to pull the dates out the way i need them seems to only work with the formula example you originally...

i have 4 groups. im trying to pull 3 dates out of a list of detail records so that i can figure days between those dates. the detail records look like this: constr 2/20/09 constr 2/20/09 constr 2/20/09 deliver 3/5/09 deliver 3/5/09 deliver 3/5/09 notice 5/7/09 notice 5/7/09...

it is for a different report. im not sure how to do date diff?