Has anyone already recreated the base “Priority Dispatch” report as a BAQ or SQL stored procedure? And that would be willing to share with us? We are looking to have the information on this report in a nice excel consumable format and the base report exported to excel is unusable.
Please advise.
Just create a new Report Style and edit the RDL to be Excelable
Yes - I have found that I would rather use a reformatted “Excel Friendly” SSRS report than to re-create one in a BAQ because of the nature of all the considerations that the report already has built into it.
I suppose that is the way less onerous option. It’s still so much work though to do that when I know that even if I get it into a usable excel friendly format that my end users are just going to want to add some extra information or other filters and then and I’ll still be back at square one with having to re-engineer it from scratch.
I’m still hoping some poor soul has put the time into recreating the entire thing from scratch as a BAQ or stored procedure that is willing to share.
What you do is make a copy of the “stock” report style. Then delete everything so you’re at a white piece of paper. Then click Insert > Table Wizard. Select the dataset with the fields you want. It should be JCR65_ScheduledResources. Drag the fields you want into the Values box. Click Next. Make sure “Show subtotals and grand totals” is unchecked. Click Next. Click Finish. Now you have a basic table that will display all the columns that you can open in Excel and filter/sort as required.
From this point, you can still do a lot of the SSRS formatting things and filter/sort within the report as required. But the gist of this thing is to just create a simple table.