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 "125.00". But recordset contains...
Hello,
I am using "ttx format" 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,
While creating a view, I am getting error like "View is greater than 26000 characters after the name expansion". 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 "1")
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 "DISTINCT" 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...
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...
Hello,
I am getting error in ObjRpt.ReadRecords. The Error Message is "Physical Database not found". 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 "Physical Database not found", while reading records for Crystal Reports.
"ObjRep.ReadRecords"
This line, I am getting error. What should I do for that.
I am using IIS server.
Please help me.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.