Parameter drop down boxes alignment

I am doing a report currently and have got 3 parameters in the header. The
problem is that I cannot fit the parameters in 1 line.
Is there a way to correct this.
I wanted the 3 dropdown boxes (assignment, start date, end date) in 1 line.
Thanks,
Kiran.Unfortunately you cannot customize the default layout of the parameter
controls. They will always show 1 or 2 per line. Best way to get the look
and layout that you want is to use the ReportViewer control and then in your
page or windows control you create your own textboxes/list boxes for your
parameters and lay them out however you like. Then you will need to pass the
values into the reportViewer control thru the api.
Let me know if you need samples of this.
Bret Updegraff
http://bretup.spaces.live.com/
"Kiran Vukkadala" wrote:
> I am doing a report currently and have got 3 parameters in the header. The
> problem is that I cannot fit the parameters in 1 line.
> Is there a way to correct this.
> I wanted the 3 dropdown boxes (assignment, start date, end date) in 1 line.
> Thanks,
> Kiran.
>|||Thank you bret. I understand the workaround. It would be appreciated if I
could get some samples. Thanks. mail address is kiranv83@.hotmail..
"Bret" wrote:
> Unfortunately you cannot customize the default layout of the parameter
> controls. They will always show 1 or 2 per line. Best way to get the look
> and layout that you want is to use the ReportViewer control and then in your
> page or windows control you create your own textboxes/list boxes for your
> parameters and lay them out however you like. Then you will need to pass the
> values into the reportViewer control thru the api.
> Let me know if you need samples of this.
> Bret Updegraff
> http://bretup.spaces.live.com/
>
> "Kiran Vukkadala" wrote:
> > I am doing a report currently and have got 3 parameters in the header. The
> > problem is that I cannot fit the parameters in 1 line.
> >
> > Is there a way to correct this.
> > I wanted the 3 dropdown boxes (assignment, start date, end date) in 1 line.
> >
> > Thanks,
> > Kiran.
> >|||OK, but if I use navigation inside a report, the linked report will show up
"in standard way" and I have no control over the parameters, right?
The only way I can imagine is to use url-navigation with relatively complex
concatenated strings like" url/owntargetreport.aspx?parameters".
I would really appreciate examples for this.
"Bret" wrote:
> Unfortunately you cannot customize the default layout of the parameter
> controls. They will always show 1 or 2 per line. Best way to get the look
> and layout that you want is to use the ReportViewer control and then in your
> page or windows control you create your own textboxes/list boxes for your
> parameters and lay them out however you like. Then you will need to pass the
> values into the reportViewer control thru the api.
> Let me know if you need samples of this.
> Bret Updegraff
> http://bretup.spaces.live.com/
>
> "Kiran Vukkadala" wrote:
> > I am doing a report currently and have got 3 parameters in the header. The
> > problem is that I cannot fit the parameters in 1 line.
> >
> > Is there a way to correct this.
> > I wanted the 3 dropdown boxes (assignment, start date, end date) in 1 line.
> >
> > Thanks,
> > Kiran.
> >

Paging Header and Detail

I would like to create a report with header and detail, like an invoice with invoice # and line items. I'd like the invoice # to come from a summary query that breaks 1 invoice # per page. Then I'd like to display the line items below the invoice # on each page, from a second query passing the invoice number as a parameter. How is this done? Do I need a subreport?

ie:

header from summary query:

invoice 101

detail from detail query passed invoice # = 101:

line 1 item A

line 2 item B

line 3 item C

page

header from summary query:

invoice 102

detail from detail query passed invoice # = 102:

line 1 item A

line 2 item B

line 3 item C

page

...

Thanks.

If you want to use two queries, yes, you need a subreport to display the line items.

If you can return all the data in one query, then you just need a table with group (by invoice #). The invoice information would be in the group header, and the line items would be in the detail rows.

Pagination

I have a report which consists of a list item, in which is a rectangle containing a header (as a subreport, but I think that's not relevant) and a subreport. The aforementioned rectangle is specified to include a pagebreak after each occurrence, but that pagebreak is not working as expected.

When I run the report I get 1 subreport on the first page, and exactly two on each subsequent page. Other than the pagination, I am getting very close to what I want. It's too bad that the subreport's pagination is ignored, but I can live with that for now.

Things I've already tried:

The report's pageSize and interactiveSize are both set to landscape

The subreport's report's pageSize and interactiveSize are both set to the actual size that the subreport takes up on the main report (which is ignored anyway)

The list does not have any of the page break options selected.

Any Ideas?

Are you using any visibility condition for subreport or rectangle?

I am asking this becasue page break is not supported with visibility condition.

|||

Thanks for your help.

I have not set any visibility settings away from the default of visible.

|||

Maybe it would help if I explained more of what I'm trying to do...

A single report is run from a single id, but there are several ways of selecting that ID, and some ways should result in batches of reports being generated. (for example, a rep may want to run one report to be mailed to each of their clients). Each report should have just one header at the beginning of it.

My report consists of one big list. In the list there are two subreports, one for the header that should be at the top of each report, and one for the body of the report itself. The list uses a query that returns the IDs that should be included in the batch as its dataset. The ID field is passed as one of the report parameters to the body subreport, with the rest of the parameters for the subreport passed straight through.

I put both of the subreports inside a rectangle (inside the list) to try to force the pagebreak.

<Edit: I removed the bit about table headers in the subreport, because that seems to be working>

|||

I hate to keep bumping my thread, but I need help figuring this out.

Maybe I am making my process too complicated? Is there another way to do what I'm trying to do that will allow the report server to correct the pagination?

Is there more info I could give that would help find a solution?

PageNumber in the body

There is Globals.PageNumber variable that can be used only in page header
and footer.
How can I get page number in page body?
Ola A.Try creating an object in the header or footer (this can be invisible)
and assign the Globals.PageNumber value to it.
Then create an object on the page body, and reference the value of the
object in the header to provide its value.
This is similar to other workarounds, and I think it will work - should
be easy enough to try, anyway...
Ola A. wrote:
> There is Globals.PageNumber variable that can be used only in page
header
> and footer.
> How can I get page number in page body?
> Ola A.|||I tried but i get this error:
The hidden expression for the rectangle â'rectangle4â' refers to the report
item â'rectangle2â'. Report item expressions can only refer to other report
items within the same grouping scope or a containing grouping scope.
The rectangle2 is the one who is in the head and the rectangle4 is in the
body.
Ola A.
"Parker" wrote:
> Try creating an object in the header or footer (this can be invisible)
> and assign the Globals.PageNumber value to it.
> Then create an object on the page body, and reference the value of the
> object in the header to provide its value.
> This is similar to other workarounds, and I think it will work - should
> be easy enough to try, anyway...
>
> Ola A. wrote:
> > There is Globals.PageNumber variable that can be used only in page
> header
> > and footer.
> > How can I get page number in page body?
> >
> > Ola A.
>

PageAudit Property Incorrect redux - with a twist

I am getting this message: "The header for file myfile.mdf is not a valid
database file header. The PageauditProperty is incorrect." However, this is
happening on a full overwrite restore! That is, the Restore goes through
successfully, but then I get the message when the Restore attempts to start
the database.
I created a fresh backup and the same thing happens! If the database was
corrupt, I would have thought the backup process would fail, not the
restore.
Any clues as what to look at?
Thanks for any tips.> If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
BACKUP does not validate database integrity. Run DBCC CHECKDB on your
source database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I am getting this message: "The header for file myfile.mdf is not a valid
> database file header. The PageauditProperty is incorrect." However, this
> is
> happening on a full overwrite restore! That is, the Restore goes through
> successfully, but then I get the message when the Restore attempts to
> start
> the database.
> I created a fresh backup and the same thing happens! If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
> Any clues as what to look at?
> Thanks for any tips.
>|||Thanks for the suggestion. I was afraid that running CHECKDB would send the
main database into suspect mode if there was some header corruption. Is
that possible? So far it is up and running and I am afraid to do the checkdb
without a good backup.
_______________________________

> If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
BACKUP does not validate database integrity. Run DBCC CHECKDB on your
source database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I am getting this message: "The header for file myfile.mdf is not a valid
> database file header. The PageauditProperty is incorrect." However, this
> is
> happening on a full overwrite restore! That is, the Restore goes through
> successfully, but then I get the message when the Restore attempts to
> start
> the database.
> I created a fresh backup and the same thing happens! If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
> Any clues as what to look at?
> Thanks for any tips.
>|||Hi
Backup will backup the corruption, it it exists. That is as good a "good
backup" as you can get.
Look at DTS'ing the data out into another DB as a safety measure.
Regards
Mike
"Neil W." wrote:

> Thanks for the suggestion. I was afraid that running CHECKDB would send th
e
> main database into suspect mode if there was some header corruption. Is
> that possible? So far it is up and running and I am afraid to do the check
db
> without a good backup.
> _______________________________
>
> BACKUP does not validate database integrity. Run DBCC CHECKDB on your
> source database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
>|||Thanks for the reply. Will the database copy wizard be sufficient, or will
that also copy over the corruption?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
Hi
Backup will backup the corruption, it it exists. That is as good a "good
backup" as you can get.
Look at DTS'ing the data out into another DB as a safety measure.
Regards
Mike
"Neil W." wrote:

> Thanks for the suggestion. I was afraid that running CHECKDB would send
the
> main database into suspect mode if there was some header corruption. Is
> that possible? So far it is up and running and I am afraid to do the
checkdb
> without a good backup.
> _______________________________
>
> BACKUP does not validate database integrity. Run DBCC CHECKDB on your
> source database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
this[vbcol=seagreen]
through[vbcol=seagreen]
was[vbcol=seagreen]
>
>|||Hi Neil,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue.
Based on my experience, you are encouraged to check your hardware to see
whether there is any data corruption for your HD or RAID Controller. For
example
PRB: SQL Server Backup Performed on Computer Configured with DPT RAID
Controller Card May Be Invalid
http://support.microsoft.com/kb/268481
For your question, DTS won't copy the corrupted data to the destination.
We appreciate your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

PageAudit Property Incorrect redux - with a twist

I am getting this message: "The header for file myfile.mdf is not a valid
database file header. The PageauditProperty is incorrect." However, this is
happening on a full overwrite restore! That is, the Restore goes through
successfully, but then I get the message when the Restore attempts to start
the database.
I created a fresh backup and the same thing happens! If the database was
corrupt, I would have thought the backup process would fail, not the
restore.
Any clues as what to look at?
Thanks for any tips.> If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
BACKUP does not validate database integrity. Run DBCC CHECKDB on your
source database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I am getting this message: "The header for file myfile.mdf is not a valid
> database file header. The PageauditProperty is incorrect." However, this
> is
> happening on a full overwrite restore! That is, the Restore goes through
> successfully, but then I get the message when the Restore attempts to
> start
> the database.
> I created a fresh backup and the same thing happens! If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
> Any clues as what to look at?
> Thanks for any tips.
>|||Thanks for the suggestion. I was afraid that running CHECKDB would send the
main database into suspect mode if there was some header corruption. Is
that possible? So far it is up and running and I am afraid to do the checkdb
without a good backup.
_______________________________
> If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
BACKUP does not validate database integrity. Run DBCC CHECKDB on your
source database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I am getting this message: "The header for file myfile.mdf is not a valid
> database file header. The PageauditProperty is incorrect." However, this
> is
> happening on a full overwrite restore! That is, the Restore goes through
> successfully, but then I get the message when the Restore attempts to
> start
> the database.
> I created a fresh backup and the same thing happens! If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
> Any clues as what to look at?
> Thanks for any tips.
>|||Hi
Backup will backup the corruption, it it exists. That is as good a "good
backup" as you can get.
Look at DTS'ing the data out into another DB as a safety measure.
Regards
Mike
"Neil W." wrote:
> Thanks for the suggestion. I was afraid that running CHECKDB would send the
> main database into suspect mode if there was some header corruption. Is
> that possible? So far it is up and running and I am afraid to do the checkdb
> without a good backup.
> _______________________________
> > If the database was
> > corrupt, I would have thought the backup process would fail, not the
> > restore.
> BACKUP does not validate database integrity. Run DBCC CHECKDB on your
> source database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
> >I am getting this message: "The header for file myfile.mdf is not a valid
> > database file header. The PageauditProperty is incorrect." However, this
> > is
> > happening on a full overwrite restore! That is, the Restore goes through
> > successfully, but then I get the message when the Restore attempts to
> > start
> > the database.
> >
> > I created a fresh backup and the same thing happens! If the database was
> > corrupt, I would have thought the backup process would fail, not the
> > restore.
> >
> > Any clues as what to look at?
> >
> > Thanks for any tips.
> >
> >
>
>|||Thanks for the reply. Will the database copy wizard be sufficient, or will
that also copy over the corruption?
--
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
Hi
Backup will backup the corruption, it it exists. That is as good a "good
backup" as you can get.
Look at DTS'ing the data out into another DB as a safety measure.
Regards
Mike
"Neil W." wrote:
> Thanks for the suggestion. I was afraid that running CHECKDB would send
the
> main database into suspect mode if there was some header corruption. Is
> that possible? So far it is up and running and I am afraid to do the
checkdb
> without a good backup.
> _______________________________
> > If the database was
> > corrupt, I would have thought the backup process would fail, not the
> > restore.
> BACKUP does not validate database integrity. Run DBCC CHECKDB on your
> source database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
> >I am getting this message: "The header for file myfile.mdf is not a valid
> > database file header. The PageauditProperty is incorrect." However,
this
> > is
> > happening on a full overwrite restore! That is, the Restore goes
through
> > successfully, but then I get the message when the Restore attempts to
> > start
> > the database.
> >
> > I created a fresh backup and the same thing happens! If the database
was
> > corrupt, I would have thought the backup process would fail, not the
> > restore.
> >
> > Any clues as what to look at?
> >
> > Thanks for any tips.
> >
> >
>
>|||Hi Neil,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue.
Based on my experience, you are encouraged to check your hardware to see
whether there is any data corruption for your HD or RAID Controller. For
example
PRB: SQL Server Backup Performed on Computer Configured with DPT RAID
Controller Card May Be Invalid
http://support.microsoft.com/kb/268481
For your question, DTS won't copy the corrupted data to the destination.
We appreciate your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

PageAudit Property Incorrect redux - with a twist

I am getting this message: "The header for file myfile.mdf is not a valid
database file header. The PageauditProperty is incorrect." However, this is
happening on a full overwrite restore! That is, the Restore goes through
successfully, but then I get the message when the Restore attempts to start
the database.
I created a fresh backup and the same thing happens! If the database was
corrupt, I would have thought the backup process would fail, not the
restore.
Any clues as what to look at?
Thanks for any tips.
> If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
BACKUP does not validate database integrity. Run DBCC CHECKDB on your
source database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I am getting this message: "The header for file myfile.mdf is not a valid
> database file header. The PageauditProperty is incorrect." However, this
> is
> happening on a full overwrite restore! That is, the Restore goes through
> successfully, but then I get the message when the Restore attempts to
> start
> the database.
> I created a fresh backup and the same thing happens! If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
> Any clues as what to look at?
> Thanks for any tips.
>
|||Thanks for the suggestion. I was afraid that running CHECKDB would send the
main database into suspect mode if there was some header corruption. Is
that possible? So far it is up and running and I am afraid to do the checkdb
without a good backup.
_______________________________

> If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
BACKUP does not validate database integrity. Run DBCC CHECKDB on your
source database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Neil W." <neilw@.netlib.com> wrote in message
news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I am getting this message: "The header for file myfile.mdf is not a valid
> database file header. The PageauditProperty is incorrect." However, this
> is
> happening on a full overwrite restore! That is, the Restore goes through
> successfully, but then I get the message when the Restore attempts to
> start
> the database.
> I created a fresh backup and the same thing happens! If the database was
> corrupt, I would have thought the backup process would fail, not the
> restore.
> Any clues as what to look at?
> Thanks for any tips.
>
|||Hi
Backup will backup the corruption, it it exists. That is as good a "good
backup" as you can get.
Look at DTS'ing the data out into another DB as a safety measure.
Regards
Mike
"Neil W." wrote:

> Thanks for the suggestion. I was afraid that running CHECKDB would send the
> main database into suspect mode if there was some header corruption. Is
> that possible? So far it is up and running and I am afraid to do the checkdb
> without a good backup.
> _______________________________
>
> BACKUP does not validate database integrity. Run DBCC CHECKDB on your
> source database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
>
>
|||Thanks for the reply. Will the database copy wizard be sufficient, or will
that also copy over the corruption?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
Hi
Backup will backup the corruption, it it exists. That is as good a "good
backup" as you can get.
Look at DTS'ing the data out into another DB as a safety measure.
Regards
Mike
"Neil W." wrote:

> Thanks for the suggestion. I was afraid that running CHECKDB would send
the
> main database into suspect mode if there was some header corruption. Is
> that possible? So far it is up and running and I am afraid to do the
checkdb[vbcol=seagreen]
> without a good backup.
> _______________________________
>
> BACKUP does not validate database integrity. Run DBCC CHECKDB on your
> source database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Neil W." <neilw@.netlib.com> wrote in message
> news:%23UfZF9L9EHA.1452@.TK2MSFTNGP11.phx.gbl...
this[vbcol=seagreen]
through[vbcol=seagreen]
was
>
>
|||Hi Neil,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue.
Based on my experience, you are encouraged to check your hardware to see
whether there is any data corruption for your HD or RAID Controller. For
example
PRB: SQL Server Backup Performed on Computer Configured with DPT RAID
Controller Card May Be Invalid
http://support.microsoft.com/kb/268481
For your question, DTS won't copy the corrupted data to the destination.
We appreciate your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Page Numbers

I need the page numbers in the header (or body if it can work like this) to
reset after a grouping in the body, is this possible?
In Crystal it is the checkbox option in the Section Expert tab called "Reset
Page Number After."I find the easiest way to do this is to use a subreport. I haven't found a
way to do that either other than subreporting it. The page numbers are only
shown on the subreport.
=-Chris
"Joe Astone" <JoeAstone@.discussions.microsoft.com> wrote in message
news:D4A3657B-2DAF-42BE-8A78-37278E851348@.microsoft.com...
>I need the page numbers in the header (or body if it can work like this) to
> reset after a grouping in the body, is this possible?
> In Crystal it is the checkbox option in the Section Expert tab called
> "Reset
> Page Number After."|||Do you have any groupings in your report?
Group A
Page 1
Page 2
Group B
Page 1
What I'm asking is that does the page number reset after each group?
"Christopher Conner" wrote:
> I find the easiest way to do this is to use a subreport. I haven't found a
> way to do that either other than subreporting it. The page numbers are only
> shown on the subreport.
> =-Chris
> "Joe Astone" <JoeAstone@.discussions.microsoft.com> wrote in message
> news:D4A3657B-2DAF-42BE-8A78-37278E851348@.microsoft.com...
> >I need the page numbers in the header (or body if it can work like this) to
> > reset after a grouping in the body, is this possible?
> >
> > In Crystal it is the checkbox option in the Section Expert tab called
> > "Reset
> > Page Number After."
>
>|||yes, my groupings are in a list (on recipient) so it can be mailed out to the
recipients, and i dont want them to see how many total pages are being mailed
out, just how many are being mailed to them
Joe Astone (passport name is company's in case you were wondering)
"Cu Nguyen" wrote:
> Do you have any groupings in your report?
> Group A
> Page 1
> Page 2
> Group B
> Page 1
> What I'm asking is that does the page number reset after each group?
> "Christopher Conner" wrote:
> > I find the easiest way to do this is to use a subreport. I haven't found a
> > way to do that either other than subreporting it. The page numbers are only
> > shown on the subreport.
> >
> > =-Chris
> >
> > "Joe Astone" <JoeAstone@.discussions.microsoft.com> wrote in message
> > news:D4A3657B-2DAF-42BE-8A78-37278E851348@.microsoft.com...
> > >I need the page numbers in the header (or body if it can work like this) to
> > > reset after a grouping in the body, is this possible?
> > >
> > > In Crystal it is the checkbox option in the Section Expert tab called
> > > "Reset
> > > Page Number After."
> >
> >
> >|||the subreport idea didnt work, it cut the header off of the subreport and
still did the total pages should i put it on the main report...any advice?
"Cu Nguyen" wrote:
> Do you have any groupings in your report?
> Group A
> Page 1
> Page 2
> Group B
> Page 1
> What I'm asking is that does the page number reset after each group?
> "Christopher Conner" wrote:
> > I find the easiest way to do this is to use a subreport. I haven't found a
> > way to do that either other than subreporting it. The page numbers are only
> > shown on the subreport.
> >
> > =-Chris
> >
> > "Joe Astone" <JoeAstone@.discussions.microsoft.com> wrote in message
> > news:D4A3657B-2DAF-42BE-8A78-37278E851348@.microsoft.com...
> > >I need the page numbers in the header (or body if it can work like this) to
> > > reset after a grouping in the body, is this possible?
> > >
> > > In Crystal it is the checkbox option in the Section Expert tab called
> > > "Reset
> > > Page Number After."
> >
> >
> >

Page Number problem

Hello,
I have a problem displaying the correct page numbers (or number of pages). I've inserted the page number field into the page header b, it will always shows 1/1, no matter how many pages i got. on the other hands...how do I solve this problem?
Thanks!Make sure you're using the 'Page N of M' field instead of the 'Page Number' field.
Then use the section expert to check if any sections have the 'Reset Page Number After' box ticked.|||erm...i tried it. it still didn't work.

i tried putting it into the report header, it displays the pages correctly, just that the problem is i dont want it to appear on Report Header, i wanted the page number in the Page Header...due to the way the report was designed (customer's format).

Plz advise?|||oh wait...
i works!
thanks!|||ok..now another problem
let say there are 2 page. the first page displays 1/2. but the 2nd page also displays 1/2

how to solve it? thanks~~~

page number outside page header and page footer

how to display page number outside page header and page footer?

Disable paging in the GridView.

In the AJAX library there is a control calledDataPager.

Set it's PagedControlID to the GridView.

This control can be placed anywhere on the Page.

Page Number Needed in Report Header

I need to create a page number in a report header.

I wrote a function to calculate a number, however I do not know how to associate this with a new page event. How can this be handled and is there an easier way?

Here is my simple function:

Public Function getPageNumber(ByRef iPageNo As Integer) As Integer
Dim iNo as Integer
iNo = iNo + 1
Return iNo
End Function

Thanks,

cj

You can put the page number into a report header without using custom code.

Drop a textbox into the report header and use this expression:

=Globals!PageNumber

-Chris

|||

I don't think that will work because the "=Globals!PageNumber" only works in the Page Header, not the Report Header, correct?

I get this error:

The value expression for the textbox ‘textbox97’ refers to the global variable PageNumber or TotalPages. These global variables can be used only in the page header and page footer.

~cj

Page Number display problem when using Cross Tab

I have created a cross tab report using Crystal Report 9. I have placed the Cross Tab object in Group Header section and in Page Footer i am displaying Page Number as well as Company Name in Page Header.
Now, the columns in Cross Tab exceeds the page and therefore goes on next page. Everything works fine, the only thing is the next page does not display Page Header and Page Footer.
What may be the problem ? I have tried placing Cross Tab object Report Header,Report Footer,Page Header,Page Footer but din't got solution.

Thanks in advance.
Chandrakant Shindehttp://support.businessobjects.com/library/kbase/articles/c2008113.asp

this explains the process

dave