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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: priyanthan
  • Order by date
  1. priyanthan

    Help with counts.

    Thank you so much MCuthill. i'll give it a try.
  2. priyanthan

    Help with counts.

    Thanks again for taking time for the reply MCuthill, I would really appreciate if you could the repost the entire solution. Also how can i display the counts on the ADMIN row. (Grouping the the ADMIN with date& time) DATE TIME NETWORK 05/01/2011 06:01 VISA 05/01/2011 06:05...
  3. priyanthan

    Help with counts.

    Thanks for your replay. but this just give me the total counts of each network. Could you please explain how i can get the count between the 2 ADMIN networks. Thanks,
  4. priyanthan

    Help with counts.

    i have the following sample data and trying get a count for each network between ADMIN network transactions. DATE TIME NETWORK 05/01/2011 06:01 VISA 05/01/2011 06:05 ADMIN 05/02/2011 06:22 MS 05/02/2011 08:15 MS 05/02/2011 08:46 MS 05/02/2011 08:47...
  5. priyanthan

    Help with Data calculation

    Can Anyone please help me with this. Thanks.
  6. priyanthan

    Help with Data calculation

    I working on a report where i have to do some date calculations. based on the transaction date i need to calculate the payment date. Basically it looks like the following, Transaction date Payment date Monday(01-31-2011) Tuesday(02-01-2011) Friday (01-28-2011)...
  7. priyanthan

    SQL ISSUE

    Hi All, I'm using the following view in my report, but for some reason the first column is not showing the actual data that is in the view. CREATE VIEW POSH.VWHOLIDAY (HOLIDAY, HLDATE, HLNAME) AS (SELECT (SUBSTR(CHAR(HLDATE),1,2)||SUBSTR(CHAR(HLDATE),4,2)) AS HOLIDAY ,HLDATE,HLNAME FROM...
  8. priyanthan

    Convert a Decimal number to hex number.

    Thanks a lot briangriffin.
  9. priyanthan

    Convert a Decimal number to hex number.

    Can someone tell me a way to Convert a Decimal number to hex number. Working with DB2 and CR 8.5. Thanks.
  10. priyanthan

    Help with time calculation

    Thansk a lot LB. I really owe you a big thanks. One more thing that i need to consider is that i need to only calculate the time between the reporting period. I think my sample data didn't cover this scenario. A: 10/6/2010 12:15:00AM 10/6/2010 12:15:00PM B: 10/6/2010 11:15:00AM...
  11. priyanthan

    Help with time calculation

    Once again thanks LB. I did sort by SetdateTime and the by ClearDateTime. But i have a scenario where this is blowing up. Reporting Period 10/06/2010 4:00:00AM to 10/07/2010 3:59:59AM A: 10/6/2010 10:15:00AM 10/6/2010 12:15:00PM B: 10/6/2010 11:15:00AM 10/7/2010 2:00:00AM C: 10/6/2010...
  12. priyanthan

    Help with time calculation

    thanks LB. I was stuck with another project all these days. Coming back to this issue, Your solution partially works. the issue is, its only comparing the previous records, not the other records on top. for example, A. 10-06-2010 04:00:00AM 10-06-2010 04:30:00AM 30 Min B. 10-07-2010...
  13. priyanthan

    report from XML data

    One of the table in by report contains XML data and need to extract data from it. the xml contains; <Info><AtmMon><Tier Cnt="10" Amt="60.0000"/><Tier Cnt="25" Amt="40.0000"/><Tier Cnt="40" Amt="42"/><Tier Cnt="50" Amt="45.0000"/><Tier Cnt="100" Amt="20.0000"/><Tier Cnt="99999"...
  14. priyanthan

    First record in a each group

    First to appear in the details
  15. priyanthan

    First record in a each group

    IS there a way to find out the first record in a group. I have a report with 2 groups (GroupA GroupB)and need to find out the first record in each member of the GroupA working with CR10 and DB2. thanks in advance.
  16. priyanthan

    Help with time calculation

    Thanks LB, i just realize the time between error 001 and 023 must subtracted since its not a downtime. (Sorry i should have mention this before) it has to be something like this 08/11/2010 11:52:00 - 08/11/2010 11:23:00 = 29 08/11/2010 13:05:00 - 08/11/2010 12:59:00 = 6 error 25 is...
  17. priyanthan

    Help with time calculation

    Thanks for concern, what if meant was the down time starts with the errorcode 001 at 08/11/2010 11:23:00 and finishes at 08/11/2010 11:52:00 then another down time starts at 08/11/2010 12:59:00 with error code 023 and ends at 08/11/2010 13:05:00 and finally another down time starts with error...
  18. priyanthan

    Help with time calculation

    I need to create a report to find out the total down time for a Machine for a particular time frame ErrorCode SetDateTime ClearDateTime 001 08/11/2010 11:23:00 08/11/2010 11:52:00 023 08/11/2010 12:59:00 08/11/2010 13:05:00 025 08/11/2010 12:58:00...
  19. priyanthan

    Formula help to manipulate XML

    Yes your correct. my mistake. thanks for pointing me that. i have another issue, hope i can post in there rather than in a new one. Now that i got i want, but the string are not complete, i need to show like this; If its Withd then i'll have to show as Withdrawal or Inq should be Inquiry...
  20. priyanthan

    Formula help to manipulate XML

    I'm trying to extract certain values from XML tags. for example i have the following XML <Trans>Withd,Inq,TrfFrm</Trans> I need to display Withd Inq TrfFrm. I tried this formula: /*{@t2} = <Trans>Withd,Inq,TrfFrm</Trans> */ stringvar array Comms := split({@t2},"/><"); numbervar i...

Part and Inventory Search

Back
Top