I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report to our Sage 100c Advanced v2019.2 Sales Order module - Custom Reports menu. When I run the report, it works great for me. I can scroll left and right for the 50" wide x 8.5" length I configured for this report to fit all 20 columns/sub-reports.
However, when I went to show one of our Sales members how to run it, it only previews in 8.5" x 11" layout. So she can only see 4 1/2 columns. She doesn't get to scroll right to see columns 5-20 like I can.
The Page Setup in the main Crystal report is set to "No Printer" and Custom size = 50" wide by 8.5 height and Landscape selected.
I'm wondering if the difference is that I have the Crystal Writer installed and they only have the viewer from the standard Sage 100 workstation setup. But I don't want to install Crystal Writer on each of the Sales staff's laptops for security reasons and I think I shouldn't have to.
Any ideas as to what is causing this and how to configure it to show all 20 columns and accept the 50" width?
Side note: I used Knowledge Sync/Sage Alerts and Workflow to try and automatically email this report each day and with .rpt set as the output type, the email never triggers, but for a brief second appears in the Attachment directory of KS. If I set the output type to .pdf, I get an email but the layout is 8.5" x 11" and don't see the entire 20 column report.
Any help would be appreciated.