VLOOKUP & OFFSET function Amazing Trick! See what to do if we have VLOOKUP with Duplicates in first column of lookup table AND we have two variables as criteria for VLOOKUP! We can use the VLLOKUP function to retrieve the data and the OFFSET function to look at just part of the desired table. See [...]
Variables
BSP – Using variables in Report Studio to change rendering based on output formats
www.bspsoftware.com Using variables in Report Studio you can change the layout or content of a report based on the format. Use this technique to help make your reports look and work their best in all formats. There are certain objects and formatting that do not transition well to some output formats, such as complex table [...]