How to set the page break using parameter value?

[foru11]

Not sure where should I post this que but actually did post it at Business Objects: Crystal Enterprise. Now I repost at here. Hoping that I am able to get help from here.

Below is my case.

I have 3 parameters passing in to the report, which not store in the datasource. The parameters are start_page_no, no_of_pages and start_page_no.

I placed all the information under GH, which I grouped using a field from datasource. No detail section is being used here. I need to use the parameters passing to print start_page_no/start_page_no.

Example of the scenario:
start_page_no: 6
no_of_pages : 4
total_page : 9

The output should be at 1st page prints 6/9. 2nd page is 7/9, 3rd page is 8/9 and the last page is 9/9. It will only have 4 pages bcoz the no_of_pages is 4. The page break should based on the no_of_pages passed in.

If the no_of_pages is 3, then the result will only have 3 pages.

Would like to know how can I display the output as mentioned?

Hope you can understand my question here. Thanks alot for helping..

 

[lbass]

BO: Crystal Enterprise is a forum for issues related to distribution of reports via the Enterprise application, so that wasn't the correct forum.

Can you clarify whether the page numbers you want to suppress are the Crystal Reports page numbers or do you actually have a database field for page number? The issue is that CR page N of M is determined after a report has been generated--but that means AFTER you have suppressed sections. So if you tried to suppress pages 1 to 5 in order to display pages 6 to 9, pages 6 to 9 would be renumbered 1 to 5 and would also be suppressed.

Why do you want to print certain report sections? Do they correspond to some group? You should be establishing parameters that relate to database fields, NOT to printtime variables, so if you can explain the logic, there is probably a better approach.

-LB

 

[foru11]

Hi LB, thanks for letting me know the purpose of BO: Crystal Enterprise and replying to this thread.

Actually I am not going to suppress any pages in the CR. The page number is just a parameter passing to CR. It is not being stored anywhere in database.

The purpose of the start_page_no is only for "in case". In case the printing somehow stops halfway of unseen circumstances, then it will allow user to key in the start page to start printing again. So in this "in case" scenario, the 1st page of CR will be printing as start_page_no/total_page. This is the logic explained by my supervisor. Hope this able to help you get a clearer picture.

 

[lbass]

As far as I know, there is no way of controlling the print function conditionally using a formula, which is what would be required here. I'm not sure whether third-party tools might be able to add this functionality. Are you using BO Enterprise? It's also possible that BOE allows for that kind of functionality--I just don't know.

-LB

 

[foru11]

If it's so, meaning this requirement will not be able to make it, am I right?

I think I am using CR Professional Edition.

 

[foru11]

CR practise is it will generate the report and page break by its own. Is it possible for me to determine no of pages to be printed? Like what I needed here. 1/4, 2/4, 3/4..... whereby '4' is the no_of_pages parameter.

Maybe you can have a look at the sample from link below.

http://www.mediafire.com/?rmpu2aggg5gqapl

Thx..

 

[lbass]

You keep referring to a page break, but your explanation relates to printing certain pages in a document, not to where a new page starts.

I am unsure how your sample data was supposed to illustrate the issue.

It sounds like you want to be able to tell CR using a formula that references a parameter, what pages to print, but no, you can't do this based on a field (page no) that is based on a printing sequence, as I explained earlier.

-LB

 

[foru11]

OK I understand your explanation. Thx for fast response.

If not to talk about the certain pages to print, is it possible to set how many pages to print in CR? Similar concept to the Windows Print function whereby we can set how many pages to print at once with every page having the same data.

Using the sample data, the "1/4" will be printed at 1st page, then 2nd page will print "2/4", 3rd page is "3/4" and the last page is "4/4".

Is this something possible to be done?

Thx

 

[lbass]

This is a feature/function of the printer, not CR.

-LB

 

[foru11]

Thx LB. I will know how to explain to my boss.