Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Formula to view Data in a certain Row? Post Reply Post New Topic
Author Message
J.J.
Newbie
Newbie


Joined: 08 Dec 2009
Online Status: Offline
Posts: 9
Quote J.J. Replybullet Topic: Formula to view Data in a certain Row?
    Posted: 08 Dec 2009 at 11:13am
I'm trying to create a Credit Application in Crystal Reports and show the debts of users. The database is ODBC on a AS400 and the data for this information is in rows tied to a Sequence {LWDEBT.CDSEQ}.

For instance:
Seq 1 = {CDTYPE} {CDDESC} {CDCRED} {CDBAL}...
Seq 2 = {CDTYPE} {CDDESC} {CDCRED} {CDBAL}...
Seq 3 = {CDTYPE} {CDDESC} {CDCRED} {CDBAL}...
Seq 4 = {CDTYPE} {CDDESC} {CDCRED} {CDBAL}...
Seq 5 = {CDTYPE} {CDDESC} {CDCRED} {CDBAL}...

Whenever I add {CDTYPE} to a report, it will only show the first row (sequence). How do I display another row like the 2nd or 3rd for {CDTYPE} using a Formula field.

I know Insert/ Cross-Tab works but I do not want that format. Can you please help?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 09 Dec 2009 at 6:30am
I can't say that I have ever seen this behavior. My first guess is that there is a grouping that is being applied where only 1 CDType is available to be displayed, or the CDType is being displayed in a footer or header, which only prints, basically, 1 record (the current one, first or last, of a group).
 
If the later, I would probably create a delimited string and stored it either in a shared stringvar or shared stringvar array and then have formulas that access this variable and split it up as desired to fit the report.
 
HTH
IP IP Logged
J.J.
Newbie
Newbie


Joined: 08 Dec 2009
Online Status: Offline
Posts: 9
Quote J.J. Replybullet Posted: 05 Apr 2010 at 8:29am
Thanks for the help HTH. However, I don't know how to create a delimited string and then have a formulas that access this variable.

next({LWDEBT.CDCRED}

NEXT (fld) works great to display the next field, but how would you display the next field after that?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 05 Apr 2010 at 10:12am

What type of section is your data in on the report?  Is it in a group header on {CDTYPE} or another field or is in details?  If it's not in details, then that's probably what's causing the problem.

It looks like you're trying to fill in a specific form.  Crystal doesn't always handle that very well.  A while back (over 10 years ago!) I had to do something similar to fill out Managed Care applications with physician data.  For sections like these I usually ended up putting a text block with "See Attached" in the form and then created a sub-report that would pull just the data the form needed in that section.

-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
J.J.
Newbie
Newbie


Joined: 08 Dec 2009
Online Status: Offline
Posts: 9
Quote J.J. Replybullet Posted: 05 Apr 2010 at 11:09am
It looks like Crystal Reports in C# is letting me do a sub-report right on top of an existing report. I didn't think that was possible.

I will just format the sub-report to so it will fit into the report.
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.020 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.