linked table does not appear in FROM clause

[sue1127]

I am trying to add two new tables to a report. When I link one of the tables to an old table, the new table does not show up. It is not in the sql, and if I request an input parameter equal to one of its fields, I get an error message saying that the column_prefix does not match with a table specified in the From clause.

If I try to link the other table to the other new table, I get an odbc error saying item 11 has already been read.

I have successfully added these tables in 4 other reports. The only difference in this report is that it includes the table containing gl transactions, rather than the table containing the gl summary records, and there are a few additional selection criteria.

Does anyone have any ideas about what might be going on?

Thanks very much.

Sue

 

[synapsevampire]

Please post the version of Crystal, type of connectivity and the database type and version being used.

It could be that you're using the wrong driver (for instance the Microsft ODBC driver instead of the CR Microsoft ODBC driver).

-k

 

[sue1127]

I'm using Crystal Reports 8.0 against Sybase 11.0.3. The driver is sysyb95. I think it's a CR odbc driver

 

[rosalindr]

Crystal doesn't recognize a new table unless you add a field from it to the Details section. In Crystal 8, you can edit the ODBC directly (Can't now in Crystal 9). Just enter the table name in the From, and add the joins to the Where clause. This will disable the visual linking, and you will have to enter new tables directly into the SQL, but it shouldn't be a problem.

Roz Rogoff

http://www.mytrainingdept.com

Crystal Reports development & training

 

[sue1127]

Roz,

Thanks for the suggestion. I tried to enter the tables and links directly, but I can't seem to get it to work.

Sue

 

[sue1127]

Roz,

I finally got it to work by typing in the sql. Thanks for the suggestion. Now I have another problem--I can't get it to accept one of my input parameters. I explained the situation in a separate posting in case no-one looks back at this one.

All ideas are appreciated.

Thanks,

Sue

 

[rosalindr]

Sue,

I saw your other message, and I'm trying to figure that one out. I'll let you know if I come up with something.

Roz