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

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

Hello, I am getting error in ObjRpt.ReadRecords. The Error Message is &quot;Physical Database not found&quot;. I am using Access Database for trial purpose. Please help me. This is the code I am using Dim strSystemPath Dim strReportFile Dim strConnectionString Dim rsTemp Dim strSql Dim...

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.

Hello, I need to take TOP 5% of account, based on Account_balance. How should i take? Pl. help me. Regards

Hello, I need to pass the Date parameter fields to Crystal reports. What should I do for that. Plese help me. Regards

Hello, I have to change the background color of the layer.Which options is there in the photoshop.Pl. help me. Regards

Hello, I am geting error in the case when select statement.The error message is &quot; 3610: internal error: please do not resubmit the last request&quot; what should I do for that Please help me. This is the query. SELECT a.DOMICILE_CHANNEL_ID AS IDD , COALESCE(SUM( CASE...

Hello, This is the query. SELECT IDD , DT , ATT , DA , DP FROM ( ( SELECT a.DOMICILE_CHANNEL_ID AS IDD , COALESCE(SUM( CASE WHEN B.OPERATIONAL_PRODUCT_ID In ('CB', 'CC', 'CD', 'CE', 'CF'...

Hello, I am using two derived tables in one Query. In that query, only difference is date field. First query, I am using today's date and second query, I am using previous date. I want to use in single query(one derived table) with two above mentioned dates. Can I use both dates in...