Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-12 : 09:12:03
|
| Jose writes "I HAVE A STORED PROCEDURE WHICH IS THE SOURCE FOR AN ACCESS REPORT, I NEED TO INCLUDE IN THE SAME STORED PROCEDURE OTHERS QUERIES THAT ARE GOING TO BE USED IN THE SAME ACCESS REPORT. SO THE FIRST OUTPUT OF THE STORED PROCEDURE IS GOING TO BE THE DETAIL OF THE REPORT AND THE OTHER OTUPUTS ARE GOING TO BE USED IN REPORT FOOTER. HOW COULD I DO THIS BY CALLING THE SOTRED PROCEDURE JOST ONCE? I KNOW THAT I CAN USE NEXT RECORDSET (VBA) BUT I COULD NOT ASSIGN THE FIRST RECORDSET TO THE REPORT SOURCE.I UNDERSTAND THAT IS NOT A PUNTUAL SQL SERVER QUESTION BUT MAYBE YOU CAN HELP ME WITH THIS OR TELL ME WHERE SHOULD I GO TO ASK.THANK YOUJOSE" |
|
|
rgaudreau
Starting Member
2 Posts |
Posted - 2002-02-20 : 08:21:27
|
| I have done this by using temporary tables populated by the various outputs |
 |
|
|
|
|
|
MAKING A REPORT SOURCE FROM STORED PROCEDURE