How do we add Name of the Page with a text of Report_Name_sysdate(), here is sysdate should be in the format of 20131204 format.
How do we add a conditional format to column which has duplicates, like if there are duplicates then they should highlighted as red.
For Ex: Name(Column Name)
Rob
Matt
Rob
i want Rob to be highlighted as Red, what would be the condition given in conditional formatting?
Hey there v2k4u,
What do you mean by name of page? If you mean you want to add a title, just add a singleton with the desired value to the header text. If you want to add dynamic text to the name property of a page (So it becomes the name of an Excel tab, for instance), I don't think you can.
Regarding your second question: I assume you're working over relational. This very much depends on the way your report is set up, but generally what you want to do is to style the column based on the result of a count(distinct) function on it, where it is bigger than 1.
Hi Nimrod,
In regards to the first question when i said to add the Name to a Page, it is supposed to added as a dynamic text so that it becomes the name of the Excel, i was able to add the Report_Name but wanted to know if we can also insert the Date in it?
In regards to the second question, yes i am working over relational model and it is basically a Employee number which is repeated multiple times and i wanted to highlight the repeated number in red.
Thanks for your reply....
try this
In take boolean variable and add following condition
count([Emp_ID]) >=2
then for yes value set foreground color for name field to red