Search results for query: *

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

...getting all the branch report. I am using ODBC connection in the Report. How do I assign the Recordset into Crystal report. strsql= &quot;select * from DP_MIS.DAILY_MIS where branch='&quot;&Request.Form(&quot;branch&quot;)&&quot;' and sdate='2003-02-11'&quot; rs.open strsql,conn If...

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

...FROM DT_VEDW.T0300_ACCOUNT A INNER JOIN dt_vedw.t0328_party_account B ON A.ACCOUNT_NBR = B.ACCOUNT_NBR INNER JOIN DT_VEDW.B0200_PRODUCT_MAP C ON A.PRODUCT_ID = C.MAPPED_ID GROUP BY 1,2 /* MODIFIED ON 11-01-2003 */

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

Hello, I am using Crystal Reports 8.5, But in the server, Crystal Reprots 8.5 is not there. Only in Client machine, I have installed CR8.5.Whether, I have to install in Server machine also. Please help regarding this issue. Regards

Hello, I am calling Crystal reports from ASP. In that ASP code (objRep.ReadRecords), I am getting error like physical Database not found. But, I am checking the recordset also. It is giving recordset also. But in Crystal Report ReadRecords function, I am getting error.Please help me for...

...& &quot;BIBLIO.MDB;Persist Security Info=False&quot; strReportFile=strSystemPath & &quot;Reports\Report2.rpt&quot; strSql=&quot;Select * from Authors&quot; Set rsTemp=Server.CreateObject(&quot;ADODB.Recordset&quot;) rsTemp.Open strSql,strConnectionString Response.Write(rstemp.fields(2)) If...

Hello, While I am installing the Terdata Demo Version 4 in Windows 2000. when I startup the services, It's immediately stops the services. I am getting following error messages in the Event log. Event number 33-11466-00 (severity 40, category 9), occurred on Mon Jan 06 01:23:30 2003 , at...

Hello, I am getting error message like this &quot;Physical Database not found&quot;, while reading records for Crystal Reports. &quot;ObjRep.ReadRecords&quot; This line, I am getting error. What should I do for that. I am using IIS server. Please help me.