15 Replies Latest reply on Sep 13, 2013 8:55 AM by rob.hock

    Unable to get character return in custom report

    dmcmichael

      I am using a custom SQL report, but am unable to get character returns to show in the web browser's reporting screen. The weird thing is when I preview/execute SQL query from report write, the character returns occur making the formatting look correct. Any suggestions on why this is occurring? Could there be a bug? I am using CHAR(13) to allow the line break.

       

      Select(Select 'F - ' + CAST ((

      Select All AVG(ResponseTime.Availability)

      FROM Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

      WHERE( DateTime BETWEEN (Select DATEADD(DD,DATEDIFF(dd,0,GETDATE()),-7)) AND GETDATE() )AND

      (Nodes.Report = 'F Store')

      )AS varchar(15)) + '%' + CHAR(13) + 'M Store Availability - ' + CAST((

      SELECT  All AVG(ResponseTime.Availability)

      FROM Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

      WHERE( DateTime BETWEEN (Select DATEADD(DD,DATEDIFF(dd,0,GETDATE()),-7)) AND GETDATE() )AND

      (Nodes.Report = 'M Store')

      )AS varchar(15)) + '%' + CHAR(13) + 'Corp LAN Availability - ' + CAST((

      SELECT  All AVG(ResponseTime.Availability)

      FROM Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

      WHERE( DateTime BETWEEN (Select DATEADD(DD,DATEDIFF(dd,0,GETDATE()),-7)) AND GETDATE() )AND

      (Nodes.Report = 'Office LAN')

      )AS varchar(15)) + '%' + CHAR(13) + 'Corp WLAN Availability - ' + CAST((

      SELECT  All AVG(ResponseTime.Availability)

      FROM Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

      WHERE( DateTime BETWEEN (Select DATEADD(DD,DATEDIFF(dd,0,GETDATE()),-7)) AND GETDATE() )AND

      (Nodes.Report = 'Office WLAN')

      )AS varchar(15)) + '%' + CHAR(13) + 'Internet Availability - ' + CAST((

      SELECT  All AVG(ResponseTime.Availability)

      FROM Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

      WHERE( DateTime BETWEEN (Select DATEADD(DD,DATEDIFF(dd,0,GETDATE()),-7)) AND GETDATE() )AND

      (Nodes.Report = 'Internet')

      )AS varchar(15)) + '%')AS Availability_Average

       

      View from Report Writer's Preview Screen:

      Web Browser's View: