Hi,
In my ASP.NET application, I am using Crystal Report for showing Report data to Users.
My client having nearly 10 branches. Hence i use formula field for
each report to retrieve BRANCH NAME as report title based on the
BRANCH ID
(I am already having for each table).
Like.
if (BranchID = 'BR001')
'xxxxx'
else if(BranchID= 'BR002')
'yyyy'
......
,,,,,,
......So on
Now problem is, in future if i need to change any one Branch name, then i need to change the BRANCH NAME for all the reports containing formulas.
Is there any other way to reach the BRANCH TABLE from the Crystal report based on the BRANCH ID ??
If so, then i can simply change the branch name in branch table affects all the reports.
Hope you understand my question.
Please help me out.