Ambitious Database Project. I need help.
In my quest to learn how to do things, be a better man, a better SQL querier and leader. I wanted to take on something and finish it.
The Project. Make an efficient Form for User Report Requests.
My goal is to force users to be more detailed in their requests to limit the back and forth that is often associated with data entry, filters, parameter, report file path, server location. Anything relevant to building a new or modifying an existing report. I would like to tie it in as much as possible to the Built-in Fields like Report Name, Server Folder & User ID.
I would like to create
Currently we are on Server 2008 latest release and are planning to migrate to a later version very soon. Trying to get this in before the migration. Any & all advice appreciated. Thank you!
The Project. Make an efficient Form for User Report Requests.
My goal is to force users to be more detailed in their requests to limit the back and forth that is often associated with data entry, filters, parameter, report file path, server location. Anything relevant to building a new or modifying an existing report. I would like to tie it in as much as possible to the Built-in Fields like Report Name, Server Folder & User ID.
I would like to create
- The database in Microsoft SQL I think I have a handle on this part. I don't know if anyone knows of things to plan for watch out for or follow-up on to insure success.
- Create a Form of some kind that hopefully can interface with the companies Website Portal for ease of access and use.
- Anything I need to do to plan for the web interface.
- Maybe there is a simpler way to do this that does not involve the website but utilizing the Report Server SSRS to do this and simply put the form up where the Current reports are. That way we can run a report against it to see the report requests at a glance.
Currently we are on Server 2008 latest release and are planning to migrate to a later version very soon. Trying to get this in before the migration. Any & all advice appreciated. Thank you!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I do not know why I did not think to do this before. Report Request Form.xlsx
If someone could take a look at the Form and see if I am on the right track or if the suggestions are on the right track? Any and all input would be helpful. Thank you gentlemen
If someone could take a look at the Form and see if I am on the right track or if the suggestions are on the right track? Any and all input would be helpful. Thank you gentlemen
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Pointing the datasource to a SQL Server database I assume is probably best? My concern is hosting the report form which I do not even know if or how to do will work on the SSRS interface. I thought maybe I Could create a parameter driven report where users select values from dropdowns select checkboxes and fill note windows with content then those reports get run dailiy to see any and all new report requests whether it be modifications or new reports.
Can an Access form live on SSRS for users to access or should my second idea of creating some kind of a Parameter Driven report where data is collected there then go to a secondary report that builds a Modify Report List Report and a Create New Report Request Report?
Can an Access form live on SSRS for users to access or should my second idea of creating some kind of a Parameter Driven report where data is collected there then go to a secondary report that builds a Modify Report List Report and a Create New Report Request Report?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can MS Access FORM be setup to live out in one of the SSRS Folders where users can enter in the values for creating a report request or would they have to have MS Access, the form and a DB connection to the DB on their machines or are you suggesting I create a Parameter driven report that stores the data in a way that a secondary report runs off of that set of data to create the reports we need?
ASKER
Would love to know if anyone does if Access forms can be embedded into SSRS in some way that looks seamless? of if there is a tool inside the suite of SSRS SSIS SSMS SS... tools that would allow me to build that interface?
I am not exactly sure what you mean...SSRS is just a reporting tool... a Ms Access form is a data entry/manipulation/validation entity.
Right now you are only slowing the 1000AU view