how to view a g/l account in crystal report

[Former Member]

hi frnds i am getting an error that g/l account cannot be added to the crystalreport

[Former Member]

Hi,

TaxMemo may not be a valid parameter here. Check by changing it to a proper key.

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Where did you get  t1.taxmemo field? Check with this field.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

What you mean by code? Did you checked with my reply?

Thanks & Regards,

Nagarajan

[Former Member]

can u send me the code

[Former Member]

HI

Its syntax error.

Your query might contain any special characters like comma without any followed field,semicolon.

As Mr.Nagarajan said,please post your query here.

[Former Member]

OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId where t1.taxmemo in{?TaxMemo@ select * from OCRD}

[kothandaraman_nagarajan]

Hi,

There is syntax error in your query.

Please paste the query that retrieving G/L account.

OR

Please try the following steps to solve the issue:

1. Go to Crystal Report designer menu, Database-> Set Datasource Location..., ensure the database name, table name and user

name & password is correct.

2. Check in SQL management studio, ensure that the fields, tables and procedures used by the crystal report exist and that

SQL Queries can be executed against them.

3. Go to Crystal Report designer menu, Database-> Show SQL query,

ensure the query does not contain any syntax error.

4. If the query shown is valid, please try to run it in the SQL management Studio.

Thanks & Regards,

Nagarajan