Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vega83

    Help on Parameter selection

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

    How to get sum of next 10 minutes ofr each minute

    LB it works like Charm , unbelievable, thanks sooo much!
  3. vega83

    How to get sum of next 10 minutes ofr each minute

    LB your right about the sum , thank you so much I will try this now.
  4. vega83

    How to get sum of next 10 minutes ofr each minute

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

    Help on doing difference of dates with prev row.

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

    need help on formula

    I got it, i used lower case fun and if condition thanks!
  7. vega83

    need help on formula

    LB is there a way i can check for case senstive or like word example Sold, sold, solden etc?
  8. vega83

    need help on formula

    You are a genius!!!
  9. vega83

    need help on formula

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

    How to a do a sum of sum on Header level

    Friends can this be done?, any help would be great
  11. vega83

    How to a do a sum of sum on Header level

    I have other field called no of days All the child tickets will have same no of days value like below GROUP A---GH1----total (40+20+30)/3(distinct GH2 field) = 30 ticket 1 GH2 total 40 child tick1 40 ----detailas child tick2 40 ticket 2 GH2 total---20 child tick1 20...
  12. vega83

    How to a do a sum of sum on Header level

    LB any way to do average on avergae? I want to to do Average of GH2 on GH1
  13. vega83

    How to a do a sum of sum on Header level

    LB got it I use your formula and said if {table.opendate} < {table.closedate} then GH2 field else {null}. It works!...Thanks a ton!
  14. vega83

    How to a do a sum of sum on Header level

    LB details will have d1 and d2 of GH2 ig GH2 has date1(08-08-2009) date2(10-08-2009) Details Childticket 1 childtciket 2 will have same dates date1(08-08-2009) date2(10-08-2009) So basically what ever i have summarized in GH2 should be again summaried on GH1
  15. vega83

    How to a do a sum of sum on Header level

    one is date is ticket opned and other is ticket closed . If open date < close data then i calculate it as one. GH2 has multiple GH3 data is liekt his GROUP A---GH1----total 2 ticket 1 GH2 total 1 child tick1 1 ----detailas child tick2 0 ticket 2 GH2 total---0 child tick1...
  16. vega83

    How to a do a sum of sum on Header level

    LB, on which date field i need to do it? I have two data fields? calculation is if datefield 1 < datefield 2 then 1 else 0. I dont use current date. Sorry i did not mention earlier.
  17. vega83

    How to a do a sum of sum on Header level

    I can do max(date1,gh2) > max(date2,gh2)then 1 else 0. But i cannot sum this again. If there is a turnaround for this it would be very helpful
  18. vega83

    How to a do a sum of sum on Header level

    that is right for each ticket it has only one data but each ticket has mutiple subtickets. I want to add up only GH2 vlaues in GH1.
  19. vega83

    How to a do a sum of sum on Header level

    LB every 1st group will have multiple groups 2 with different date . Basically i am trying to sum (total value of GH2). Thanks so much for your help on this
  20. vega83

    How to a do a sum of sum on Header level

    I have a formula if date1 < date2 then 1 else 0 in details. In header i used same formula too

Part and Inventory Search

Back
Top