CR 7 not showing all entries in SQL 2000 Tables

[Rotton3]

We purchased a Help Desk product that came bundled with Crystal Reports 7. I self-taught myself, through Trial & Error mostly, how to create Reports from the data entered into the various Help Desk Tables. I apologize for not knowing the correct terminology in describing my problem.

The Tables are maintained in MS SQL 2000.

In one Table, called "Type", I have 194 entries. When I attempt to create a Report only 112 entries are in the drop-down list. I can manually enter the missing entries and when I run the Report the data is correct. This is in the "Report", "Report Expert", "TopN Report Expert", "Sort" tab, making a "New Named Group...", and editing the 'New Named Group'.

In another Table, called "Staff", I have 10 entries. When I attempt to create a report only 8 entries are in the drop-down list. Once again I can manually enter the missing entries and when I run the Report the data is correct. This is in the "Report", "Edit Selection Formula", "Record" area.

I contacted the Help Desk company about this problem and was told by them:
"Crystal reports seems to have limitations of what will and will not appear in their drop down lists inside a filtered view. I have played with this now for two years and cannot get around these limitations. If you build parameter prompts, whether the information appears in the drop down list or not, if you type what you are looking for correctly, it always returns what you are looking for inside the main report."

When I asked if they contacted Crystal Reports about this problem I was told:
"Yes we have, and their answer to us is that this is a known limitation of the Crystal Reports product."

I find this hard to believe.

Is this a known limitation of Crystal Reports?

Is there any way around this problem?

Thanks,
Ralph

 

[AndrewBaines]

What's the helpdesk product? Andrew Baines
Chase International

 

[synapsevampire]

It's a known limitation if you don't do anything about it.

A drop down list can be populated, but they are NOT populated automatically,though some people think they are because when you originally populate thm, they allow you to do so froma table, but they must be maintained either with code that or manually.

So the limitation is twofold, Crystal doesn't automatically populate drop downs, and your helpdesk people aren't coding correctly (if at all, they may just be populating it originally, then relying upon their users to manually update and save the report).

A common nuisance for Crystal developers and users.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com