Print Page | Close Window

Help with formula

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18406
Printed Date: 02 May 2025 at 12:28pm


Topic: Help with formula
Posted By: stevetothink
Subject: Help with formula
Date Posted: 09 Jan 2013 at 5:24am
I have 60 database fields
 
Shares1, Shares2, Shares3, Shares4... all the way up to Shares60.
 
Each "Shares#" field is tied to a vesting date.
 
Instead of inserting 60 rows of details (one for each Shares# field), I'm hoping I can create a single formula field that will automatically insert rows if the share value is greater than 0 for the next Shares field.
 
For example. If Person #1 has Shares1 = 100, Shares2 = 50 and Shares3 = 0 then I want it to look like this.
 
Name         Shares
Person 1    100
Person 1    50
 
I will need to do that same thing for the vest date.
 
Does this make sense?


Print Page | Close Window