Last post Feb 07, 2012 06:10 AM by nkd1083
Feb 06, 2012 05:02 AM|nkd1083|LINK
I am new in ssrs reporting . I am building a report...
my requirement is, i am using one store procedure for displaying data, it is working fine ...
but i want to run one select query to take name , detail or particular person from DB and display . i have to show it in single ssrs
please tell me how can i acheive this...
Plz help me
Feb 06, 2012 06:25 AM|Sankalpa|LINK
do you want to run a another select query with your sp? or you want to run select statement insted of sp?
Feb 06, 2012 06:31 AM|nkd1083|LINK
I want to run both(sp and select query) simultaneously both have same parameter , but i cant merge select query in sp because it is a business report....
Feb 06, 2012 07:06 AM|Sankalpa|LINK
i don't belive thats possible can't you join the select query inside the sp and get the result from sp
Feb 07, 2012 03:45 AM|nkd1083|LINK
no i can't because SP returns lacs of record and this is a kind of report.
Feb 07, 2012 06:10 AM|nkd1083|LINK
could u tell me how can i pass same parameter in subreport which is passing in main report