Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: DB fields getting jumbled Post Reply Post New Topic
Author Message
maniac
Newbie
Newbie
Avatar

Joined: 17 May 2007
Location: United States
Online Status: Offline
Posts: 28
Quote maniac Replybullet Topic: DB fields getting jumbled
    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.


Edited by maniac - 05 Jun 2007 at 1:38pm
A+ BS MCSE OOP Security+ Web Developer
Get creative, not even.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
maniac
Newbie
Newbie
Avatar

Joined: 17 May 2007
Location: United States
Online Status: Offline
Posts: 28
Quote maniac Replybullet 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.
IP IP Logged
maniac
Newbie
Newbie
Avatar

Joined: 17 May 2007
Location: United States
Online Status: Offline
Posts: 28
Quote maniac Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.