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 Chriss Miller 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
Joined
Jul 7, 2006
Messages
15
Location
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 Question
export multiline address field from crystal to excel
Replies
3
Views
1K
hilfy
hilfy
semsel
  • Locked
  • Question Question
Checking if a value exists in an Array for conditional suppression
Replies
0
Views
1K
semsel
semsel
LMGroup
  • Locked
  • Question Question
Need to get a value from a completely unrelated table to use as a constant
Replies
1
Views
233
kray4660
kray4660
lesleycampbell
  • Locked
  • Question Question
Group Not Working When Field Value Is Null
Replies
2
Views
278
hilfy
hilfy
BeeBear2
  • Locked
  • Question Question
ODBC Unstable when using Multiple Connections
Replies
5
Views
525
BeeBear2
BeeBear2

Part and Inventory Search

Sponsor

Back
Top