external variable for report query

More
11 months 3 weeks ago #22039 by rick101
We want to create a report and email it using an SQL data base. We want to extract customer number and their email from the data base and create the report using the customer number as the selection criteria to pick the correct data and also then email the report to the customer using the email address that comes for the data selected. We are having problem passing the customer number variable to the report. Can anyone help to solve this.
Thanks

Please Log in or Create an account to join the conversation.

More
11 months 3 weeks ago #22040 by admin
Please have a look at the following tutorial
www.etl-tools.com/wiki/aetle/reports
Also, check the videos

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
11 months 3 weeks ago #22041 by rick101
We are having problem with the MySQL syntax for the query. We are getting an undeclared identifier message. If we use a fixed value, it works but if we use a defined variable, it does not.

Please Log in or Create an account to join the conversation.

More
11 months 3 weeks ago #22042 by admin
Can you provide us with some screenshots, please?
Can I also suggest following the forum rules?
That will save you and us a lot of time

Mike
ETL Architect

Please Log in or Create an account to join the conversation.