Recent content by PNC

Thanks for your reply, but what I'm trying to do is to enter multiple values in the default field, so that in the prompt I have this: Available Selected 1 1 2 2 3 4 4 5

Hi, I'm using CRXI, and I would like to specify multiple default values for a parameter that allows multiple values, I know it was possible in CR10, but I don't see the option in CRXI. Thanks.

OK, here's what I did, instead of using a command query, I linked the tables, I added record selection parameters and I converted all of my formulas into SQL expressions, in order for the query to be performed on the server.

OK, here's what I did, instead of using a command query, I linked the tables, I added record selection parameters and I converted all of my formulas into SQL expressions, in order for the query to be performed on the server.

I don't like to do this but...BUMP!!!

I don't like to do this but...BUMP!!!

Hi all, I know this has been discussed multiple times on this forum, but I would like to know if anyone came up with a workaround since the last post on this. How can I have a parameter with a dynamic list of values on the SQL command. I'm using CRXI, and I don't want to put the parameter in...

Hi all, I know this has been discussed multiple times on this forum, but I would like to know if anyone came up with a workaround since the last post on this. How can I have a parameter with a dynamic list of values on the SQL command. I'm using CRXI, and I don't want to put the parameter in...

I found a solution, in the query I change the select statement from SELECT Field to: SELECT IsNull(Field, '[NULL]') When the parameter prompt appears, you can select the null values as well as any other fields.

Thanks for your reply, but what I would like to have is this, the user cliks on the report, and there's a prompt: SELECT VALUES FOR FIELD1 Available values: [NULL] Value1 Value2 ... I don't know if it's possible in crystal, I don't want to use a text file with a list of values, I would like...

Hi, I've created a parameter in CR XI with a dynamic list of value based on a field which contains some null values, my problem is the null value option won't show up in the group prompt... And I don't want to modify the formula to say field = null or field = {?My Parameter}, because I want to...

The code is not the problem, it's a bug in Crystal XI, it has been discussed in this thread also http://www.tek-tips.com/viewthread.cfm?qid=1157169 The only solution I found so far is not to use a command parameter along with a report parameter with a dynamic list of values. Thanks for your...

How can you suggest using a View when a view can't have parameters? And if you build the view without parameters and use the Select Expert of Crystal, the report will be slow because it has to retreive all the rows, then crystal will do the filtering.

You're right lbass this issue is similar, however it would be nice to have a better solution for this bug then the one offered in the thread http://www.tek-tips.com/viewthread.cfm?qid=1157169. Thanks.

Hi, Here's my problem, I have a command parameter for my query and I also have report parameters, so when I create a report parameter with a dynamic list of values, the name of the command parameter changes when I run the report in the prompt screen, it displays the name of the report parameter...