Hello, if you want a random value, you can use TO_CHAR(dbms_random.value(1,999999),'999999'); The best would be to use a sequence, but I understand you can't modify the tables.

In my case, it's top of the characters that do not appears when genarating a PDF. If you look at the picture you can noptice that the "G" is not complete and the 2 "f" are also incomplete. In the template, it appears fine. In the RTF format the letters are all complete.

I can not upload the template here because it is containing private information. But I can do a similar template for you to view.

Can't we upload files in the forum ?

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?>…

I finally got a solution. It seems that adding tables with for my newest datasets will affect the display of hidden chracters. They do not appears now.

We had similar problems with reports from different environments. 1) Be sure tu upload the data sources into the right environment. Look for the right directory. 2) Be sure your datasource confiugration is pointing on the right database schema. 3) Look that each dataset points on the right environment. 4) Make sure your…

Are you sure you are using the right user with the right roles ? I had a similar problems after merging from 11g to 12c. The role plus the security made impossible to me to reach the analytics page from my old url. For me it gave error 500. I had to log in an other account prior to be enable to access the target page,…

Ok, it seems I found a solution, but I do not understand why it's doing this. I my Data Set I had a field that was a VARCHAR2 pour is in fact a numeric value. When I wrote the query, it was, BI Publisher selected a double type for it. But, in my examples, this field might be null and each of the example I used were null.…

Ok, thank you !