Solved

No 2nd DataReport Printout

Posted on 2002-03-03
6
170 Views
Last Modified: 2010-05-02
Hello,

I have a wierd problem:

In my proj, i have a data environment and data report. A command in the DE(which is my datareport source) access 4 tables. 3 of the tables I use for computing.  The content of the 4th table is displayed directly.

My problem is that all my report printouts are good except for the 2nd printout.  There is no data.  In using a parameterized command.  I've tried different parameters for the command. Every 2nd printout has no data.  But if i use the same parameter for the 3rd printout, the correct data is printed.

Any ideas? Please help.
Thanks
0
Comment
Question by:3Mann
  • 3
  • 3
6 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6837638
0
 
LVL 1

Author Comment

by:3Mann
ID: 6838432
yup, already read that one...
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 200 total points
ID: 6838763
Are you closing the recordset before re-using it?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 1

Author Comment

by:3Mann
ID: 6839030
uh... sorry for not posting...
already solved the bug...
i closed the connection before reusing it...

Thanks emoreau
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6840087
will you award me the points or will you delete the question?
0
 
LVL 1

Author Comment

by:3Mann
ID: 6841038
Hope you'll agree if I don't give the full points posted...
First, I have already solved the prob before reading the comments and second, closing only the recordset was not enough.

Cheers
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question