Hi Ashish, It seems to be the error exists within the Query itself. 1. Please check the query precisely and if you had used any LOV's and Parameters find out are they properly invoke the parameters created because i have faced this issue and after precise diagnosis, resolved this issue. 2. One more cause is, if the query…

Can you send the Screenshot of the data sets with join condition along with query for the main data set ? So that can analyse the solution.

Hi, If you need to edit the report file, Navigate to this path " ${oracle.home}/xdo/repository" and do the same as above mentioned process

Hi, While you are creating the list of values, create 3 values input as you are required ie.., it's fine to choose SQL Query for parameters.By using Query builder or using direct query for retrieving the values from the data sets.Then Create a parameter and invoke the corresponding list of value which was created…

Hi, Once you built the data model with data sets, it generates sample.xml file.As it' recommended to backup this xml file for the future purpose the one which you are requesting now... In order to edit this xml file, you should have NPP installed on your machine.Once you have installed it, just make a context click over…

Hi Ashish, As of my Analysis this is the error occurring only in this version.In order to resolve this issue,just go through the below solutions: > Logout and restart the BI Server an Login again > Check the server log file if there is any error details resides or not. > Validate the .xdo file whether it's rendering…

Hi, As per your requirement it's intuitively possible to connect across different data sources in this version.For this, you have to do that select one source as parent data set (G1) and later select secondary data set (G2) and provide join Condition as necessary between both data sets.Now create sample.xml and validate it…

Hi, If you are using RTF template then please set the properties of columns and apply the same for complete table and columns would make output. There is an option to fit text and wrap text for an cell/column. Usually, MS Excel is having the capability of auto adjustment but not adobe. Regards Pavan kumar

Hi, Change the default settings here. Step-1: Step-2: Step-3: Now you can perform Export >> .csv for every time Hope this helps you Regards Pavan kumar

Hi, As xdofx is the extended SQL function the above syntax was true.So as of SQL script from dual it's giving proper result below <span class="kwd" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #101094;">select</span><span class="pln" style="font-style: inherit;…

Hi, Try using 'IF END IF' condition

Hi, In the Bursting Query, Add this parameter to generate output type in 'xlsx' format. >> select --------- --------- 'xlsx' OUTPUT_FORMAT, --------- --------- --------- from <table name>

Can you try this.... 1. Add @section in for-each tag. Example: <?for-each@section:G_HEADER?> 2. Enable below check box in Table properties. 'Repeat as header row at the top of each page'

Hi, If you have fixed logo or signature to print in RTF template, then perform below steps 1) Copy file in .gif format to $OA_MEDIA path at Application Server 2) Insert picture in RTF template and add below text in Web Tab url:{'${OA_MEDIA}/MAB_NEW.gif'} and If you want to print the fixed data in header for each sheet…

Hi, Add a form field for the first column in the table and you just add below code in to form field help text. <?if@row:position:() mod 3=0?> <xsl:attribute name="background-color" xdofo:ctx="in context">lightgray</xsl:attribute> <?end if?> Regards, Pavan

Hi, As you mentioned : The Actual Distance of lease 8373 has been suppressed, as it is 28250 (same as the one above), but ideally we would like it to only suppress the values for each Lease... does that make sense? If there is a explicit actual distance covered in the data model (XML data),Then it would be possible or else…

Hi, Need to get some more understanding on below... 1.Do you mean that to suppress the lease distance explicitly ? 2.What are the values of actual distance before suppressing for each of the Lease distance.It means is there a list of actual distances for each Lease ? If my understanding was correct ' Please have a try this…

Hi, You can use the below example: If your form field is <?Status?> then change the form field <?STATUS?> to <?STATUS[not(.=preceding::STATUS)]?> Regards Pavan

Hi, Because BI Publisher has extended set of SQL and XSL functions in RTF Templates. Whereas we cannot not use mix them within one expression as suggested by the oracle team. As you mentioned in the first expression with AND Operand is belongs to SQL and whereas you are using it in XSL expression. It's one of the primary…

Hi, It seems to be issue with installation setup file for template builder for word.Uninstall it and install it again.Next install the correct TBSetup64 setup file which will get enable to you login and upload the sample .xml file for the BI Server. Regards Pavan kumar