This is really a combination of Crystal Reports and SQL to modify an existing invoice for a specific client. You would have access to the report file, stored procedure and a scratch/test database. I think the bulk of the form probably needs to be handled on the SQL side, which is a bit over my head.
I've added a PO filed to the report, (ex PO#, 0002-0215p3859). The line items on the invoice need to be sorted by the number to the left of the hyphen. All line items associated with that number need to display and total. Freight needs to do the same thing in parallel.
I don't think it's overly complicated for someone that knows what they're doing in SQL and Crystal Reports. If the basic form can be made functional, I can "pretty it up" and fine tune the final output.
The software that generates the invoice EPMS which probably doesn't mean much to anyone.
Hi, I'm an experience Crystal Reports / SQL developer and can make these report modifications for you. Please feel free to message me here if I can answer any questions for you. Thanks, Mitch
$50 USD in 1 day
5.0 (4 reviews)
3.9
3.9
13 freelancers are bidding on average $149 USD for this job
Hello, I write Crystal Reports with SQL Server backend as part of my day job.
A bit about me: I am a Microsoft Certified Solutions Master: SQL Server. I am a SQL Server consultant working as a Developer and DBA. I have had 14 years experience with SQL Server and 3 years with Crystal and SSRS reports. You can check out my website: http://www.nicholsonsql.com. If you have any questions let me know.
Hi
I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 4 + years experience in .NET with C#,VB,ASP.NET, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and HTML
I've been working with MSSQL and Crystal Reports continously for nearly 5 years (iScala ERP Invoices, Warehouse Documents, Reports, etc.).
I'd gladly try to help in your issue - there would be only one inconvenience concerning eventual work on Crystal Reports file - currently I don't have CR installed on my machine so in order perform such task I'd need a remote connection to the machine with CR installed.
As for SQL Server there is no problem at all.
Kind regards,
Hi,
I have 15 years of experience in creating / modifying reports using Crystal Reports. I have worked with various database like MS SQL, MySQL, etc.
Further, I have very good programming knowledge of Visual Studio and C#. Have developed many application using c# with Crystal Reports run time integration.
Please let me know if you need more information.
Regards
Sri
==