Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
put default number in a data cell of a matrix
You could try something like this: =iif(Sum(Fields!ID.Value)=0, 0, Sum(Fields!ID.Value))- FooCorwin
- Post #2
- Forum: Microsoft SQL Server: Reporting Services
-
SSRS and MySQL?
In your query, leave the parameters as '?' marks: ... AND c.DownloadDate >= ? AND c.DownloadDate <= ? AND r.source = ? You need to leave the parameters 'named' as Parameter1, Parameter2, etc., in the report. Deploy the report like that -- then, in the Report Manager, for that report...- FooCorwin
- Post #3
- Forum: Microsoft SQL Server: Reporting Services
-
Administering Internal Reports
In active directory, you can create groups, add users to that group, and then add that group under the security for a given report - assign Browser role (et al).- FooCorwin
- Post #2
- Forum: Microsoft SQL Server: Reporting Services
-
Security - who's got what?
Does anyone know an easy way to see what reports each user or group has access to? I can see who is set to view, etc. any particular report, but I'd like to see all reports a particular user has access to. (Basically, I've created so many reports for several different groups and individuals...- FooCorwin
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Reporting Services
