Hello Community,
I have been trying to get the details under the Attributes tab displayed in the Subcontract SF (SC641000) report. I Have added the following Text Box in the Report designer, but still the value isn’t getting displayed in the report:
Best answer by ChandraM
View original
+4
Have you made other modifications which are showing up, or just this one?
Additionally, what does the join look like you are using to bring in CSAnswers?
Have you made other modifications which are showing up, or just this one?
Additionally, what does the join look like you are using to bring in CSAnswers?
Hello
Not getting the logic behind this.
+4
Then use the Alias field on the report, this worked for me:
The Value is displaying as the number result of which selections were made in the Attribute configuration (mine are numbered 1, 2, 3..etc but they have different descriptions)
If you want the descriptions to display you’ll need to join in CSAttributeDetail to see these
Then use the Alias field on the report, this worked for me:
The Value is displaying as the number result of which selections were made in the Attribute configuration (mine are numbered 1, 2, 3..etc but they have different descriptions)
If you want the descriptions to display you’ll need to join in CSAttributeDetail to see these
Hey
Thank you soo much for your help.
Then use the Alias field on the report, this worked for me:
The Value is displaying as the number result of which selections were made in the Attribute configuration (mine are numbered 1, 2, 3..etc but they have different descriptions)
If you want the descriptions to display you’ll need to join in CSAttributeDetail to see these
I am also looking to display the values 1,2 in 2 separate lines. Would that be possible to do so?
+4
You can join CSAnswers to CSAttribute on AttributeID = AttributeID, then join CSAttribute to CSAttributeDetail also on AttributeID = AttributeID.
Lastly you can display them on separate lines, but you would need to adjust the expression probably or at least make the text box force the next line by limiting the display size and enabling Multiline = True for the text box.
Might also want to include CanGrow = True so that it would be one line if there was only one attribute but drop down to be two lines for 2 attributes.
You can join CSAnswers to CSAttribute on AttributeID = AttributeID, then join CSAttribute to CSAttributeDetail also on AttributeID = AttributeID.
Lastly you can display them on separate lines, but you would need to adjust the expression probably or at least make the text box force the next line by limiting the display size and enabling Multiline = True for the text box.
Might also want to include CanGrow = True so that it would be one line if there was only one attribute but drop down to be two lines for 2 attributes.
So one last ques 🤓, here I am trying to join the tables:
Now trying to display the Attribute Description and the selected value under the Attribute tab.
+4
You’ll need to include the Alias value SubcontractAtt in the Parent Alias of CSAnswers join to CSAttribute
+2
from your example,
=’Binding’ + [CSAnswers.AtrributeID]+[CSAnswers.Value]
will not show the word Binding if either field is null.
You have to conditionalize the fields if you want the word Binding to print. like this:
=’Binding’ + iif( [CSAnswers.AtrributeID]<>null,[CSAnswers.AtrributeID] ,’’)+iif ( [CSAnswers.Value] <>null, [CSAnswers.Value],‘’)
You can join CSAnswers to CSAttribute on AttributeID = AttributeID, then join CSAttribute to CSAttributeDetail also on AttributeID = AttributeID.
Lastly you can display them on separate lines, but you would need to adjust the expression probably or at least make the text box force the next line by limiting the display size and enabling Multiline = True for the text box.
Might also want to include CanGrow = True so that it would be one line if there was only one attribute but drop down to be two lines for 2 attributes.
Hey
It really worked as expected, but just one thing here is getting stuck is displaying the data into different lines. Since, I have selected 2 values under the Attributes tab → Values column, Report is only able to display one of those lines.
This is it what I tried:
What am I missing here?
+2
When I want to force data onto multiple lines, I use the ‘{br}’ to force a new line.
This is what the address fields do on forms like the Sales Order, SO641010.rpx.
Like this:
+IIf([CompanyAddress.AddressLine1]<> null, [CompanyAddress.AddressLine1] + '{br}', '')
+IIf([CompanyAddress.AddressLine2]<>null,[CompanyAddress.AddressLine2] + '{br}','')
+4
When I want to force data onto multiple lines, I use the ‘{br}’ to force a new line.
This is what the address fields do on forms like the Sales Order, SO641010.rpx.
Like this:
+IIf([CompanyAddress.AddressLine1]<> null, [CompanyAddress.AddressLine1] + '{br}', '')
+IIf([CompanyAddress.AddressLine2]<>null,[CompanyAddress.AddressLine2] + '{br}','')
Hello
thank you for your suggestion, but still it doesn’t work out:
Even the system is actually taking the second line from the Values columns under Attributes, it is missing the first line.
Hello
So, it is easily displaying the values for both the selected checkboxes in the reports, but not their descriptions:
Hello Community, haven’t found any resolution to this. Can anyone please guide me out?
Thanks in advance.
Hi
Are you looking for a way to show all the Values selected for the Attribute in the Contract, as shown below?
Hi
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
