Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Subreport addendum Expand / Collapse
Author
Message
Posted Tuesday, July 09, 2013 7:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 07, 2014 8:54 AM
Points: 68, Visits: 265
I want to provide a report that prints a manifest containing all the products on an order. The report will prompt for a key order number and number of pallets.

I've added the subreport to the order field and when I click it the subreport runs OK but inherits the page layout of the main report. How do I make the subreport keep its page setting?
Post #1471631
Posted Wednesday, July 10, 2013 9:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:24 PM
Points: 197, Visits: 668
I think you need to provide a little more info here: What is the subreport trying to do? If you're clicking an Order Number, possibly to view the details of that order, that's really more like linking to a separate report.

Perhaps you should just make a new completely stand-alone report that will receive the parameters from that first main report, and then you can do the layout and pagination any way you'd like?

A little insight to what you're trying to do will help elicit useful suggestions, though.

Cheers,
EJM
Post #1472224
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse