how to call Excel file in SSRS

Hi ,

I have one report in SSRS , in my report I have one table that display severel links,

and when I click in one line in the table I want to display the Excel file linked to this line.

exemmple :

Line1: Report Balance

Line2: Report Statistic

.....

and When i click on the line1 it will call one Excel file called RPTBAL.xls

Thanks for your help

Where are these Excel files? On a web server? If so, you can add a hyperlink expression that points to the Excel file for each row.

You can't add them on an entire row but you could add them on all the textboxes in the row. You can also make the hyperlink dynamic based on the content of the textbox. That way each row could point to a different file.

|||

Thanks for your eplay , is correct and I tested it and it works fine,

but each time it gives meesage when I call this Excel file , so please you have solution about this , to don't ask me in each call ,

I have the same problem in sharepoint when I call Excel file it dispay message before to open the file .

Regards

How to call and pass parameters to Subreport using AWC.RS.Extensio

I am using AWC.RS.Extension to develop both my main and subreport. The
subreport links to the main report through a main report field.
I can pass the xml to the main report by @.DataSource parameter and it works
fine. I also can call the subreport directly (as if it is the main report)
by passing the xml to it through @.DataSource as well.
I don't know how to code both the main and subreport together and pass
parameters to them through their @.DataSource!
Please help!I'm not familiar with exactly what you are doing here but it seems like
@.Datasource is a report parameter in both the main and subreport. So, put
the subreport in the main report. Right click on the subreport, properties,
parameters and set the parameter for the subreport to the parameter from the
main report. This allows you to chain together a parameter from the main and
pass it on to the subreport.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trancomp" <Trancomp@.discussions.microsoft.com> wrote in message
news:0918BA5D-7456-4B9E-980F-EAECF2A7407F@.microsoft.com...
> I am using AWC.RS.Extension to develop both my main and subreport. The
> subreport links to the main report through a main report field.
> I can pass the xml to the main report by @.DataSource parameter and it
works
> fine. I also can call the subreport directly (as if it is the main
report)
> by passing the xml to it through @.DataSource as well.
> I don't know how to code both the main and subreport together and pass
> parameters to them through their @.DataSource!
> Please help!
>|||Bruce, thanks for your reply, I already know how to do the report and
subreport the 'normal' way just like you described.
I am using the data extension from AWC.RS.Extension , I retrieve all the
data first in my code and convert the data to XML stream and then pass the
XML as datasource to the report and subreport. I know how to call the main
report and pass XML as datasource to it, I just don't know how to code the
call to the subreport and pass data to it as XML.
Thanks,
"Bruce L-C [MVP]" wrote:
> I'm not familiar with exactly what you are doing here but it seems like
> @.Datasource is a report parameter in both the main and subreport. So, put
> the subreport in the main report. Right click on the subreport, properties,
> parameters and set the parameter for the subreport to the parameter from the
> main report. This allows you to chain together a parameter from the main and
> pass it on to the subreport.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trancomp" <Trancomp@.discussions.microsoft.com> wrote in message
> news:0918BA5D-7456-4B9E-980F-EAECF2A7407F@.microsoft.com...
> > I am using AWC.RS.Extension to develop both my main and subreport. The
> > subreport links to the main report through a main report field.
> >
> > I can pass the xml to the main report by @.DataSource parameter and it
> works
> > fine. I also can call the subreport directly (as if it is the main
> report)
> > by passing the xml to it through @.DataSource as well.
> >
> > I don't know how to code both the main and subreport together and pass
> > parameters to them through their @.DataSource!
> >
> > Please help!
> >
>
>