using web to pull table values

[jgarza2044]

hey everyone,
i have a question about a crystal report i am trying to write. i want to use a value from an asp table to pull into the crystal. what i have is a asp page which displays values from a table. i want to write a report from that table using crystal reports. i have a field set up as a link which will take you to a more detailed page. i want to print different reports from this detailed page. my problem is that i keep getting an error of "This field name is not known" when i use the following code:

{table.fieldname} = {?fieldname}

the fieldnames are the same because i want to write the report from the same table as the asp table located in a microsoft sql server. i want the report to recognize to only the fieldname link i have click.

ex:
if fieldname is customer and the values of customer are 1, 2, 3....then when i click on 1, i want the report to realize that 1 is the fieldname value and to only pull information when for customer 1.


any suggestions would be appreciated. thanks.

 

[kenhamady]

I am not sure I understand, but if you are trying to read data from an ASP page table, I am not sure the CR can read tables in pages. It can only read data from ODBC, OLEDB, etc.

But it could probably read the data that is being used to generate this table. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/