char(13) is carriage return and char(10) is line feed. Different text editors/viewers will interpret it differently.
Use replace function to get all data in 1 line.
replace(replace(replace(column_name,char(13),’ ‘),char(10),’ ‘), char(9), ‘ ‘)
when copying data which have char(13), char(10) in it to text editor/excel- we notice data showing up in different rows. For this scenario we replace it by ‘ ‘ to get in 1 row.
SQL Carriage Returns or Tabs in SQL Server strings
Char(10) – New Line / Line Break
Char(13) – Carriage Return
Char(9) – Tab
Had a situation where I need to develop a detail report for a dashboard based on the prompts selected in that dashboard.
Dashboard had multiple summary lists/crosstabs/charts
below are high level steps.
1. develop a detail list report based on the same prompts.
2. At master report
- create a singleton (on the dashboard where you want to see the url)and say you assigned it to query – q_detail.
- Create a data item say “Detail data” and with value “click for detail data”
- now add this data item to the singleton you created.
- select the data item in the singletom and select drill-Through definitions.
- select required report and other options. At parameters click on edit sign and use
- “Pass parameter value” and select associated prompt name.
- click ok.
now when you run the summary report you should see a link “click for detail data”