Programmer-Designer »   Register   Login   Logout   FAQ 
 Buyer-Project Manager »   Signup   Login   Post a Project   Logout   FAQ 
Browse Recent projects :: Post your Project :: Testimonials onmouseover="status='Click in Explorer -OR- press Ctrl and D in Netscape.';return true" onmouseout="status=' ' ">bookmark :: tellafriend :: affiliate programaffiliate program :: contactus :: homepage
programmingbids.com

Project: Need improved report output

ID: 1211917979 Urgent!
email this project to your friends
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others is not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Status: Frozen (No bidding. Waiting for action from project owner.) Urgent!
Budget: N/A
Created: 5/27/2008 at 13:52 (MST)
Bidding Ends: 6/3/2008 at 13:52 (MST)(expired)
Project Creator: wildcard
Rating: (No Feedback Yet) --- login to your account to pick a bid, when you are ready.
Description:
«Login» to edit the description

Hello.

I admin for a proprietary communication type voip server, and one of my duties is to run a certain report. It is very inefficient and time consuming to run it the way the developer has setup vs the way management desires it.

So I come to you. I am willing to pay you out of my pocket to make my life easier.

Server uses phone-like devices, each one with a MAC address. Server keeps track of which user uses which device. Sometimes people take the devices home or lose them.

Present reports are run on the server, and output with Crystal reports in a format that isn't quire random, but it's somewhat by department. It's not an ideal sort.

Ideally I want the output to be like:

/department1/badge1/ /last used date/ /last used user/
/department1/badge2/ /last used date/ /last used user/
/department2/badge1/ /last used date/ /last used user/
/department2/badge2/ /last used date/ /last used user/
/etc/etc/
There are about 30 departments, each department has between 5 and 30 devices.

I have an Excel spreadsheet of all badges with mac addresses.

So the best solution would be some means to have a crystal reports report made that I can run in Crystal reports on my server - that generates output listed above.

Second best solution would be last known use report is generated as usual, then broken down and manipulated in whatever way you see fit to do the needful.

I will attach a TXT to the project that shows some of the output for the 'last known use' report. I have edited it some for privacy. Don't forget that other than this TXT/CSV, I also have an XLS sheet that defines which MAC=Which device's Department/device number.

I am online often, so feel free to ask whatever questions. I will generate a reply quick.

Thank you for your help,

Attached File: last_known_user_sample.txt
Project Type:
  • Databases
  • Expert/Advice
  • PDF Related
  • Custom Scripting
  • Spreadsheets
OS-Platform: None
Programming Language: None
Database Type: mySQL
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: 0 - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others are not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Programmer Bids for this project

Programmers/Freelancers Bid Delivery Within Time of Bid
Rating
(No bids have been placed yet.)


Share |



 Affiliate $19.95/programmer sign-up and 30% commission (every time) - perfect for web hosting providers and programmer resource or service provider websites.

Site Terms : Your use of this website constitutes your agreement to the terms and conditions of Programmer Bids. Any bids/quotes provided by individual freelancers, programmers, web designers and consultants on this website are not recommendations by Programmer Bids - we neither provide any quotes directly to the buyer, nor do we recommend any "specific" service provider registered on our web site. Buyers and corresponding freelancers, programmers, web developers and consultants must assume responsibility for the delivery of work and payment transactions. Programmer Bids.com only provides a buy/sell marketplace for interested buyers, freelance programmers and web designers to buy or sell programming and web development services, on our website. Please read and accept Terms & Conditions before using our service.

 Copyright © 2001-Current, Programmer Bids.comSM ¤ Terms of Use ¤ Contact Us ¤ Tell Friends ¤ Affiliate Program Home