Recent content by bwalvoord

Thanks for the tip. I have never used commands before. FYI, here is the syntax for Excel: Select Budget$.[Account], Budget$.[CustomerID], Budget$.[Item #], Budget$.[Jan-05 C] AS Cases, Budget$.[Jan-05 D] AS Dollars, CDATE('1/1/2005') AS BudgetDate From [Budget$]

The issue is not whether I'm trying to pull the C or D number, it's that there are three years and therefore 36 if then's to loop through for every formula. I was really hoping there was a way to pick only the twelve columns I need.

I'm using CR9 to create a budget report based on an excel spreadsheet which looks like the following: Item# Jan-05 C Jan-05 D Feb-05 C Feb-05 D ------- -------- ---------- --------- ---------- 11111 500 $15,000 450 $13,500 22222 100 $1,000 200...

That's what I've been forced to do, I was hoping there was an easier route. Thanks for your help.

There are hundreds of letter templates created in an application and each of these has any number of variables. The letter templates are stored as rich text and when the report is called, Oracle does the bulk of the work replacing each variable with the correct data. Some letters might be only...

Thanks lbass, but I that appears to only give me a carriage return and does not create a new page, even when I print it.

I am using a single formula field interpreting Rich Text to create the body of my letter in CR XI. CR will not interpret the \page page break. Is there another way to force crystal to insert a page break based on some text in the field (ie., in the text find a replace the ##NewPage!## with " +...

I have a page header in CR XI that must display a logo (jpg) stored as a blob in Oracle 10g. The logo's may be different sizes and my users would prefer not to have to become graphic artists and recreate the logo at a set size. Is there a way to pass the pixel length and width (and for that...