SSRS Expand specific drilldown by defaulthttps://joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget to tick the option "display can be...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Select unique values in Microsoft Excel columnhttps://joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Change div height to fit contenthttps://joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn overflow:hidden;height:1%;: A long heading that wraps over several lines Source(s): Stack Overflow - make div's height expand with its...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *