Monday, 15 February 2010

reporting services - SSRS Report Builder Tablix not displaying dataset results but dataset/query returns results -



reporting services - SSRS Report Builder Tablix not displaying dataset results but dataset/query returns results -

on ssrs/report builder have written dataset/query , returns results. however, when create tablix display results of dataset/query tablix displays column headers. rows not display results. need check? recommendations?

not sure if factor: dataset combines info 2 databases. i.e;

select t1.bookingnumber, t2.receiptnumber databasea.dbo.bookings t1 left bring together databaseb.dbo.receipts t2 on t1.bookingspkey = t2.bookingsfkey

it when seek display results of query on tablix nail issue.

however, when info 1 database, i.e;

select t1.bookingnumber databasea.dbo.bookings

and effort display on tablix there no issues displaying results.

reporting-services reportbuilder

No comments:

Post a Comment