Report/subreport help?

How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well.

Would you create a subreport or something else, and how many subreports can you have within a report, and if you had more then one where is the best places to insert it in the report and would you know where can I find some info about that.

I hope all of this makes sense,because I am just completely stuck.

Regards"How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well... and if you had more then one where is the best places to insert it in the report"

- I would create 2 subreports. The best place to put them (I think) would be the details section. Make a Details a and a Details b and set the NewPageAfter for Details a.

"how many subreports can you have within a report"

- I'm not sure what the limit is. I have a report that has 3 subreports without a problem.

"where can I find some info about that."

- Not sure about any specific websites, but you can try a search in following links:

Crystal Reports Help:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp|||thanks a lot for your help, I got some good suggestions, I just have to make it work now.

Regards

Report Viewer Information

Does anyone know of a good tutorial to learn how to use the Report Viewer with ASP.NET pages? I will just be stored procedures, and I haven't used a reporting tool before. I tried to make up one just to try it out, but I kept getting table errors. It also referenced the file locally, which I don't think is right for what I need. I am converting Access Reports to the ASP.NET site that will replace the Access application, and I need a report that can be accessed from remote computers though the side. Please help if you have any ideas because I couldn't find much information about this.

try here:

http://www.gotreportviewer.com/

|||I tried that site before, and didn't have too much luck with it, but I was able to figure out some of the basics on my own. Does anyone know how to make it so that the report will be converted horizontally on the PDF file when exported with the report viewer control?

report viewer and reporting services security

i have a web application in studio 2005 using the report viewer control. i have my own security model implemented on my web pages for clients [1..n] each of the [1..n] clients should be able to view reports of their order history. i have the report viewer set up in url mode. the question is that when i have drill downs in my final reports, a user with some tech knowledge, would be able to obtain the url to my sql server running reporting services.

the sql server will not be given a port 80 acess. how do i go about displaying reports without any savvy user being able to locate the server locations/credentials?

i donot want to create windows account for each [1..n] clients as this is ever growing

If by "url mode" you mean hyperlinks pointing to the report URL address, you should rethink your approach. Instead, consider server-side report generation. In this case, SSRS does reasonable job to protect the parameters as you can see by inspecting the drilldown hyperlinks.|||

Teo, thats what i mean. How would i go about the approach that you are suggesting?

- would i have to create subscriptions to generate the reports and save them to disk?

\

|||If i am to use SOAP then the interactive features are not availabe as this read up provides that info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhcvb04/html/vb04k8.asp|||You will host the VS.NET 2005 ReportViewer control on your ASP.NET page and bind it to the server report. If you are new to the Report Viewer control, you may find the following article useful.|||I did read the article but from read ups, the drill down interactive feature is lost when using SOA/web services to gerenate report in 'remote mode'. is that statetment true? if not then i guess this would work out well|||This is incorrect. SSRS 2005 enhances the web service APIs to support interactive features so interactive featues will work with the VS.NET ReportViewer.

report to url

I have a question to ask:
I type
"http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport"
in jump to url box, it will go to open a report named testreport in my report
server. It is good. I want to rename the testreport to a variable name.
If I change testreport to Field!ReportName.Value in stead, then it does
not work, how do you make the Field!ReportName.Value to convert to
testreport. I have other reports in the report server="http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2f" &
Feild!ReportName.Value
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henry Chen" <HenryChen@.discussions.microsoft.com> wrote in message
news:85B76250-BB7F-4C78-96CB-2BB5B0C7804F@.microsoft.com...
>I have a question to ask:
> I type
> "http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport"
> in jump to url box, it will go to open a report named testreport in my
> report
> server. It is good. I want to rename the testreport to a variable name.
> If I change testreport to Field!ReportName.Value in stead, then it does
> not work, how do you make the Field!ReportName.Value to convert to
> testreport. I have other reports in the report server