Recent content by priyanthan

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.