Crystal Report - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Crystal Report

Author

Topic

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-31 : 01:47:57

Hello,

I got an issue with the Crystal Report 9, i developed the report and then i binded it with the dataset.

Now there is table in the Dataset which has 4 records in it, but when in the report it showing only one record.

The reports has 4 pages but when i scroll to the page 2, that page appear's blank.

Any pointer's if i had missed anything?

Thanks.

Chirag

http://chirikworld.blogspot.com/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-31 : 01:59:35

The first thing I would check is paper size and/or margins.
Also check the layout so that no part is "out of limit" for paper size.

Peter Larsson
Helsingborg, Sweden

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-31 : 02:04:57

Thanks for the reply.

The first record is geting displayed properly only the hassles come for the multiple records.

Its the normal A4 size of paper.

Chirag

http://chirikworld.blogspot.com/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-31 : 02:11:56

Is the "Keep together" option checked?
What about the "Insert new page" (before/after) option?

Peter Larsson
Helsingborg, Sweden

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-31 : 05:57:20

Peter will check and get back to you.

Chirag

http://chirikworld.blogspot.com/

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-31 : 06:20:39

just one of the worse days in office. :-(

Peter, for each and every field on the crystal report, the keep to gather property is true.

and for every section, i made after/before property also true..

Any other pointers?

Chirag

http://chirikworld.blogspot.com/

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-10-31 : 06:47:15

Yes. Give Businees Objects support boards a try. They can help you there a LOT faster and more accurately than we can. You may have your grouping wrong, or a formula wrong, or any of a hundred other little things wrong. We don't really know what question to ask you so that we can narrow down the problem.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-31 : 07:20:48

Thanks dude..

can you give me the link for it .. ??

Chirag

http://chirikworld.blogspot.com/

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-10-31 : 10:09:02

http://technicalsupport.businessobjects.com/KanisaSupportSite/supportcentral/supportcentral.do?id=m1

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-31 : 10:20:54

In the design view, check whether there are lot spaces between each row. If so remove them.

Also try at http://support.businessobjects.com/

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-31 : 10:22:01

Also, do verify database and referesh the report

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources