Traditional web-based reporting with SAS BI tools

Line breaks inside dataset

Reply
Occasional Contributor
Posts: 6

Line breaks inside dataset

The actual data inside a dataset I'm using in a report contains control code to insert line breaks at certain places. Using EG I can print out the data and the line breaks are preserved (also using EG to export other formats preserves the breaks). However, when I insert the data in the web report, the line breaks are ignored and the data is displayed as one continuous line. Is there any ways to keep these line breaks in the data?

Thanks,

Jeff
SAS Super FREQ
Posts: 383

Re: Line breaks inside dataset

Web Report Studio does not honor line breaks inserted by using control code. There is one workaround if you have 4.2 or later, but you would need to manipulate the data.

Specifically, if you replace your control code with </br>, and then turn on the "Display as hyperlink" feature for the data item in Information Map Studio, then WRS will honor the break.

Message was edited by: BIC_USER_3@SAS Message was edited by: BIC_USER_3@SAS
Occasional Contributor
Posts: 6

Re: Line breaks inside dataset

Thank you very much for the quick help! Seems to of solved my problem.
Occasional Contributor
Posts: 6

Re: Line breaks inside dataset

This does however lead to a follow-up question...

Using
works great and honors the line breaks in the report but the amount of data in an individual cell can be up to about 8,500 characters long. This makes the display of the data very odd when viewing a report (the column width for this variable is extremely large and is unable to be exported to a pdf). Is there any possible way to control this?

Thanks
Post a Question
Discussion Stats
  • 3 replies
  • 226 views
  • 0 likes
  • 2 in conversation