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