darkhelmutis (5/2/2013)
I agree, 700,000 rows in not feasible, thus why I am looking for options. Sadly SSRS 2005 is pretty limited in that regard.The Transaction ID is one of the criteria the end user can use to identify the Transaction in question. They will sometimes look up very old Transaction IDs at that.
For the moment, they can overcome this by using the Start and End Dates.
We are in the process of upgrading to SSRS 2012, so I may not bother any further with this. Thanks for the .02 cents!
DH
Then allow them to run a report that searches for TransactionID's between dates.
which outputs the id's to a data table then link to another report that calls your report by ID.
and / or allow them to just type it in as Lowell suggests.