Share
Report
345Hi -
I need a little help with understanding how I can use Reference group fields from a form in a SSRS Report.
We have a Project Contracts form in (Project management and accounting/Common/Projects/Project contracts)
If you double click on Project Contract ID it will take you to project contract ID details form.
The Column Driver Grant is a reference group field of ProjGrant table. you can see this when I personalize the column
CH_DriverGrant field is from ProjFundingSource Table but it is used in projGrant as a reference. Now when I look in the ProjFundingSource table under CH_DriverGrant field I see an int64 type field which has some numbers. But that exact same field is displaying a string value on this form ?
My question is how Can I convert this int64 field into a string to show me the string value of that int64 number on my ssrs report just like it is shown in the form (as a string value) ?
5637149077 (This is the value from CH_DriverGrant field)
F1EJ (this is the value for the same field in Project contract Form)
Is there anyway I can get the string value of this field in my SSRS Report from the form shown above ? or is there a code a function perhaps which will convert this value to a string for me and I can then use this in my report ?
Any suggestions will be helpful
Thank you
*This post is locked for comments
All responses (
Answers (
