Report ciew correct but print no

Hi,
first
Program language visual basic 6 +SP5
Crystal Report 8.5
SQL Server2000

Day2(Namr of report)

the problem
i use these code so when any one click print in report view he can select the printer

UseDefault = False
Day2.PrinterSetup Me.hwnd
Day2.PrintOut True

first time view report its print ok but if i open report again with differnet parameters its showing correct data in report view but after i click print and choose printer it still print the first report

why these happen?I've seen this problem before, a few years ago.
I don't work at the same place now, so I can't go back into SourceSafe and check the code, but I seem to recall we had this problem due to originally not properly disposing of the report object.
If you have a report object open (instantiated) and you then reset some parameters, it may not function properly unless you dispose of the object when you next start a "view" process.
So, when you click on a button to regenerate your view of the report, make sure you do something like this;

set objReport = Nothing
set objParams = Nothing

and then provide code to recreate the objects, which should flush the report object and all objects is has created, and then create a clean new object so you can set parameters.

Davesql

report as side by side records display

I want to generate a report for information related to different libraries. It is required to print two library information (two records) side by side in a page. I do not know how to do so.like

libraray name: abc libraray name: abc
address: abc address:abc
phone:30 phone:abc

best regards
kashifIf there is a link between these table, then u can use linking concept and retrieve data from any of the tables.

If not, try to look at the sub reports concept. May be helpful to you.

Report Access

I have created a new report that all my users except for one can print and
view the same data on this report. One user gets the
report headers -- but no data.
I checked this user's active directory settings, and she is a member of the
same Reporting Group.
What could be the problem?Sounds like SQL data permissions issue. If I understand correctly the user
is seeing text that is static in the report but no data from the dataset.
Is the dataset SQL a stored procedure, or a select statement. If it's a
select statement probably doesn't have access to read the tables. Try
loging onto query analyzer with the users credentials (or similar) and
seeing what data is returned.
Steve MunLeeuw
"Cindy" <CindyMikeworth@.newsgroups.nospam> wrote in message
news:OHuLuAu7GHA.3644@.TK2MSFTNGP03.phx.gbl...
>I have created a new report that all my users except for one can print and
>view the same data on this report. One user gets the
> report headers -- but no data.
> I checked this user's active directory settings, and she is a member of
> the same Reporting Group.
> What could be the problem?
>|||Hello Cindy,
Does Steve's suggestion make any sense to you?
Also, you could try to test on other client with your user's credential. If
you could access the report on other client, you may need to check the IE
security setting.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)