Got error while viewing report using crystal report
Author |
Message |
sidz #1 / 6
|
 Got error while viewing report using crystal report
Hi Everyone, I have used Crystal Report 8.5 with VB6 (SP4). My report contains more than 20 sub-reports. I guess my report contains more 3000 pages. My problems are: 1) when I click on next button, it takes around a minute to display next page. 2) finally I have clicked on last page button (regardless how much time it will take), but after some hours (around page no. 400. However, when I run this report before I have already made report displayed till page no. 490.) I got error masage : "ADODB.field:Either BOF or EOF is true, or the current record has been deleted. Requested operation requires a current record". After clicking on 'OK' button another msg screen appears with msg: "Error detected by database DLL". I guess, this is the problem of Crystal report viewer. Please help me to get out of this problem. Regards, Sidz
|
Fri, 04 Jun 2004 15:01:57 GMT |
|
 |
Bas #2 / 6
|
 Got error while viewing report using crystal report
20 subreports! and 3000 pages, wow! I even hate to have to use 1 subreport in my reports. (they suck and CR crashes as a rule when i'm editing the subreport) Regardless if you're getting errors or not, I'd redesign the bunch to make it less complex (and thus better maintainable, scalable and expandable). Can't you split it into multiple reports and print them separately? I'd never trust CR with such a big job... Cheers, Bas
Quote: > Hi Everyone, > I have used Crystal report 8.5 with VB6 (SP4). My report contains more > than 20 sub-reports. I guess my report contains more 3000 pages. > My problems are: > 1) when I click on next button, it takes around a minute to display next > page. > 2) finally I have clicked on last page button (regardless how much time it > will take), but after some hours (around page no. 400. However, when I run > this report before I have already made report displayed till page no. 490.) > I got error masage : "ADODB.field:Either BOF or EOF is true, or the current > record has been deleted. Requested operation requires a current record". > After clicking on 'OK' button another msg screen appears with msg: "Error > detected by database DLL". > I guess, this is the problem of Crystal report viewer. > Please help me to get out of this problem. > Regards, > Sidz
|
Fri, 04 Jun 2004 19:15:54 GMT |
|
 |
sidz #3 / 6
|
 Got error while viewing report using crystal report
Thank for your interest Bas, I am briefing my report status now...... I have made 20 tables in SQL 7.0. One is master and other (all 19) tables have one to many relationship with master table. Now, I want to show report which contains data from all 20 tables in such a way that : e.g: first record from master table and then all records (which has same ID as of first record of master table) from second table and then all records (which has same ID as of first record of master table) from third table and..................till 20th table. Then again, with new page, second record from master table and then all records (which has same ID as of second record of master table) from second table and then all records (which has same ID as of second record of master table) from third table and..................till 20th table. And so and so till all records from master table. Is this possible with multiple reports without using subreport? If yes, please let me know. Regards, Sidz
Quote: > 20 subreports! and 3000 pages, wow! > I even hate to have to use 1 subreport in my reports. (they suck and CR > crashes as a rule when i'm editing the subreport) > Regardless if you're getting errors or not, I'd redesign the bunch to make > it less complex (and thus better maintainable, scalable and expandable). > Can't you split it into multiple reports and print them separately? I'd > never trust CR with such a big job... > Cheers, > Bas
> > Hi Everyone, > > I have used Crystal report 8.5 with VB6 (SP4). My report contains more > > than 20 sub-reports. I guess my report contains more 3000 pages. > > My problems are: > > 1) when I click on next button, it takes around a minute to display next > > page. > > 2) finally I have clicked on last page button (regardless how much time it > > will take), but after some hours (around page no. 400. However, when I run > > this report before I have already made report displayed till page no. > 490.) > > I got error masage : "ADODB.field:Either BOF or EOF is true, or the > current > > record has been deleted. Requested operation requires a current record". > > After clicking on 'OK' button another msg screen appears with msg: "Error > > detected by database DLL". > > I guess, this is the problem of Crystal report viewer. > > Please help me to get out of this problem. > > Regards, > > Sidz
|
Fri, 04 Jun 2004 20:15:25 GMT |
|
 |
Bas #4 / 6
|
 Got error while viewing report using crystal report
Are you sure your database design is okay? I can't quite follow what you're showing on the report (I understand the structure as you describe it) Can't you make one sql query that does this? Or otherwise you could make 19 queries and combine those with unions. That 'd give you one combined query and you wouldn't need all those subreports. Bas
Quote: > Thank for your interest Bas, > I am briefing my report status now...... > I have made 20 tables in SQL 7.0. One is master and other (all 19) > tables have one to many relationship with master table. > Now, I want to show report which contains data from all 20 tables in > such a way that : e.g: first record from master table and then all records > (which has same ID as of first record of master table) from second table and > then all records (which has same ID as of first record of master table) from > third table and..................till 20th table. Then again, with new page, > second record from master table and then all records (which has same ID as > of second record of master table) from second table and then all records > (which has same ID as of second record of master table) from third table > and..................till 20th table. And so and so till all records from > master table. > Is this possible with multiple reports without using subreport? If yes, > please let me know. > Regards, > Sidz
> > 20 subreports! and 3000 pages, wow! > > I even hate to have to use 1 subreport in my reports. (they suck and CR > > crashes as a rule when i'm editing the subreport) > > Regardless if you're getting errors or not, I'd redesign the bunch to make > > it less complex (and thus better maintainable, scalable and expandable). > > Can't you split it into multiple reports and print them separately? I'd > > never trust CR with such a big job... > > Cheers, > > Bas
> > > Hi Everyone, > > > I have used Crystal report 8.5 with VB6 (SP4). My report contains > more > > > than 20 sub-reports. I guess my report contains more 3000 pages. > > > My problems are: > > > 1) when I click on next button, it takes around a minute to display next > > > page. > > > 2) finally I have clicked on last page button (regardless how much time > it > > > will take), but after some hours (around page no. 400. However, when I > run > > > this report before I have already made report displayed till page no. > > 490.) > > > I got error masage : "ADODB.field:Either BOF or EOF is true, or the > > current > > > record has been deleted. Requested operation requires a current record". > > > After clicking on 'OK' button another msg screen appears with msg: > "Error > > > detected by database DLL". > > > I guess, this is the problem of Crystal report viewer. > > > Please help me to get out of this problem. > > > Regards, > > > Sidz
|
Fri, 04 Jun 2004 21:18:07 GMT |
|
 |
A. Smi #5 / 6
|
 Got error while viewing report using crystal report
Quote:
> Hi Everyone, > I have used Crystal report 8.5 with VB6 (SP4). My report contains more > than 20 sub-reports. I guess my report contains more 3000 pages. > My problems are: > 1) when I click on next button, it takes around a minute to display next > page. > 2) finally I have clicked on last page button (regardless how much time it > will take), but after some hours (around page no. 400. However, when I run > this report before I have already made report displayed till page no. 490.) > I got error masage : "ADODB.field:Either BOF or EOF is true, or the current > record has been deleted. Requested operation requires a current record". > After clicking on 'OK' button another msg screen appears with msg: "Error > detected by database DLL". > I guess, this is the problem of Crystal report viewer. > Please help me to get out of this problem. > Regards, > Sidz
I think I understand your desired result... First, I would do ALL SQL work on the server via a view or stored procedure. I finally got tired of trying to design (and maintain!) my SQL code within Crystal and have a personal rule that I do use Crystal to do formulate complex SQL - that is just not what it does best. I think you could design a view, or better yet a stored procedure, to output the results that you want much faster than you will get by sending all the data to Crystal and letting it join/sort it all out. The database is targeted toward this work while Crystal is more targeted toward presentation - sort of like using your car to haul firewood while you have a pickup truck parked in the driveway. Sql server has some nice extensions available within the stored procedures, that are not readily available within views, that will help you fly through a task like this and will kick the data back as fast as you need it. An additional benefit of this approach is that you can debug your sql in an environment friendly to that effort - and you will not have to wait minutes to see the results. Whether you use a view or a stored procedure you can execute it from the query analyzer and look for errors and/or nulls that may cause a problem later. From the error that you describe I would suspect that you may need an outer join - one of you 19 tables may not be coming up with a matching row and you are trying to reference the resultset/recordset when there is no row to get. Again, this is easier dealt with at the server/database level. Having said that, I would revisit my design goals to see if anyone really needs one 3000 page report - who uses it and for what? Is it not so cumbersome that it gets ignored? Does anyone print this monster or do you expert it to a file that they must search? You will experience some delay if your users bring this up in preview - Crystal formats the pages as they pass by. but if you move the query off to the server you will get faster response because you be bringing only the information that you need over the net. Maybe you, and your users, would be better served by either separate, smaller reports and/or more of a summary report? If so, you have a real opportunity to pass the work off to the server. Good luck, A. Smith Oracle Certified DBA
|
Sun, 06 Jun 2004 00:14:45 GMT |
|
 |
Bruce Ferguso #6 / 6
|
 Got error while viewing report using crystal report
For a report that large you will need to have plenty of disk space available so CR can have room do do it's magic. And you can remove the subreports and just have a main report by using a UNION join to put all your sub tables together. Get the DB to do all the hard work. Good luck
Quote: > Hi Everyone, > I have used Crystal report 8.5 with VB6 (SP4). My report contains more > than 20 sub-reports. I guess my report contains more 3000 pages. > My problems are: > 1) when I click on next button, it takes around a minute to display next > page. > 2) finally I have clicked on last page button (regardless how much time it > will take), but after some hours (around page no. 400. However, when I run > this report before I have already made report displayed till page no. 490.) > I got error masage : "ADODB.field:Either BOF or EOF is true, or the current > record has been deleted. Requested operation requires a current record". > After clicking on 'OK' button another msg screen appears with msg: "Error > detected by database DLL". > I guess, this is the problem of Crystal report viewer. > Please help me to get out of this problem. > Regards, > Sidz
|
Sun, 06 Jun 2004 17:02:15 GMT |
|
|
|