"Mary Bray [MVP]" <reply@tonewsgroup.com.NOSPAMPLEASE> wrote in message
news:O7C9rtYMFHA.3512@TK2MSFTNGP15.phx.gbl...
> Basicaaly you can't - multi value lists are not natively support in the
> current version.
> You can however roll it yourself, either by dynamically building the sql
> string to use JobID In (@somecommadelimitedlist) or if you have some SQL
> skills you can create a function in SQL Server to take a comma separated
> list and return a table for use in a query.
> Check this out:
> http://www.windowsitpro.com/Article/ArticleID/26244/26244.html?Ad=1
>
> --
>
> Mary Bray [SQL Server MVP]
> Please reply only to newsgroups
>
> "Greg Rowland" <greg@waveltd.com> wrote in message
> news:OWkRW9VMFHA.3708@TK2MSFTNGP14.phx.gbl...
> > Having designed a report that accepts a Job# parameter and returns;
> > Individual Job Information
> > Summary of Tabled Labor Charges, Grouped by Labor Type
> > Summary of Tabled Material Charges, Grouped Purchase Order
> > Summary of Tabled Subcontracts Charges, Grouped Purchase Order
> >
> > Bottom Line Totals
> >
> > Each section provided by a separate Dataset using the Job# parameter
> >
> > Now I would like to modify this report to be created/batched from a list
> > of
> > Job#s contained in a list table.
> >
> > How can I link the datasets to the list table in place of the parameter,
> > or
> > something?
> >
> > Suggestions?
> >
> > Thanx in advance,
> >
> > Greg
> >
> >
> >
>
>

"Greg Rowland" <greg@waveltd.com> wrote in message
news:OWkRW9VMFHA.3708@TK2MSFTNGP14.phx.gbl...
> Having designed a report that accepts a Job# parameter and returns;
> Individual Job Information
> Summary of Tabled Labor Charges, Grouped by Labor Type
> Summary of Tabled Material Charges, Grouped Purchase Order
> Summary of Tabled Subcontracts Charges, Grouped Purchase Order
>
> Bottom Line Totals
>
> Each section provided by a separate Dataset using the Job# parameter
>
> Now I would like to modify this report to be created/batched from a list
> of
> Job#s contained in a list table.
>
> How can I link the datasets to the list table in place of the parameter,
> or
> something?
>
> Suggestions?
>
> Thanx in advance,
>
> Greg
>
>
>

"Greg Rowland" <greg@waveltd.com> wrote in message
news:utO$RCaMFHA.2988@TK2MSFTNGP14.phx.gbl...
> Hi Mary,
>
> (@somecommadelimitedlist) as a report parameter?
>
> Is there a way to pass the JobList Dataset between datasets as a
> parameter.
>
> SQL Skills I got, I was thinking of creating a stored procedure that flat
> files all of the records "from the JobList table" into a couple of
> simplifed
> tables. Then let Report Services, Group and Filter it out.
>
> Basically I am prepossessing the "Jobs List entered by the user" in a
> Delphi
> Win32 application, into the SQL Jobs List Table. Then I Just want Report
> Services to repeat the existing report for each job in the list.
>
> select
> job_num as [Job#],
> job_desc as [Description]
> from TWO WorkOrders
> where job_num in
> (
> select
> [Job#]
> from [Jobs_Batch_List]
> )
>
>
> "Mary Bray [MVP]" <reply@tonewsgroup.com.NOSPAMPLEASE> wrote in message
> news:O7C9rtYMFHA.3512@TK2MSFTNGP15.phx.gbl...
>> Basicaaly you can't - multi value lists are not natively support in the
>> current version.
>> You can however roll it yourself, either by dynamically building the sql
>> string to use JobID In (@somecommadelimitedlist) or if you have some SQL
>> skills you can create a function in SQL Server to take a comma separated
>> list and return a table for use in a query.
>> Check this out:
>> http://www.windowsitpro.com/Article/ArticleID/26244/26244.html?Ad=1
>>
>> --
>>
>> Mary Bray [SQL Server MVP]
>> Please reply only to newsgroups
>>
>> "Greg Rowland" <greg@waveltd.com> wrote in message
>> news:OWkRW9VMFHA.3708@TK2MSFTNGP14.phx.gbl...
>> > Having designed a report that accepts a Job# parameter and returns;
>> > Individual Job Information
>> > Summary of Tabled Labor Charges, Grouped by Labor Type
>> > Summary of Tabled Material Charges, Grouped Purchase Order
>> > Summary of Tabled Subcontracts Charges, Grouped Purchase Order
>> >
>> > Bottom Line Totals
>> >
>> > Each section provided by a separate Dataset using the Job# parameter
>> >
>> > Now I would like to modify this report to be created/batched from a
>> > list
>> > of
>> > Job#s contained in a list table.
>> >
>> > How can I link the datasets to the list table in place of the
>> > parameter,
>> > or
>> > something?
>> >
>> > Suggestions?
>> >
>> > Thanx in advance,
>> >
>> > Greg
>> >
>> >
>> >
>>
>>
>
>