Search results for query: *

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...

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...

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

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...

xir2/xp ive created a count of days between two dates. however to get those dates i had to create them using variables. now that i have my count of days, i need to create an average between of those dates for the column. if i create a formula then is says the fields can not be summarized. If I...

cr xir/ xp i have colums that i need to flip into rows. here is what i have. Date Task Dayofweek 7/6/09 List A 2 7/7/09 Install B 3 7/7/09 List B 3 7/8/09 List C 4 7/9/09 Rewalk 5 What i need this to look like is Mon Tues...

xp/xir2 I have a set of records in the detail section and I have to group them asc so that the most recent record can be shown in the group header. The next step is grouping the records by Description. The problem with that is my GH2 is by Road and that needs to remain. If I add a GH4 on...

xir2/win xp I need to bring in only 6 months of data based on a date field using the record selection editor. there isnt a set function like lastfullweek, monthtodate, etc. whats the best way to calculate this?

xp/xir2/sql server I'm pretty sure this is a variable question and I am really bad at variables. I need to get a value from a record and create a column using that value. The value can be associated with an ID for each record. I am just not sure how to go about doing it. Example: GH1 Title...

Xp/R2/sql server Im not really sure of the best way to explain this. I need to show only the highest count of records in a group. Example: GH1 Title GH2 Subtitle1 1 12.5% GH2 Subtitle2 1 12.5% GH2 Subtitle3 4 50% GH2 Subtitle4 2 25% GH2...

CR XI SP2 Win XP I have a report that I need a count for. Displayed on the report is Group Header 1 and Group Header 2. The count should be for each record shown in GH2 within GH1. For Example: GH1 - The Arbors Gh2 - 001 GH2 - 002 GH2 - 003 GF1 - Count = 3 I have been playing around...

CRXIR2SP2 Win Pro I have a formula that generates a Date in a String Datatype. This is the code: whileprintingrecords; stringvar array x := [totext({@00 Date}),totext({@01 Date}),totext({@02 Date}), totext({@2A Date}),totext({@03 Date}),totext({@3A Date}),totext({@04 Date}), totext({@05...

CRXISP2 XP Pro I have two groups in my report. In group header 2 I am displaying my records and I have a running total which counts a specific type of record that is displayed. I need to show the sum of that running total in Group Footer 1. This is what I want to see: GH2 00 2 weeks 1...

i have 3 records. The user only wants to see one of those 3 records based on the most recent date. is there a way to have the report display just the most recent record? the other 2 are not necessary for the report.

win XP CRXIR2SP2 i have this formula and it has been working fine. whileprintingrecords; stringvar array x := [totext({@00 Date}),totext({@01 Date}),totext({@02 Date}), totext({@2A Date}),totext({@03 Date}),totext({@3A Date}),totext({@04 Date}), totext({@05 Date}),totext({@06 Date}),totext({@07...

CR XI R2 Data from a Universe OK, this is so basic..... I have 2 parameters. The user should be able to fill in at least one parameter. When I set up the selection: {@Days Late} >= {?Days Late} or {Query1.Create User Name} Like {?Created User} and when I fill in only 1 parameter and leave the...

cr xi r2 win xp i need to end my variable count - PDates[i+1]; When it hits the last value in PDate it keeps trying to add. How do i stop it? Formula: stringvar array ADates := [totext({@Actual - 00 Date}),totext({@Actual - 01 Date}),totext({@Actual - 02 Date}), totext({@Actual - 2A...

CR XI R2 Win XP I have a formula built off of several other formulas. It identifies records as 1 or 0. Then I want to use this formula in the record selection formula to prevent records from coming in. This has worked on several other formulas I have written/had help writing, but this one just...