Recent content by mdtimo

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