Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PNC
  • Order by date
  1. PNC

    How to add multiple default values in CRXI

    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
  2. PNC

    How to add multiple default values in CRXI

    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.
  3. PNC

    Workaround for SQL Command Parameter with Dynamic List of values

    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.
  4. PNC

    Workaround for SQL Command Parameter with Dynamic List of values

    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.
  5. PNC

    Workaround for SQL Command Parameter with Dynamic List of values

    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...
  6. PNC

    Workaround for SQL Command Parameter with Dynamic List of values

    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...
  7. PNC

    Dynamic Null Parameter

    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.
  8. PNC

    Dynamic Null Parameter

    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...
  9. PNC

    Dynamic Null Parameter

    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...
  10. PNC

    Command parameter changes name when used with report parameters

    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...
  11. PNC

    Multiselect Parameter in Command

    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.
  12. PNC

    Command parameter changes name when used with report parameters

    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.
  13. PNC

    Command parameter changes name when used with report parameters

    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...
  14. PNC

    Command parameter changes name when used with report parameters

    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...
  15. PNC

    BCP Uiltity Arguments

    No ";" is not part of the value, the way it is currently, I'm only able to upload 6000 rows, but the file contains 70000 rows, I need to add an argument that says the row ends after ";" and on to the next line.
  16. PNC

    BCP Uiltity Arguments

    Hi, I have a text file with one column: value1; value2; value3; I want to use the bcp utility to export it to a table with one column [varchar (128)], but I'm not able to define the right arguments so that it can be exported properly. BCP DBNAME.OWNER.TABLE IN FILE.TXT /U USERNAME /P...
  17. PNC

    Add Numbers to Char Data Type

    You're the man rac2... I know that NextStamp should have been an int, but I didn't develop the database, I'm just the guy who's stuck with the bad design. Thx.
  18. PNC

    Add Numbers to Char Data Type

    Hi, I have a field of data type char(16) containing numbers, I want to add "1" to it, but I still want to keep the same format. SELECT NextStamp, NextStamp + 1 FROM Defaults --Returns 0000000000880025 880026 --I want 0000000000880025 0000000000880026 Any ideas on how to do this? Thanks.

Part and Inventory Search

Back
Top