Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-19
4
Medium Priority
?
718 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

715 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