Search results for query: *

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

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

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

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

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

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

A string can be at most 254 characters long. I get the above error message from the following formula when I try to add in more line of narrative. Maximum ({@Desc1 }, {@grouper}) +&quot; &quot; + Maximum ({@Desc 2}, {@grouper}) +&quot; &quot; + Maximum ({@Desc 3}, {@grouper}) +&quot; &quot; +...

I pass a variable(numbervar) from my subreport to the detail of my master report. I then want to subtotal this variable in my master report. But unlike other fields or formulas I can not subtotal on the variable. Is there a way around this?

I am dealing with three tables with the fields listed below Time -index -tworkdt -tudef Cost -index(links to costudf.index) -cdisbdt Costudf (there will be no record fo Costudf for Costs with no udf) -index -cudef I want a querry that will list all the distinct values for both tudef and cudef...

This isn't exactly related to Crystal but I am writing a stored program for Crystal and wanted to see if anyone had an idea of what I am doing wrong. The three tables involved are charge,charge_udf, and sales, I want a list of the distinct udf values from these two fields but with nulls I get...

I have a string that always starts with a name. It would be something like this: Jim Green labor certification. I want to pull out Green. I only want to display &quot;Green&quot;.

I have created a stored procedure on an Informix Database and want to be able to pass a parameter from a crystal report to the stored procedures parameter. I can set the parameter on the stored procedure when adding the stored procedure but then can't see how to have the stored procedures...

How can I get a subreport to display when there are no records in the master. It only displays if I click on the subreport. It displays fine when the master report has data though.

I have two subreports that I need to link to a master report. The field the expenses subreport links to the master is a user defined field in a seperate table from the actual expenses. Often this field is null and I use a left outer join to link the expense table to the expenses user defined...

I have two tables. One with the expense incurred and another with the desciption of the expense. they might look something likes this. table 1 index amount table 2 index line number description I link the two tables with the index. With a longer description I might have two or more line...

I want to be able to show a date when no row in the database is present for that date. For example. The data in the database would look as follows for 1/2/02 through 1/5/02 for employee 612 employee date hours worked 612 1/2/02 4 612 1/3/02 7 612 1/5/02 3 but...