Skip to Content
author's profile photo Former Member
Former Member

List of Values Error

I am creating reports with dynamic/cascading parameters using Crystal XI R2. I've looked through the forums and have seen the issue I'm having, but no solution that fits my situation. I am creating the reports on my machine, then moving them to a remote server for the client to use (external client, not on my network). The Crystal runtime is installed, and I have no issues with reports that don't have dynamic parms. Stored procedure-based reports also work fine. I am at a loss and desperately need to solve this issue as nearly all of the required reports call for dynamic lists. I also get an error when I try to use SQL commands. Any help would be most appreciated.

Thanks,

Jimmie

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2008 at 04:32 PM

    what kind of errors are you getting while using SQL? What is the database you are using and what is the database client is using?

    With dynamic, are you using the same name of the database at both ends? How are they connected?

    Please provide further details so we can help you out.

    Regards

    Jehanzeb

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sorry I wasn't more specific. The client server and mine are both using SQL2005. When I use dynamic, the error is "list of values failure: fail to get values." When I first tried to run the report at the client site, the database name was different, but I changed it and still got the same error. In the report I am currently building, I have a sp and two lookup tables specified. The report is populated by the sp, and the lookup tables serve to populate the dynamic LOV. One is for County, the other is for Neighborhood code. I have the two of them linked on county code. As I said, this works fine on my machine, but not on the client's. Our machines are not on the same network. I FTP the reports to their machine and install them through our custom app. The app calls the report and brings up the Crystal prompt.

      I quit using SQL commands because they were causing a similar, if not the same, issue but it's been a while since I used one so I can't remember the error. And I'm not as concerned about those as I am the dynamic LOV in general.

      The general structure is this:

      sp_res_report has columns:

      acctno

      dos

      price

      county_cd

      nh_cd

      lu_nh has columns:

      nh_cd

      county_cd

      lu_county ahs columns:

      cd

      dscr

      In the Database expert, lu_nh and lu_county are linked via inner join on lu_county.cd = lu_nh.county_cd. My dynamic/cascading parm @nh pulls lu_county.cd, then lu_nh.cd. The report pulls records based on sp_res_report.county_cd = @nh.

      Hopefully this is a little more clear.

      One other note: When using separate lookup tables, I get an error that says "the parameter is incorrect." When I created a SQL command with this logic

      SELECT lu_county.cd county_cd

      ,lu_county.dscr county

      ,lu_nh.cd

      ,lu_nh.dscr

      FROM lu_county

      INNER JOIN

      lu_nh

      ON lu_county.cd = lu_nh.county_cd

      WHERE lu_nh.cd IS NOT NULL

      to populate the dynamic LOV, the report will run but I get 454 rows for each record. There are 358 county-nh combinations, co I'm not sure what this number means.

      Edited by: Jimmie May on Oct 8, 2008 8:23 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.