Print Page | Close Window

DB fields getting jumbled

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=788
Printed Date: 02 May 2025 at 12:07am


Topic: DB fields getting jumbled
Posted By: maniac
Subject: DB fields getting jumbled
Date Posted: 05 Jun 2007 at 1:06pm

How do you get 20+ fields to line up, meaning page header & details?

They don't match up (e.g. Last Name header has Work Phone details). This occurs using OutputType.ExcelRecord.
 
I know it works because the legacy rpt had it, but it's using the wrong sproc.
 
PDF shows exactly what is in CR9 standalone, but it's all bunched together.
 
Any suggestions?
 
When I get the first rpt working, I'm going to post all my mistakes so someone else can learn from them. Trust me, you're going to laugh ...
 
Hopefully, I can get an reply tomorrow. Enuf coding today ...
 
Thanx in advance for prompt professional reply.


-------------
A+ BS MCSE OOP Security+ Web Developer
Get creative, not even.


Replies:
Posted By: BrianBischof
Date Posted: 05 Jun 2007 at 2:00pm
Business Objects has a great whitepaper on their support site about how to best design reports with Excel. I don't have the link, but it should be easy enough to find.

The problem is that CR tries how to figure out how to match up the fields and it appears that this can be tough to figure out. They've done a better job in CR XI, but I see that you're using .NET 2003. So you are going to have a bit more work on your hands. Check out the whitepaper for good tips.

Also, I would LOVE to see a list of all the mistakes you've made. Some might find it humorous, but it would give me great research material for making sure the book covers the topics in enough details.

Thanx.


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: maniac
Date Posted: 06 Jun 2007 at 5:41am
Will do ... been keeping status rpt for client, along with comments in code
 
Thanx ...


-------------
A+ BS MCSE OOP Security+ Web Developer
Get creative, not even.

Posted By: maniac
Date Posted: 06 Jun 2007 at 12:44pm
I noticed in the design view that some flds had 'red column markers'. That's how I fixed the header/detail err.


-------------
A+ BS MCSE OOP Security+ Web Developer
Get creative, not even.


Print Page | Close Window