?
Solved

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

Posted on 2009-02-24
9
Medium Priority
?
2,052 Views
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.
SELECT "TG_INVENTORY"."OFFICE", "TG_INVENTORY"."ST", "TG_INVENTORY"."HOST", "TG_INVENTORY"."VENDOR", "TG_INVENTORY"."REGION", "TG_INVENTORY"."TGN", "TG_INVENTORY"."NEAR_PC", "TG_INVENTORY"."FAR_PC", "TG_INVENTORY"."TRKS", "TG_INVENTORY"."TCIC_min", "TG_INVENTORY"."TCIC_max", "TG_INVENTORY"."TG_TYPE", "TG_INVENTORY"."TRAFFIC_TYPE", "TG_INVENTORY"."BILL_NMBR", "TG_INVENTORY"."OCN", "TG_INVENTORY"."TELCO", "TG_INVENTORY"."CATEGORY", "TG_INVENTORY"."OVERALL_OCN", "TG_INVENTORY"."CIC", "TG_INVENTORY"."ACNA", "TG_INVENTORY"."IXC", "TG_INVENTORY"."OVERALL_CIC"
 FROM   "SS7_TG_INVENTORY"."dbo"."TG_INVENTORY" "TG_INVENTORY"

Open in new window

0
Comment
Question by:dovrlrd
  • 4
  • 4
9 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 23741102
I have no idea what you are describing, and what you need help with.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23741583
Which dlls are you using in the application?
VS2005 or from CR2008?

mlmcc
0
 

Author Comment

by:dovrlrd
ID: 23743852
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.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 96

Expert Comment

by:Bob Learned
ID: 23747142
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.
0
 

Author Comment

by:dovrlrd
ID: 23747181
Visual Studio 2005, Crystal Reports 2008 for Visual Studio
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 23747373
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"?
0
 

Author Comment

by:dovrlrd
ID: 23747598
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

Save...Done

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 entry...CENTRAL...it should have four entries.

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

0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 23748826
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.
0
 

Accepted Solution

by:
dovrlrd earned 0 total points
ID: 23749018
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
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
Suggested Courses

616 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