Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

crystal viewer and subreport on-demand

crystal viewer and subreport on-demand

crystal viewer and subreport on-demand

Hi There,

I have created a report with one subreport inside it. (using Crystal report XI)
The report shows list of dates and connects to stored prog1.
The subreport shows 24 hours inside each of the date and connects to stored prog2.

I chose "On-demand subreport" option so that the report won't burst into hundreds of pages.

I stored the report into another software that has embedded Crystal Report Viewer into it and ran the report, I can see the link for drill down but when I clicked it the window popup asking to loggin again (user name and password).

Could anyone please suggest a solution so that I can drill down the subreport on-demand without asking to login again to the oracle database?

Many thanks,

RE: crystal viewer and subreport on-demand

Try going into database->set datasource location->subreport->properties->use DSN Default properties-> change this to "true".


RE: crystal viewer and subreport on-demand

Thank you for the reply LB
Is it in Crystal .I went database -> set datasource location ->subreport->highlight properties and it not lem me do anything .Try right click windows pop up.

Thank Nirel

RE: crystal viewer and subreport on-demand

sorry no any windows pop up

RE: crystal viewer and subreport on-demand

You should be able to click on the + sign next to Properties. Then highlight: Use DSN Default Properties: True. Then put your cursor in front of true and change it to "false".

I'm not sure whether your driver is set up the same way as mine though.


RE: crystal viewer and subreport on-demand

I think my is different
Under properties i have
Database Type :Oracle Server
Service : server name
User ID : user name
OS Authentication : False

RE: crystal viewer and subreport on-demand

Sorry, but I don't know what else to suggest. Maybe someone else does.


RE: crystal viewer and subreport on-demand

Thank you for your time. I had a chart with our developer,they will need to change a code in .net.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close