Page break and on last record problem

Hello,

In crystal these are available-

1- Conditional Page break 'OnLastRecord'- I have few groups and if I put page break it breaks on each group even if that group has 2 rows but I want a break at the end of the page. So is there conditional page break in SSRS 2005.

2- I am also having problem with controlling Number of lines in a page, few pages are very long as compared to others, though when export to pdf it gives according to the page size set, but not while viewing, is there any work around to this in SSRS 2005.

I will appreciate any suggestion or comment.

regards

1 - this might help you get started http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682115&SiteID=1 -- if not, what have you tried so far?

2 - when you say "few pages are very long as compared to others" you have to specify: what output format are you talking about? PDF uses printable page size, HTML uses interactive page size, Excel is different because it's allowed to have as many rows as are within an explicit page break set by your code.

I have tried to define "explicit" and "implicit" page breaks separately; see the grey shaded note close to the beginning of this post: http://spacefold.com/lisa/post/Reset-On-Group-(Page-X-of-XX-in-a-group%2c-within-a-total-Y-of-YY-for-the-report)%2c-SQL-Reporting-Services-Style-.aspx. You will also find something similar referenced in the thread to which I linked above.

The difference between behavior of "implicit" page breaks for different formats isn't a bug requiring a "workaround"; it's a feature <s>. Different formats do have different requirements and that's a fact of output life.

So if you want page breaks based on some condition which is external to formatting requirements for a given output format, IOW consistent across output formats, you need to define what that condition is explicitly.

>L<

|||

Thanks for the reply.

I think I am still having problem.

Here is what I am doing-

I have three groups - 1-Customer, 2-Department,3-Priority and the details.

1- need to break if customer = Inactive

2- need to break if Department = Closed

3- need to break Priority = normal

So I made first group - Group1(Customer) then inside that I made another groupd Group1A(for customer) without any header and footer and changed the Group expresseion with a boolean parameter 'PageBreak' as is mentioned in the article and similarly did the for other groups but still no luck and it is breaking with the Group. Please let me know if I am following this correctly.

I am hiding the boolean parameter as I don't want to prompt it.

thanks

|||

I think you are mixing up a couple of things. The idea of using a parameter had nothing to do with data-based conditional page breaks <s>.

That example I pointed you to had a condition that came in from the outside, so it was a parameter. Your condition has to do with your data, and I didn't mean you to emulate the parameter part . I'm sorry about this...

I wanted you to see the idea of the nested groups in which one group handles your real group break and the other one is responsible for the conditional page break, by grouping on what may be a completely unrelated expression. OK?

I don't have your exact data set but I have created an example with a completely arbitrary page break that is caused by a data condition, instead of the external (parameterized) condition in the other example I pointed to. I will tell you what I did and maybe this will be a better example for you. It isn't going to be *exactly* what you need. But it should show you what you have to do, depending on the effect you're after.

1. I have a table of orders for customers with locale data. I did a query out of this data that looks like this:

Code Snippet

SELECT Customer, Locale FROM OrderHeader ORDER BY Customer

2. In this dataset, let's say I wanted to group by the customer's last name. I only want page breaks if the Locale starts with "N". (I told you it was totally arbitrary! )

3. I set a group on a "normal" group break expression -- in this case

Code Snippet

=Fields!Customer.Value

I set this group to repeat headers since that happened to be where the headers were.

4. I create an outer group on the following, non-normal expression:

Code Snippet

=IIF(LEFT(Fields!Locale.Value,1) ="N",
Fields!Customer.Value,
False)

... and this is the group that has the page break.

Does this help you understand better? The point is, the outer group is going to force a page break when you provide the group break expression with the value that is actually changing, which I've done in the first argument to IIF() here. In the second argument, the value False isn't changing, and the outer group doesn't break.

>L<

|||

Thanks a lot, I thing I got it.

Is there anything like 'OnLastRecord' in SSRS.

and is there a way to get a certain number of rows in a page.

thanks

Packaging VB 6.0 with Crystal report Control

Dear All,

Pls give reply for this problem,this is the last helping source for me,so pls don't leave me without solutions.

I have a problem,pls help me .

I have created the front end application in V.B 6.O and Back end in Sql 2K and iam generating report using Crystal Report 8.5.
Our OS is windows 2k professional.\
My problem is I generated report using Crystal report as a Blank report and called in VB by adding the component Crystal report Control(Crystl32.ocx)

My Problems
1. Iam not able package my Vb application because it is showing Crystl32.ocx file can’t be registered, if I remove this control from VB I can create the package .
2. So I done another way ,by making exe of my VB application ,then create a new project and add all controls I used in my application except Crystal report Control, then I made package of this Project ,then I run the exe file in another computer and also installing the package that I created so that I can use runtime of VB,it is working fine accept reports.if the forms contain any report it gives error like this : Run-time error ‘339’ ,Component Crystl32.ocx or one of its dependencies not correctly registered a file is missing or invalid.
3. So while I add crystal report control I can’t run the application ,so I copied the file Crystl32.ocx and dumped to another machine system32 folder and tried to run “regsvr32 with the path where I stored the file”, while I run this iam getting error like this “LoadLibrary (“C:\i386\system32\Crystl32.ocx”) failed-The specified module could not be found”.
4. so can u help me for that ,I want to run this application in 90 users, this projects related to school attendance register

I will be very Thank full to u all ,if u provide me a solution for this,iam new to Crystal report and my client needs report to be generated in CR.So pls give me a solution for this.

With regards

SaijuRemove Crystal report components then create package for your application. If the process became successful then, ad the components back and make new exe file
Copy new exe file over the one installed at the client machine.
hop this would help you|||Thank u this helped me.
I made the exe & run in all the client computers

Thanks for the reply

SaijuMammen

Package without having to install crystal Report Environment

I 've finished developing system...... I want to install system to client computer without having to install crystal report environament..... Please helpYou need to do a search on the dlls that you need to include with your package.

I use CR 8.5. My version came with a file called runtime.hlp that has a list of everything I need to include depending on what features I used in my program.

Do a search on Crystal's website or on a search engine like www.google.com.

Crystal's website:
http://support.businessobjects.com/search/advsearch.asp

Overflow error

Hi!

I created a VB6 program using MS Access DB and crystal reports 9. It works fine on WinXP, but I sometimes encounter an 'Overflow' error on Win98 SE.

For example, I have report A and B. When I start the program and immediately print report A, I encounter the error. But when I print report B first and then print report A, the errors gone. I think there's really no problem with the code...so what gives?

By the way, on some PCs with Win98, there's no problem too. Weird huh?

Thanks a lot!

This one's urgent...I'm too embarrassed already with the department using the program...I don't want them to think that I'm stupid or something hehe.Is there any link between those two reports?
Did you use any formula?|||Thanks for replying...

Regarding your question, the two reports are not linked...the data are also gathered from different tables, that is, I do all the necessary computations first and then load up a table for specific reports wherein data for the report will be gathered.