subreport for export purposes...help!

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: subreport for export purposes...help!

spazmanian

subreport for export purposes...help!
Posted: Tuesday, March 20, 2007 6:57 PM (GST)

I am wanting a sort of start page for our engineers that looks like a bit like the following:

Search for Part ID?:

then the engineer types in their part id pushes search and it launches a subreport that returns the results. The reason for this is so that he/she can then do an export as (if they want) and manipulate it to suit them. Currently I have everything working but only as a main report. This causes a problem because when you export it it shows a bunch of stuff (the above) at the top which is not needed and everyone complains because they have to remove it (in excel). Any ideas on how to go about this and/or a tutorial or something. Thanks!

Comments:

Author Thread:

JSelburg

subreport for export purposes...help!
Posted: Saturday, April 21, 2007 12:02 AM (GST)

Use a "middle-man" sub report.

Have the users's selection open a subreport that simply displays a text field saying "Click her to view report". Set that text box's navigation property to "Jump To Report". Set the target to be your original sub-report.

This way, it's a completely seperate report and the export will work fine.

I'm not sure if this will work for your specific needs, but it will work.