Multiple tables from within a stored procedure - how?

Hi,
I'm currently analyzing SSRS as a potential replacement for Crystal Reports
(and yes, it's definitely going to replace it). I do have one issue,
however... I'm attempting to point SSRS to a stored procedure that returns
four separate tables, but only the first one seems to be returned.
Is there a way to have access to each of the tables within the sproc?
Regards,
ScottNo there is not and this has not changed in RS 2008.
The most you can do is to have a parameter that selects which one you want
and then when calling the stored procedure set that parameter to a constant
value. If used in a report and all four are desired you have to call it four
times.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott McNair" <smcnair@.beachexpress.takethispartout.com> wrote in message
news:Xns9A218ECAC3E7Adonquixote235gmailco@.207.46.248.16...
> Hi,
> I'm currently analyzing SSRS as a potential replacement for Crystal
> Reports
> (and yes, it's definitely going to replace it). I do have one issue,
> however... I'm attempting to point SSRS to a stored procedure that returns
> four separate tables, but only the first one seems to be returned.
> Is there a way to have access to each of the tables within the sproc?
> Regards,
> Scott

multiple select in the parameter field in Crystal reports 8.5

I have a multiple select in the parameter field in Crystal reports 8.5 how do i check against that value in my SP?

Suppose I select 2 user from Drop down say

Mary
John

Are they comma seperated the way they r in Web based apps?
how do i build a SQL String based on the User criteria?Where is the dropdown - in Crystal (as a defined range of inputs) or in an application devloped from Vb or C++ or similar?
To use the VB example, when you populate a combo box, you can assign a value to the .ItemData property of the combo, and then return that to the report via the .ParameterFields collection exposed via the CR Active X control.
Say you populate your combo with data from a table:
RecordID Name
1 Fred
2 Mary
3 Joan
4 John
etc

then in VB code would be
...open recordset
...start looping thru records
cboTest.AddItem value_to_appear ' eg Fred
cboTest.ItemData(cboTest.NewIndex) = id 'eg 1
next

when you click on the combo, you can get the index and pass it to crystal
lngID = cboTest.ItemData(cboTest.ListIndex)

then in your code you can pass that to report when you open it, eg
Dim objPrintApp As CRAXDRT.Application
Dim objReport As CRAXDRT.Report
Dim objParamDefs As CRAXDRT.ParameterFieldDefinitions
Dim objParamDef As CRAXDRT.ParameterFieldDefinition

' code presumes you have an input parameter to your report named pID
' Set the report source
Set objPrintApp = New CRAXDRT.Application
Set objReport = objPrintApp.OpenReport(strReportSourcePath & strSource)
objPrintApp.LogOnServerEx put logon parameters here

Set objParamDefs = objReport.ParameterFields
For Each objParamDef In objParamDefs
With objParamDef
Select Case .ParameterFieldName
'It finds and sets the appropriate Crystal parameters.
Case "pID"
.SetCurrentValue lngID

' add other Case conditions here to handle other parameter names.

' Catch-all for others
Case Else
strInput = InputBox("Enter a value for '" & .ParameterFieldName & "'")
If strInput <> "" Then
.SetCurrentValue strInput
Else
Exit Sub
End If
End Select
End With
Next

objReport.PrintOut

hope this helps

dave|||Thks for ur prompt reply...but the drop down is in crystal reports 8.5

I am using Crystal reports 8.5 stand alone with enterprise server......i mean i not using VB or anything else as App dev.
I have SP in SQL server 2000

I need to select multiple values from the drop down of the parameter field.
how do I put those values in the drop down of the parameter field which needs to be passed to the SP?

How do I build the Sql query once the multiple values r selected? are the multiple values comma seperated??

Multiple Sections in a Report

Hi
I was wondering, I previously worked with Crystal Reports and in this
offered the functionality of Multiple Sections, in the Report Header/Footer,
Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
cannot seem to work out how to do this in SSRS, whilst building reports?
--
Kind regards
Ricky
(SS2005/SSRS2005)On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
> Hi
> I was wondering, I previously worked with Crystal Reports and in this
> offered the functionality of Multiple Sections, in the Report Header/Footer,
> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
> cannot seem to work out how to do this in SSRS, whilst building reports?
> --
> Kind regards
> Ricky
> (SS2005/SSRS2005)
As far as I know, in SSRS, you can only create a single header and
single footer (via the Layout view -> Report drop-down -> Page Header/
Page Footer). If you are using table/matrix controls, you are able to
use multiple group headers and footers; and using a table/matrix
control, you can have multiple detail rows. While this is not exactly
the same as in CR, it should get you by. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique
Shame that this is the case, do you not think this is somewhat restricting,
I thought that MS would have been able to implement something like this
quite easily...
Perhaps SS2008, may bring some enhancements?
Kind regards
Ricky
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182645968.089622.279980@.p77g2000hsh.googlegroups.com...
> On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
>> Hi
>> I was wondering, I previously worked with Crystal Reports and in this
>> offered the functionality of Multiple Sections, in the Report
>> Header/Footer,
>> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
>> cannot seem to work out how to do this in SSRS, whilst building reports?
>> --
>> Kind regards
>> Ricky
>> (SS2005/SSRS2005)
>
> As far as I know, in SSRS, you can only create a single header and
> single footer (via the Layout view -> Report drop-down -> Page Header/
> Page Footer). If you are using table/matrix controls, you are able to
> use multiple group headers and footers; and using a table/matrix
> control, you can have multiple detail rows. While this is not exactly
> the same as in CR, it should get you by. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 24, 8:00 am, "Ricky" <r...@.msn.com> wrote:
> Hi Enrique
> Shame that this is the case, do you not think this is somewhat restricting,
> I thought that MS would have been able to implement something like this
> quite easily...
> Perhaps SS2008, may bring some enhancements?
> Kind regards
> Ricky
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1182645968.089622.279980@.p77g2000hsh.googlegroups.com...
> > On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
> >> Hi
> >> I was wondering, I previously worked with Crystal Reports and in this
> >> offered the functionality of Multiple Sections, in the Report
> >> Header/Footer,
> >> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
> >> cannot seem to work out how to do this in SSRS, whilst building reports?
> >> --
> >> Kind regards
> >> Ricky
> >> (SS2005/SSRS2005)
> > As far as I know, in SSRS, you can only create a single header and
> > single footer (via the Layout view -> Report drop-down -> Page Header/
> > Page Footer). If you are using table/matrix controls, you are able to
> > use multiple group headers and footers; and using a table/matrix
> > control, you can have multiple detail rows. While this is not exactly
> > the same as in CR, it should get you by. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I checked out the SQL Server 2008 White Papers and I haven't seen
mention of it so far; of course, it is still in Beta 1 at this point
so you never know.
Regards,
Enrique Martinez
Sr. Software Consultant
`