英文:
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的延续 |
不幸的是,我无法找到一种方法来使工单评论拥有自己的行。它只会被分组在第一列中。基本上,我只想让最近的评论字段跨越整个表格的长度。
有没有办法让工单评论拥有自己的完整行?感谢!
我尝试将评论字段插入到第一列,期望它会自动延伸到整个表格的宽度,但它却被困在第一列的宽度中。我还尝试创建一个矩阵,但结果看起来与表格可视化效果相同。我还尝试创建另一个表格,但然后所有评论都显示在其余工单信息之后。我希望它的显示方式是:工单信息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
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,以展示它的操作方式。 (如果太小,请右键单击动画并选择“在新窗口中打开链接”)
英文:
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)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论