导出到Excel时，如何防止A列几乎完全隐藏在Report Services报表中? [英] How can I prevent column A from being almost completely hidden in a Report Services report when it is exported to Excel?

问题描述

我正在对旧版报表进行一些更改(阅读:不是由我或仍然在这里的任何人创建的)，其中一项要求是取消隐藏列A"

I am making some changes to a legacy report (read: not created by me or anyone still here), and one of the requirements is to "Unhide Column A"

是的，当我运行报表并将其导出到Excel时，A列几乎完全被遮盖了:

And yes, when I run the report and export it to Excel, column A is almost completely obscured:

当我展开它时，它不包含自己的数据.我不知道为什么以及为什么这种方式被大部分隐藏".

When I expand it, it contains no data of its own. Why and how it is being "mostly hidden" this way, I don't know.

但是它显然使用户感到困惑或烦恼，第一个可用列是"B"

But it apparently confuses or irritates the users that the first usable column is "B"

如何在不将工作表上的内容向右移动的情况下显示A列? IOW，我基本上想显示A列，但将所有数据向左移动(B列中的内容应在A列中，C列中的内容应在B列中，依此类推)

How can I get column A to display without moving the contents on the sheet to the right? IOW, I basically want to display column A but move all the data one row to the left (what's in Column B should be in Column A, what's in column C should be in column B, etc.)

这是扩展列A后的外观:

Here is how it looks after expanding column A:

这是他们希望的外观(手动调整工作表之后):

This is what they want it to look like (after a manual tweaking of the sheet):

推荐答案

您将不得不将报告中的徽标一直向左移动.导出到Excel会尝试尽可能匹配布局.如果没有很好地对齐，则图像和表格列之间的任何间隙或宽度不匹配都会在Excel中看起来很粗糙.如果您对图像的放置不太精确，则可以在整个位置合并单元格.

You are going to have to move the logo in the report all the way to the left. The export to Excel tries to match the layout as closely as it can. Any gaps, or mismatched widths between images and table columns will come out looking pretty rough in Excel if things aren't lined up perfectly. You can have merged cells all over the place if you aren't precise with image placement.

我总是尝试确保使用的图像在左上角，没有空白，并且Tablix或矩阵中的第一列与图像的宽度相同.有时，它最终是几列，它们都与图像的宽度匹配.只要他们排队，出口就应该看起来不错.

I always try to make sure the image I use is in the upper left corner, with no margin, and the first column in my tablix, or matrix, is the same width as the image. Sometimes it ends up being a few columns that all together match the width of the image. Just as long as they line up, the export should look pretty good.

使所有这些对齐可能会有些痛苦.使用设计器中显示的蓝色对齐指示器来帮助自己.有时我必须进入属性并手动调整宽度和高度.

Making these all align can be a bit of a pain. Use the blue alignment indicators that show in the designer to help yourself out. Some times I have to go into the properties and adjust widths and height manually.

如果不是图像，则报告中的其他内容需要对齐.

If it isn't the image then something else in the report needs alignment.

所有这些...或者只是以PDF格式提供给他们！！ ;)

All this... or just give it to them in a PDF!! ;)

这篇关于导出到Excel时，如何防止A列几乎完全隐藏在Report Services报表中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！