• 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
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
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
Posts: 55
Veteran Member
3/16/2010 11:48 AM
yes - it can return several records.
Chris Martin
Veteran Member
Posts: 277
Veteran Member
3/16/2010 1:34 PM
What version of LBI are you running?
Jan
Veteran Member
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
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
Posts: 55
Veteran Member
3/16/2010 2:48 PM
no - they have the same datasource
Chris Martin
Veteran Member
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
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
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
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
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
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.