web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) CRM 2013 Specify Forma...

Microsoft Dynamics CRM (Archived)

CRM 2013 Specify Format in SSRS

(0) Share

Report

Report

Posted on by Nirvana115

4,921

Hi all people,

I have one field in Forms with 5 multiLine like this :

In my report SSRS i want to show to same Format in TextBox (Fields!description.Value) as it is in the picture.

When i try in SSRS, he gives me one line like this: Line 1 line 2 info 3 info 4, but me i want this :

Line 1

line 2

info 3

info 4

It's possible to specify this textbox with HTML in SSRS.

If some one have solution.

Thanks For all Member

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Nirvana115 4,921 on at

Like (0)

Report

Hi Guido, Thanks for your replay.

I am using table, but when i click right with mousse button i see Textbox Properties like in image :

Thanks

Was this reply helpful? Yes No
Nizar JLASSI 2 on at

Like (0)

Report

It' work for me :

I took an account and I modified his comment (Description) like this :

When I used transact sql to query description field I got this one :

I copied the description cell content and I pasted it in a notepad++ window and I got this :

We can see CR LF in the end of each line.

And when I use SSRS to show description I got this :

As you see, I used Matrix, Table and TextBox components and all of them are showing data correctly.

Nizar JLASSI

Dymamics CRM Trainer and Senior Consultant
Email : n.jlassi@gmail.com

Blog : http://mscrm-njl.blogspot.fr/

Was this reply helpful? Yes No
Nirvana115 4,921 on at

Like (0)

Report

Thanks Nizar for your replay,

I'll try, but i use FetchXml in SSRS.

Thanks for all member.

Was this reply helpful? Yes No
Verified answer

Nirvana115 4,921 on at

Like (0)

Report

Hi for all,

'Carriage Return'

This a solution i am using to resolve the probleme :

=Replace(Fields!YourField.Value, VbCrLf, CHAR(10) & CHAR(13))

Or:

=Replace(Replace(Fields!YourField.Value, CHAR(10), VbLf), CHAR(13), VbCr)

OR : =Replace(Fields!Header01.Value, Chr(13) ,Chr(10))

Thanks For member, and for help.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans