Crystal reports across multiple pages

Using crystal reports, I want to display many fields from the database. All the fields does not fit in single page, even with maximum page length. If I have some 30 fields, is it possible to display first 20 fields in page 1 and remaining fields in page 2? And continue the same in page 3/4, 5/6 etc? :confused:Yes. You can format the page layout to do so. Add the 20 fields in page one. Add a New section (i.e. page) then add the remaining 10 fields.

Hope This helps,
Vinny P|||Thanks for the response. :wave:
But, while adding the section, I could not see any option to add the page. There are options to add report header, page header, group header, footers etc, but not for adding the page itself. :confused:
Can you make it more clear?|||I think what shashidharkr had in mind was being able to display very wide reports, one data row on the line, spanning multiple pages horizontally. The answer is "no". You cannot create wider reports than your printer driver supports. This is one of the most annoying limitations of the Crystal Reports. If your printer driver supports A2 landscape, you are lucky, but when displaying and printing this report on another machine or printer, the report will be truncated to whatever other printer driver supports.

The only exception is the crosstab object that can span itself to multiple pages. So there is a tricky workaround to use a hidden crosstab to span a usual report:
http://support.businessobjects.com/library/kbase/articles/c2014205.asp
But it comes with severe limitations (only first page will be spanned, the export to excel will be ruined etc).

For myself, I choose A3-landscape for wide reports. A3 is supported by most printer drivers. For extra-wide reports, I use A2-landscape. On client machine, the report gets truncated on the screen but export to excel will still export all fields.|||wapper,
You got my problem right! ;)

It is really surprising to know that crystal report has such a serious limitation. :o I need to create wide report, which spans across more than one page and thousands of rows of data. Even the workaround suggested by you may not be of much help, as I have many rows of data.

I think it makes no sense to limit the report width based on the paper sizes! If the report is wider, it should span to next page. I understand other reporting tools like cognos has such feature.

Any clue, if crystal report is going to fix this in future releases atleast? I hope this is in Seagate's agends. However, if we want to voice our concern, where can this be raised?|||I think it makes no sense to limit the report width based on the paper sizes! If the report is wider, it should span to next page. I understand other reporting tools like cognos has such feature.

The problem is, Crystal uses windows forms to compose the layout of the report. Forms are related to printer driver. You can experiment with creating custom forms (Control panel-Printers-File-Server properties-Forms) but custom forms are for one computer only, and IIRC there was also a limitation that you cannot create larger forms than some value, can't remember what exactly the limit was.

Any clue, if crystal report is going to fix this in future releases atleast? I hope this is in Seagate's agends. However, if we want to voice our concern, where can this be raised?

If you find such place, please let me know :) I got toooons of stuff to complain about Crystal.|||wapper
Thanks again for the response.

You can experiment with ....
Unfortunately, I can't spend more time on this :) . I have to look for some feasible workarounds. :ehh: I strongly feel that Seagate should resolve this problem. Being widely used report tool, such a major drawback should be addressed immediately. :rolleyes: Still I can't digest that Crystal imposes such a serious limitation on it's users! :(

Just to draw analogy, page width should be independent of paper size as in excel. Irrespective of the width, if paper width is less, excel prints in next page.

I got toooons of stuff to complain about Crystal.
Can the moderators or any others help on this?|||This problem has always been around and it is still not fixed in CR XI. Guess it is some kind of fundamental feature that can't be changed easily. Of course Crystal guys are aware of it because people have been crying for ages but still no solution, only workarounds.

You can try different support options in their web if you want to yell at someone. BTW there is also bunch of forums there. I don't know if those are actually monitored by Crystal.sql

Cross-tab query definition problem

Hi there,
I have got this problem. I want to know which concrete combination of 7
variables gives the maximum value of some non-linear function. I have
created 7 tables (per 1 column) with all possible values of each
variable (e.g. for the first variable: 0.00,0.01,0.02,0.03,...,1.00)
and then made the cross-tab query based on these 7 tables: Select
Max(...) from dbo.var1 cross join dbo.var2 ... cross join dbo.var7.
This query finds the maximum value of the function but how should I
find out which concrete combination of the variables is connected with
this max.value?
I know that it is not clever to use relational DBS for this problem but
I want to find out how quickly SQL server calculates the result.
Thanks a lot.
MilanHello, Milan
You are talking about cross joins, not crosstabs.
You can get the values using something like this:
SELECT Col1, Col2, ...
FROM Table1, Table2, ...
WHERE YourExpression=(
SELECT MAX(YourExpression)
FROM Table1, Table2, ...
)
If you have 7 tables with 100 values each, that would be a total of
100000000000000 combinations (that is one hundred thousand billions). I
would not dare to think how many years it would take for SQL Server to
return the result of this query.
Razvan|||Hello Razvan,
Thanks for your answer. I am sorry for that mistake, of course I ment
cross joins :).
The problem with your solution is that expression for every
combinations have to be calculated two-times. Since the total number of
combinations is great (the number of rows in each table is: 100, 20,
10, 10, 10, 5, 20 resp., which gives 200 mil. combinations) there is a
serious problem with calculation. Is it somehow possible to obtain the
concrete combination of variables which yield the maximum value of that
function within one single query'
Thank you.
Milan|||Another way would be:
SELECT TOP 1 WITH TIES Col1, Col2, ...
FROM Table1, Table2, ...
ORDER BY YourExpression DESC
Razvan