Recent content by natncm70

Hello, I am having one main report and two sub reports. If I close the connection in the last line of the ASP page. it is dsiplaying only main report. If I am not closing the database connection. it is displaying all the reports. This is my problem. This is my code. <!-- #include...

Hello, I am using Crystal report with ttx format. I am calling report from ASP. In that, I am assigning recordset to report. In the recorset, one column is containing decimal value also. While viewing report, the decimal column is displaying &quot;125.00&quot;. But recordset contains...

Hello, I am using &quot;ttx format&quot; for developing reports. In that ttx format, I have one field value is decimal. For that, I have used number data type and that field, I have formated in the reports as decimal. I am assigning recordset through ASP. It is showing value plus...

Hello, I need only one branch Regards

Hello, I am getting problem in ASP and Crystal Report. I am having branch wise report. From the ASP page, I need to select one branch from aSP page and display the Crystal Report. But, I am getting all the branch report. I am using ODBC connection in the Report. How do I assign the...

Hello, I am getting error in the Teradata ODBC driver like this Microsoft OLE DB Provider for ODBC Drivers (0x80040E31) [NCR][ODBC Teradata Driver] Query timeout expired I am running a view. Actually, it takes 2.5 min in Query man. While calling this query in the ASP pages. I am getting...

Hello, I need to the values(numbers) into Crores like 21,814,007,627.77 to 2181.40 . What should i do for that? Please help me. Regards

Hello, While creating a view, I am getting error like &quot;View is greater than 26000 characters after the name expansion&quot;. What should i do for that. Regards

Hello, How to suppress the zero(0) record value in the row. Like. 1 45 67 78 89 2 0 0 0 0 4 45 7 8 9 6 0 0 0 0 I want to suppres the 2nd and 4th row. Because, all the column values are zero. is it possible in CR. Please help me. Regards

Hello Krishnan, This is the Recordset like this. Branch Bal_amt rank 1 50,000 1 ( I need rank like this, But in the query is not coming like &quot;1&quot;) 1 49,000 2 2 47,000 3 3 34,000 4 3 34,000 4 4 32,000...

Hello, Eventhough, I have tried with bal_amt in rank function. It is started from total number of records(50,000) then it decreasing one by one(50,000,49,999,49998....).what should i use for that. Regards

Hello, I have some problem in this following query. In this query, I am taking top 5% of customers and i need to rank it accordingly(like 1,2,3,4 ....). But, I am not getting proper order in this query. Please help me . select t3.branch ,t1.acct_nbr ,rank(t1.acct_nbr) as...

Hello, I got the answer. I have used &quot;DISTINCT&quot; in side the count. It is working fine. This is the query SELECT A.DOMICILE_CHANNEL_ID , A.PRODUCT_ID , COUNT (DISTINCT B.PARTY_ID) , COUNT( B.ACCOUNT_NBR) FROM...

Hello, I have query like this SEL distinct A.DOMICILE_CHANNEL_ID , A.PRODUCT_ID , COUNT(B.PARTY_ID) , COUNT( B.ACCOUNT_NBR) FROM DT_VEDW.T0300_ACCOUNT A INNER JOIN dt_vedw.t0328_party_account B ON...

Thanks Krishnan It is giving error messages in BTEQ