I have one table in my dashboard which I am using in my mashup page.
Table in App:
Customer ID
Customer Name
Customer Address
Mobile
E-mail
Total ( Count of customers)
In my mashup page, I want to display few columns of it as below:
Customer ID
Customer Name
Mobile
Is it possible to achieve this because in mashp page it is using object ID of table which has all the columns but out of this I want to display only few.
in html report edit template, extend the object id and select the columns you only want to show, you need to enclose them in <table> tag with <tr> and <td> as in the following screenshot.
you can put it in a sperate sheet and choose from sheet properties, in the general tab:
show sheet to : conditional.
in the condition value create a variable in your load statement and you can assign it to zero if you don't want to show the sheet, or 1 if you want to show it.
