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!

Smartlists

Status
Not open for further replies.
itasueb

itasueb

MIS
Mar 11, 2005
29
US
Is there anyway to find out on a particular smartlist report, what tables are used to pull the data from? I want to create a crystal report the uses the exact same fields from the exact same tables as this particular smartlist uses.

Thanks
 
Sort by date Sort by votes
I'm having the same problem. Here's how I'm tackling it.

I log in as myself (an account with lots of privileges). I setup a SQL trace to observe activity against the SQL server (from me only), then pause it. I get the Smartlist to the point just before I will activate the lookup, unpause the trace, then click the Smartlist. Once the Smartlist has run I stop the trace and start sorting through it for SQL stuff.

Yeah, it's a bit tedious, but it works!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ddell
  • Locked
  • Question
Smartlists Builder Documentation
Replies
0
Views
55
ddell
ddell
bradth
  • Locked
  • Question
Removing smartlists
Replies
5
Views
217
jazgeek
jazgeek
bradth
  • Locked
  • Question
Smartlists
Replies
2
Views
72
jymm
jymm
rmaslanka
  • Locked
  • Question
Smartlists column descriptions
Replies
1
Views
94
DaveXYZ
DaveXYZ

Part and Inventory Search

Sponsor

Back
Top