Hello,
I have a crystal report 2008 SP2 on Windows 7 64 bit machine. 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, it shows my all periods (1 thru 12). But when I create a dynamic parameter on period, 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, it shows me all the period values! 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. Please help!
Could it be 32 bit -64 bit issue? If it is, how should i resolve it? My ODBC set up currently is 32 bit.
Thanks,
KJ