Search results for query: *

The list of dates comes from a table in the database. The first of every month will always be in this table. My hope is that the user won't have to scroll through many dates to find the date when in most cases the date they want is the first of the current month. I want them to have the...

The first two suggestion don't seem to impact the drop down list at all. The default value for the drop down is not impacted. My parameter has an associated list of dates that the user sees in a drop downlist. I want the user to pick from this list of dates. But I want the default value for...

Can you dynamically set the default value for a parameter. I have a list of dates (the first date of the month going back to 1980) that I want the user to select from and I want the default value to be the first day of the current month. Now I have to change the report each month to the...

lbass's technique worked. Using the multi select parameter in the select criteria did not work.

I have a multiple value parameter that I want use to with wildcards to select records to pull up client names For example If the user enters General and Ford it will pull up General Motors and Ford Motor Company. I can't seem to place a multi value parameter in the "is like" part of the...

That works!!! Thanks.

I have a salary table that has a record for every person for every payrun. Even if your salary never changes a new record is posted to this table each payrun with the effective date of that payroll I want to return the records from this table so that just one record per salary per person with...

Thanks. It worked without the \r. It took a 3500 line text file and removed the extraneous hard returns in seconds. Thanks.

I found a construct that doesn't have the same problem with backslashes and doesn't error out. Below is the script I have. $infile = "/elite/custom/ebill/micron/MyFilesmallx.txt" ; $outfile = "/elite/custom/ebill/micron/MyOutPutFile.txt" ; open(INFILE, "< $infile") ; open(OUTFILE, ">...

I am using MKS toolkit version 8.6. I mistated on what I wanted the script to do. I have a file that looks like this. abcde fghij[] klmnopqrst uvw[] xyz[] I want it to look like this: abcdefghij[] klmnopqrstuvw[] xyz[] When I attempt to run your perl script I get the following: Bareword...

Where in the perl script do I define the input and output files. When I try to run that script I get the message aborted due to compilation errors. I am not even sure I am running the script correctly. I'd prefer to use sed because I know how to get it to execute.

I am attempting to remove all carriage returns from a file when the carriage return is not proceeded by []. My attempt below failed when trying to create Myfile2, it returned the message input line too long. It works on a smaller file. tr -d '\r\n' < D:\elite\custom\ebill\Micron\Myfile.txt >...

Using the replace in the stored procedure worked like a charm.

For whatever reason SQL expression is not available. Could it because the data is in a stored procedure, or could it because this is a subreport? I see SQL expressions as a choice in other reports.

I have a memo field that displays serval lines worth of data, hard returns are identified as the character &quot;`&quot;, with similar fields I had used a formula to replace &quot;`&quot; with chr(13) but this formula won't work on this memo field. I am using CR 8.5 and know this works on 9.0...

My data looks something like this Patent Application No: 09/342,233`Light Creating Diode`Inventor name: Joe Smith' Application Date : January 2003` Reference No. : 205802 I want to display the same data but with a hard return wehre there is a &quot;`&quot; I used the formula and only the...

I have data in a table that allows for hard returns but represents them with a &quot;`&quot; sign. I can't seem to do a replace so that every &quot;`&quot; is turned into a hard return. Any ideas on how to do this?

I used the same logic that you refered to in my report but instead of displaying data in the first space of each line it has a blank space then the data. It is happening on both 8.0 and 8.5. For example _08122003 with the underscore representing a blank space. It should display 08122003

I'll add a little more detail. If I have a report with just one text box and this column is on the far left of the report and then I export it to a text file it adds a single space to the left of the text file. Any ideas?

I have a report that I export to a fixed width text file. For years it worked fine and then today it started to add a blank space before it displayed the data in the report. Any ideas on what could have caused this? We didn't change versions of Crystal and notepad is the same version as well.