[AccessD] Moving reports to Visual Studio

[David McAfee]

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

https://docs.microsoft.com/en-us/sql/reporting-services/import-reports-from-microsoft-access-reporting-services


And

https://www.mssqltips.com/sqlservertip/4187/converting-ms-access-reports-to-sql-server-reporting-services-reports/

Hth,
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
>