Hello experts,
I'm doing a report.
- I have a dataset which summarize transaction grouped by companyID.
- Now i need to display the company's name for each row..
So how do i go about if i do not want to use custom assembly?
I tried creating another new dataset which takes companyID from row field,
but i got this error :
--
A value expression used for the report parameter â'ds_compIDâ' refers to a
field. Fields cannot be used in report parameter expressions.
--
Any ideas guys?
Thank you very much...
--
* chingu *Correct, inside of a dataregion (list, table, etc) you can directly
reference columns from the dataset of the dataregion. In addition you can
also pull aggregates from another datasets. So if you have the second
dataset returning just the company name and you want to pull this value into
a dataregion you need to wrap the value in some aggregate. Try using "First"
aggregate
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"duckduck" <duckduck@.discussions.microsoft.com> wrote in message
news:0B0D3FCB-6D52-4F91-B025-01BA5FED77AD@.microsoft.com...
> Hello experts,
> I'm doing a report.
> - I have a dataset which summarize transaction grouped by companyID.
> - Now i need to display the company's name for each row..
> So how do i go about if i do not want to use custom assembly?
> I tried creating another new dataset which takes companyID from row field,
> but i got this error :
> --
> A value expression used for the report parameter 'ds_compID' refers to a
> field. Fields cannot be used in report parameter expressions.
> --
> Any ideas guys?
> Thank you very much...
> --
> * chingu *