I cannot figure out a way to copy data from a cross tab table and paste it elsewhere on the report.

Example :

Cross table :

          Jan   Feb   Mar
Client A   2     1     0
Client B   4     3     1
Client C   3     0     0


Is there a way to create a box dialog that shows whatever value is on Feb - Client A ? For this example the value on the box would be 1, but say the report's updated and now client A bought 5 units on february, I'd like the value on the box dialog to be automatically updated to 5.

Hope this is not too confusing, thanks for the help.

Hi Dell,

Thanks for the help. I want to get the data from the two last months (two lasts columns) of the cross table. I would also like to make a formula that shows the percentage of change between this two months.

I'm using the cross table to show the percentage of orders that were sent on time to the clients on each month.

My parameteres:

Columns: order.delivery_date
Lines: client.name
summarized fields : average(good_ratio)

good_ratio is actually the percentage of orders on time, I get it by using a series of formulas, hope it doesn't get too confusing :

good_ratio = 100 - month_ratio

month_ratio = 100*(Sum ({@Retard}, {order.delivery_date}, "weekly")/DistinctCount ({order_line.ID_order_line}, {order.delivery_date}, "weekly"))

retard = if ({order.delivery_note_date} - {order.delivery_date}) > 0 then 1 else 0




-Santiago.

The date parameters the user enters.


Santiago.

Ok, the maximum date range is the last day of the previous month. For example, if we used the report today, we would set a date range from January 1st up to May 31st.

Hi Dell,

I actually found a soltuion!

I was using the same two date parameters (start and end) to limit both the data for the whole report and the data to be used on the formulas for the current and previous month.

Here's what I did:

I use a start_date and end_date to limit the data of the report.

{CLIENT.DELIVERY_DATE}>={?Start_Date} AND {CLIENT.DELIVERY_DATE}<={?End_Date}

I created a month_start_date and a month_end_date to select the data from the last month and all the formulas are parametered in order to use just the data between those two dates.

Example: every formula I created starts with this condition :

IF {CLIENT.DELIVERY_DATE}>={?Month_Start} AND {CLIENT.DELIVERY_DATE}<={?Month_End}...

That way the report shows the data from the whole year and the formulas use only the data from the last month.


Thanks a lot for your help these last days!


Edited by sanur13 - 27 Jun 2016 at 4:30am