Search results for query: *

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

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

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

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

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.

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

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

i need report on XML tag from a database table. following is a sample of data, <Key Type="[TMK1]mfk0" Crypt="301096BD60A1092D"/> <Key Type="Pvk" Crypt="F65F86C54E91BA37" Chk="2AE35863" /> <Key Type="Pvk" Crypt="4B812E342284C3D0"/> <Key Type="[TMK1]mfk0" Crypt="DCB77140D560CD4ADCB77140D560CD4A"...

I have a report that looks like the following Terminal Change ACTIONFLG CHGED TMK MMK 990000 2/25/2000 1 TMK 990000 6/30/2008 11 990000 2/25/2001 1 TMK...

Can any one please tell me how to convert int into Binary. for example; i need to change 2 into 0010 3 into 0011 4 into 0100 5 into 0101 and then "AND" the 0010 and 0011. for example; 0010 AND 0011 should give me 0010. working with CR 8.5 and...

Can anyone please help me how to convert a smallint value into a binary. Thanks in advance.

I have a report with duplicate records and need to summarize few fields. I’m using the following formula (@DisPurchase) to eliminate the duplicate records, If Onfirstrecord or ({BNSMISRPT.TRANSEQ}) <> previous ({BNSMISRPT.TRANSEQ}) then {@Purchase} else 0 When i try to sum the @DisPurchase...

I have a report with a subreport, where i'm bringing a value from the sub report to the main report by using the shared variables. Everything works fine but when i export to csv format, all values are present expect the the value that i brought from the sub report. Its works fine with other...

I need to join two tables, but the issue is there is no similar columns to join. what i mean is; table 1 name type notes ---- ---- ------------ 12345678-22556 3601 sample notes 123123123-22555 3601...

Can someone please help me how to create a report using a ttx file as a data source? I created a ODBC data source and defined the path for the TTX file and when I try to select the file into the report I’m getting an error saying the following: "Database connector error 42000 Microsoft...

i have a report with 2 Groups G1 Sites. G2 Terminals. i have to list all the terminals one below the other in the G2 footer. for example lets say i have following G2s G22a Term1 G22d Term2 G22c Term3 then in the G1 footer i have to display like Term1 Term2...

I need to create a report with number of orders for each hour. Basically I need to have a group for each hour for a particular day. The data for this report comes from the orders table, which looks as follows, OrderID EmpID OrderDate OrderTime Amount 0001 6798 03/03/2009 06.30...

I have a report with a sub report and tiring to export to CSV format. the exported CSV file only contains the data from the main report and don't have the data from the sub report. Can any one tell me why? Working with CR 8.5 and DB2. Any thoughts much appreciated.

I’m trying to export my report to a txt file, but I have a space in front on each line. The txt file looks like this, D,42Q007 ,42Q10007,2008-12-31,6,516,562,A,00 D,42Q030 ,42Q10030,2008-06-31,6,210,563,K,00 But I need to be like this, D,42Q007...