If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 > Carriage return in a Crystal Formula

 MikeA57 Registered User Join Date: Jan 2013 Posts: 1
Carriage return in a Crystal Formula

 Crystal Version 11 R2 I'm working in a cross tab report and I need to place the Week # (data field in a table - datatype is Number) and the Day number (formula I built) in the X axis of the report. The fields need to be 1 atop the other like this: Week: 1 2 3 4 etc Day: 1 8 15 22 etc The weeks need to display in numerical order across the top of the crosstab. EDIT: OK, I noticed that the numbers in my illustration are not aligned like they should be. Just bear in mind that I need 1 & 1 vertically aligned with each other, 2 & 8 aligned, 3 & 15, etc. The Day field is a formula I built that is simply (({CrystalData.WeekAsNum}*7)-6). My idea was to create a formula that placed the Week # on line 1, do a Carriage Return then place the Day # below the Week #. Here's the formula I built to do that: {CrystalData.WeekAsNum} + chrw (13) + {@Day Number} The problem is, the formula evaluator keeps telling me "A number, currency amount, date, time, or date-time field is required here." It highlights the chrw (13). If I change the formula to set the Week & Day fields as Strings, it of course displays the weeks as 10, 11, 12, etc., then 3, 4, 5, etc., which won't work. Same thing if I use this formula: {CrystalData.WeekAsNum}&chrw (13)&{@Day Number} If I place the 2 fields in the X axis of the Crosstab Expert then I get an unnecessary Total column that I can't remove. How can I get around this limitation in Crystal that won't allow me to place a carriage return in the midst of number fields??? Thanks, Mike

Last edited by MikeA57; 01-24-13 at 11:50. Reason: Explain illustration that didn't post correctly.