Crystal 2008 SP1 Parameter Issue

[KJBULLS]

Hello,

I have a crystal report 2008 SP1. I have a parameter issue. I have command SQL in my crystal. I am trying to make a dynamic parameter on period/month selection. When I run my SQL in query tool, it shows my all periods (1 thru 12). But when I create a dynamic parameter on period in crystal, it only shows me period 1 and 12. I decided to test, I removde my SQL from the command and just imported the table without SQL coding , and I created a dynamic parameter on period field, it shows me all the period values 1 thru 12! It works when I do not have SQL. Can anyone tell me how to resolve this? I have tested my SQL and it works when i run my code my a query tool. Infact I tested SELECT * FROM TABLE and it still doesnt show me all the period values in my dynamic parameter. It looks like it doesn't like SQL selection fields. Please help!

Thanks,

KJ

 

[kenhamady]

Try select distinct in your query. There is a limit to the number of rows that CR will process and within that limit there may only be 2 values.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/