I have search around but couldn't find anything relating to my query..
I want to create a report which is just a line by line listing of various variable - like an Excel list essentially.
In my data I have 4 'types' of data. I need to have each of the 4 types as a separate page(s) with a text box header for each type.
I set up the listing a straight table with a filter in the expression which works (although I need to find a way to hide the 'calculated' column)
My problem is, each of the 4 pages needs to have a header row with dynamic variables, for example a name specific to that 'type',and I need to apply the same filtering to the textbox as I have the straight table.
So, to cut a long story short, a) can I hide a column in a straight table and b) how can I apply a filter to a dynamic text box?
yes, you can hid columns in a straight table and there are a few differnt methods. You can set up your dimension and or expressions to be conditional - they will only show when the condition is met - is is usually accomplished by the user selecting something, having a variable set and then the condtion tests the variable and only shows when the condition is true - the same can be done at the column level on the presentation tab
The table I am creating could be a simple table box (as I just trying to replicate an Excel type listing) but I used a straight table in order to add an expression so I could filter the table and only show relevant rows.
The thing is, I dont really want to show the expression field! I can probably work around but ideally I would just like to hide the 'expression' column.
P Think green - please do not print this email unless you really need to
This email, and all related attachments, is strictly confidential and intended solely for the person or organisation to whom it is addressed. If you have received this information in error, please notify us as soon as possible and delete the email. If you are not the intended recipient, you must not copy, distribute or take any action in reference to it. Any such action may be unlawful.
Jelf Insurance Brokers Ltd* (Reg No. 0837227), Jelf Wellbeing Ltd* (Reg No. 2647586), Jelf Financial Planning Ltd* (Reg No. 3072281) and Jelf Commercial Finance Ltd (Reg No. 4333281) are part of Jelf Group plc (Reg No. 2975376) and are all registered in England and Wales at Hillside Court, Bowling Hill, Chipping Sodbury, BS37 6JX. *Authorised and regulated by the Financial Conduct Authority (FCA). Not all products and services offered are regulated by the FCA.