topic Detailed Report in Report Server

Detailed Report

diogolf — Fri, 18 Oct 2024 17:44:51 GMT

Hi all,

Please let me know if PBI could do an individual record report of a single record. Like an individual costumized file, where i could add data fields, decide position of them and export all to a paginated pdf.

It is possible ?

Kind Regards

Re: Detailed Report

hackcrr — Sat, 19 Oct 2024 05:25:25 GMT

Hi, diogolf

Use Power BI Report Builder .Connect to your data source (this can be the same data source you use in Power BI Desktop).

Design the Layout:

Add fields (data elements) from your dataset to the report.

You can position each field manually, allowing for complete customization of how the data is displayed.

Filter for a Single Record:

You can create a parameter that allows filtering down to a single record. For example, you could use a RecordID or some unique field that the user can input or select to filter the data for just that record.

Once the report is designed and filtered, you can export the report to PDF with the exact layout and details you specified.

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Detailed Report

diogolf — Sun, 20 Oct 2024 00:30:05 GMT

Hi, hackcrr

Thank you for your response

Just missing one detail. How to link from PBI to this report?

I have a table of records and showing record details by drill through in a new page. I'm wondering if it is possible to show a specific individual record by drill through selected filters. Like a custom URL, ex:

https://www.domain.com/recordpage/001
https://www.domain.com/recordpage/002

Last question, this information is displayed in PBI report like a page, or this represents another plattform?

Best Regards,

Re: Detailed Report

Anonymous — Mon, 28 Oct 2024 09:47:07 GMT

Hi,hackcrr .thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,diogolf .I am glad to help you.
If you want to use Power BI Report Builder to create paginated reports and apply URL filters to enable clicking a link to jump to the corresponding filtered record, you can refer to the following documentation about URL filters for paginated reports:
URL:
Report parameter concepts in Power BI paginated reports - Power BI | Microsoft Learn
URL parameters in paginated reports in Power BI - Power BI | Microsoft Learn

Using drill through in paginated reports is also a good option
URL:
Drillthrough reports in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
Drilldown action in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
Add a drillthrough action on a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.