parameters drop down list

[tezzyr]

I have a report created in crXI which runs off an sql server db.
the report contains a parameter to gather user input which is generated dynamically from the db.
when running the report on my machine I see a nicely formatted window which populates a drop down list containing all the companies in my database.
however, when running the report from an application on the server, I have no drop down list and have to enter the company names manually.
I assume that this is because my pc generates the reports using crxi and the server is running an earlier version (version 9 according to regedit)

how can i have the users run the report on the server and see a drop down list rather than have the user type in the parameter values. do i need to upgrade the server to a later version of cr? or just upgrade an active x control or something? if so how do i do this?

thanks for your help with this, as you can tell, im a newbie!

 

[synapsevampire]

You can either update your server to CR XI (first version with dynamic parameters), or you can use static values and prepopulate them at save time using set default values.

They won't be dynamic but you'll have all of the current ones listed.

There are other options as well, such as 3rd party products, check out:

http://www.kenhamady.com/bookmarks.html

-k

 

[tezzyr]

thanks for the fast reply, I had an idea that I'd need to upgrade the server to cr XI but wasnt 100% sure. I cant upgrade the server unfortunately as it doesnt belong to our company and there are already lots of reports using the current version already and i dont want to break them
the report is viewed using a normal report viewer coded in vb.net(not a web based report viewer) so i assume that upgrading to a later version activex wont achieve anything?


thanks again.