Hi

Assume I have a few columns in Crystal

Jan       Feb      Mrt       Apr       May      Jun       Jul        Aug      etc        Total

The user select a date range based on start and end date

Let’s assume the data selected 15/02/2011 to 15/08/2011 and for whatever reason there were no transactions in June

What I would like to see in Crystal is

Feb      Mrt       Apr       May      Jul        Aug      Total

Can a column that has no data returnd be susspended and the column to the right automatically be moved to the left.

If not, can the formula button on the X and Width parameter when doing Object Size and Position be used in anyway to achieve the same and if so how?

(Nevermind what I put in the formula nothing seems to change anyway)

If none of the above can be achieved, I am open for any other suggestions that might give me the required data return as long as no heavy coding is involved as I am not a programmer

Regards

Burger

Hi Lockwell

This works great. If I can now take it one step further.

Is there a way to pick up the X (Left start) and Width from a column

Where I am going with this is to say: (Explained in English not coded)

Start value for column 1 = 1 inch for X and Width = .5 Inch

NOW my formula for column 2

If my Col1 field have no value Then my X for Column 2 must be X of Column 1 x 1440 and width must be Width of Column 1 * 1440

For Column 3 I do a check for blank column 2 or not

Then for column 3 my X would be my (X of column 1 + width of column 2 + width of column 3) * 1440

Hopes this gives an idea what I want to achieved

To do this thou as mentioned I need to know how to pick up the X and width of a specific column

Can you help or have any idees on this

Regards

Burger