Solved

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

Posted on 2010-08-19
4
709 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
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with Query not working in client's PC 1 35
Anyway to make "All" the default in the dropdown? 6 34
Angular JS Route 3 52
SSL https .net web site force redirect 3 36
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now