Best way to replicate an Access 2000 front-end form 3

[jimmyfishbean]

Hi,

I am migrating data, including a form-based application from Access 2000 to SQL Server 2005. I have successfully migrated the data and also generated the necessary views, functions, stored procedures etc.

The Access application generates lots of reports, which I have replicated in SSRS.

My question is, how (or what is the best way) to re-create the front end form in SSRS? Basically, all I need to do is create the form and link the buttons to the Views, SPs etc that already exist in the SQL Server 2005 DB.

Many thanks in advance.

Jimmy

 

[SgtJarrow]

Not really a SSRS question but here's a short answer:

You probably want to look to Visual Studio (either C# or VB depending on your preference). You can create a Visual Studio Windows Forms project and make use of the SSRS Report Viewer control to display all your reports in the application.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[paulkeys]

The above is probably the best way to approach this, but you could implement a workaround using SSRS, and have a report that has a series of textboxes, with the navigation options set to jump to the relevant report when the textbox is clicked

 

[xlbo]

Yup - Paulkeys suggestion is one that I have used for a basic interface. Textboxes have a navigation property that can either be a report link, a file link or a url so you have a few options there...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question