Dynamic Parameter Question

I have a report that has different layers of resolution: Global, Region, State, Facility and Issue. For different each level
chosen I want to display a different set of parameters and execute a different SP for my dataset (which will return the same rows).
I've seen posts where I can do the dynamic SP calls but I'm stumped on the showing and hiding of the parameters that I need. I
tried putting a =IIF(blah... as the prompt but that just displayed the expression and didn't evaluate it.
ANY help is appreciated to keep me from having to do 5 different reports :)
Thanks
ScottI think to do this you would want cascading parameters. Then when you call
your stored procedure you will need a wrapper sp that determines which to
call.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:uzKenwSvEHA.2200@.TK2MSFTNGP11.phx.gbl...
> I have a report that has different layers of resolution: Global, Region,
State, Facility and Issue. For different each level
> chosen I want to display a different set of parameters and execute a
different SP for my dataset (which will return the same rows).
> I've seen posts where I can do the dynamic SP calls but I'm stumped on the
showing and hiding of the parameters that I need. I
> tried putting a =IIF(blah... as the prompt but that just displayed the
expression and didn't evaluate it.
> ANY help is appreciated to keep me from having to do 5 different reports
:)
> Thanks
> Scott
>|||Or you create 1 report with all the parameters and then use linked reports
in which you enable specific parameters.
It's like creating 5 reports, but way faster :-)
Hth,
Tom
"Bruce L-C [MVP]" wrote:
> I think to do this you would want cascading parameters. Then when you call
> your stored procedure you will need a wrapper sp that determines which to
> call.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:uzKenwSvEHA.2200@.TK2MSFTNGP11.phx.gbl...
> > I have a report that has different layers of resolution: Global, Region,
> State, Facility and Issue. For different each level
> > chosen I want to display a different set of parameters and execute a
> different SP for my dataset (which will return the same rows).
> > I've seen posts where I can do the dynamic SP calls but I'm stumped on the
> showing and hiding of the parameters that I need. I
> > tried putting a =IIF(blah... as the prompt but that just displayed the
> expression and didn't evaluate it.
> >
> > ANY help is appreciated to keep me from having to do 5 different reports
> :)
> >
> > Thanks
> > Scott
> >
> >
>
>|||Yeah, but how can I set up my parameters to be cascading like that?
IE
Global requires no parameters
Region requires a FK of a region
State requires a two letter state
Facility requires a facilities key value (int)
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:Ofr5IHTvEHA.1300@.TK2MSFTNGP14.phx.gbl...
>I think to do this you would want cascading parameters. Then when you call
> your stored procedure you will need a wrapper sp that determines which to
> call.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:uzKenwSvEHA.2200@.TK2MSFTNGP11.phx.gbl...
>> I have a report that has different layers of resolution: Global, Region,
> State, Facility and Issue. For different each level
>> chosen I want to display a different set of parameters and execute a
> different SP for my dataset (which will return the same rows).
>> I've seen posts where I can do the dynamic SP calls but I'm stumped on the
> showing and hiding of the parameters that I need. I
>> tried putting a =IIF(blah... as the prompt but that just displayed the
> expression and didn't evaluate it.
>> ANY help is appreciated to keep me from having to do 5 different reports
> :)
>> Thanks
>> Scott
>>
>|||even if you have cascading paprameters, it would still show up on the report
though greyed out, making the report parameter section really cluttered.
Having the IIF at the prompt of the parameters is a real cool add on. Should
be added to the wish list.
I would just create subreports, as suggested later
"Bruce L-C [MVP]" wrote:
> I think to do this you would want cascading parameters. Then when you call
> your stored procedure you will need a wrapper sp that determines which to
> call.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:uzKenwSvEHA.2200@.TK2MSFTNGP11.phx.gbl...
> > I have a report that has different layers of resolution: Global, Region,
> State, Facility and Issue. For different each level
> > chosen I want to display a different set of parameters and execute a
> different SP for my dataset (which will return the same rows).
> > I've seen posts where I can do the dynamic SP calls but I'm stumped on the
> showing and hiding of the parameters that I need. I
> > tried putting a =IIF(blah... as the prompt but that just displayed the
> expression and didn't evaluate it.
> >
> > ANY help is appreciated to keep me from having to do 5 different reports
> :)
> >
> > Thanks
> > Scott
> >
> >
>
>|||I was thinking that these were somehow related. Only certain regions based
on Global, only certain states based on region, only certain facilities
based on State. If so, they you have each of them based on a dataset where
the dataset query parameter is based on the preceding parameter.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:Oez$zzbvEHA.716@.TK2MSFTNGP10.phx.gbl...
> Yeah, but how can I set up my parameters to be cascading like that?
> IE
> Global requires no parameters
> Region requires a FK of a region
> State requires a two letter state
> Facility requires a facilities key value (int)
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:Ofr5IHTvEHA.1300@.TK2MSFTNGP14.phx.gbl...
> >I think to do this you would want cascading parameters. Then when you
call
> > your stored procedure you will need a wrapper sp that determines which
to
> > call.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in
message
> > news:uzKenwSvEHA.2200@.TK2MSFTNGP11.phx.gbl...
> >> I have a report that has different layers of resolution: Global,
Region,
> > State, Facility and Issue. For different each level
> >> chosen I want to display a different set of parameters and execute a
> > different SP for my dataset (which will return the same rows).
> >> I've seen posts where I can do the dynamic SP calls but I'm stumped on
the
> > showing and hiding of the parameters that I need. I
> >> tried putting a =IIF(blah... as the prompt but that just displayed the
> > expression and didn't evaluate it.
> >>
> >> ANY help is appreciated to keep me from having to do 5 different
reports
> > :)
> >>
> >> Thanks
> >> Scott
> >>
> >>
> >
> >
>

dynamic grouping

Hi,
I have a report with grouping. I am passing a parameter via asp.net and if
that parameter @.paramrep=7 then i want to group by type and by region
otherwise i want to group only by region.
I have looked at Chris Hay's example but I am still not sure i do get it to
work as I keep on getting an error: the expression referenced a non-existing
field in the fields collection.
This is my expression:
=iif(Parameters!Paramreport.Value
=7,1,Fields(iif(Parameters!Paramreport.Value =7,
"region",Parameters!Paramreport.Value)).Value)
I am not sure what I am doing wrong as basically I didn't really understand
the article.
I would appreciate any help offered.
ThanksWhile I haven't seen the example you mention, I often use functions for
dynamic grouping ie...( my syntax here might be bad...)
Public function GetGroups(Byref Groupid as integer, Byref Paramval as
Integer) as String
Switch Paramval
Case 7 If Groupid = 1 Then
Return("Price")
Else Return("Productname")
End IF
Case Else If Groupid = 1 Then
Return("Othercol1")
Else Return("Othercol2")
End IF
End
End
THen in the Grouping dialog
=Fields(GetGroups(1,Parameters!Parametername.Value)).Value
=Fields(GetGroups(2,Parameters!Parametername.Value)).Value
Hope this helps... By the way, sometimes I have to dynamically change the
sort to match the grouping at the highest level, otherwise I have gotten an
error...But the sort is handled the same way..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"collie" <collie@.discussions.microsoft.com> wrote in message
news:416E56D8-9856-412A-8381-A7BBD1DCBAC5@.microsoft.com...
> Hi,
> I have a report with grouping. I am passing a parameter via asp.net and if
> that parameter @.paramrep=7 then i want to group by type and by region
> otherwise i want to group only by region.
> I have looked at Chris Hay's example but I am still not sure i do get it
to
> work as I keep on getting an error: the expression referenced a
non-existing
> field in the fields collection.
> This is my expression:
> =iif(Parameters!Paramreport.Value
> =7,1,Fields(iif(Parameters!Paramreport.Value =7,
> "region",Parameters!Paramreport.Value)).Value)
> I am not sure what I am doing wrong as basically I didn't really
understand
> the article.
> I would appreciate any help offered.
> Thanks|||Hi,
Thanks so much for your response.
I have a few questions about your code if you could please clarify (I feel
stupid for asking but...)
Ok here goes :-)
What do you mean by groupid such as groupid=1?
What is price? A field name to group by if groupid=1?
Parmetername in my case would be the parameter that i send from asp.net
@.paramrep=7 correct?
Thanks
"Wayne Snyder" wrote:
> While I haven't seen the example you mention, I often use functions for
> dynamic grouping ie...( my syntax here might be bad...)
> Public function GetGroups(Byref Groupid as integer, Byref Paramval as
> Integer) as String
> Switch Paramval
> Case 7 If Groupid = 1 Then
> Return("Price")
> Else Return("Productname")
> End IF
> Case Else If Groupid = 1 Then
> Return("Othercol1")
> Else Return("Othercol2")
> End IF
> End
> End
>
> THen in the Grouping dialog
> =Fields(GetGroups(1,Parameters!Parametername.Value)).Value
> =Fields(GetGroups(2,Parameters!Parametername.Value)).Value
> Hope this helps... By the way, sometimes I have to dynamically change the
> sort to match the grouping at the highest level, otherwise I have gotten an
> error...But the sort is handled the same way..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "collie" <collie@.discussions.microsoft.com> wrote in message
> news:416E56D8-9856-412A-8381-A7BBD1DCBAC5@.microsoft.com...
> > Hi,
> >
> > I have a report with grouping. I am passing a parameter via asp.net and if
> > that parameter @.paramrep=7 then i want to group by type and by region
> > otherwise i want to group only by region.
> > I have looked at Chris Hay's example but I am still not sure i do get it
> to
> > work as I keep on getting an error: the expression referenced a
> non-existing
> > field in the fields collection.
> > This is my expression:
> > =iif(Parameters!Paramreport.Value
> > =7,1,Fields(iif(Parameters!Paramreport.Value =7,
> > "region",Parameters!Paramreport.Value)).Value)
> > I am not sure what I am doing wrong as basically I didn't really
> understand
> > the article.
> >
> > I would appreciate any help offered.
> >
> > Thanks
>
>|||Wayne your code was a great help.
Thanks :-)
"Wayne Snyder" wrote:
> While I haven't seen the example you mention, I often use functions for
> dynamic grouping ie...( my syntax here might be bad...)
> Public function GetGroups(Byref Groupid as integer, Byref Paramval as
> Integer) as String
> Switch Paramval
> Case 7 If Groupid = 1 Then
> Return("Price")
> Else Return("Productname")
> End IF
> Case Else If Groupid = 1 Then
> Return("Othercol1")
> Else Return("Othercol2")
> End IF
> End
> End
>
> THen in the Grouping dialog
> =Fields(GetGroups(1,Parameters!Parametername.Value)).Value
> =Fields(GetGroups(2,Parameters!Parametername.Value)).Value
> Hope this helps... By the way, sometimes I have to dynamically change the
> sort to match the grouping at the highest level, otherwise I have gotten an
> error...But the sort is handled the same way..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "collie" <collie@.discussions.microsoft.com> wrote in message
> news:416E56D8-9856-412A-8381-A7BBD1DCBAC5@.microsoft.com...
> > Hi,
> >
> > I have a report with grouping. I am passing a parameter via asp.net and if
> > that parameter @.paramrep=7 then i want to group by type and by region
> > otherwise i want to group only by region.
> > I have looked at Chris Hay's example but I am still not sure i do get it
> to
> > work as I keep on getting an error: the expression referenced a
> non-existing
> > field in the fields collection.
> > This is my expression:
> > =iif(Parameters!Paramreport.Value
> > =7,1,Fields(iif(Parameters!Paramreport.Value =7,
> > "region",Parameters!Paramreport.Value)).Value)
> > I am not sure what I am doing wrong as basically I didn't really
> understand
> > the article.
> >
> > I would appreciate any help offered.
> >
> > Thanks
>
>

Dynamic filenames from scheduled reports

We created a sales history report for a client that has one prompt, Sales
Region, and when they schedule the report all the filenames of the Excel
attachments are the same. They are all the report name.
They would like each file to have a name like
"SalesRegion-SelectedRegion.xls". And possibly the dynamic month generated
in the report from a user defined function.
Is there anyway to include the prompted Sales Region in the filename?
On a related issue I have noticed people discussing doing Data Driven
subscriptions, but even though the report data source credentials are saved
in the report server it is not an option for them.
Any help would be greatly appreciated.Without using Data Driven subscription, the fileshare delivery extension
does not have any means to accomplish this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IST" <IST@.discussions.microsoft.com> wrote in message
news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
> We created a sales history report for a client that has one prompt, Sales
> Region, and when they schedule the report all the filenames of the Excel
> attachments are the same. They are all the report name.
> They would like each file to have a name like
> "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
> generated
> in the report from a user defined function.
> Is there anyway to include the prompted Sales Region in the filename?
> On a related issue I have noticed people discussing doing Data Driven
> subscriptions, but even though the report data source credentials are
> saved
> in the report server it is not an option for them.
> Any help would be greatly appreciated.|||These reports are scheduled to be delivered as Excel attachments. Please
elaborate on your response to this.
"Daniel Reib [MSFT]" wrote:
> Without using Data Driven subscription, the fileshare delivery extension
> does not have any means to accomplish this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "IST" <IST@.discussions.microsoft.com> wrote in message
> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
> > We created a sales history report for a client that has one prompt, Sales
> > Region, and when they schedule the report all the filenames of the Excel
> > attachments are the same. They are all the report name.
> >
> > They would like each file to have a name like
> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
> > generated
> > in the report from a user defined function.
> >
> > Is there anyway to include the prompted Sales Region in the filename?
> >
> > On a related issue I have noticed people discussing doing Data Driven
> > subscriptions, but even though the report data source credentials are
> > saved
> > in the report server it is not an option for them.
> >
> > Any help would be greatly appreciated.
>
>|||When a regular subscription is created the name of the file must be passed
in. The Fileshare extension provides no means for which to add information
dynamically to the name of the generated file. If you used a data driven
subscription you could create the name in the SQL query and have that passed
in as the file name. If the query is smart enough it could generate the
filename with the desired parameter embedded. However, you said DD
subscriptions were not an option, and the Fileshare extension does not have
the ability to do this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IST" <IST@.discussions.microsoft.com> wrote in message
news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
> These reports are scheduled to be delivered as Excel attachments. Please
> elaborate on your response to this.
>
> "Daniel Reib [MSFT]" wrote:
>> Without using Data Driven subscription, the fileshare delivery extension
>> does not have any means to accomplish this.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "IST" <IST@.discussions.microsoft.com> wrote in message
>> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
>> > We created a sales history report for a client that has one prompt,
>> > Sales
>> > Region, and when they schedule the report all the filenames of the
>> > Excel
>> > attachments are the same. They are all the report name.
>> >
>> > They would like each file to have a name like
>> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
>> > generated
>> > in the report from a user defined function.
>> >
>> > Is there anyway to include the prompted Sales Region in the filename?
>> >
>> > On a related issue I have noticed people discussing doing Data Driven
>> > subscriptions, but even though the report data source credentials are
>> > saved
>> > in the report server it is not an option for them.
>> >
>> > Any help would be greatly appreciated.
>>|||Thanks for your assistance Daniel. So there is no way to override the
"report name" as the attachment name in a standard scheduled report
regardless of the render type.
Outside of the fact that you should be able to select the attachment name in
the report manager just like you do the subject when scheduling a report.
i.e. "@.ReportName was executed at @.ExecutionTime"
The sales manager at our client location refuses to open each Excel
spreadsheet attachement in his email to find the sales region and then select
"Save As" with this name for each of their 77 sales regions every month.
I can't blame them. This is supposed to be automated.
Do you have any suggestions to make this work as an automated solution?
If this has to be done via Data Driven Subscriptions, do you have any
information about why a report that has stored credential would not have the
option of data driven subscription? If that works, could you please give me
an example to use for giving these managers their reports with Region/Month
filenames?
I have been using RS since the first public beta. It is an amazing product.
We are just struggling with a few of these detail issues.
Thank you so much for your time.
"Daniel Reib [MSFT]" wrote:
> When a regular subscription is created the name of the file must be passed
> in. The Fileshare extension provides no means for which to add information
> dynamically to the name of the generated file. If you used a data driven
> subscription you could create the name in the SQL query and have that passed
> in as the file name. If the query is smart enough it could generate the
> filename with the desired parameter embedded. However, you said DD
> subscriptions were not an option, and the Fileshare extension does not have
> the ability to do this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "IST" <IST@.discussions.microsoft.com> wrote in message
> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
> > These reports are scheduled to be delivered as Excel attachments. Please
> > elaborate on your response to this.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Without using Data Driven subscription, the fileshare delivery extension
> >> does not have any means to accomplish this.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
> >> > We created a sales history report for a client that has one prompt,
> >> > Sales
> >> > Region, and when they schedule the report all the filenames of the
> >> > Excel
> >> > attachments are the same. They are all the report name.
> >> >
> >> > They would like each file to have a name like
> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
> >> > generated
> >> > in the report from a user defined function.
> >> >
> >> > Is there anyway to include the prompted Sales Region in the filename?
> >> >
> >> > On a related issue I have noticed people discussing doing Data Driven
> >> > subscriptions, but even though the report data source credentials are
> >> > saved
> >> > in the report server it is not an option for them.
> >> >
> >> > Any help would be greatly appreciated.
> >>
> >>
> >>
>
>|||Data driven subscriptions are not supported in the standard edition of RS.
Is it possible that he has that?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IST" <IST@.discussions.microsoft.com> wrote in message
news:956BB75C-B82C-46E6-AA5E-91AEDDD7B0CB@.microsoft.com...
> Thanks for your assistance Daniel. So there is no way to override the
> "report name" as the attachment name in a standard scheduled report
> regardless of the render type.
> Outside of the fact that you should be able to select the attachment name
> in
> the report manager just like you do the subject when scheduling a report.
> i.e. "@.ReportName was executed at @.ExecutionTime"
> The sales manager at our client location refuses to open each Excel
> spreadsheet attachement in his email to find the sales region and then
> select
> "Save As" with this name for each of their 77 sales regions every month.
> I can't blame them. This is supposed to be automated.
> Do you have any suggestions to make this work as an automated solution?
> If this has to be done via Data Driven Subscriptions, do you have any
> information about why a report that has stored credential would not have
> the
> option of data driven subscription? If that works, could you please give
> me
> an example to use for giving these managers their reports with
> Region/Month
> filenames?
> I have been using RS since the first public beta. It is an amazing
> product.
> We are just struggling with a few of these detail issues.
> Thank you so much for your time.
>
> "Daniel Reib [MSFT]" wrote:
>> When a regular subscription is created the name of the file must be
>> passed
>> in. The Fileshare extension provides no means for which to add
>> information
>> dynamically to the name of the generated file. If you used a data driven
>> subscription you could create the name in the SQL query and have that
>> passed
>> in as the file name. If the query is smart enough it could generate the
>> filename with the desired parameter embedded. However, you said DD
>> subscriptions were not an option, and the Fileshare extension does not
>> have
>> the ability to do this.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "IST" <IST@.discussions.microsoft.com> wrote in message
>> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
>> > These reports are scheduled to be delivered as Excel attachments.
>> > Please
>> > elaborate on your response to this.
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Without using Data Driven subscription, the fileshare delivery
>> >> extension
>> >> does not have any means to accomplish this.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "IST" <IST@.discussions.microsoft.com> wrote in message
>> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
>> >> > We created a sales history report for a client that has one prompt,
>> >> > Sales
>> >> > Region, and when they schedule the report all the filenames of the
>> >> > Excel
>> >> > attachments are the same. They are all the report name.
>> >> >
>> >> > They would like each file to have a name like
>> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
>> >> > generated
>> >> > in the report from a user defined function.
>> >> >
>> >> > Is there anyway to include the prompted Sales Region in the
>> >> > filename?
>> >> >
>> >> > On a related issue I have noticed people discussing doing Data
>> >> > Driven
>> >> > subscriptions, but even though the report data source credentials
>> >> > are
>> >> > saved
>> >> > in the report server it is not an option for them.
>> >> >
>> >> > Any help would be greatly appreciated.
>> >>
>> >>
>> >>
>>|||Hello Daniel, That is exactly it. They have the standard version of RS.
Do we have any options using either Email or Fileshare to get a Excel
filename other than the default report name? i.e. Instead of all 77 email
having the same attachment filename "Sales Region.xls" it could be even the a
combination of the report name and report parameter "@.SALESREGION" resulting
in "Sales Region - North East.xls".
Thanks.
"Daniel Reib [MSFT]" wrote:
> Data driven subscriptions are not supported in the standard edition of RS.
> Is it possible that he has that?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "IST" <IST@.discussions.microsoft.com> wrote in message
> news:956BB75C-B82C-46E6-AA5E-91AEDDD7B0CB@.microsoft.com...
> > Thanks for your assistance Daniel. So there is no way to override the
> > "report name" as the attachment name in a standard scheduled report
> > regardless of the render type.
> >
> > Outside of the fact that you should be able to select the attachment name
> > in
> > the report manager just like you do the subject when scheduling a report.
> > i.e. "@.ReportName was executed at @.ExecutionTime"
> >
> > The sales manager at our client location refuses to open each Excel
> > spreadsheet attachement in his email to find the sales region and then
> > select
> > "Save As" with this name for each of their 77 sales regions every month.
> >
> > I can't blame them. This is supposed to be automated.
> >
> > Do you have any suggestions to make this work as an automated solution?
> >
> > If this has to be done via Data Driven Subscriptions, do you have any
> > information about why a report that has stored credential would not have
> > the
> > option of data driven subscription? If that works, could you please give
> > me
> > an example to use for giving these managers their reports with
> > Region/Month
> > filenames?
> >
> > I have been using RS since the first public beta. It is an amazing
> > product.
> > We are just struggling with a few of these detail issues.
> >
> > Thank you so much for your time.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> When a regular subscription is created the name of the file must be
> >> passed
> >> in. The Fileshare extension provides no means for which to add
> >> information
> >> dynamically to the name of the generated file. If you used a data driven
> >> subscription you could create the name in the SQL query and have that
> >> passed
> >> in as the file name. If the query is smart enough it could generate the
> >> filename with the desired parameter embedded. However, you said DD
> >> subscriptions were not an option, and the Fileshare extension does not
> >> have
> >> the ability to do this.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
> >> > These reports are scheduled to be delivered as Excel attachments.
> >> > Please
> >> > elaborate on your response to this.
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Without using Data Driven subscription, the fileshare delivery
> >> >> extension
> >> >> does not have any means to accomplish this.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
> >> >> > We created a sales history report for a client that has one prompt,
> >> >> > Sales
> >> >> > Region, and when they schedule the report all the filenames of the
> >> >> > Excel
> >> >> > attachments are the same. They are all the report name.
> >> >> >
> >> >> > They would like each file to have a name like
> >> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
> >> >> > generated
> >> >> > in the report from a user defined function.
> >> >> >
> >> >> > Is there anyway to include the prompted Sales Region in the
> >> >> > filename?
> >> >> >
> >> >> > On a related issue I have noticed people discussing doing Data
> >> >> > Driven
> >> >> > subscriptions, but even though the report data source credentials
> >> >> > are
> >> >> > saved
> >> >> > in the report server it is not an option for them.
> >> >> >
> >> >> > Any help would be greatly appreciated.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Maybe I am a little confused here. Do you have 77 subscriptions? How are
you generating each file?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IST" <IST@.discussions.microsoft.com> wrote in message
news:B5F42661-0335-4D38-85D1-DCCD47882BC0@.microsoft.com...
> Hello Daniel, That is exactly it. They have the standard version of RS.
> Do we have any options using either Email or Fileshare to get a Excel
> filename other than the default report name? i.e. Instead of all 77 email
> having the same attachment filename "Sales Region.xls" it could be even
> the a
> combination of the report name and report parameter "@.SALESREGION"
> resulting
> in "Sales Region - North East.xls".
> Thanks.
> "Daniel Reib [MSFT]" wrote:
>> Data driven subscriptions are not supported in the standard edition of
>> RS.
>> Is it possible that he has that?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "IST" <IST@.discussions.microsoft.com> wrote in message
>> news:956BB75C-B82C-46E6-AA5E-91AEDDD7B0CB@.microsoft.com...
>> > Thanks for your assistance Daniel. So there is no way to override the
>> > "report name" as the attachment name in a standard scheduled report
>> > regardless of the render type.
>> >
>> > Outside of the fact that you should be able to select the attachment
>> > name
>> > in
>> > the report manager just like you do the subject when scheduling a
>> > report.
>> > i.e. "@.ReportName was executed at @.ExecutionTime"
>> >
>> > The sales manager at our client location refuses to open each Excel
>> > spreadsheet attachement in his email to find the sales region and then
>> > select
>> > "Save As" with this name for each of their 77 sales regions every
>> > month.
>> >
>> > I can't blame them. This is supposed to be automated.
>> >
>> > Do you have any suggestions to make this work as an automated solution?
>> >
>> > If this has to be done via Data Driven Subscriptions, do you have any
>> > information about why a report that has stored credential would not
>> > have
>> > the
>> > option of data driven subscription? If that works, could you please
>> > give
>> > me
>> > an example to use for giving these managers their reports with
>> > Region/Month
>> > filenames?
>> >
>> > I have been using RS since the first public beta. It is an amazing
>> > product.
>> > We are just struggling with a few of these detail issues.
>> >
>> > Thank you so much for your time.
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> When a regular subscription is created the name of the file must be
>> >> passed
>> >> in. The Fileshare extension provides no means for which to add
>> >> information
>> >> dynamically to the name of the generated file. If you used a data
>> >> driven
>> >> subscription you could create the name in the SQL query and have that
>> >> passed
>> >> in as the file name. If the query is smart enough it could generate
>> >> the
>> >> filename with the desired parameter embedded. However, you said DD
>> >> subscriptions were not an option, and the Fileshare extension does not
>> >> have
>> >> the ability to do this.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "IST" <IST@.discussions.microsoft.com> wrote in message
>> >> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
>> >> > These reports are scheduled to be delivered as Excel attachments.
>> >> > Please
>> >> > elaborate on your response to this.
>> >> >
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Without using Data Driven subscription, the fileshare delivery
>> >> >> extension
>> >> >> does not have any means to accomplish this.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
>> >> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
>> >> >> > We created a sales history report for a client that has one
>> >> >> > prompt,
>> >> >> > Sales
>> >> >> > Region, and when they schedule the report all the filenames of
>> >> >> > the
>> >> >> > Excel
>> >> >> > attachments are the same. They are all the report name.
>> >> >> >
>> >> >> > They would like each file to have a name like
>> >> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
>> >> >> > generated
>> >> >> > in the report from a user defined function.
>> >> >> >
>> >> >> > Is there anyway to include the prompted Sales Region in the
>> >> >> > filename?
>> >> >> >
>> >> >> > On a related issue I have noticed people discussing doing Data
>> >> >> > Driven
>> >> >> > subscriptions, but even though the report data source credentials
>> >> >> > are
>> >> >> > saved
>> >> >> > in the report server it is not an option for them.
>> >> >> >
>> >> >> > Any help would be greatly appreciated.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||For the purposes of this question there are two reports involved. One for
Sales Regions and another for Product Regions. Each report has a parameter
for its respective region.
For Sales Region (14 regions) and Product Regions (63 regions) each have a
subscription setup to send as an email.
They originally created 77 reports covering each of the regions and a
subscription to each. Then management decided to make a few modifications to
the report format. Then we were faced with modifying 77 reports anytime
changes were needed. Each report had a unique name so that was the name of
the Excel Attachment.
We created the two reports with parameters so when changes were needed to
the format there were only two reports that needed to be modified. But now
that each region comes from the same report the Excel attachment name is the
same for all reports.
They simply want to setup the subscription to email each region with an
attachment name descriptive of the report. i.e. Sales Region - Southwest.xls
These reports use dynamic dates so the report is always based on the
previous complete month. It would be even better if the email attachment
would have the name "Sales Region - Southwest - 1204.xls" adding the month
year to the attachment name.
Do you have any idea how we could accomplish this? Would it even be
possible to set the email Excel attachment name if we create a custom
application? Is attachment name something that is exposed with the Reporting
Services API?
Thanks.
"Daniel Reib [MSFT]" wrote:
> Maybe I am a little confused here. Do you have 77 subscriptions? How are
> you generating each file?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "IST" <IST@.discussions.microsoft.com> wrote in message
> news:B5F42661-0335-4D38-85D1-DCCD47882BC0@.microsoft.com...
> > Hello Daniel, That is exactly it. They have the standard version of RS.
> >
> > Do we have any options using either Email or Fileshare to get a Excel
> > filename other than the default report name? i.e. Instead of all 77 email
> > having the same attachment filename "Sales Region.xls" it could be even
> > the a
> > combination of the report name and report parameter "@.SALESREGION"
> > resulting
> > in "Sales Region - North East.xls".
> >
> > Thanks.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Data driven subscriptions are not supported in the standard edition of
> >> RS.
> >> Is it possible that he has that?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> news:956BB75C-B82C-46E6-AA5E-91AEDDD7B0CB@.microsoft.com...
> >> > Thanks for your assistance Daniel. So there is no way to override the
> >> > "report name" as the attachment name in a standard scheduled report
> >> > regardless of the render type.
> >> >
> >> > Outside of the fact that you should be able to select the attachment
> >> > name
> >> > in
> >> > the report manager just like you do the subject when scheduling a
> >> > report.
> >> > i.e. "@.ReportName was executed at @.ExecutionTime"
> >> >
> >> > The sales manager at our client location refuses to open each Excel
> >> > spreadsheet attachement in his email to find the sales region and then
> >> > select
> >> > "Save As" with this name for each of their 77 sales regions every
> >> > month.
> >> >
> >> > I can't blame them. This is supposed to be automated.
> >> >
> >> > Do you have any suggestions to make this work as an automated solution?
> >> >
> >> > If this has to be done via Data Driven Subscriptions, do you have any
> >> > information about why a report that has stored credential would not
> >> > have
> >> > the
> >> > option of data driven subscription? If that works, could you please
> >> > give
> >> > me
> >> > an example to use for giving these managers their reports with
> >> > Region/Month
> >> > filenames?
> >> >
> >> > I have been using RS since the first public beta. It is an amazing
> >> > product.
> >> > We are just struggling with a few of these detail issues.
> >> >
> >> > Thank you so much for your time.
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> When a regular subscription is created the name of the file must be
> >> >> passed
> >> >> in. The Fileshare extension provides no means for which to add
> >> >> information
> >> >> dynamically to the name of the generated file. If you used a data
> >> >> driven
> >> >> subscription you could create the name in the SQL query and have that
> >> >> passed
> >> >> in as the file name. If the query is smart enough it could generate
> >> >> the
> >> >> filename with the desired parameter embedded. However, you said DD
> >> >> subscriptions were not an option, and the Fileshare extension does not
> >> >> have
> >> >> the ability to do this.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> >> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
> >> >> > These reports are scheduled to be delivered as Excel attachments.
> >> >> > Please
> >> >> > elaborate on your response to this.
> >> >> >
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Without using Data Driven subscription, the fileshare delivery
> >> >> >> extension
> >> >> >> does not have any means to accomplish this.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> >> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
> >> >> >> > We created a sales history report for a client that has one
> >> >> >> > prompt,
> >> >> >> > Sales
> >> >> >> > Region, and when they schedule the report all the filenames of
> >> >> >> > the
> >> >> >> > Excel
> >> >> >> > attachments are the same. They are all the report name.
> >> >> >> >
> >> >> >> > They would like each file to have a name like
> >> >> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic month
> >> >> >> > generated
> >> >> >> > in the report from a user defined function.
> >> >> >> >
> >> >> >> > Is there anyway to include the prompted Sales Region in the
> >> >> >> > filename?
> >> >> >> >
> >> >> >> > On a related issue I have noticed people discussing doing Data
> >> >> >> > Driven
> >> >> >> > subscriptions, but even though the report data source credentials
> >> >> >> > are
> >> >> >> > saved
> >> >> >> > in the report server it is not an option for them.
> >> >> >> >
> >> >> >> > Any help would be greatly appreciated.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Ok, I have a better idea what is going on now. Unfortunately I don't have
good news. The FileShare Delivery Extension does not have anyway to get
report parameters into the name of the file. It can't do this because the
Delivery API do not give it this information, so you would not be able to
even write your own extension to do this. The only option you have with
Standard is to create the 77 subscriptions, giving each subscription a
unique filename. (You could create 77 linked reports and have each report
have a single subscription. This would make managing them a little easier
since the descriptions of the subscriptions are not helpful)
The best option would be to use DataDriven subscriptions, but that would
require you purchasing the Enterprise Edition.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"IST" <IST@.discussions.microsoft.com> wrote in message
news:BE830564-D7BC-4373-90AF-3A55B75E66E4@.microsoft.com...
> For the purposes of this question there are two reports involved. One for
> Sales Regions and another for Product Regions. Each report has a
> parameter
> for its respective region.
> For Sales Region (14 regions) and Product Regions (63 regions) each have a
> subscription setup to send as an email.
> They originally created 77 reports covering each of the regions and a
> subscription to each. Then management decided to make a few modifications
> to
> the report format. Then we were faced with modifying 77 reports anytime
> changes were needed. Each report had a unique name so that was the name
> of
> the Excel Attachment.
> We created the two reports with parameters so when changes were needed to
> the format there were only two reports that needed to be modified. But
> now
> that each region comes from the same report the Excel attachment name is
> the
> same for all reports.
> They simply want to setup the subscription to email each region with an
> attachment name descriptive of the report. i.e. Sales Region -
> Southwest.xls
> These reports use dynamic dates so the report is always based on the
> previous complete month. It would be even better if the email attachment
> would have the name "Sales Region - Southwest - 1204.xls" adding the month
> year to the attachment name.
> Do you have any idea how we could accomplish this? Would it even be
> possible to set the email Excel attachment name if we create a custom
> application? Is attachment name something that is exposed with the
> Reporting
> Services API?
> Thanks.
>
> "Daniel Reib [MSFT]" wrote:
>> Maybe I am a little confused here. Do you have 77 subscriptions? How
>> are
>> you generating each file?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "IST" <IST@.discussions.microsoft.com> wrote in message
>> news:B5F42661-0335-4D38-85D1-DCCD47882BC0@.microsoft.com...
>> > Hello Daniel, That is exactly it. They have the standard version of
>> > RS.
>> >
>> > Do we have any options using either Email or Fileshare to get a Excel
>> > filename other than the default report name? i.e. Instead of all 77
>> > email
>> > having the same attachment filename "Sales Region.xls" it could be even
>> > the a
>> > combination of the report name and report parameter "@.SALESREGION"
>> > resulting
>> > in "Sales Region - North East.xls".
>> >
>> > Thanks.
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Data driven subscriptions are not supported in the standard edition of
>> >> RS.
>> >> Is it possible that he has that?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "IST" <IST@.discussions.microsoft.com> wrote in message
>> >> news:956BB75C-B82C-46E6-AA5E-91AEDDD7B0CB@.microsoft.com...
>> >> > Thanks for your assistance Daniel. So there is no way to override
>> >> > the
>> >> > "report name" as the attachment name in a standard scheduled report
>> >> > regardless of the render type.
>> >> >
>> >> > Outside of the fact that you should be able to select the attachment
>> >> > name
>> >> > in
>> >> > the report manager just like you do the subject when scheduling a
>> >> > report.
>> >> > i.e. "@.ReportName was executed at @.ExecutionTime"
>> >> >
>> >> > The sales manager at our client location refuses to open each Excel
>> >> > spreadsheet attachement in his email to find the sales region and
>> >> > then
>> >> > select
>> >> > "Save As" with this name for each of their 77 sales regions every
>> >> > month.
>> >> >
>> >> > I can't blame them. This is supposed to be automated.
>> >> >
>> >> > Do you have any suggestions to make this work as an automated
>> >> > solution?
>> >> >
>> >> > If this has to be done via Data Driven Subscriptions, do you have
>> >> > any
>> >> > information about why a report that has stored credential would not
>> >> > have
>> >> > the
>> >> > option of data driven subscription? If that works, could you please
>> >> > give
>> >> > me
>> >> > an example to use for giving these managers their reports with
>> >> > Region/Month
>> >> > filenames?
>> >> >
>> >> > I have been using RS since the first public beta. It is an amazing
>> >> > product.
>> >> > We are just struggling with a few of these detail issues.
>> >> >
>> >> > Thank you so much for your time.
>> >> >
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> When a regular subscription is created the name of the file must be
>> >> >> passed
>> >> >> in. The Fileshare extension provides no means for which to add
>> >> >> information
>> >> >> dynamically to the name of the generated file. If you used a data
>> >> >> driven
>> >> >> subscription you could create the name in the SQL query and have
>> >> >> that
>> >> >> passed
>> >> >> in as the file name. If the query is smart enough it could
>> >> >> generate
>> >> >> the
>> >> >> filename with the desired parameter embedded. However, you said DD
>> >> >> subscriptions were not an option, and the Fileshare extension does
>> >> >> not
>> >> >> have
>> >> >> the ability to do this.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
>> >> >> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
>> >> >> > These reports are scheduled to be delivered as Excel attachments.
>> >> >> > Please
>> >> >> > elaborate on your response to this.
>> >> >> >
>> >> >> >
>> >> >> > "Daniel Reib [MSFT]" wrote:
>> >> >> >
>> >> >> >> Without using Data Driven subscription, the fileshare delivery
>> >> >> >> extension
>> >> >> >> does not have any means to accomplish this.
>> >> >> >>
>> >> >> >> --
>> >> >> >> -Daniel
>> >> >> >> This posting is provided "AS IS" with no warranties, and confers
>> >> >> >> no
>> >> >> >> rights.
>> >> >> >>
>> >> >> >>
>> >> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
>> >> >> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
>> >> >> >> > We created a sales history report for a client that has one
>> >> >> >> > prompt,
>> >> >> >> > Sales
>> >> >> >> > Region, and when they schedule the report all the filenames of
>> >> >> >> > the
>> >> >> >> > Excel
>> >> >> >> > attachments are the same. They are all the report name.
>> >> >> >> >
>> >> >> >> > They would like each file to have a name like
>> >> >> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic
>> >> >> >> > month
>> >> >> >> > generated
>> >> >> >> > in the report from a user defined function.
>> >> >> >> >
>> >> >> >> > Is there anyway to include the prompted Sales Region in the
>> >> >> >> > filename?
>> >> >> >> >
>> >> >> >> > On a related issue I have noticed people discussing doing Data
>> >> >> >> > Driven
>> >> >> >> > subscriptions, but even though the report data source
>> >> >> >> > credentials
>> >> >> >> > are
>> >> >> >> > saved
>> >> >> >> > in the report server it is not an option for them.
>> >> >> >> >
>> >> >> >> > Any help would be greatly appreciated.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||I appreciate your assistance. Thanks.
"Daniel Reib [MSFT]" wrote:
> Ok, I have a better idea what is going on now. Unfortunately I don't have
> good news. The FileShare Delivery Extension does not have anyway to get
> report parameters into the name of the file. It can't do this because the
> Delivery API do not give it this information, so you would not be able to
> even write your own extension to do this. The only option you have with
> Standard is to create the 77 subscriptions, giving each subscription a
> unique filename. (You could create 77 linked reports and have each report
> have a single subscription. This would make managing them a little easier
> since the descriptions of the subscriptions are not helpful)
> The best option would be to use DataDriven subscriptions, but that would
> require you purchasing the Enterprise Edition.
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "IST" <IST@.discussions.microsoft.com> wrote in message
> news:BE830564-D7BC-4373-90AF-3A55B75E66E4@.microsoft.com...
> > For the purposes of this question there are two reports involved. One for
> > Sales Regions and another for Product Regions. Each report has a
> > parameter
> > for its respective region.
> >
> > For Sales Region (14 regions) and Product Regions (63 regions) each have a
> > subscription setup to send as an email.
> >
> > They originally created 77 reports covering each of the regions and a
> > subscription to each. Then management decided to make a few modifications
> > to
> > the report format. Then we were faced with modifying 77 reports anytime
> > changes were needed. Each report had a unique name so that was the name
> > of
> > the Excel Attachment.
> >
> > We created the two reports with parameters so when changes were needed to
> > the format there were only two reports that needed to be modified. But
> > now
> > that each region comes from the same report the Excel attachment name is
> > the
> > same for all reports.
> >
> > They simply want to setup the subscription to email each region with an
> > attachment name descriptive of the report. i.e. Sales Region -
> > Southwest.xls
> > These reports use dynamic dates so the report is always based on the
> > previous complete month. It would be even better if the email attachment
> > would have the name "Sales Region - Southwest - 1204.xls" adding the month
> > year to the attachment name.
> >
> > Do you have any idea how we could accomplish this? Would it even be
> > possible to set the email Excel attachment name if we create a custom
> > application? Is attachment name something that is exposed with the
> > Reporting
> > Services API?
> >
> > Thanks.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Maybe I am a little confused here. Do you have 77 subscriptions? How
> >> are
> >> you generating each file?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> news:B5F42661-0335-4D38-85D1-DCCD47882BC0@.microsoft.com...
> >> > Hello Daniel, That is exactly it. They have the standard version of
> >> > RS.
> >> >
> >> > Do we have any options using either Email or Fileshare to get a Excel
> >> > filename other than the default report name? i.e. Instead of all 77
> >> > email
> >> > having the same attachment filename "Sales Region.xls" it could be even
> >> > the a
> >> > combination of the report name and report parameter "@.SALESREGION"
> >> > resulting
> >> > in "Sales Region - North East.xls".
> >> >
> >> > Thanks.
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Data driven subscriptions are not supported in the standard edition of
> >> >> RS.
> >> >> Is it possible that he has that?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> >> news:956BB75C-B82C-46E6-AA5E-91AEDDD7B0CB@.microsoft.com...
> >> >> > Thanks for your assistance Daniel. So there is no way to override
> >> >> > the
> >> >> > "report name" as the attachment name in a standard scheduled report
> >> >> > regardless of the render type.
> >> >> >
> >> >> > Outside of the fact that you should be able to select the attachment
> >> >> > name
> >> >> > in
> >> >> > the report manager just like you do the subject when scheduling a
> >> >> > report.
> >> >> > i.e. "@.ReportName was executed at @.ExecutionTime"
> >> >> >
> >> >> > The sales manager at our client location refuses to open each Excel
> >> >> > spreadsheet attachement in his email to find the sales region and
> >> >> > then
> >> >> > select
> >> >> > "Save As" with this name for each of their 77 sales regions every
> >> >> > month.
> >> >> >
> >> >> > I can't blame them. This is supposed to be automated.
> >> >> >
> >> >> > Do you have any suggestions to make this work as an automated
> >> >> > solution?
> >> >> >
> >> >> > If this has to be done via Data Driven Subscriptions, do you have
> >> >> > any
> >> >> > information about why a report that has stored credential would not
> >> >> > have
> >> >> > the
> >> >> > option of data driven subscription? If that works, could you please
> >> >> > give
> >> >> > me
> >> >> > an example to use for giving these managers their reports with
> >> >> > Region/Month
> >> >> > filenames?
> >> >> >
> >> >> > I have been using RS since the first public beta. It is an amazing
> >> >> > product.
> >> >> > We are just struggling with a few of these detail issues.
> >> >> >
> >> >> > Thank you so much for your time.
> >> >> >
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> When a regular subscription is created the name of the file must be
> >> >> >> passed
> >> >> >> in. The Fileshare extension provides no means for which to add
> >> >> >> information
> >> >> >> dynamically to the name of the generated file. If you used a data
> >> >> >> driven
> >> >> >> subscription you could create the name in the SQL query and have
> >> >> >> that
> >> >> >> passed
> >> >> >> in as the file name. If the query is smart enough it could
> >> >> >> generate
> >> >> >> the
> >> >> >> filename with the desired parameter embedded. However, you said DD
> >> >> >> subscriptions were not an option, and the Fileshare extension does
> >> >> >> not
> >> >> >> have
> >> >> >> the ability to do this.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> >> >> news:AB59B9E4-9395-4D37-BD0A-43C02CCFAD1B@.microsoft.com...
> >> >> >> > These reports are scheduled to be delivered as Excel attachments.
> >> >> >> > Please
> >> >> >> > elaborate on your response to this.
> >> >> >> >
> >> >> >> >
> >> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >> >
> >> >> >> >> Without using Data Driven subscription, the fileshare delivery
> >> >> >> >> extension
> >> >> >> >> does not have any means to accomplish this.
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> -Daniel
> >> >> >> >> This posting is provided "AS IS" with no warranties, and confers
> >> >> >> >> no
> >> >> >> >> rights.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "IST" <IST@.discussions.microsoft.com> wrote in message
> >> >> >> >> news:5A358241-7057-4E4C-B5B3-F7E5C32D3A2C@.microsoft.com...
> >> >> >> >> > We created a sales history report for a client that has one
> >> >> >> >> > prompt,
> >> >> >> >> > Sales
> >> >> >> >> > Region, and when they schedule the report all the filenames of
> >> >> >> >> > the
> >> >> >> >> > Excel
> >> >> >> >> > attachments are the same. They are all the report name.
> >> >> >> >> >
> >> >> >> >> > They would like each file to have a name like
> >> >> >> >> > "SalesRegion-SelectedRegion.xls". And possibly the dynamic
> >> >> >> >> > month
> >> >> >> >> > generated
> >> >> >> >> > in the report from a user defined function.
> >> >> >> >> >
> >> >> >> >> > Is there anyway to include the prompted Sales Region in the
> >> >> >> >> > filename?
> >> >> >> >> >
> >> >> >> >> > On a related issue I have noticed people discussing doing Data
> >> >> >> >> > Driven
> >> >> >> >> > subscriptions, but even though the report data source
> >> >> >> >> > credentials
> >> >> >> >> > are
> >> >> >> >> > saved
> >> >> >> >> > in the report server it is not an option for them.
> >> >> >> >> >
> >> >> >> >> > Any help would be greatly appreciated.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

dynamic columns: in search of the Tatrix data region

This subject has been much discussed but I haven't found a solution
that really works in my situation.
What we need here is a hybrid table/matrix data region with static
columns on the left and (at least) one dynamic column on the right.
Thus do I reveal my cultural bias and no doubt my ignorance of
Reporting Services as well. Maybe this can be done, but I haven't
figured it out.
Wishlist for this "Tatrix" data region:
1) No corner cell
2) A header row that runs straight across the top like a table
3) Header row repeats on each new page
4) Ability to define n static columns at left or right of region
5) Ability to define at least one dynamic column at right or left of
data region, respectively.
In my case I have an inventory with the usual ItemID, ItemName,
ItemCategory fields in the Dataset. These and other fields are
enterprise-level, common across all business units. An ItemRetailPrice
field is potentially unique to each business unit. Therefore I'd like
to have a Tatrix that would display the enterprise-level fields as
static columns and the business-unit-level field(s) as dynamic columns.
Ideally you could have repeating groups of dynamic columns
growing/shrinking out to the side.
The only kludge so far that looks something like what the customer
wants is a Matrix with an Image in the corner cell, simulating the
headers for the static columns. It's hard to get the Image right since
the dimensions of the corner cell change from format to format. The
corner cell graphic seems to shrink on export to Excel. There's no way
to dynamically change the embedded Image to display the product group
you're looking at in a given report.
Apologies if this has been done and described and I didn't find it,
Highly ObscureHi,
I'm sorry that I could not find a way to do this with Matrix in Reporting
Services. You are welcome to send suggestions for product enhancements that
you would like to see in future versions of Microsoft products to us by
submitting MS Wish to mswish@.microsoft.com. By submitting your concerns,
you can get your voice into the design plans for upcoming versions.
Microsoft takes customer requests and suggestions very seriously. MSWISH is
your voice to the development team. A significant number of the design
change requests come from our customers through the MSWISH alias and the
MSWISH web site. http://www.microsoft.com/mswish. I encourage you to submit
this request.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>NNTP-Posting-Date: Thu, 10 Mar 2005 08:20:34 -0600
>From: "HighlyObscure" <HighlyObscure@.nospam.nospam>
>Subject: dynamic columns: in search of the Tatrix data region
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>User-Agent: XanaNews/1.17.1.2
>MIME-Version: 1.0
>Content-Type: text/plain; charset=iso-8859-1
>Message-ID: <-oGdnd2P_48vyq3fRVn-hw@.giganews.com>
>Date: Thu, 10 Mar 2005 08:20:34 -0600
>Lines: 42
>X-Trace:
sv3-AdcAxaYs02709d1QLmyISb8L5LZ1SscpiD0Uxn9maeA2kWFvFAuwfshGnq4q+8NXAFKwvaVH
CDw2zH1!3UOd+sBB1baL2C/VrYQhkqjo1KZExYUfZWDixZF1cqFUrf7vda8YFYzxJeLF9A==>X-Complaints-To: abuse@.giganews.com
>X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
>X-Postfilter: 1.3.32
>Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP0
8.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.c
om!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews