Search results for query: *

Friends I have two sub reports in a main report, and have a parameter stating to select which sub report to display. If i select A1 then user will see only A1 if A2 then he sees only A2, this part works fine. But depending on main parameter selection there are parameters with in the sub report...

Friends here is the tricky part of data, I want to sum of value for next ten minutes for each minute Here is data Date Value 05/06/2010 9.51 am 1 05/06/2010 9.52 am 0 05/06/2010 9.53 am 1 05/06/2010 9.54 am 1 05/06/2010 9.55 am 0 05/06/2010 9.56 am 1 05/06/2010 9.57...

Friends I have data like below TICK: user time A1 D1 12/30/2009 A1 D2 12/31//2009 A1 D2 01/01/2010 A3 D1 01/01/2010 A3 D2 01/02/2010 A3 D2 01/03/2010 I wold like to do date...

Friends I need some help on formula I am trying to create I have a field which is like a message Tickets are sold for less price , etc. SO if my message has word sold I need to hilight it in red, just that one word. Any help please? Vega

Friends I have data this way Gh1 WHOLE total-----2 GH2 ZZ total--- 1 details abc 1 abc 0 GH2 SS total---0 details abc 0 abc 0 GH2 CO total---1 details abc 1 abc 1 But in GH 1 when i do sum it summing up every detail and giving me value 3. Is...

Hello friends I am trying to use % for all in my SQL statement in where caluse I have AND B.County_Id in {?County} or {?County} = '%' B.County_Id is numeric and {?County} is string. Any ideas?. I also tried cast(B.COUNTY_ID as varchar(32)) in {?County} or {?County} = '%' and cast(B.COUNTY_ID...

Hello friends I am trying to use % for all in command statement in where caluse I have AND B.County_Id in {?County} or {?County} = '%' B.County_Id is numeric and {?County} is string. Any ideas?. I also tried cast(B.COUNTY_ID as varchar(32)) in {?County} or {?County} = '%'

Friends, I am new to BO designer, cam you please tell me how to use @Aggregate_Aware and when to use it?. Also in my prompy how to display LOV's. Thanks a ton V

Friends, I need help on below selection critieria in DB2. Below where clause works fine, but only If I pass my paramter in DATE or DATE TIME format. I wan to give my end user an option to select by Month Year format May2009 instead of 05/23/2009 or so. Below selection criteria gives me data for...

Friends, Here is my Selection Criteria {Command.ADDED_DT} in DateAdd("m",-13,{?Date}-day({?Date})+1) to DateAdd("m",1,{?Date}-day({?Date})+1) - 1 This gives me data for entire year, but I want to change into below. I will have two parameters Year and MonthYEAR. The user will select a link with...

Friends I need your hrlp, Below is the sample data June July Aug 103 1 1 0 105 2 4 6 104 1 1 1 104 1 1 1 I did running total based on data June July Aug 103 1 1 0 105 2 4 6 104 1 1 1 I...

Friends here is my selection criteria {Command.ADDED_DT} in CDate(CSTR(Month(DateAdd("m",-13,{?Date})),0,'')&"/1/" &CSTR(Year(DateAdd("yyyy",-1,{?Date})),0,'')) to {?Date} I am getting only 12 months, i,c if i slect may2009, i am getting data from May2009 to june 2008 not may 2009 to may2008...

Friends If i slected todays date my data should sortup as below, how can i achive this? MOnth July09 June09 May09 APR09 Mar09 Feb09 jan09 Dec08 Nov08 Oct08 Sep08 Aug08 jul08 Thanks so much, V

Hello, I have two fields PAID amount and Amount debit And user has a paramter where he can select the month or date. Suppose if I select todays date I need to get the data from july 08 to july 09. If I select August it should be aug 08 to aug 09 , below is the example. I select todays date. How...

Friends I have data like below Source PO SKU Rtoal(count PO where source='PM') WM 454 34234 0 PM 454 76876 1 IB 454 NUll 1 TM 454 5131 1 I want to checK If PO is in WM or PM or IB or so . But when in the first line If I do...

Friends , Right now I am showing running totals in report footer which is working fine. I am doing counting no of SKU no which has condition so in evaluate section i am using condtion DEPT no = 1 then only ia counting. But now users want to see the toal summmary on repot header instead of...

Frieds I have two groups and I am showing the group1 and grpup 2 values in group header two. I have hardoced paragraph in group footer 2. And i am shwoing some details in detail section. there is parameter selection too, single value paramter. So when user enter one value it will display...

Friends I have field which has values 01EE013,LANE215, etc I have 5 different sort slection in paramter If {?Sort} = 1 then tonumber({Command.STORE}) else If {?Sort} = 2 then tonumber(left({Command.LOCN},1)) else If {?Sort} = 3 then {@rdays1} else If {?Sort} = 4 then {@tdays1} sort is...

Friends I have data this way LPN SKU TYPE Date packs 123 231 PTS 10/7/2008 11:41:33 AM 1 123 141 CCS 10/9/2008 11:44:33 AM 2 123 221 BP 10/8/2008 11:44:33 AM 1 AS PTS type is having min date i wan tto sum the packs and show the count under it...

Friends, Here is my sample data Store Locn TYPE PO DATE DATE2 Tot 13 A1 R 341 9/15/2008 Null 2 13 A1 T 542 8/15/2008 7/23/2008 3 I want to show this as Store Locn TYPE PO R DATE1 T Date DATE2 Tot 13 A1 R...