Showing posts with label address. Show all posts
Showing posts with label address. Show all posts

Wednesday, March 21, 2012

Reports with fixed position elements

Hi,
I am having a problem with my report. I would like to display this way
----
<Main Report>
Employee Name: XXX Employee Address: xxxx
-----
<Subreport consisting of 2 tables>
Code / Description / Amount ! Code / Description / Amount
XXX XXXXXXX xxxxxx ! XXX XXXXXXXX xxxxxx
XXX XXXXXXX xxxxxx ! XXX XXXXXXXX xxxxxx
----
Total xxxx
xxxx
However, since the data region for the subreport are tables, they almost
always do not have the same height. I would like to set a maximum height for
the table rows where the rows that will not fit will continue on the next
page. Is this possible?
In other words, I need to have the table totals exactly on the 6 inch mark
of the report. How can I do this?
Also, I need to be able to print to a pre-printed form, if I have to (hence
the exact positioning)
Thanks for your help.
RegardsTry setting the bottom margin to force the page break.
"PacMan" <PacMan@.discussions.microsoft.com> wrote in message
news:3C2B22FE-BFFA-483B-8CFE-74D73FA721DE@.microsoft.com...
> Hi,
> I am having a problem with my report. I would like to display this way
> ----
> <Main Report>
> Employee Name: XXX Employee Address: xxxx
> -----
> <Subreport consisting of 2 tables>
> Code / Description / Amount ! Code / Description /
> Amount
> XXX XXXXXXX xxxxxx ! XXX XXXXXXXX
> xxxxxx
> XXX XXXXXXX xxxxxx ! XXX XXXXXXXX
> xxxxxx
> ----
> Total xxxx
> xxxx
>
> However, since the data region for the subreport are tables, they almost
> always do not have the same height. I would like to set a maximum height
> for
> the table rows where the rows that will not fit will continue on the next
> page. Is this possible?
> In other words, I need to have the table totals exactly on the 6 inch mark
> of the report. How can I do this?
> Also, I need to be able to print to a pre-printed form, if I have to
> (hence
> the exact positioning)
> Thanks for your help.
> Regards
>|||Hi Tim,
Thanks for your advice. However, that does not solve the problem of my 2
tables having different lengths. Their subtotals rows (repeated on every
page) should be on the same line.
like this:
---
cost desc amount tax desc amount
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx
xxx xxx xxxx
---
subtotal: xxxx subtotal: xxx
where the 2 tables are separate data regions.
NOT like this
---
cost desc amount tax desc amount
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx --
xxx xxx xxxx subtotal: xxx
--
subtotal: xxxx
Regards,
PM
"Tim Dot NoSpam" wrote:
> Try setting the bottom margin to force the page break.
> "PacMan" <PacMan@.discussions.microsoft.com> wrote in message
> news:3C2B22FE-BFFA-483B-8CFE-74D73FA721DE@.microsoft.com...
> > Hi,
> >
> > I am having a problem with my report. I would like to display this way
> >
> > ----
> >
> > <Main Report>
> >
> > Employee Name: XXX Employee Address: xxxx
> >
> > -----
> >
> > <Subreport consisting of 2 tables>
> >
> > Code / Description / Amount ! Code / Description /
> > Amount
> >
> > XXX XXXXXXX xxxxxx ! XXX XXXXXXXX
> > xxxxxx
> >
> > XXX XXXXXXX xxxxxx ! XXX XXXXXXXX
> > xxxxxx
> >
> > ----
> > Total xxxx
> > xxxx
> >
> >
> >
> > However, since the data region for the subreport are tables, they almost
> > always do not have the same height. I would like to set a maximum height
> > for
> > the table rows where the rows that will not fit will continue on the next
> > page. Is this possible?
> >
> > In other words, I need to have the table totals exactly on the 6 inch mark
> > of the report. How can I do this?
> >
> > Also, I need to be able to print to a pre-printed form, if I have to
> > (hence
> > the exact positioning)
> >
> > Thanks for your help.
> >
> > Regards
> >
>
>

Monday, February 20, 2012

reporting services works over internet ?

Is it possible to access reports from internet, using a public address like
http://www.mydomain.com/reports instead of http://myserver/reports ? How can
I do it ?
Thanks
MorenoChange the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
-Steve
"Moreno" <movendra@.yahoo.com> wrote in message
news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Is it possible to access reports from internet, using a public address
like
> http://www.mydomain.com/reports instead of http://myserver/reports ? How
can
> I do it ?
> Thanks
> Moreno
>|||I did that, restarted Reporting services as well. But doesnt work.
It says "Directory Listing Denied"
"Stephen Walch" wrote:
> Change the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> -Steve
> "Moreno" <movendra@.yahoo.com> wrote in message
> news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Is it possible to access reports from internet, using a public address
> like
> > http://www.mydomain.com/reports instead of http://myserver/reports ? How
> can
> > I do it ?
> >
> > Thanks
> > Moreno
> >
> >
>
>|||Hello,
Have you tried the url http://www.mydomain.com/reportserver ?
you will be independant of web application parameters ReportManager.
Have you set Directory Security of your Web Application under IIS ?
Is your client authenticated against your application ?
HTH
Jerome Berthaud (MCSD)
http://www.winsight.fr
"AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
news:05359046-2E28-4402-BED3-8F3F3FC70B1A@.microsoft.com...
> I did that, restarted Reporting services as well. But doesnt work.
> It says "Directory Listing Denied"
> "Stephen Walch" wrote:
> > Change the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
> > Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> >
> > -Steve
> >
> > "Moreno" <movendra@.yahoo.com> wrote in message
> > news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > > Is it possible to access reports from internet, using a public address
> > like
> > > http://www.mydomain.com/reports instead of http://myserver/reports ?
How
> > can
> > > I do it ?
> > >
> > > Thanks
> > > Moreno
> > >
> > >
> >
> >
> >|||Jerome,
I have the same problem in earlier post of 10/15 that received no replies.
I've had 5 folks email me with the same problem.
I have Server2003/SQL2000/IIS6 and have just installed Reporting services. I
have two websites on the server. Access to reports is fine using the
http://servername/reportServer, and using IUSR_servername, but even when
adding the following:
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExternalURL>
</UI>
and
I've added virtual directories under above domain for reportManager and
reportServer giving appropriate read/execute permissions and security under
IIS to IUSR account only - no clear no windows authentication.
I continue to get: HTTP Error 403.8 - Forbidden
I've reset permission on website with ISUR account, flushed dns on
webserver, and flushed dns on domain controller.
Multiple websites continue to work fine, but same error whenever I try to
use a domain instead of server name.
Thanks,
Janet
"Jerome BERTHAUD" wrote:
> Hello,
> Have you tried the url http://www.mydomain.com/reportserver ?
> you will be independant of web application parameters ReportManager.
> Have you set Directory Security of your Web Application under IIS ?
> Is your client authenticated against your application ?
> HTH
> Jerome Berthaud (MCSD)
> http://www.winsight.fr
> "AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
> news:05359046-2E28-4402-BED3-8F3F3FC70B1A@.microsoft.com...
> > I did that, restarted Reporting services as well. But doesnt work.
> > It says "Directory Listing Denied"
> >
> > "Stephen Walch" wrote:
> >
> > > Change the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
> > > Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> > >
> > > -Steve
> > >
> > > "Moreno" <movendra@.yahoo.com> wrote in message
> > > news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > > > Is it possible to access reports from internet, using a public address
> > > like
> > > > http://www.mydomain.com/reports instead of http://myserver/reports ?
> How
> > > can
> > > > I do it ?
> > > >
> > > > Thanks
> > > > Moreno
> > > >
> > > >
> > >
> > >
> > >
>
>