Crystal reports 2008 cascading dynamic parameters past two levels only returns one option in first parameter list.

Posted on 2009-02-24
Last Modified: 2013-11-06
I am building a cascading parameter list in a simple report. If I make this list 2 levels deep...say REGION and then STATE. I see the full list of REGIONS. However, if I add mor levels into the Cascade, the list only populates the REGION with 1 value, the first one in the list. The list should contain 4 values.

Crystal Reports 2008 via Visual Studio 2005 for an ASP Page. The dynamic data comes from a SQL Server Table.


Open in new window

Question by:dovrlrd
    LVL 96

    Expert Comment

    by:Bob Learned
    I have no idea what you are describing, and what you need help with.
    LVL 100

    Expert Comment

    Which dlls are you using in the application?
    VS2005 or from CR2008?


    Author Comment

    Let me try again...

    I am building a Crystal Report that will be called from an ASP page. This is currently being designed in VS2005 with CR2008. (CR is up to date.) I have not created the Windows Installer for the project yet, since its still under development. I am only viewing the Web Pages and Reports via the VS2005 Debugger.

    This Web Site has dozens of CR Reports, but with this particular one, I want to add Cascading Parameters to allow the user to zero in on the information they want returned. Cascading Parameters seems like a straightforward concept.

    However, if I add more than two layers of parameters and debug the website and go to the report. The drop down to pick the first layer only lists the first entry. Now, if I remove some of the layers, so there are only two layers, the drop down is properly populated.

    Here it is with more specifics. This is for telephony, but you should get the gist.

    Parameters I want to cascade:
    Region (East, West, Central, Rochester)
    -      State
    o      Host Switch
    §      Trunk Group number

    If I build a Cascading Parameter as above, the drop down only shows: CENTRAL (which alphabetically would be first in the list)

    If I remove the levels of: Host Switch and Trunk Group Number, the drop down from region shows (CENTRAL, EAST, WEST, ROCHESTER) as expected.

    If I add back Host Switch and Trunk Groups into the cascade of parameters, it goes back to just showing CENTRAL. Even if I add just Host Switches, the other Regions go away as choices.

    I am stumped because, as I said, the concept of Cascading Parameters to a CR is straightforward. I have made literally hundreds of Crystal Reports for ASP pages before, but now as I review them, I never had a report with more than 2 cascading parameters. Every forum and book I have read on cascading parameters tells me that you can have virtually infinite cascading parameters.
    LVL 96

    Expert Comment

    by:Bob Learned
    1) Cascading parameters come with XI, and I am still stuck on Crystal for 2005 (version 10).

    2) I had to discover that what you meant is a new construct for 2008.

    3) That is a much better explanation of the problem.

    4) I don't usually concern myself with parameters, since I use the "push" method, instead of the "pull" method, so all the data work is done outside of the report.

    Author Comment

    Visual Studio 2005, Crystal Reports 2008 for Visual Studio
    LVL 96

    Expert Comment

    by:Bob Learned
    OK, I overlooked 2005 in my haste.  I also mixed myself up, as Dynamic Cascading Parameters were added in XI.  I will never say that I am an expert on every facet of Crystal Reports, but I am try to keep in touch with those concepts.

    How are you defining the "cascading parameters"?

    Author Comment

    1) In VS...I pick the .rpt in the Solution Explorer and open it
    2) Right Click Parameter Field in the Field Explorer, click NEW
    3) Enter a name for the parameter...example parmPickFields
    4) Select Dynamic under list of values
    5) Go down to values and in turn pick each Table Field I want to use in the Cascade of Parameters
    i.e. Region, State, Host Switch, TGN
    6) Under the Parameters Column I click on the Host Switch and TGN fields to make them ?Parameters since, those techically are the unique fields. (I have also tried by making them all Parameters but that did not fix the problem.)
    7) Click Ok
    8) Go into Report>Select Expert> Record
    9) Select Host Switch...set it equal to ?parmPickFields - Host Swtich
    10) Select TGN...set it equal to ?parmPickFields - TGN


    Like I said, it seems quite straight forward once you get the hang of it. I followed the procedure out of Crystal Reports 2008 Reference Guide.

    However, when I pull the report up in the debugger or publish it, the Region Drop down on the parameter page only lists the first should have four entries.

    I also went into other reports and tried to do something similar, add cascading pickable parameters. Same thing happened.

    LVL 96

    Expert Comment

    by:Bob Learned
    OK, I also believe that you are using the full version, and not the one that comes with the 2005 IDE, right?  I think I need to go to my 2008, and look at that.

    Accepted Solution

    Yes, we upgraded to the full version.

    I think that I came across the answer. It has to do with a registry setting that only allows the population of 1000 records. As, I cascade down the number of records could pass 1000. Hence, it limits what I can cascade to.

    I am messing around with adding a registry entry: MaxrowsetRecords

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    How to increase the row limit in Jasper Server.
    THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
    The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now