Using MS Access we have created really pretty publication ready reports that we then export with specific filenames and send to external customers. We are being told not to use MS Access and we're looking for an alternative. We're looking into Power BI, Rmarkdown, and SAS Visual Analytics. We need a tool that can do the following: enable us to create queries from multiple tables and use multiple data sources to populate the report; export dynamic paginated reports with assigned filenames. If you have experience with MS Access you know what I'm looking for. We were using vba to customize our reports. Everyone we go to recommends Tableau - but Tableau isn't really designed to make reports to be exported to pdf en masse. We often need to create 50 or 100 reports. We do have some python code that can export pdfs from Tableau, but it's not ideal, and i'm not sure how that would work if we want to assign different information on different pages. Feels like we're forcing Tableau to do something it's not designed to do. Please ask me any questions if this needs clarification. Any help is much appreciated! thansk matt
... View more
