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.