SQL Crystal Report for Monthly Intrastat Submissions
Budget: $30 – $250 USD
I'm seeking a data analyst with experience in SQL and Crystal Reports. The task involves creating a crystal report to generate monthly Intrastat declarations derived from our sales data. This data is stored in a SQL database and needs to be transformed into Excel format for the reports.
Key components of the reports:
- Sales data fields: Product information, Transaction value, Date, Invoice No, Customer Name, Item Description, Quantity, Item Amount Value, Nominal Code, SIC, Weight Each, Line Weight Amount, Gross Amount Value, Type, Customer VAT No.
- Customer-based segmentation for the reports.
Ideal skills:
- Proficiency in SQL and Crystal Reports.
- Experience with sales data analysis.
- Ability to segment data by customer.
- Excel expertise for report formatting.
Looking forward to your proposals.
Key components of the reports:
- Sales data fields: Product information, Transaction value, Date, Invoice No, Customer Name, Item Description, Quantity, Item Amount Value, Nominal Code, SIC, Weight Each, Line Weight Amount, Gross Amount Value, Type, Customer VAT No.
- Customer-based segmentation for the reports.
Ideal skills:
- Proficiency in SQL and Crystal Reports.
- Experience with sales data analysis.
- Ability to segment data by customer.
- Excel expertise for report formatting.
Looking forward to your proposals.