Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multi Value Explode?

Status
Not open for further replies.
kenp705

kenp705

Technical User
Jul 7, 2006
15
US
I am using CR XI and a Unidata ODBC connection. Does anyone know if Crystal has the ability to explode multi value fields? Thanks for any help or advice.
 
Sort by date Sort by votes
The database has a function to do so itself, it's been awhile but I think that it used qselect or some such.

So select the Add Command under the database connection and paste in real SQL to return the data in a usable fashion, or perhaps you can create a View or Stored Procedure to return the data.

-k

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
666
hilfy
hilfy
semsel
  • Locked
  • Question
Checking if a value exists in an Array for conditional suppression
Replies
0
Views
643
semsel
semsel
LMGroup
  • Locked
  • Question
Need to get a value from a completely unrelated table to use as a constant
Replies
1
Views
79
kray4660
kray4660
lesleycampbell
  • Locked
  • Question
Group Not Working When Field Value Is Null
Replies
2
Views
99
hilfy
hilfy
BeeBear2
  • Locked
  • Question
ODBC Unstable when using Multiple Connections
Replies
5
Views
180
BeeBear2
BeeBear2

Part and Inventory Search

Sponsor

Back
Top