I appreciate both of you responding so quickly.
I chose the "Join" solution, as that was enough for this little project. It worked perfectly.
I'm glad to find a CR Forum that is responsive and well informed.
Thanks!
In CR 8.5, I see how to define a parameter which allows multiple values to be chosen. I assume such a parameter is an array of strings. In the Report Header, I would like to display the parameters the user chose. I can easily display the first, but how do I show the others?
Thanks.
Solved! Now I see what I was doing wrong.
I didn't know that in order to use an alias table, one should link the primary key of the first table to that of its alias. Then the error message goes away and suddenly the field(s) from the dead tables come alive in the report.
Reports against...
dgillz~
Thanks for the quick reply. Here is some more info:
I am using CR 8.5 to report on a MS SQL 2000 database of Clarify data. Clarify's schema is non-traditional and highly normalized.
Using SQL Query Analyzer, I can display the fields I need like this:
select c.id_number, s.name...
With the Visual Linking Expert, I need to link 1 table to 2 other tables, so I created an alais table for the table with 2 links. I linked the first instance of the table one way and the alaised copy the other way. Now I get an error message: "Your current link configuration contains...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.