tablix

4 Topics

Technical Issue - SSRS Power BI PDF export triggers Acrobat 110/117 errors on large tablix reports
SSRS Report / Power BI / PDF Export Issue (Not sure if it’s VS’s report designer or Power BI that’s causing this so I’m putting it here): Using VS 2026, Microsoft Reporting Services Projects 4.0.0, Power BI Report Server 1.26.9682.1442 (May 2026) I have this SSRS report (designed with Microsoft Reporting Services Projects 4.0.0) with a tablix that has nested row groups published on a Power BI server. When the report gets over about 2500 records (~220 pages maybe) the report still generates. But when I save as PDF from the report viewer, it does produce a fine PDF but when any changes are saved in it from Adobe Acrobat, we’ll either get error code 110 “Unrecognized object name” or 117 “Non-hex character in a hex string”. I found it’s not because of specific records because when I made it retrieve 2500 records it worked, when I made it retrieve 4000 records it produced a corrupt PDF, but when I had the report’s SQL query skip the first 2500 records and get only those 1500 records that apparently corrupted the PDF, it produced a noncorrupt PDF. This has been confirmed with other records as well. I’ve tried every combo of row group, cell, and tablix settings that were half reasonable to try. I’ve added in and stripped out accessibility features. I fixed all warnings given when deploying the report. It’s always the same thing, it’s fine until over about 2500 records. We need the PDF to be editable after generation; I’ve exhausted every option. If anyone knows how to fix this that’d be great.
nelsonj
7 hours ago Place Report Server
2Views
0likes
1Comment
Power BI Paginated Report with two layers of column header- Freeze both column headers
Hi, I have created Power BI paginated report with Matrix. The matrix has two layers of column headers as shown in picture below. I was able to freeze only first column header when scrolling. Second column headers disappears when scrolling. I tried all the options with taxblix property, Fixed data. Nothing seems to be working. Can you please help me? This is how it looks when the matrix expands This is how it looks like after i scroll down
alpha2025
2 years ago Place Report Server
664Views
0likes
1Comment
Ordering a Table from different Datasets
Hello, This has me quite stumped on how to make this possible, but I am going to do my very best at explaining what I am trying to achieve. Dataset P6: Name Status Henry P6: Last Update Dataset P5: Name Status Jill P5: Almost Last Update Jack P5: Almost Last Update Dataset P4: Name Status Dataset P3: Name Status Peter P3: Almost First Update Andrew P3: Almost First Update Casey P3: Almost First Update Dataset P2: Name Status Ryan P2: Near First Update GOAL: Create a table that counts all the rows and puts the Name's in order based off Status without showing the status, and adding the row number before each name, while also adding the word UPDATE after each name. It should also check all datasets, and if blank move on to the next dataset. 1. Henry UPDATE 2. Jill UPDATE 3. Jack UPDATE 4. Peter UPDATE 5. Andrew UPDATE 6. Casey UPDATE 7. Ryan UPDATE Any insight on how to accomplish in the easiest and best manner will be greatly appreciated.
Solved
Anonymous
2 years ago Place Report Server
913Views
0likes
3Comments
Extra colum and row for a tablix in Paginated Report when exporting into excel file.
We have noticed that when we export the result of the paginated report as an Excel file, the report's tablix contains an extra column (almost hidden) and also an extra row at the right and bottom margins. For instance, consider this basic tablix: Of course, this is just an example. We have more complex reports with multiple tablixes that are formatted with the same column size and alignment. Nevertheless, we would like to know if this can be done (per client requirements).
Anonymous
2 years ago Place Report Server
319Views
0likes
0Comments