Showing posts with label subreport. Show all posts
Showing posts with label subreport. Show all posts

Friday, March 23, 2012

Right Pane of Report

I have a report where I have setup a table and am using a subreport for the header and using the Page footer for the footer (Subreports can't be used in traditional Page Headers. I also have a Right pane. What i'd like to do is create a table that will use the space that isn't the header/footer/right pane for the body of a report but I can't seem to figure it out.
Is there any absolute positioning in RS? I'd love to be able to take the right pane (which is just a rectangle with sub-items) and say, please print this at x,y on every page. Am I asking too much?
My alternative approach (which I don't love) is to create an image of the template and use it as a page background, then draw the data over the the image. But that is hard to maintain long-term.
Ideas? Please?
Thanks,
Shawn Wildermuth
http://adoguy.com
http://magenic.comI haven't tried what you're doing yet, but am very interested in it. Are
you using rectangles to size and position elements? I'm finding that
placing items in rectangles gives me much more control over how they render
relative to each other.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Shawn Wildermuth" <swildermuth_at_adoguydotcom> wrote in message
news:%23qiQwt71EHA.3616@.TK2MSFTNGP11.phx.gbl...
>I have a report where I have setup a table and am using a subreport for the
>header and using the Page footer for the footer (Subreports can't be used
>in traditional Page Headers. I also have a Right pane. What i'd like to
>do is create a table that will use the space that isn't the
>header/footer/right pane for the body of a report but I can't seem to
>figure it out.
> Is there any absolute positioning in RS? I'd love to be able to take the
> right pane (which is just a rectangle with sub-items) and say, please
> print this at x,y on every page. Am I asking too much?
> My alternative approach (which I don't love) is to create an image of the
> template and use it as a page background, then draw the data over the the
> image. But that is hard to maintain long-term.
> Ideas? Please?
> Thanks,
> Shawn Wildermuth
> http://adoguy.com
> http://magenic.com

Monday, March 12, 2012

Reusing parameters in a subreport.

Is it possible to reuse parameters from a primary query to trigger the query in a subreport?

My primary report does totals sold grouped by salesman code, and now we need grand totals per salesmanin the report footer.

So what I did was create a subreport that gives me exactly what I need. Now for my problem. We use the visual basic ActiveX control for our users to query the database for the report.

It was fine before since all the user had to do was enter a from_date, to_date, and a state parameter and the report would do it's thing. Now with the subreport it asks for...

from_date
to_date
state
from_date (SalesManTotals)
to_date (SalesManTotals)
state (SalesManTotals)

So our users are forced to enter the same parameters twice. Once from the VB interface, and then a second time from a Crystal Reports box requesting the same parameters for the subreport.

How can I tell the report to use the first set of parameters for both reports without being requested to enter them a second time for the subreport?Try linking those parameter fields to the field in the subreport that contains that data