Can we have the ability to adjust the alignment of the Header of the first Column of a report so tha

Tomiwa Adetola

Currently we can't change the alignment of the Header of the first column in a typical Board reports. See attached screenshot for illustration.

Alexander Kappes

Dear Tomiwa Adetola,

 

unfortunately it is not possible to align the header for the first column.

 

As workaround you can insert a Label with the wished text and aligned like you want over the first column header.

 

Inside your DataView you just insert a space into the layout Title and it should work directly.

 

Hope it helps

 

regards

 

Alexander Kappes

Tomiwa Adetola

Thank you for your last reply.

However, I am faced with another problem,

I am designing an Aged Debt report which will require users to select dates and based on the new date, recalculate the Ageing segmentation using the Transaction DueDate and the selected Dates. The challenge is all these objects are Entities (Dimensions in the Data) . I thought I could write a procedure then drop a Button on the screen for the users to recalculate anytime they change the date.

Alexander Kappes

Dear Tomiwa Adetola,

 

thanks again for your request.

 

For general Master Data (Entities) can´t be calculated using Procedures with DataFlows, or DataEntry on Screens.

 

You can change Entities using ATO and ATO Pager inside your screen, more information find here About ATO .

 

Otherwise Entities can only be changed / added using DataReaders.

 

Inside Procedures you are able to select your Entities with some steps well known to the procedure designer.

 

Hope it helps

 

regards

 

Alexander Kappes

Tomiwa Adetola

Thanks once again. Maybe I should present the scenario better. 

 

I want to calculate a block  (column) which depends on the difference in days between a selected date on the screen, and the duedate cube loaded through the data reader. Using an algorithm like if((DateA-DateB)<1, CubeA, 0) The issue I have is DateA is an Entity selected with a selection box, and DateB is a date Cube. Currently when I use these dates, the algorithm does not return any value, But if I replace the dates with a Date function like Today(), it works?. How do  I go about using selected dates in the calculation?

 

Thanks 

Alexander Kappes

Dear Tomiwa Adetola,

 

in short you want to calculate the number in days between two date fields.

 

The main problem you achieve. The content of the Day or Date Entities in general in BOARD are saved as text.

 

To get the wished behavior you have to perform some transformations.

 

Attached some screenshots which illustrate a possible solution using Nexel.

 

 

 

 

 

All informations about Nexel you can find here: Nexel Complete Formulae library and here: Nexel 

 

Hope it helps

 

regards

 

Alexander Kappes

Tomiwa Adetola

Yes it does fast track the journey. 

Still on it tho. 

I will keep you posted as I progress with it and get stuck again.

Thanks once again