Search results for query: *

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

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

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,

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

Can Anyone please help me with this. Thanks.

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

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

Thanks a lot briangriffin.

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

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

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

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

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

First to appear in the details

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.

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

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

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

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

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