When you view the report in Report Manager it shows that it is Page 1 of 1
but when I export it to PDF it actually has 437 pages. Which is fine...no
probs there but would like to know the reason that it says Page 1 of 1 rather
than the 437.
Any help would be greatly appreacited on this, as its baffling me.Hi Nat,
Reports can appear different when rendered in different formats. For
example, your report is displayed using HTML in Report Designer preview
mode versus PDF when exported. So it is this formatting in HTML that
can cause the page number issue you describe (HTML has no concept of
page numbers - the whole report is '1' page...)
Maybe these suggestions can help?
1) When you preview a report in report designer, you can press the
<print preview> button (<print layout> in RS2005 if I recall...) on the
preview pane toolbar to display the report with pages (as it would
print out). At least you'll know how many pages the report truly has
this way.
2) If your report has hard page breaks set, you'll see the pages
displayed in preview window automatically.
HTH
Matt A
Reporting Services Newsletter at www.reportarchitex.com
Nat Johnson wrote:
> When you view the report in Report Manager it shows that it is Page 1 of 1
> but when I export it to PDF it actually has 437 pages. Which is fine...no
> probs there but would like to know the reason that it says Page 1 of 1 rather
> than the 437.
> Any help would be greatly appreacited on this, as its baffling me.
Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts
Wednesday, March 28, 2012
Report pages - reduce render time
Is there a way to minimize the number of pages obtained from a report. My report has more than 9000 pages. I want to minimize the number of pages as it would fasten the rendering of the report in excel,pdf formats. how would one do this? is there any expression?. your help is very much appreciated. I am tearing my hair to minimize the time taken to render a report.! help pls!
Thanks,
You say the report is 9000 pages, so what did you have in mind when you say "minimize the number of pages" -- it seems like you already know how big the report is.
If you only need to see some of the 9000 pages at a time, or only certain people need to see certain pages, you should filter the data (preferably at the data source) with parameters and/or UserId.
Report Page Numbering ***Really Urgent****
I need to place on my report "Page # of #". How do I do this as Im unsure of
the number of pages my report will be.
Also have a problem with getting my header details for each report to show
on every page. Have a Name for report, then the start and end dates and a
logo. Haven't put them into actual Page Header Area as the start and end
date bit wont work that way. Any help is appreciated.Someone seemed to have a similar problem:
Find this group in google groups, search on "Data Header on every
page".
They are suggesting to use tables within lists.
HTH
Dom|||Thanks.
"Dom" wrote:
> Someone seemed to have a similar problem:
> Find this group in google groups, search on "Data Header on every
> page".
> They are suggesting to use tables within lists.
> HTH
> Dom
>|||Also, in VS.NET, you should see "page header" under the report menu,
try that to set a page header. You should be able to put in textboxes
for the name, dates, etc...
For your page number issue, add a textbox, edit its properties, and set
its value to ="Page " & Globals!PageNumber & " of " &
Globals!TotalPages
HTH
Dominique|||Super thanks
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Just to let you know what I have for a header. I have one txt box with Name
of Report, an Image Box with Company Logo and another txt box with the
following in it.
=First(Fields!DateFrom.Value, "DateRange") & "to " &
First(Fields!DateTo.Value, "DateRange")
Is this ok to have in a page header area of the report.
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Dear Nat:
Is this giving you an error?
If so, try putting it in the report header (at the top of the body)
Have a good night!
the number of pages my report will be.
Also have a problem with getting my header details for each report to show
on every page. Have a Name for report, then the start and end dates and a
logo. Haven't put them into actual Page Header Area as the start and end
date bit wont work that way. Any help is appreciated.Someone seemed to have a similar problem:
Find this group in google groups, search on "Data Header on every
page".
They are suggesting to use tables within lists.
HTH
Dom|||Thanks.
"Dom" wrote:
> Someone seemed to have a similar problem:
> Find this group in google groups, search on "Data Header on every
> page".
> They are suggesting to use tables within lists.
> HTH
> Dom
>|||Also, in VS.NET, you should see "page header" under the report menu,
try that to set a page header. You should be able to put in textboxes
for the name, dates, etc...
For your page number issue, add a textbox, edit its properties, and set
its value to ="Page " & Globals!PageNumber & " of " &
Globals!TotalPages
HTH
Dominique|||Super thanks
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Just to let you know what I have for a header. I have one txt box with Name
of Report, an Image Box with Company Logo and another txt box with the
following in it.
=First(Fields!DateFrom.Value, "DateRange") & "to " &
First(Fields!DateTo.Value, "DateRange")
Is this ok to have in a page header area of the report.
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Dear Nat:
Is this giving you an error?
If so, try putting it in the report header (at the top of the body)
Have a good night!
Monday, March 26, 2012
Report not exporting full file
I'm using RS sp1 and have a report that's 50 pages long and has 1000
thumbnail images in it (it serves as a products catalog). When I export as
a PDF or tif, only half the data is exported so in the case of the PDF it
cant open because it says its corrupt, and in the case of a tif, it will
open, but the 2nd half of the pages are missing. The downloaded files are
half the size they should be and when downloading, it say's its complete
after 25 seconds even though its downloaded half the data.
My setup:
1) When I run the report on my local machine and its using sql server and
the image files are stored on the local machine, the report will export
fine.
2) When I run the report from my local machine, but its calling sql server
on a remote server and the image file's paths are to the remote server the
report runs OK, but only half the data is exported.
3) When I run the report from the remote server only half the data is
exported.
Any ideas on what might be happening here?
--
moondaddy@.nospam.comI forgot to mention, if I export it to excel or a web archive I get the
followoing error msg:
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Index was outside the bounds of the array.
----
--
Microsoft Reporting Services
Any idea what its refereing to when it says "Index was outside the bounds of
the array."?
moondaddy@.nospam.com
"moondaddy" <moondaddy@.nospam.com> wrote in message
news:%232E93MldEHA.2752@.TK2MSFTNGP12.phx.gbl...
> I'm using RS sp1 and have a report that's 50 pages long and has 1000
> thumbnail images in it (it serves as a products catalog). When I export
as
> a PDF or tif, only half the data is exported so in the case of the PDF it
> cant open because it says its corrupt, and in the case of a tif, it will
> open, but the 2nd half of the pages are missing. The downloaded files are
> half the size they should be and when downloading, it say's its complete
> after 25 seconds even though its downloaded half the data.
> My setup:
> 1) When I run the report on my local machine and its using sql server and
> the image files are stored on the local machine, the report will export
> fine.
> 2) When I run the report from my local machine, but its calling sql
server
> on a remote server and the image file's paths are to the remote server the
> report runs OK, but only half the data is exported.
> 3) When I run the report from the remote server only half the data is
> exported.
> Any ideas on what might be happening here?
> --
> moondaddy@.nospam.com
>|||I had tried to get a report to intentionally abort by throwing an exception in custom code in hopes of being able to not send a subscription if there was no data. Throwing an exception just left me with half a report and no error message just like you described here.
Mike
"moondaddy" wrote:
> I forgot to mention, if I export it to excel or a web archive I get the
> followoing error msg:
> Reporting Services Error
> ----
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Index was outside the bounds of the array.
> ----
> --
> Microsoft Reporting Services
> Any idea what its refereing to when it says "Index was outside the bounds of
> the array."?
>
> --
> moondaddy@.nospam.com
> "moondaddy" <moondaddy@.nospam.com> wrote in message
> news:%232E93MldEHA.2752@.TK2MSFTNGP12.phx.gbl...
> > I'm using RS sp1 and have a report that's 50 pages long and has 1000
> > thumbnail images in it (it serves as a products catalog). When I export
> as
> > a PDF or tif, only half the data is exported so in the case of the PDF it
> > cant open because it says its corrupt, and in the case of a tif, it will
> > open, but the 2nd half of the pages are missing. The downloaded files are
> > half the size they should be and when downloading, it say's its complete
> > after 25 seconds even though its downloaded half the data.
> >
> > My setup:
> > 1) When I run the report on my local machine and its using sql server and
> > the image files are stored on the local machine, the report will export
> > fine.
> > 2) When I run the report from my local machine, but its calling sql
> server
> > on a remote server and the image file's paths are to the remote server the
> > report runs OK, but only half the data is exported.
> > 3) When I run the report from the remote server only half the data is
> > exported.
> >
> > Any ideas on what might be happening here?
> >
> > --
> > moondaddy@.nospam.com
> >
> >
>
>
thumbnail images in it (it serves as a products catalog). When I export as
a PDF or tif, only half the data is exported so in the case of the PDF it
cant open because it says its corrupt, and in the case of a tif, it will
open, but the 2nd half of the pages are missing. The downloaded files are
half the size they should be and when downloading, it say's its complete
after 25 seconds even though its downloaded half the data.
My setup:
1) When I run the report on my local machine and its using sql server and
the image files are stored on the local machine, the report will export
fine.
2) When I run the report from my local machine, but its calling sql server
on a remote server and the image file's paths are to the remote server the
report runs OK, but only half the data is exported.
3) When I run the report from the remote server only half the data is
exported.
Any ideas on what might be happening here?
--
moondaddy@.nospam.comI forgot to mention, if I export it to excel or a web archive I get the
followoing error msg:
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Index was outside the bounds of the array.
----
--
Microsoft Reporting Services
Any idea what its refereing to when it says "Index was outside the bounds of
the array."?
moondaddy@.nospam.com
"moondaddy" <moondaddy@.nospam.com> wrote in message
news:%232E93MldEHA.2752@.TK2MSFTNGP12.phx.gbl...
> I'm using RS sp1 and have a report that's 50 pages long and has 1000
> thumbnail images in it (it serves as a products catalog). When I export
as
> a PDF or tif, only half the data is exported so in the case of the PDF it
> cant open because it says its corrupt, and in the case of a tif, it will
> open, but the 2nd half of the pages are missing. The downloaded files are
> half the size they should be and when downloading, it say's its complete
> after 25 seconds even though its downloaded half the data.
> My setup:
> 1) When I run the report on my local machine and its using sql server and
> the image files are stored on the local machine, the report will export
> fine.
> 2) When I run the report from my local machine, but its calling sql
server
> on a remote server and the image file's paths are to the remote server the
> report runs OK, but only half the data is exported.
> 3) When I run the report from the remote server only half the data is
> exported.
> Any ideas on what might be happening here?
> --
> moondaddy@.nospam.com
>|||I had tried to get a report to intentionally abort by throwing an exception in custom code in hopes of being able to not send a subscription if there was no data. Throwing an exception just left me with half a report and no error message just like you described here.
Mike
"moondaddy" wrote:
> I forgot to mention, if I export it to excel or a web archive I get the
> followoing error msg:
> Reporting Services Error
> ----
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Index was outside the bounds of the array.
> ----
> --
> Microsoft Reporting Services
> Any idea what its refereing to when it says "Index was outside the bounds of
> the array."?
>
> --
> moondaddy@.nospam.com
> "moondaddy" <moondaddy@.nospam.com> wrote in message
> news:%232E93MldEHA.2752@.TK2MSFTNGP12.phx.gbl...
> > I'm using RS sp1 and have a report that's 50 pages long and has 1000
> > thumbnail images in it (it serves as a products catalog). When I export
> as
> > a PDF or tif, only half the data is exported so in the case of the PDF it
> > cant open because it says its corrupt, and in the case of a tif, it will
> > open, but the 2nd half of the pages are missing. The downloaded files are
> > half the size they should be and when downloading, it say's its complete
> > after 25 seconds even though its downloaded half the data.
> >
> > My setup:
> > 1) When I run the report on my local machine and its using sql server and
> > the image files are stored on the local machine, the report will export
> > fine.
> > 2) When I run the report from my local machine, but its calling sql
> server
> > on a remote server and the image file's paths are to the remote server the
> > report runs OK, but only half the data is exported.
> > 3) When I run the report from the remote server only half the data is
> > exported.
> >
> > Any ideas on what might be happening here?
> >
> > --
> > moondaddy@.nospam.com
> >
> >
>
>
Monday, March 12, 2012
Report Manager Not Working
I am suddenly unable to access report manager :
http://localhost/ReportManager/Pages/Folder.aspx
I am getting the error :
Could not find file "C:\WINDOWS\TEMP\_cm2qpki.dll".
The name of the DLL is different each time I try, but the end result
is the same. I can't find much on this. What I did find indicates a
lack of permission. I have tried accessing it with a couple of
different accounts (both were administrators on the server) and
security methods (anonymous access w/ an admin account, integrated
windows , digest, and basic authentication). I still get the same
error. This is Windows 2003 server, and SQL 2000. Any ideas? Thanks in
advance.
EricDOH!
I must have searched the web for an hour and a half for this. As soon
as I posted this I found the solution right here on Google groups:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9f7ef9267b35eb5c/300a9da8cb33b9f7?lnk=gst&q=Report+manager+%22could+not+find+file%22+temp&rnum=1#300a9da8cb33b9f7
http://localhost/ReportManager/Pages/Folder.aspx
I am getting the error :
Could not find file "C:\WINDOWS\TEMP\_cm2qpki.dll".
The name of the DLL is different each time I try, but the end result
is the same. I can't find much on this. What I did find indicates a
lack of permission. I have tried accessing it with a couple of
different accounts (both were administrators on the server) and
security methods (anonymous access w/ an admin account, integrated
windows , digest, and basic authentication). I still get the same
error. This is Windows 2003 server, and SQL 2000. Any ideas? Thanks in
advance.
EricDOH!
I must have searched the web for an hour and a half for this. As soon
as I posted this I found the solution right here on Google groups:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9f7ef9267b35eb5c/300a9da8cb33b9f7?lnk=gst&q=Report+manager+%22could+not+find+file%22+temp&rnum=1#300a9da8cb33b9f7
Friday, March 9, 2012
Report Manager - Page Count Issue
Dear All,
while opening report using Report Manager its show me the no of Pages 6 and
when i Print this report, it will print 8 Pages. So is there any way that
Report Manager shows the no of Printing Pages i.e 8.
Thanx in advance.
Regards,
StephenI think you'll want to adjust your report InteractiveSize property. When
you print, are you printing the htlm rendering, or pdf rendering engine?
Steve MunLeeuw
"Stephen" <faisal@.hotmail.com> wrote in message
news:OD%23e6DZ1GHA.1256@.TK2MSFTNGP04.phx.gbl...
> Dear All,
> while opening report using Report Manager its show me the no of Pages 6
> and when i Print this report, it will print 8 Pages. So is there any way
> that Report Manager shows the no of Printing Pages i.e 8.
> Thanx in advance.
> Regards,
> Stephen
>
>
while opening report using Report Manager its show me the no of Pages 6 and
when i Print this report, it will print 8 Pages. So is there any way that
Report Manager shows the no of Printing Pages i.e 8.
Thanx in advance.
Regards,
StephenI think you'll want to adjust your report InteractiveSize property. When
you print, are you printing the htlm rendering, or pdf rendering engine?
Steve MunLeeuw
"Stephen" <faisal@.hotmail.com> wrote in message
news:OD%23e6DZ1GHA.1256@.TK2MSFTNGP04.phx.gbl...
> Dear All,
> while opening report using Report Manager its show me the no of Pages 6
> and when i Print this report, it will print 8 Pages. So is there any way
> that Report Manager shows the no of Printing Pages i.e 8.
> Thanx in advance.
> Regards,
> Stephen
>
>
Wednesday, March 7, 2012
Report Layout
Hi,
When I preview my Reporting Services Report in VS2005 the report uses 2 separate pages. Even when there is very little data on Page 1 it will display something on Page 2.
How do I get all data on the one page?
Thanks.
Hi,
I guess the reason could be that the body of the report exceeds the width of the page. Try reducing the width of the body.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
|||tried reducing width but no difference|||
Hi,
Could you mention the width of the page and the width of the report body. Also mention the width of the Left and Right margins of the page.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
|||
Body:
Size: 16.75cm(w), 11.25cm(h)
Report:
InteractiveSize: 8.5in(w), 15in(h)
PageSize: 21cm, 30cm
Magins: 2.5cm, 2.5cm
|||Hi,
Ok. So now let us calculate the width of the report.
report body widht = 8.5 in = 21.59 cm.
As I said before, the report width should be less than the width of the page
widht of the page = 16.75 cm
width of the report body = 21.59 cm
Try reducing the width of the report body.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
|||
didn't make a difference.
everything seems fine with the width.
Its the two textboxes located at bottom left of report that appear on the second page.
|||Got it.
There was a ListView in behind one of the tables. Removed that and it works now.
Thanks for the help!
|||Its about the height then. I hope you arent using a control that increases the height of the page, there by throwing the boxes onto a different page.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
|||Ok cool..didn't see your earlier post. Glad you could solve it.
Tuesday, February 21, 2012
Report Header / Group Header repeating on every pages
I'm new on SQL Server Reporting Services.
Now, I have a problem on create a report header / group header which can
repeating on every pages.
However, I can't use the page header because I would like to show data which
retrieved from my passed dataset. Also, I tried to use "Repeat report item
with data region on every page". However, it seems doesn't work.
Using Crystal Report, there are Report Header and Group Header. Thus, I can
set what I want. But, would you suggest how can I do this? Thanks!
MandaHi,
I have been using SQL Server Reporting Services for last 2 motnhs. From
my, knowledge,if you are using a table, then you can give the date in
the table header and make the table header to repeat in all pages by
property settings.
If you want to display data in page header, store the data in a text
box(say, textbox1) in the report, then create another textbox
(textbox2) in the page header. Set the value of textbox2 as
Reportitems!textbox1.value. I believe this should do the trick and you
will get the data in every page.
Manda Ho wrote:
> I'm new on SQL Server Reporting Services.
> Now, I have a problem on create a report header / group header which can
> repeating on every pages.
> However, I can't use the page header because I would like to show data which
> retrieved from my passed dataset. Also, I tried to use "Repeat report item
> with data region on every page". However, it seems doesn't work.
> Using Crystal Report, there are Report Header and Group Header. Thus, I can
> set what I want. But, would you suggest how can I do this? Thanks!
> Manda|||Thanks for your suggestion.
I found there is limitation if using table header, it only allow to use data
from single dataset. And the location of content can't be set flexible even
cells can be merged.
When I tried to use "Reportitems!textbox1.value", "Unrecognized identifier"
is prompted. Do I have something wrong?
"vyshak" <vyshaknr@.gmail.com> wrote in message
news:1139985067.476396.87780@.g14g2000cwa.googlegroups.com...
> Hi,
> I have been using SQL Server Reporting Services for last 2 motnhs. From
> my, knowledge,if you are using a table, then you can give the date in
> the table header and make the table header to repeat in all pages by
> property settings.
> If you want to display data in page header, store the data in a text
> box(say, textbox1) in the report, then create another textbox
> (textbox2) in the page header. Set the value of textbox2 as
> Reportitems!textbox1.value. I believe this should do the trick and you
> will get the data in every page.
> Manda Ho wrote:
> > I'm new on SQL Server Reporting Services.
> >
> > Now, I have a problem on create a report header / group header which can
> > repeating on every pages.
> >
> > However, I can't use the page header because I would like to show data
which
> > retrieved from my passed dataset. Also, I tried to use "Repeat report
item
> > with data region on every page". However, it seems doesn't work.
> >
> > Using Crystal Report, there are Report Header and Group Header. Thus, I
can
> > set what I want. But, would you suggest how can I do this? Thanks!
> >
> > Manda
>|||Yes,
Reporting services only allows one dataset per table, but dont forget,
you can have multiple tables and even/or use that table as a header(by
placing another table aboe the other.)
As to the error that you are getting, did you rename the name for the
text box textbox1?|||Seems it is not possible to show information through another table. If I
show those information under another tables, I couldn't shown it as "Group"
header as they are independent and no linkage can be set for these datasets.
I have created a new textbox (Textbox21) which having value "Testing". And,
I created another new textbox (Textbox27) which make use of the value of
Textbox21 by using
"ReportItem!Textbox21.Value"/"ReportItem!Textbox21.ToString" under its
expression (Because Value is not one of properties for Textbox) . However,
"Unrecognized identifier" found under Expression Dialog. And the following
message found when preview.
----
An error occurred during local report processing.
The definition of the report '/rptLedger' is invalid.
The Value expression for the textbox 'textbox27' contains an error:
[BC30108] 'ReportItem' is a type and cannot be used as an expression.
----
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1140011658.987628.29720@.g43g2000cwa.googlegroups.com...
> Yes,
> Reporting services only allows one dataset per table, but dont forget,
> you can have multiple tables and even/or use that table as a header(by
> placing another table aboe the other.)
> As to the error that you are getting, did you rename the name for the
> text box textbox1?
>|||the proper term is ReportItems! with an 's' ... I dont know if that gave
you the unrecognized error or if you just put a typo in your posting. I hope
it is that simple as it will work for you then.
"Manda Ho" wrote:
> Seems it is not possible to show information through another table. If I
> show those information under another tables, I couldn't shown it as "Group"
> header as they are independent and no linkage can be set for these datasets.
> I have created a new textbox (Textbox21) which having value "Testing". And,
> I created another new textbox (Textbox27) which make use of the value of
> Textbox21 by using
> "ReportItem!Textbox21.Value"/"ReportItem!Textbox21.ToString" under its
> expression (Because Value is not one of properties for Textbox) . However,
> "Unrecognized identifier" found under Expression Dialog. And the following
> message found when preview.
> ----
> An error occurred during local report processing.
> The definition of the report '/rptLedger' is invalid.
> The Value expression for the textbox 'textbox27' contains an error:
> [BC30108] 'ReportItem' is a type and cannot be used as an expression.
> ----
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1140011658.987628.29720@.g43g2000cwa.googlegroups.com...
> > Yes,
> > Reporting services only allows one dataset per table, but dont forget,
> > you can have multiple tables and even/or use that table as a header(by
> > placing another table aboe the other.)
> >
> > As to the error that you are getting, did you rename the name for the
> > text box textbox1?
> >
>
>
Now, I have a problem on create a report header / group header which can
repeating on every pages.
However, I can't use the page header because I would like to show data which
retrieved from my passed dataset. Also, I tried to use "Repeat report item
with data region on every page". However, it seems doesn't work.
Using Crystal Report, there are Report Header and Group Header. Thus, I can
set what I want. But, would you suggest how can I do this? Thanks!
MandaHi,
I have been using SQL Server Reporting Services for last 2 motnhs. From
my, knowledge,if you are using a table, then you can give the date in
the table header and make the table header to repeat in all pages by
property settings.
If you want to display data in page header, store the data in a text
box(say, textbox1) in the report, then create another textbox
(textbox2) in the page header. Set the value of textbox2 as
Reportitems!textbox1.value. I believe this should do the trick and you
will get the data in every page.
Manda Ho wrote:
> I'm new on SQL Server Reporting Services.
> Now, I have a problem on create a report header / group header which can
> repeating on every pages.
> However, I can't use the page header because I would like to show data which
> retrieved from my passed dataset. Also, I tried to use "Repeat report item
> with data region on every page". However, it seems doesn't work.
> Using Crystal Report, there are Report Header and Group Header. Thus, I can
> set what I want. But, would you suggest how can I do this? Thanks!
> Manda|||Thanks for your suggestion.
I found there is limitation if using table header, it only allow to use data
from single dataset. And the location of content can't be set flexible even
cells can be merged.
When I tried to use "Reportitems!textbox1.value", "Unrecognized identifier"
is prompted. Do I have something wrong?
"vyshak" <vyshaknr@.gmail.com> wrote in message
news:1139985067.476396.87780@.g14g2000cwa.googlegroups.com...
> Hi,
> I have been using SQL Server Reporting Services for last 2 motnhs. From
> my, knowledge,if you are using a table, then you can give the date in
> the table header and make the table header to repeat in all pages by
> property settings.
> If you want to display data in page header, store the data in a text
> box(say, textbox1) in the report, then create another textbox
> (textbox2) in the page header. Set the value of textbox2 as
> Reportitems!textbox1.value. I believe this should do the trick and you
> will get the data in every page.
> Manda Ho wrote:
> > I'm new on SQL Server Reporting Services.
> >
> > Now, I have a problem on create a report header / group header which can
> > repeating on every pages.
> >
> > However, I can't use the page header because I would like to show data
which
> > retrieved from my passed dataset. Also, I tried to use "Repeat report
item
> > with data region on every page". However, it seems doesn't work.
> >
> > Using Crystal Report, there are Report Header and Group Header. Thus, I
can
> > set what I want. But, would you suggest how can I do this? Thanks!
> >
> > Manda
>|||Yes,
Reporting services only allows one dataset per table, but dont forget,
you can have multiple tables and even/or use that table as a header(by
placing another table aboe the other.)
As to the error that you are getting, did you rename the name for the
text box textbox1?|||Seems it is not possible to show information through another table. If I
show those information under another tables, I couldn't shown it as "Group"
header as they are independent and no linkage can be set for these datasets.
I have created a new textbox (Textbox21) which having value "Testing". And,
I created another new textbox (Textbox27) which make use of the value of
Textbox21 by using
"ReportItem!Textbox21.Value"/"ReportItem!Textbox21.ToString" under its
expression (Because Value is not one of properties for Textbox) . However,
"Unrecognized identifier" found under Expression Dialog. And the following
message found when preview.
----
An error occurred during local report processing.
The definition of the report '/rptLedger' is invalid.
The Value expression for the textbox 'textbox27' contains an error:
[BC30108] 'ReportItem' is a type and cannot be used as an expression.
----
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1140011658.987628.29720@.g43g2000cwa.googlegroups.com...
> Yes,
> Reporting services only allows one dataset per table, but dont forget,
> you can have multiple tables and even/or use that table as a header(by
> placing another table aboe the other.)
> As to the error that you are getting, did you rename the name for the
> text box textbox1?
>|||the proper term is ReportItems! with an 's' ... I dont know if that gave
you the unrecognized error or if you just put a typo in your posting. I hope
it is that simple as it will work for you then.
"Manda Ho" wrote:
> Seems it is not possible to show information through another table. If I
> show those information under another tables, I couldn't shown it as "Group"
> header as they are independent and no linkage can be set for these datasets.
> I have created a new textbox (Textbox21) which having value "Testing". And,
> I created another new textbox (Textbox27) which make use of the value of
> Textbox21 by using
> "ReportItem!Textbox21.Value"/"ReportItem!Textbox21.ToString" under its
> expression (Because Value is not one of properties for Textbox) . However,
> "Unrecognized identifier" found under Expression Dialog. And the following
> message found when preview.
> ----
> An error occurred during local report processing.
> The definition of the report '/rptLedger' is invalid.
> The Value expression for the textbox 'textbox27' contains an error:
> [BC30108] 'ReportItem' is a type and cannot be used as an expression.
> ----
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1140011658.987628.29720@.g43g2000cwa.googlegroups.com...
> > Yes,
> > Reporting services only allows one dataset per table, but dont forget,
> > you can have multiple tables and even/or use that table as a header(by
> > placing another table aboe the other.)
> >
> > As to the error that you are getting, did you rename the name for the
> > text box textbox1?
> >
>
>
Report Header
It doesn't appear to be possible, but does anyone know of a way to suppress
the Report Header on all pages except the first page?
Thanks
JohnHi there,use visibility->Hidden=iif( Globals!PageNumber =1,True,False)|||You could just have an empty page header, and put whatever you want as a
heading in the body.
"John Grant" wrote:
> It doesn't appear to be possible, but does anyone know of a way to suppress
> the Report Header on all pages except the first page?
> Thanks
> John
the Report Header on all pages except the first page?
Thanks
JohnHi there,use visibility->Hidden=iif( Globals!PageNumber =1,True,False)|||You could just have an empty page header, and put whatever you want as a
heading in the body.
"John Grant" wrote:
> It doesn't appear to be possible, but does anyone know of a way to suppress
> the Report Header on all pages except the first page?
> Thanks
> John
Subscribe to:
Posts (Atom)