Report Builder, SSRS Not Displaying One Column Data When Running

DJ 0 Reputation points
2023-02-28T17:05:52.4733333+00:00

What the table looks like prior to running:
Report Prior to Run

What part of the report looks like after running:

Report During Run

All of the fields seem to be populating correctly with the exception of the Notes column. The notes field should contain a few sentences of data for each row, a mixture of numbers, dates, and words. I've included an example of my sql query below. Most of it was written with the help of the Query Designer, but I added the two JOINs myself.

Currently, I have the expression =Replace(Fields!text.Value, vbCrLf, " ") in the Notes column. I've also tried these expressions:

=Fields!text.Value

=Replace(Replace(Fields!text.Value, Chr(13), " "), Chr(10), " ") =IIf(IsNothing(Fields!text.Value), "", IIf(IsNumeric(Fields!text.Value), CDbl(Fields!text.Value), Fields!text.Value))

None of these made the data populate in the Notes column when running the report. I've tried expanding the size of my notes column, just in case the data is too large for the space. I've got "Allow height to increase" checked, and I've got "CanGrow" set to True. I'm not sure what else I can try, and I'm not sure what other information might be necessary when trying to understand what I've got going on here. Anyone have any suggestions? In advance, I appreciate the help!

SELECT
  Reporting.CFS.Id
  ,Reporting.CFS.Number
  ,Reporting.CFS.CreatedOn
  ,Reporting.CFSEvent.address_streetAddress
  ,Reporting.CFSEvent.address_zipCode_Description
  ,Reporting.CFSEvent.startDate
  ,Reporting.CFSEvent.address_city_Description
  ,Reporting.CFSEvent.type
  ,Reporting.CFSEvent.address_state_Code
  ,Reporting.CFSEvent.reason_V2
  ,Reporting.CFSNarrative.text
FROM
  Reporting.CFS
  LEFT OUTER JOIN Reporting.CFSEvent
    ON Reporting.CFS.Id = Reporting.CFSEvent.CFS_Id
  LEFT OUTER JOIN Reporting.CFSNarrative
    ON Reporting.CFS.Id = Reporting.CFSNarrative.Id
WHERE
  Reporting.CFSEvent.startDate >= @startDate
  AND Reporting.CFSEvent.startDate <= @startDate2
SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Uyemura 1 Reputation point
    2026-07-03T02:19:53.38+00:00

    I had a similar situation so I will post in case this helps someone in the future. I right clicked on "Column Properties" in Report Builder and selected this highlighted item and selected "Show" and that was it! Good luck.User's image

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-03-01T02:08:04.79+00:00

    Hi @DJ

    I don't know much about T-SQL, can you try to run it in the query designer of the dataset to see if the data in the Text column can be displayed?

    You can also try to run the report on the report server or export it as a file instead of using the report builder preview to check whether the data is displayed normally to determine whether it is a problem with the report builder.

    Best regards,

    Aniya

    Was this answer helpful?

    0 comments
  3. Michael Taylor 61,226 Reputation points
    2023-02-28T17:18:28.4033333+00:00

    I notice that you're using a left join which means all the rows in CFS are being returned and only those that have a corresponding narrative row would be included. However I notice that your join is combining CFS.Id to CFSNarrative.Id. Shouldn't the CFSNarrative have a CFS_Id column that contains the Id from the CFS table? That is how your previous join works. The CFSNarrative.Id I assume is a PK and therefore isn't the CFS.Id value.

    Was this answer helpful?

    0 comments