I recently presented to a Dynamics GP user group on SSRS. It was a very interactive session with lots of questions. (Which was great. I hate when people just sit and nod.) One particular discussion was about the merits of delivering data in Excel vs. PDF. Some folks thought PDFs were more secure because people couldn’t manipulate the data as they can with Excel. Others said their users wanted data in Excel and, therefore, they got it in Excel.
From my perspective, there’s no difference. Why? Because any well-formatted PDF can be turned into Excel in about two minutes using Adobe’s own tool.
For example, let’s take the PDF below. It was created by SSRS over the Microsoft AdventureWorks database.
Can I turn this PDF into an Excel document? Well, if I cut and paste; I get strange results. But with Adobe’s Export PDF service, which they push right in Adobe Reader, I can covert from PDF to Excel (or Word or other formats) for about $25 a year.
When in Adobe, click Tools. You’ll see various options, including Export PDF. Assuming you’ve signed in and have a subscription, simply choose Excel as your desired format and then click Convert.
Abode quickly returns a “Completed” message with a link to download the file.
When you open the file in Excel, you get this:
It’s not perfect, but it’s pretty good.
There may be ways to lock PDFs. But that functionality isn’t part of the PDF creation process in either Crystal or SSRS. So that wouldn’t work either.
My point: Data honesty in your organization must be a function of people and process, not technology. Whatever format you choose, once data is released to your users you lose control of it. Instead, any number you count on must be verifiable back to or produced by a standard reporting software—and not generated from Excel or a manual process. This isn’t an easy thing to do. But you may have no option.
How does your company share data with users? Excel or PDF?