Excel to Excel drill down

I have 2 reports, Parent and Child, Parent drills-down to the Child. The
parent is an RS report which goes directly to Excel, therefore the hyperlink
in the Parent, points to the Child. Now I also want the child to go directly
to Excel, however I can't make it work. I can't use the rs:Format as a
parameter, it won't let me - anybody got this to work please ?
Cheers,
--
Mike StephenI think the closest you can get is instead of using a drillthrough action,
you use an expression to dynamically construct a hyperlink action that uses
URL access to request the report with the desired parameter values and
exports to Excel. You may want to read up in BOL on the Globals collection
(which contains for instance the name of the report server) and how to pass
parameter values correctly encoded on URL access.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Stephen" <MikeStephen@.discussions.microsoft.com> wrote in message
news:EC400A67-E402-4678-A9F1-C509FCFD5873@.microsoft.com...
>I have 2 reports, Parent and Child, Parent drills-down to the Child. The
> parent is an RS report which goes directly to Excel, therefore the
> hyperlink
> in the Parent, points to the Child. Now I also want the child to go
> directly
> to Excel, however I can't make it work. I can't use the rs:Format as a
> parameter, it won't let me - anybody got this to work please ?
> Cheers,
> --
> Mike Stephen|||OK, thanks Robert, I'll have a dig around BOL. If I get the answer I'll post
it here. Cheers,
Mike.
--
Mike Stephen
"Robert Bruckner [MSFT]" wrote:
> I think the closest you can get is instead of using a drillthrough action,
> you use an expression to dynamically construct a hyperlink action that uses
> URL access to request the report with the desired parameter values and
> exports to Excel. You may want to read up in BOL on the Globals collection
> (which contains for instance the name of the report server) and how to pass
> parameter values correctly encoded on URL access.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mike Stephen" <MikeStephen@.discussions.microsoft.com> wrote in message
> news:EC400A67-E402-4678-A9F1-C509FCFD5873@.microsoft.com...
> >I have 2 reports, Parent and Child, Parent drills-down to the Child. The
> > parent is an RS report which goes directly to Excel, therefore the
> > hyperlink
> > in the Parent, points to the Child. Now I also want the child to go
> > directly
> > to Excel, however I can't make it work. I can't use the rs:Format as a
> > parameter, it won't let me - anybody got this to work please ?
> > Cheers,
> > --
> > Mike Stephen
>
>|||OK, I've given a try to the suggestions in BOL - but the problem is to be
able to parameterise the URL. The examples that BOL gives, shows how to
hard-code the URL, fine, but my drill from the Parent to the Child isn't
fixed. How can I parameterise the URL please ?
Many thanks,
Mike.
--
Mike Stephen
"Mike Stephen" wrote:
> OK, thanks Robert, I'll have a dig around BOL. If I get the answer I'll post
> it here. Cheers,
> Mike.
> --
> Mike Stephen
>
> "Robert Bruckner [MSFT]" wrote:
> > I think the closest you can get is instead of using a drillthrough action,
> > you use an expression to dynamically construct a hyperlink action that uses
> > URL access to request the report with the desired parameter values and
> > exports to Excel. You may want to read up in BOL on the Globals collection
> > (which contains for instance the name of the report server) and how to pass
> > parameter values correctly encoded on URL access.
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Mike Stephen" <MikeStephen@.discussions.microsoft.com> wrote in message
> > news:EC400A67-E402-4678-A9F1-C509FCFD5873@.microsoft.com...
> > >I have 2 reports, Parent and Child, Parent drills-down to the Child. The
> > > parent is an RS report which goes directly to Excel, therefore the
> > > hyperlink
> > > in the Parent, points to the Child. Now I also want the child to go
> > > directly
> > > to Excel, however I can't make it work. I can't use the rs:Format as a
> > > parameter, it won't let me - anybody got this to work please ?
> > > Cheers,
> > > --
> > > Mike Stephen
> >
> >
> >|||Just add a textbox in the report and "play" with expressions till the
evaluated expression will generate a URL that contains what you need. The
Globals collection is documented here:
http://msdn.microsoft.com/library/en-us/rscreate/htm/rcr_creating_expressions_v1_7ilv.asp
For instance, start with:
=Globals!ReportServerUrl & "?" & Globals!ReportFolder &
"DrillthroughReportName&rs:Command=Render&rs:Format=EXCEL&rc:Parameters=false&YearParameter="
& Fields!Year.Value
Note: parameter values in general should always get encoded by using
HttpUtility.UrlEncode("<parameter value") - otherwise the generated URL may
be invalid and get blocked by IE, report server, etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Stephen" <MikeStephen@.discussions.microsoft.com> wrote in message
news:4FC84921-27D8-45D5-AEAE-2D2CC63A9542@.microsoft.com...
> OK, I've given a try to the suggestions in BOL - but the problem is to be
> able to parameterise the URL. The examples that BOL gives, shows how to
> hard-code the URL, fine, but my drill from the Parent to the Child isn't
> fixed. How can I parameterise the URL please ?
> Many thanks,
> Mike.
> --
> Mike Stephen
>
> "Mike Stephen" wrote:
>> OK, thanks Robert, I'll have a dig around BOL. If I get the answer I'll
>> post
>> it here. Cheers,
>> Mike.
>> --
>> Mike Stephen
>>
>> "Robert Bruckner [MSFT]" wrote:
>> > I think the closest you can get is instead of using a drillthrough
>> > action,
>> > you use an expression to dynamically construct a hyperlink action that
>> > uses
>> > URL access to request the report with the desired parameter values and
>> > exports to Excel. You may want to read up in BOL on the Globals
>> > collection
>> > (which contains for instance the name of the report server) and how to
>> > pass
>> > parameter values correctly encoded on URL access.
>> >
>> > -- Robert
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Mike Stephen" <MikeStephen@.discussions.microsoft.com> wrote in message
>> > news:EC400A67-E402-4678-A9F1-C509FCFD5873@.microsoft.com...
>> > >I have 2 reports, Parent and Child, Parent drills-down to the Child.
>> > >The
>> > > parent is an RS report which goes directly to Excel, therefore the
>> > > hyperlink
>> > > in the Parent, points to the Child. Now I also want the child to go
>> > > directly
>> > > to Excel, however I can't make it work. I can't use the rs:Format as
>> > > a
>> > > parameter, it won't let me - anybody got this to work please ?
>> > > Cheers,
>> > > --
>> > > Mike Stephen
>> >
>> >
>> >

Excel rendering - Merged cells issue

Hi,
My rendered Excel reports have lot of merged cells (because of the layout I
made in the designer). Therefore when I open it, the excel takes lot of
minutes to open. So the question is: what can I do in order to avoid having
merged cells in the rendered excel file.
TIA,
Gastón.-
PS: I've opened the excel file, unmerged all cells, save, reopen it, and the
problem disapear.Are you using table or matrix?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gastón Pírez" <gaspirez@.adinet.com.uy> wrote in message
news:O28R3kekFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Hi,
> My rendered Excel reports have lot of merged cells (because of the layout
> I made in the designer). Therefore when I open it, the excel takes lot of
> minutes to open. So the question is: what can I do in order to avoid
> having merged cells in the rendered excel file.
> TIA,
> Gastón.-
> PS: I've opened the excel file, unmerged all cells, save, reopen it, and
> the problem disapear.
>
>|||I'm using table.
Thx,
Gastón.-
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23DTU3CfkFHA.576@.TK2MSFTNGP15.phx.gbl...
> Are you using table or matrix?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Gastón Pírez" <gaspirez@.adinet.com.uy> wrote in message
> news:O28R3kekFHA.1948@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> My rendered Excel reports have lot of merged cells (because of the layout
>> I made in the designer). Therefore when I open it, the excel takes lot of
>> minutes to open. So the question is: what can I do in order to avoid
>> having merged cells in the rendered excel file.
>> TIA,
>> Gastón.-
>> PS: I've opened the excel file, unmerged all cells, save, reopen it, and
>> the problem disapear.
>>
>|||OK, here is what I did. Do not have any textboxes above your table. Instead,
add additional header rows. You can merge cells together, put in text and
center so usually I could still get it where it looked similar. For some
reason even though you are merging cells it does it differently when
exporting to Excel. After doing this you will be able to select the data
region and sort the data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gastón Pírez" <paytrue@.newsgroup.nospam> wrote in message
news:uyDMNJfkFHA.1464@.TK2MSFTNGP14.phx.gbl...
> I'm using table.
> Thx,
> Gastón.-
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23DTU3CfkFHA.576@.TK2MSFTNGP15.phx.gbl...
>> Are you using table or matrix?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Gastón Pírez" <gaspirez@.adinet.com.uy> wrote in message
>> news:O28R3kekFHA.1948@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> My rendered Excel reports have lot of merged cells (because of the
>> layout I made in the designer). Therefore when I open it, the excel
>> takes lot of minutes to open. So the question is: what can I do in order
>> to avoid having merged cells in the rendered excel file.
>> TIA,
>> Gastón.-
>> PS: I've opened the excel file, unmerged all cells, save, reopen it, and
>> the problem disapear.
>>
>>
>