Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
RTF XDO_METADATA setup not working despite mirroring other setup that is working
Summary:
We have customized an RTF to where the results are broken out into different tabs. We used the same for each loop as the other tabs, but the new tab is putting all results in a single row instead of one row per record.
Content (please ensure you mask any confidential information):
Why is this happening? How do we fix it?
Version (include the version you are using, if applicable):
24C
Code Snippet (add any code snippets that support your topic, if applicable):
Putting all records on one row:
<xsl:for-each select=".//G_1"><xsl:if test="./REPORT_TYPE='G'"> | </xsl:if></xsl:for-each> |
|---|---|
<?TIN?> | |
<?VENDOR_NAME?> | |
<?NAME2?> | |
<?ADDRESS?> | |
<?CITY?> | |
<?STATE?> | |
<?ZIP?> | |
<?SUPPLIER_NUMBER?> | |
<?GOV6?> |
putting records in one record per row:
<xsl:for-each select=".//G_1"><xsl:if test="./REPORT_TYPE='N'"> | </xsl:if></xsl:for-each> |
|---|---|
<?TIN?> | |
<?VENDOR_NAME?> | |
<?NAME2?> | |
<?ADDRESS?> | |
<?CITY?> | |
<?STATE?> | |
<?ZIP?> | |
<?SUPPLIER_NUMBER?> | |
<?MISC7?> |
Best Answer
-
Go to Formulas→Name Manager the G_4 group is not defined.
Rgds,
Kevin
0
Answers
-
Just to clarify, this is an Excel layout, not an RTF, correct?
Rgds,
Kevin
0 -
@Kevin M-Oracle correct it is an excel layout.
0 -
If you can provide just the simplest layout and sanitized sample XML data no PI/CI.
We can take a look.
Rgds,
Kevin
0 -
@Kevin M-Oracle see attached. Should break on the G and N records. N works, but G for some reason does not.
0 -
I also need your simple Excel layout.
Thx,
Kevin
0 -
@Kevin M-Oracle attached.
0 -
In the name manager you have three groups for the first three tabs.
There is no group for the fourth tab: 1099GOV6.
Rgds,
Kevin
0 -
@Kevin M-Oracle is this not the group? XDO_GROUP_?XDOG4?
0 -
Yes that is the group, but it has to be defined in Excel's Name Manager as the other three are.
This is where you link it to a worksheet.
Rgds,
Kevin.
0