Display List on a Layout with charts

aguest · August 21, 2015

Hi,

I'm creating a summary dashboard that is displayed when a user logs into the system. The intention is not to be able to print it but to have a visual representation of the data.

I've created the charts, however, I want to be able to display a list of top 10 students in a table format. It will only show the name of the student and the number of incidents raised. Is there an easy way of doing this?

TIA

mr_vodka · August 21, 2015

Can you provide more details? You can make your table format using various tools including using a portal, web viewer, or even just a variable on the layout but you havent provided enough details on your setup for us to help in a further direction I'm afraid.

aguest · August 24, 2015

Hi,

I've attached a screen print of the charts that are already on layout. The layout is based on the detail table. It links to the student table to get the student name. I would like to add a table to this layout which gives the name of the student and the number of incidents raised (but only show top 10) and this is where I'm struggling.

I've tried a portal but it give me one row, with the first student name and then a total of all the incidents raised rather than what is just for that student.

Hope that's provided a bit more information.

TIA

mr_vodka · August 24, 2015

Sorry but this was not what I meant by details. :-) Can you post your table occurrence graph or a copy of the file? You can use ExecuteSQL to give you context independent data considering that you are trying to grab students and I am unsure of whether or not your details list is currently sorted or if indeed your chart can be dervied from your current found set. Again we need more details.

aguest · August 25, 2015

Spologies, so some more detail,

I've used ExecuteSQL to create a summary table of the data that hold just the student name and number of incidents they raised and loaded this into a table I've call VL_VictimSummary. I've related to my bullydetails table as per the graph attached.

The following html code has been used to display the information on the layout. The issue now is that no data displays. When I base the layour on the VL_VictimSummary table though it does appear but with a new wv panel for each student.

Code:

"data:text/html,
<html>
<body>

<table border = 1 style=\"width:100%\">
   <tr>
    <th>Student Name</th>
     <th>Total Incidents</th>
   </tr>
<tr>
    <td>"& bullying_VICTIMSUMMARY::Victim &"</td>
     <td>"& bullying_VICTIMSUMMARY::TotalIncidents &"</td>
   </tr>
</table>

</body>
</html>
"

dwdata · August 25, 2015

If I am following you correctly, you are able to compile the records you need, but you are are having a problem producing the HTML OUTPUT to display the list correctly in a different table. Correct me, if I am wrong.

Here's how I would handle this:

In the VL_VICTIMSUMMARY table, define a new field:

html_line_code - (Calculation, Text Result) = "<tr><td>" & VL_VICTIMSUMMARY::Victim & "</td><td>" & VL_VICTIMSUMMARY::TotalIncidents & "</td></tr>"

Now change you relationship in your DB to this:

BULLYINGDETAILS::pk X VL_VICTIMSUMMARY::Victim (Sort By Victim)

The above relationship uses the X operator which should match every record in that table

Now in the BULLYINGDETAILS WEB VIEWER display the html code like the the following:

"data:text/html,
<html>
<body>

<table border = 1 style=\"width:100%\">
   <tr>
    <th>Student Name</th>
     <th>Total Incidents</th>
   </tr>" &
  
   List (VL_VICTIMSUMMARY::html_line_code)

& "</table>

</body>
</html>

Let me know if this works for you. If you run into issues or have any questions, post them.

aguest · September 3, 2015

Thank you. That has worked a treat.

Sign In

Display List on a Layout with charts

Recommended Posts

aguest

mr_vodka

aguest

mr_vodka

aguest

dwdata

aguest

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information