How to create a dynamic header with BIP 12.2.1.0 ? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create a dynamic header with BIP 12.2.1.0 ?

Received Response
12
Views
1
Comments

Summary

How to create a dynamic header with BIP 12.2.1.0 ?

Content

Hello everybody,

 

we would like to create an dynamic header for our BIP reports.  The header must presents the information of each of the parameters.  This is the easy part.  But we were told that if one of the parameters is null, we must free the space taken by the parameter.  We must not see any blank space between our parameters.  This is my biggest problem because when I'm using <?xdofx: if  MyCondition  then  PARAM end if?> it's leaving blank space.  Not only that, if I'm trying to write multiple conditions , some values are repeated to the wrong place.

 

The only solution I know that is working is to format my header in the dataset and use a single parameter into the template for the header.  But my client doesn't like that solution because they want to see each parameters individually inside the header.  And they also don't want to see blanks.  I know they would probably dislike using some sort of import solution where we could create multiple headers and import subreports.  I guess they want to see everything in only 1 template.

 

I would like to know if you have an idea on what I could do about it.  Here is an example of what they want :

 

<?TITLE?>

<?PARAM1?> <?PARAM2?>

<?PARAM3?> <?PARAM4?>

<?PARAM5?> <?PARAM6?>

 

If TITLE = 'Hello the world', PARAM1 = 'Abc' PARAM2 = 'efg' PARAM3 = 'hij' PARAM4 = 'klm' PARAM5 = 'nop' PARAM6 = 'qrs' Then

 

Hello the world

Abc efg

hij klm

nop qrs

 

If TITLE = 'Hello the world', PARAM1 = null PARAM2 = null PARAM3 = 'hij' PARAM4 = 'klm' PARAM5 = 'nop' PARAM6 = 'qrs' Then

 

Hello the world

hij klm

nop qrs

 

If TITLE = 'Hello the world', PARAM1 = null PARAM2 = null PARAM3 = null PARAM4 = null PARAM5 = 'nop' PARAM6 = 'qrs' Then

 

Hello the world

nop qrs

 

 

If TITLE = 'Hello the world', PARAM1 = null PARAM2 = null PARAM3 = 'hij' PARAM4 = 'klm' PARAM5 = null PARAM6 = 'qrs' Then

 

Hello the world

hij klm

qrs

 

So is it possible to do something like that using the FOP commands ?

 

I tried :

 

<?TITLE?>

<?xdofx: if PARAM1 != null then PARAM1 end if?> <?xdofx: if PARAM2 != null then PARAM2 end if?>

<?xdofx: if PARAM3 != null then PARAM3 end if?> <?xdofx: if PARAM4 != null then PARAM4 end if?>

<?xdofx: if PARAM5 != null then PARAM5 end if?> <?xdofx: if PARAM6 != null then PARAM6 end if?>

 

But it left spaces.

 

If I'm trying to imbricate conditions one inside the other, it doesn't look well.

 

<?TITLE?>

<?xdofx: if PARAM1 != null then PARAM1  else  if PARAM2 != null then PARAM2 end if   end if?>

...

 

I try to use the choose but I was never be able to make it work....

 

I've seen an example using <?dhtml:ShowHide:Hide?> but it doesn'"t work when I'm genarating a PDF.  It only works in HTML.

 

So I hope you can help, IM continuing to search meanwhile, thank you ofr your time !

Tagged:

Answers

  • persona4-77
    persona4-77 Rank 3 - Community Apprentice

    Hello,

    I was able to find the right way to use <?choose?> and it's working well.  The major problem is the fact that it's really complex to read.  It might not be the best solution.

    <?choose:?>

    <?when:PARAM1 !=’’ and PARAM2 != ’’ and PARAM3 !=‘’ and PARAM4 != ‘’?> <?PARAM1?>  <?PARAM2?> <?xdofx:chr(10)?><?PARAM3?> <?PARAM4?> <?end when?>

    <?otherwise:?> <?end otherwise?>

    <?end choose?>