Click here to Skip to main content
15,889,403 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am currently working on a management project where i want to print fee details using crystal reports.
The problem is that the fee heads(its name) will be added dynamically by the client in the software. So, now when i am preparing the report i will have to add all the fee heads that client have created as columns in the report. I have seen many solutions here, but they all tell us to add all the columns and hide those not required. But here before hand i dont know how many columns would be there, how can i add the columns.
Eg:

The report could br like:

Class Adm_FEE TermI TermII TermIII Bus //client may have created more or less columns
I 2000 2000 3000 1000 200
II 20999 2322 3332 1233 1233
....
....
.....


Kindly help me guys.....
Posted

I have done this using CROSS TAB feature of Crystal report with ease.

Refer these CP article-
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]


2nd method - In some of the scenarios you can go with IMPORT PICK LIST with the notepad having the predifined column and couple of user defined formulas as per your requirement.
Refer this-
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx[^]

Choice is yours.

Best Regards.
 
Share this answer
 
Thanks for the first option. The cross tab works perfectly. The second option is invalid in my case as i dont have predefined column list,since clients add columns during runtime......


Thanks..
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900