Search results for query: *

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.

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

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

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

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

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

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.

Hi, When scheduling a report to run, I want to automatically add the date, but the placeholder %SI_STARTTIME% also includes the time, how can I have only the date? Thanks.

Hi, I have a report with 3 groups (1, 2 &3). I would like to change the text of the page header based on the group displayed, i.e if group #2 is being shown then the text of the page header should say "Page Header for group #2". Thx, PNC.

Hi, I would like to know, how to automatically insert the first name and the alias from the contact properties in the message body of my email in a message template. Thanks, PNC.

Hi, Does anyone know when it will be available? Should I pursue the MCDBA 2000 instead of waiting? Thanks, PNC.

Hi, What's the equivalent in SQL Server of the server settings in Sybase [lock_wait_period]??? Thanks.

Hi, I'm having lots of blocking in my DB, and I always need to kill the blockers in order for the web application to function properly (update, insert, delete), so I would like to know if it's possible to use SET LOCK_TIMEOUT for every session started in the DB? Thanks, PNC.

Hi, I'm trying to do an import from an excel file, but I get an error message saying that the destination field cannot be null at row 29, but row 29 is empty in my Excel file. Why is DTS trying to import the empty rows from the file?

Hi, I've used HTML Help Workshop to create a help file (*.chm) for an access database, then I specify this file in the form properties and change the help context id to a valid value available in my file. My problem is, when I press F1, I don't see the navigation pane, however when I execute...

Hi, I've used HTML Help Workshop to create a help file (*.chm) for an access database, then I specify this file in the form properties and change the help context id to a valid value available in my file. My problem is, when I press F1, I don't see the navigation pane, however when I execute...

Hi, This is my code DoCmd.OpenReport stDocName, acPreview, , "ASC([Field]) like ASC("& Variable &")" ERROR: Data type mismatch in criteria expression It works fine in a query, therefore it should also work in the code, right? Any ideas why not? Thanks, PNC.

Hi, This is my code DoCmd.OpenReport stDocName, acPreview, , "ASC([Field]) like ASC("'Variable'")" ERROR: Data type mismatch in criteria expression It works fine in a query, therefore it should also work in the code, right? Any ideas why not? Thanks, PNC.

I open a form and depending on the command button that I click, the values for the report and query name are placed in 2 text fields. I select a value from the combo box, and modify my where clause depending on the value selected, then I click on the command button to open the report...