Not directly, at least not with SSRS. You'd need more of an interface to pass down parameters for rowcounts and starting rows to a proc which would restrict the data being passed up. ASP.NET or something similar.
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