Visual Basic Forum for Visual Basic Programmers VB

[shiji]

Hi,

I Have to create one Crystal report by designers in VB.
I have two detail tables and second table values should place in the detail section as a single raw.The detai section contains the first detail table values. How can i do it ?Please help me.

With Regards & thanks
shiji

[DoobieKeebler]

It sounds like you're trying to do an Inner Join. See this page for a quick example. It's about 2/3 of the way down. Is that what you're after?

Hmmm. Maybe a little more info would help. Say Table1 has the fields BookID, BookTitle, PublisherID. Table2 has the fields PublisherID, PublisherName. If you say "Select Table1.[BookID],Table1.[BookTitle],Table2.[PublisherName] From Table1 Inner Join Table2 On Table2 Table1.[PublisherID]=Table2.[PublisherID]" you'd get a row like:
1263 | 500 Ways To Skin A Dead Cat | Mega Book Publishing Corp.

Is that the sort of thing you need?
_________________
Always take into account what a user would never ever in a million years do, because someone will.

"In theory, there's no difference between theory and practice. In practice, there is." -- Yogi Berra

[shiji]

Hi ,

Thanks for Your Reply I think It would helpful for me.

With Regards

Shiji