Missing values in dynamic parameter list

[BettyJ]

I have a report using BOOK table having an ID and NAME field. When I display ID and NAME fields in the report, all values are being displayed.

I have a parameter - [tt]bookid[/tt] (Value is ID and Description is NAME, prompt with Description only). When I use this parameter in the report some of the values are missing. The ones that are missing are those that were added recently.

Since, I was having the issue I created another parameter - [tt]bookname[/tt]( parameter (value-NAME, then it is pulling all the values correctly.

Also if I give [tt]{BOOK.ID}=1321557644556390[/tt] in the record selection criteria, then I am able to get the row corresponding to the ID.

Can someone please offer solutions as to why the first parameter is not pulling all values? Thank you in advance.

Betty

 

[LaurieHamlin]

You say {BOOK.ID}=1321557644556390 works, but when you use the BOOK.ID parameter it doesn't list everything? Are you entering partial ID numbers?

 

[PeterDimitrov]

How many possible values for bookid do you have ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

 

[BettyJ]

Thank you for your replies.

The issue was fixed by adding the LOV key which was present earlier.(I believe our recent upgrade may be the reason why the LOV key was not present anymore).