Simple report portal with 6 reports, user logs in (stored procedure call to authenticate) then calls stored procedure to get reports that can be run for that user. User clicks on report, show filter criteria and then call stored procedure to get result set. Portal should have common, reusable objects for parms and report viewer, with export, sort, filter, print capabilities (standard for major reporting tool). Should support multiple browsers including IE5, Chrome, FoxPro and Opera. Also need to be viewable from mobile device on mobile browser for run both Android and IOS. NOTE: This is not a mobile app, only a web portal, viewable on both web and mobile.
o Simple website using development tools of your choice.
o Must have experience calling stored procedures to retrieve data (no inline SQL).
o Must be able to do this quickly.
o Login ID
o Forgot Password
o Login button to call sp_Login
-- failure call SP to get error message and display
Get Reports - call SP with Login ID
o get result set back of reports available (Report ID, Description, Flag for what parms to prompt)
o Display list of available reports for this user
o click on report to run
Run any report
o prompt for parms (based on parm flag)
o call standard sp_Report parm,parm,parm,parm to get report results
o display result set in report format we will provide
o change sort