SSRS Reports - Alternative Editor

Hey!

Is there an alternative editor we can use that isnt Microsoft Report Builder? Its like stepping back into 1995 to make reports… I use Dev Express outside of Epicor and reports can be set up in minutes but ive been on this all day without a successful result…

So
I have a BAQ that returns 350 rows of active jobs and those jobs are shared between 15 companies. Instead of sending 350 separate emails (1 of each report page), i need to send only 15 emails, 1 to each company with the print of each page(s) per company.

In my report i have added a ‘tablix’… and grouped it by Company, by JobNo, by a combination of them both.

In my Report Style i have added a break on the Company & Job number columns…

My results are 1 email per page but currently if a company has more than 1 page, they only get the first report page and others are skipped… So for example if CompA has 7 jobs, i need 1 pdf with 7 pages each showing the info per job.

Do i need to group the BAQ?
Is there anything special i need to do with the tablix grouping?
Is there another tool i can use instead of MSRB that is more intuitive?

Thanks

image

You can use this as an alternative to the Report Builder. But there is a lot of overlap in the feel of the two.

If you have the Advanced Print feature (the one with Break/Routing), you could make a single report that would normally printout all the pages (regardless of company), and then add a Break/Routing by company. The Break/Routing takes a single report output and breaks it into multiple reports based on the field(s) of your choice.

If you don’t have that, a bit of a hack that works is to make a single BAQ report, grouping on the company, and make individual Report Styles. You can then have the RDL determine which style was run and use that as a filter to hide the data that isn’t for that company (via the selected Report Style).

We use Visual Studio for SSRS reports, it’s MUCH better than Report Builder.