September 4, 2012 at 6:13 pm
I am currently learning to create simple reports in Visual Studio's Report Wizard.
When it comes to more complicated reports, is there anyway of using a block of t-sql code as a data source for a report?
September 4, 2012 at 6:22 pm
Via the wizard I have no idea.
Via the regular build interface in BIDS/VS, yes. Go to the data tab and switch it from 'procedure' to 'text', and plug in your SQL query there. I'd recommend you build said query in SSMS first to make sure it's syntactically correct and gets what you want before transporting it, the editor there isn't that great.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply