3Mann
asked on
No 2nd DataReport Printout
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
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
Have you read http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244779
ASKER
yup, already read that one...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
uh... sorry for not posting...
already solved the bug...
i closed the connection before reusing it...
Thanks emoreau
already solved the bug...
i closed the connection before reusing it...
Thanks emoreau
will you award me the points or will you delete the question?
ASKER
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
First, I have already solved the prob before reading the comments and second, closing only the recordset was not enough.
Cheers