Parameters as bitmasks

[jwaldner]

If I have a command in a report that takes in int value that it needs to use like a bit mask; can I have a list of integers in the actual report where the user could pick all or any of them and the total value of what the user picked would be sent to the database command?

 

[crystalkiwibruce]

Sounds like a user interface a programmer would dream up. I'd recommend a custom front end application that then calls the report with a combined integer as a parameter value, or feed that value directly into the record selection formula.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[jwaldner]

I don't really have that choice. This was an existing query and report that a previous designer began. He never figured put the flags. Just hard coded default values in the query and wrote a giant report around it. Then he added the parameters but did not link them in. Now of course people want the parameters to actually work. it would be weeks of work to re do the mess.

 

[Turkbear]

Hi,
You could create a table with the needed values and use that to build a dynamic parameter list to allow users to choose from.

Add that table to your report but DO NOT link it to the command - use it just to populate the pick list.





To Paraphrase:"The Help you get is proportional to the Help you give.."