[AccessD] Moving reports to Visual Studio

David McAfee davidmcafee at gmail.com
Tue Feb 11 11:25:56 CST 2020

I was able to convert a dozen reports successfully from ms Access to SSRS
using SSDT.

I did have problems with embedded reports (subreports), so I had to make
versions without the sub report, then import them and the separate sub
reports, then embed the sub manually.

I also had to fix several expressions in the reports, but it was still
faster than recreating the reports from scratch

I forget if I had to strip the VBA from reports that were using it, but I
found most of the stuff I was doing in VBA was not needed in ssrs, or was
handled some other way.

Oh, and I might add that I exported all if the reports into a new access
database before importing them into ssrs.

Look at




David McAfee

On Tue, Feb 11, 2020, 8:27 AM Gustav Brock via AccessD <
accessd at databaseadvisors.com> wrote:

> Hi Jeff
> Yes and no. If you mean move/convert to Reporting Services, it is a no-go
> - those are completely different animals.
> /gustav
> -----Oprindelig meddelelse-----
> Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Jeff
> Barrows
> Sendt: 11. februar 2020 17:24
> Til: 'Access Developers discussion and problem solving' <
> accessd at databaseadvisors.com>
> Emne: [AccessD] Moving reports to Visual Studio
> Anybody have experience moving reports from Access to Visual Studio?
> Thank you,
> Jeff Barrows
> jeff.developer at gmail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list