SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:39 PM
| ||||
| ||||
 Re: Correlated Sub-Query Crystal reports most definitely can do this - it's only a few mouse clicks. In fact, it's faster to do than to explain here, and so simple, I reckon you'll figure it out in a few minutes. "EoRaptor" <rchrismon@patmedia.net> wrote in message news:faeeb769.0403310729.3965b929@posting.google.c om... > "Mark Yudkin" <myudkinATcompuserveDOTcom@nospam.org> wrote in message news:<c4dmif$160$1@ngspool-d02.news.aol.com>... > > Your best bet is to use a report writer to do the formatting (cross-tabular > > layout) of the SQL output. SQL is not a formatting language, it's for data > > retrieval. Your query is giving the right answer. > > > > Thank you for the thoughts. Unfortunately, this whole question came > about because the person in my company who prepares reports (Crystal > Reports 9) says Crystal can't do this formatting and that I must > create a column in the invoice table to hold a text string of all the > codes from the line_items table. He then went on to say that I need to > do this for every table that he might need to report on! > Normalization? What normalization? So, it sounds like I'll have to > learn Crystal Reports so that I can prove it can be done. What a bite!      |
Linear Mode
