Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dynamic Column Headings Post Reply Post New Topic
Author Message
chloecd
Newbie
Newbie


Joined: 21 Dec 2015
Online Status: Offline
Posts: 10
Quote chloecd Replybullet Topic: Dynamic Column Headings
    Posted: 21 Dec 2015 at 10:31pm
Hello!

I am currently designing a report for a payroll bureau. We want the report to be accurate for many different payrolls and so were wanting dynamic column headings. Is this possible?

Basically what I want Crystal to do is to show the Description for each Pay Component. The database is set up so that each Pay Component has an ID number, and a description. So I was wondering if there is a formula I can use that shows PCDescr for PCompID=1 etc. It's not really an if function because I don't want it to analyse the data, just show the Description.

I don't know if that makes any sense?!

Thank you very much
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 23 Dec 2015 at 8:21am
What I would do is create a table that will contain all of the column headings in each record, with each client the bureau is processing for having its own record. You can then include that table in the report, linking on the client id, and use the column labels from there.

-Dell
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.063 seconds.