• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

OnDemand linked subreport in Crystal question

 12 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/15/2010 7:14 PM

I have a design dilemma with my Crystal report.  I have two subreports that I've put onto the detail line as on-demand reports.  I like the way this looks but since the on-demand report doesn't run in LBI until the user clicks on the link, they are asked to enter their odbc userid/password to call the data up.  Is there anyway to include this subreport as an on-demand item on the detail, but get around forcing the user to enter a userid/password?

 

Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/15/2010 8:32 PM

Does your subreport return more than 1 record for each record in the main report?

Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/16/2010 11:48 AM
yes - it can return several records.
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/16/2010 1:34 PM
What version of LBI are you running?
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/16/2010 1:41 PM
we're running Reportin Services Version: (200905) 9-0-3-2-102 05 - is that what you mean?
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/16/2010 2:02 PM
Yes, that is what I was asking. Are your main report and subreport pointing to different datasources?
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/16/2010 2:48 PM
no - they have the same datasource
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/16/2010 3:34 PM
I thought most of the subreport bugs were resolved by version 9.0.2. Does it prompt you for the login credentials when it's not an ondemand subreport?
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/16/2010 4:16 PM
no - subreports that are not on-demand work ok. I partially put this out here to see if the issue was on my side or with the system. From your comments, it sounds like it may be a system problem. I've created a ticket for my local help desk on this.

Do you recall that prior to 9.0.2, subreports had issues including this type of log-on issue? Does my issue sound similar to those earlier issues?
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/16/2010 4:27 PM
I'm not 100% sure it's a bug, but it sounds like it.

Here's one thing you can try as a possible workaround: If you are using Override Datasources, try selecting "Use Report Data Source" and hardcoding the db credentials at the report level.

Honestly, I don't recall if I ever tested on-demand subreports on the pre-9.0.2 versions. I do recall, however, that there were significant subreport issues.
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/16/2010 4:48 PM
I don't have the option of hardcoding db credentials at the report level. I use an override data source set up for me by I.T. but the userid/password are then hidden from me. I need to use the override datasource so that the report will run when scheduled - since it won't run on the server under my own userid.
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/16/2010 5:04 PM
You could have IT hardcode db credentials for testing purposes. Hardcoding the credentials should not affect the scheduling results.
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
3/16/2010 7:50 PM

Just as an FYI follow-up on this, after working on this issue with I.T. for a while, we've found out that everyone can see this subreport ok without the login screen popping up - except for me - the report owner.  We're not sure what the issue is - perhaps it has something to do with the url, or maybe there's an LBI bug that only kicks in when the owner views the report.  Don't know at this point.