Wonder if you can help me. I am using conditional formatting to hide a column, this works fine.
But when i upload the RTF template to BI Publisher and output the report as XML the column still shows up. Is there a way to conditionally hide it in the XML aswell?
If so could you point me in the the right direction,
Thank you for you Email,
I guess that RTF wouldnt change it, been looking into it this morning. but thanks for the clarification
do you know the best method to use? I want the column to be accessible by the report because it contains data that is used to determine what data is actually shown in the report and depending on what is in the columns determines what data the user sees.
I just dont want to show the column in the XML output.... if that makes sense.
Edited by: 951250 on Aug 7, 2012 5:24 AM
XML is not just one of output formats, it's a source data for the report. The data cannot affect report, unless they are in the XML. Pleae, give a simple example of what you are trying to achieve to see how it can be done.
Ok here is what i want to do...
the back end database has been setup to display 3 different tables a, b and c... each table has a user associated with it.
when user 1 is called table a is shown, when user 2 is called table b is shown and so on. The Tables that are not shown will be Null.
all 3 users will have different data shown to them, columns will be hidden, column names will be different etc... I want this done all from one report, and output the XML with the corresponding columns hidden and also column headers will be different depending on which user runs the report.
You can substitute different tables in the data model SQL depending on the user. You need, however, use some generic column names in the SQL, like Column1, Column2, ... etc., so that you could build your template. To display titles for those columns you can again use user as parameter, but this time on the template level.
Ok i understand this, but by going back to the template level when i output this in XML i am going to have the same issue as i originally had? the hidden columns in the template will show because XML is taken directly from the data model and is not rendered via the template....
No - the columns are not hidden, they are just not in the XML. Under the generic names Column1, Column2, ... the XML brings the data only for the current user. On the template, however, you will need to provide the correct column names, if they depend on user.