September 9, 2014 at 3:22 am
Hi I'm writting my First SSRS report on SQL 2008 R2, using MS Visual Studio 2008
Some of the report rows are blank, yet when I export to excel I can see the data.
The Report is based of a view, similar to this example
create view myTstReport
AS
SELECT
tC.CustID, tC.CustName,
tInv.InvDate,
ISNULL(tInv.SalesPerson,'') as SalesPerson
FROM tblCustomer tC
LEFT JOIN vwLastInvoice as tInv
ON tC.CustID = tInv.CustID
When I added the left join, I started to get the empty rows in the previewer but the rows are populated when I export to Excel
I made sure for all character fields I return '' rather than NULL. I tried to put a
ISNULL(tInv.InvDate, '19000101') as InvDate
The Blank rows are those with NULL InVDates but some rows do show.
I just cannot figure it out. I am formatting the dates to a custom format however that would effect all NULL dates and putting 19000101 didn't fix it.
I'm still in dev on my machine have not tried publishing (if this is the right term) it on my local SSRS to see if error is still there
Thanks
September 9, 2014 at 3:53 am
I've found the Answer. sorry.
I increased the row height.
After a Customer with a long name in words e.g.
"My Little cat has chewed my socks Incorporated" it did not display the last 3 words. the next row would be blank.
I'll try and find an auto grow for row,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply