Solved

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

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

707 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

10 Experts available now in Live!

Get 1:1 Help Now