CRM Report question: how to set the maximum width of a column?

Hi,

I have a very weird problem with a subreport. On the server, the report looks okee. But from a cleint, the width of a column is larger than it should be (see the 2 print screens.

So, I've got a report with several subreports. In one of the subreports, the width of the column of a table is 2cm. When I view the report on the server, the column-width is 2 cm. If the text in the cells is too long, then the text is continued on the next line (as it should be). But, when I view the report on a client, the column-width is maximized, so the text in the cells of that column fits on 1 line. The actual width of the column is the larger than the 'supposedly' maximum width.

I thought that the width of a column is always the maximun width, but probably this is not the case. Anyone knows a solution?

Best regards,
Leonard

 
 Dossier-Intern.txt Dossier-Intern-Sub-Calculations.txt   Print Screen of Report- viewed from Server Print Screen of Report- viewed from Client
Leonard4pAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dennis AriesCEO @ Arkro ITCommented:
Your problem is that the text cannot be split (since it is a single word). Since the report is converted to a HTML-page, your column get's bigger.
I would suggest that you make sure that your type will always fit in your column (either by shortening the type or widening the column) since your description (omschrijving ) is the same as the type.
It is possible to use styles to fix the width of a column in HTML, but even if that would be possible to use in reports, it would just hide the remainder of the word instead of pushing it to the next line.
0
Leonard4pAuthor Commented:
hi djjaries,

thanks for your answer.

I'm afraid i have no control over the text of the type, so I can't demand that it''s a small text.

And about your claim that the text cannot be split. What about the report viewed from the server? If you look at the print screen of the report viewed from the server, you see that the text is split !

0
Dennis AriesCEO @ Arkro ITCommented:
The report on the server is rendered by a different engine than the report you view inside CRM. You can upload the report to the server instead of CRM and point to that of course (or show it in a custom IFrame). That might bypass your issue.
You have some control about the number of characters in the type. You can set a maximizum length to the CRM-field or just show the first X characters.
0
Leonard4pAuthor Commented:
Still don't understand why column width is getting larger, but I found a work around.

I've set the value property of the textbox to:

IIF( Len(Fields!Type.Value)>10, Left(Fields!Type.Value,12) & " " & Mid(Fields!Type.Value,13,12) & " " & Mid(Fields!Type.Value,26,12), Fields!Type.Value)


Regards, Leonard
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.