stuaz
March 7th, 2007, 11:31 AM
Hello All,
I am very new to Crystal reports and so i have come across two issues:
I currently connect through an ODBC connection to a Unidata Database. I am selecting about 7 tables (all related). But when i place certain attriubtes from one table it gives me an error when i try to preview:
"Failed to retreive data from the database.
Details: HY000:[Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Too many unnest fields"
This obviously stops me reciveing the data. How would one solve this issue?
My next question:
How can i limite Crystal Reports so it on brings back one result?
Becasue at the moment (trying to create a invoice report) I get the first page fine. but then there is like 712010 other records, but the layout to those pages arent the same to the first page?
Thanks
Stu
I am very new to Crystal reports and so i have come across two issues:
I currently connect through an ODBC connection to a Unidata Database. I am selecting about 7 tables (all related). But when i place certain attriubtes from one table it gives me an error when i try to preview:
"Failed to retreive data from the database.
Details: HY000:[Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Too many unnest fields"
This obviously stops me reciveing the data. How would one solve this issue?
My next question:
How can i limite Crystal Reports so it on brings back one result?
Becasue at the moment (trying to create a invoice report) I get the first page fine. but then there is like 712010 other records, but the layout to those pages arent the same to the first page?
Thanks
Stu