Crystal Reports Parameterized Query 
Author Message
 Crystal Reports Parameterized Query

I'm not sure this is the best place to ask, but here goes.

We are trying to specify a parameter that we want Crystal to prompt for
in a query being run against an ODBC connection to an SQL Anywhere DB:

Dirpo."PoNum", Dirpo."CustNum", Dirpo."Slsman", Dirpo."BilltoAdd1",
Dirpo."BilltoAdd2", Dirpo."BilltoAdd3", Dirpo."BilltoCity",
Dirpo."BilltoState", Dirpo."BilltoCountry", Dirpo."BilltoZip",
Dirpo."Shipto", Dirpo."ShiptoAdd1", Dirpo."ShiptoAdd2",
Dirpo."ShiptoAdd3", Dirpo."ShiptoCity", Dirpo."ShiptoState",
Dirpo."ShiptoCountry", Dirpo."ShiptoZip", Dirpo."PreparedBy",
Dirpo."ProjectCode", Dirpo."CustDateNeeded", Dirpo."CustName",
Dirpo."OrderNotes", LineItem."LineNum", LineItem."LineType",
LineItem."PartNumSKU", LineItem."Quantity", LineItem."UnitPrice",
    "admin"."Dirpo" Dirpo,
    "admin"."LineItem" LineItem
    Dirpo."PoNum" = LineItem."PoNum" AND
    Dirpo."PoNum" LIKE {?OrderNumberInput}*

Problem is, we get "ODBC systax error."

On the 'Database' tab of Options, we have "Perform Grouping on Server"
checked in the belief it will enable 'pass-through' behavior on the ODBC

We've been able to get the prompting to work, but can't plug the
resulting value into the SQL.

Sent via http://www.*-*-*.com/
Share what you know. Learn what you don't.

Mon, 03 Dec 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. use parameterized query in Crystal Report

2. Any Interest in Crystal Report Viewer which support Parameterized Queries

3. parameterized Query/Report

4. Reports+parameterized queries in VB6


6. Parameterized SQL X Crystal reports

7. How to export a parameterized crystal report to pdf format file

8. Using Sub Query in Sql Query - Crystal Report 5.0

9. Crystal report based on Crystal query, doesnt work

10. CRYSTAL REPORT, run time query report by date

11. Q: Pass a SQL query from VB to crystal report sub-report

12. sub-report (2 query's ) in crystal reports


Powered by phpBB® Forum Software