Tech Support > Microsoft Windows > Windows CRM > about SQL Server Reporting Services
about SQL Server Reporting Services
Posted by YZQ on May 29th, 2006


when i create a report in Microsoft Visual Studio .NET 2003, named
Report1.rdl, and it's SQL:
SELECT name, price, producturl FROM FilteredProduct
there is many record in database,but it has none record in Report1
what's the matter?
thanks!

Posted by Min Fan [MFST] on May 31st, 2006


Please make sure that you are a CRM licensed user and you can see those
records inside CRM. FilteredViews verifies the user's privilege. It only
returns the records the user can see.

It is also possible the rdl was not build properly. So although the data is
retrieved, but it was not properly displayed on the report.

Min Fan

--
This posting is provided "AS IS" with no warranties, and confers no rights.


"YZQ" wrote: