Symantec Management Platform (Notification Server)

 View Only
  • 1.  Report Views Types

    Posted Feb 09, 2012 11:02 AM

    Hi,

    I have been searching with no luck to find the syntax of adding a value to a report when using the templated text view type. Can anyone let me know what this syntax is? Any Examples on how to use it?

    Best Regards,

    Rubén



  • 2.  RE: Report Views Types

    Posted Mar 23, 2012 06:54 AM

    Runsann,

    Did you get an answer to this?

    Kindest regards,

    QuietLeni



  • 3.  RE: Report Views Types
    Best Answer

    Posted Mar 23, 2012 01:41 PM

    Ruben,

    I have been working upon researching this - the documentation is a bit rubbish.

    As far as I have found, the format of the templated text seems to be purely HTML.

    If I have a Data Source such as:

    SELECT Name, Zip

    FROM Locations

    Then I can do something like this in the Templated Text field:

    <p>%Name:name%:&nbsp;<font color="red">I want to buy some cheese!</font>:&nbsp;<font color="green">%Zip:name%</font></p>
    <p>Location:&nbsp;<font color="red">%Name:value%</font>&nbsp;Zip:&nbsp;<font color="green">%Zip:value%</font></p>

    And I will get this:

    Name: I want to buy some cheese! Zip

    Location: top Level Location Zip: 123456

    Except, you are going to have to check this yourself, as the renderer of this message is removing the colours! sad

     

    My main issue, though, is how do you get the repetition of the lines at this point?

    However, I seem to remember in the NS 6.0 Report Builder, that this functionality was available, but only for reports of a fixed size. I.e. you can format the report with 4 lines if you give 4 lines of formatting.



  • 4.  RE: Report Views Types

    Posted Mar 23, 2012 03:00 PM

    Thanks QuietLeni!

    The :value part I didn't understand, now is clear from viewing your example. Now my change is learning HTML! wink

    For what I read this view only works for the first row returned by the query. Like you said maybe we have to create "N" lines of formatting for each row the query return!

    In my case I want to use this view for a query that return only one line (details of an asset by serial number).

    Have you tried to save as..  the report? I use the options (spreadsheet, HTML and XML) but the formatting is lost, the file is saved with the "grid view".

    Thank you again and best regards,

    Rubén



  • 5.  RE: Report Views Types

    Posted Mar 26, 2012 05:26 AM

    Ruben,

    Glad I was able to help you out. It took a little time to check it out, as I was researching this to help someone else!

    I just think that the Template Text method is a little useless... ...but I just had an idea!

    Kindest regards,

     

    QuietLeni



  • 6.  RE: Report Views Types

    Posted Mar 26, 2012 06:08 AM

    Rubensann,

    Oh yes and the "Saved As..." ALWAYS outputs in a Grid View. It would be nice if it did a picture, or as the formatted HTML, but that might be asking for too much!

    Kindest regards,

    QuietLeni