Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

huangapple go评论59阅读模式
英文:

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

问题

在分页报表表格中,是否有办法将一个独立的字段(位于具有多个列的行下方)放到自己的行中?

我正在尝试创建一个报告,用于显示帮助工单的各种信息,包括提交日期、主题、工单状态等字段。我希望将所有信息都显示在一个表格中,以便显示如下:

工单表格:

列A 列B 列C 列D
字段A 字段B 字段C 字段D
字段E 字段E的延续 字段E的延续 字段E的延续
字段 字段 字段 字段
字段E 字段E的延续 字段E的延续 字段E的延续

不幸的是,我无法找到一种方法来使工单评论拥有自己的行。它只会被分组在第一列中。基本上,我只想让最近的评论字段跨越整个表格的长度。

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

有没有办法让工单评论拥有自己的完整行?感谢!

我尝试将评论字段插入到第一列,期望它会自动延伸到整个表格的宽度,但它却被困在第一列的宽度中。我还尝试创建一个矩阵,但结果看起来与表格可视化效果相同。我还尝试创建另一个表格,但然后所有评论都显示在其余工单信息之后。我希望它的显示方式是:工单信息1,评论1,工单信息2,评论2,而不是:工单信息1,工单信息2,评论1,评论2。

英文:

Is there a way to give a singular field (that is below a row with multiple columns) its own row in a paginated report table?

I am trying to create a report that displays various information for help tickets including fields like the submission date, subject, ticket status, etc. I am trying to get all the info on one table so it is displayed like:

ticket table:

Column A Column B Column C Column D
field a field b field c field d
field e continuation of e continuation of e continuation of e
field field field field
field e continuation of e continuation of e continuation of e

Unfortunately I cannot figure out a way to give the ticket comment its own row. It just gets grouped in that first column. Basically I just want the recent comment field to stretch across the length of the table

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

Any ideas on how I can give the ticket comment its own full row?

Thanks!

I tried inserting the comment field in that first column expecting it to automatically go the width of the table but it get stuck in the width of the first column. I also tried creating a matrix, but the result appeared the same as the table visual. Also tried creating another table but then all the comments get displayed after the rest of the ticket info.
I want it to be like: ticket info 1 , comment 1, ticket info 2, comment 2
as opposed to: ticket info 1, ticket info 2, comment 1, comment 2

答案1

得分: 1

以下是翻译好的部分:

这很简单。

在报告中创建一个表格,并添加除了您的评论字段以外的所有字段。

测试报告,您应该获得每个数据集行的1行。现在基本操作已完成,右键单击数据行中的任何单元格(不是标题),然后选择“插入行/在组内 - 下方”。

现在您可以合并该行上的所有文本框,然后在其中选择您的评论字段。就是这样!

这是一个30秒的GIF,以展示它的操作方式。 (如果太小,请右键单击动画并选择“在新窗口中打开链接”)

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

英文:

This is quite simple.

Create a table in your report and add all the fields except your comment field.

Test the report and you should get 1 rows per row in the dataset. Now the basics are OK, right click on any cell from the data row (not the header) and choose "insert row / inside group - below."

Now you can merge all the textboxes on that row and then select your comments field in it. That should be it!

Here's a 30 second gif to show you it in action. (Right-click the animation and choose "open link in new window" if it's too small)

Create a new row with widths that differ from first row of table in Power BI SSRS paginated report builder

huangapple
  • 本文由 发表于 2023年5月11日 05:04:05
  • 转载请务必保留本文链接:https://go.coder-hub.com/76222543.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定