Solved

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

Posted on 2010-08-19
4
716 Views
Last Modified: 2013-11-27
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
0
Comment
Question by:Leonard4p
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Dennis Aries
ID: 33475833
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
 

Author Comment

by:Leonard4p
ID: 33476529
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
 
LVL 18

Expert Comment

by:Dennis Aries
ID: 33476574
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
 

Accepted Solution

by:
Leonard4p earned 0 total points
ID: 33509790
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

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question