You can see where I am up to by viewing the screenshots.
What am I doing wrong here:
Report Preview:
Report data definition:
SSRS Field:
SSRS Expression:
I am having the same issue.
I have made a copy of the rdd and created a new report.
The user is using the report but needs another column on the report. unchecking the exclude column check box does not seem to make the column visible in ssrs.
Please include me in the reply.
Try the T1.ClosedDate without the T1.
should just read ClosedDate ClosedDate
What you are doing is setting the ClosedDate field to = “T1.ClosedDate”, which is what you are seeing on the report.
You can remove the alias form the dataset properties but I would think that would show blank, at worst. If that does not work can you paste a screenshot of the field on the report (shown below)
You need to add the column in the SSRS expression, then add the column to the SSRS field, and then add the SSRS field to the report.
DON’T PUSH THE SYNC DATASET BUTTON!!!
2 Likes
that is the query.
You need to add it to the report as a field
There will be three spots.
Query expression
Report Field
Report Field on Report
Which report? Can you attach the report to the thread. It might be easier to view that then this back and forth.
see my screenshots at the top.
the screen shots up top does not show all three steps.
Can you provide me a screenshot of which step i am missing?
You have all three screenshots above that you need. Are you still seeing the word T1.ClosedDate appear when running the report?
Yes i am
that is what I was asking Dan. The T1.ClosedDate is not a correct value. It should be the data object ClosedDate.
That is where the rpt file would have been easier to see what is going on.
This is what I have done just now:
Dragged and dropped ClosedDate onto the report:
Uploaded:
Ran report:
don’t think you want a SUM
try something like
=First(Fields!ClosedDate.Value, “NAME OF DATASET FIELD IS IN”)
The dataset is in the reportbuilder. Where you added your field, it is just up higher than your screenshot. The other datasets on the report are JobMtl and RptParameter
Ok, update:
Did this:
And got this
