Viewing 15 posts - 1 through 15 (of 22 total)
Set visibility for a row based on an expression, when the condition meets, the row is hidden. Latter rows occupy the space of the row.
the row is not...
August 31, 2015 at 9:11 am
Server Memory just limits the memory consumed by SQL Server Buffer Pool. Memory consumed by Non-buffer pool portion of SQL Server and memory consumed by external dll's loaded into SQL...
August 27, 2015 at 9:45 am
Check if you have set report cache in process option, or run report from snapshot. You can open report from report manager use report builder to see dataset return results....
August 27, 2015 at 9:23 am
Detail information of reports deployed in report server are stored in report server database catalog table, you can query data source, dataset, parameters and so on in this table. Sample...
August 27, 2015 at 9:15 am
We can sort data returned by a query in SQL Server using Order By clause:
•Order the result set of a query by the specified column list and, optionally, limit the...
August 27, 2015 at 9:04 am
As far as I know, there is no related settings in rsreportserver.config file to set this default values. However, you can use F12 developer tool to find corresponding tag, using...
July 31, 2015 at 3:32 am
Hi,
Based on ( https://msdn.microsoft.com/en-us/library/ms160340.aspx ), when use RSCM to change service account, it will automatically updates the login permissions on the SQL Server Database Engine instance used to...
July 31, 2015 at 3:17 am
Hi,
Do you want to suppress blank space when the page header content is hidden?
Though you hide those content in page header, in fact it still occupy the space. As far...
July 30, 2015 at 3:30 am
Hi,
Do you want to display page number only with 1 or 2?
If so, you can specify the expression like that: =IIF(Globals!PageNumber mod 2=1,1,2). With this expression, the third page will...
July 30, 2015 at 3:04 am
Hi,
The SSRS has a built-in feature which called file share delivery subscription. You can create a file share delivery extension so that you can deliver a report to a folder...
July 30, 2015 at 2:45 am
Hi,
1. Check if you add any page break for the first tablix.
2. In SSRS 2008 or higher, there is a Report Property ConsumeContainerWhitespace which controls whether white space in...
July 30, 2015 at 2:36 am
Hi,
If you have created a tooltip for some columns, you can specify the background of those columns as red color, and add a words like there is a tooltip where...
July 30, 2015 at 1:21 am
You can create subscription using file share delivery extension in SSRS 2005. In order for file delivery to succeed, you must set write access permissions on the shared folder. In...
July 27, 2015 at 3:42 am
In my opinion, both option 2) and 3) can be considered. For option 2), since you want to grant users to access report server, you should add them to a...
May 27, 2015 at 2:39 am
According to the error message, it seems that the query in dataset1 is failed to executed. You should open dataset properties, then run the query in query designer to check...
May 27, 2015 at 2:04 am
Viewing 15 posts - 1 through 15 (of 22 total)