2 or more user sessions variables for login. Transform (cross-table) query(s)
Require two or more Session Variables to restrict users to login in to see their own company’s data only. The first is user_id to access, view, and modify client's account (user & company account data). The second session variable is for the user to view only data from metrics reports based on company detail events. Users should only view their company's data only (not modify – admin restricted). Data will be 5 summary reports are based on three separate tables: Company, Users, Events/Records Tables, and are illustrated as the following reports: 1) Annual, QTRLY, Monthly, Biweekly, Cumulatively The reports based on ” company events” table (using only a generic label here, the actual name will be different), the reports are extracted from the following 8 fields: 1)Company, 2) Value, 3) Weight, 4) Time period (event date), 5) Metal_lbs, 6) plastic_lbs, 7) C02_lbs, 8)KWH) . Examples have been (or will be) provided of a couple of session variables to a Task Manager Database. Essentially, I just want to copy & test & ensure it’s fully functioning on the site. The second phase of the project is to summarize the data into pivot tables ("transform" queries) similar to MS Cross-tab queries. These are readily created in MS SQL MS Access, through the "Cross-Tab" query function. However, in any sql engine, they need to be created from scratch. A couple of examples have been provided. Essentially, creating the reports as pivot table queries (presently existing as tables). Hence, rather than copying these as tables (as they are presently stored now) I would like to store them as SQL queries. A couple of SQL examples have been provided in the url link. http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/ Require this in ASP, and (preferably) within Code Charge Studio 4x. Though the latter isn't necessary, they need to be tested within existing pages written in ASP on the site.
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."