My Dynamic Paramter in Crystal 11 doesn't pick all Database Values!!!!

[SQLRory]

I created a report which uses a couple of Dynamic parameters.
The first time I wrote the report the Dynamic Parameters worked absolutely fine and picked up all database values when I was prompted for my parameters.

I then made minor change to the report totally insignificant to the parameters and now one of the Parameters only picks up some of the Database Values and not all of them!!!!!!

I wrote the report entirely from scratch and even tried to add the parameters at different stages. I can even see the values that the parameter is supposed to pick up when I run the report without any parameters!!!!!

The parameter picks up a 'EMPLOYERID' which has around 30 types yet the report only brings back 6 when I create the dynamic parameter.

Please help somebody I have spent 5 hours trying to fix this and want to throw my PC at the wall!!!!!!!!

Kind Regards

Rory

 

[Tatertot45]

What did your report look like before the "Isignificant change" and then what was that change? Your issue could be any number of things, but we can't help you if we don't know what your report looks like.

 

[beltmanjr]

And are you certain you're taking the correct field to create the dynamic parameter population? And have you checked that particular field in the db to ensure all values you expected are still there? I believe you could check this using a distinct select.

 

[SQLRory]

Hi guys,

I have checked the db values as they appear in the report before I add the dynamic parameter to the field in question.

For example before I create the dynamic parameter the field show's these values.

e2e
E2E Harpurhey Centre
E2E Longsight
Nortern Way
.........etc < ----- *there are approx 30 of these

However when I create the dynamic paremeter it only appends about 6 of the values, instead of all 30!

The minor change was a change to the name of the row in my query from
EMPLOYER.description as 'Scheme' to
EMPLOYER.description as 'EMPLOYERID'

However I changed the code in the select expert and mapped the field to the relevant field.

Thanks for your help.

 

[lbass]

You need to show the content of your query (a command, I guess).

-LB

 

[beltmanjr]

So is this fixed now?

 

[SQLRory]

It is not fixed but I do appreciate your help.

I don't actually think it is the script or anything I am doing, I think it is a Crystal fault. One of our senior Programmers has told me that there are bugs in Crystal XI where the parameters don't work properly.

I have therefore used a static parameter and input my own values.

Thanks for you help.

Rory

 

[beltmanjr]

Is this a cascading parameter?