Converting SSRS report to PDF creates blank pages?

When you export a SSRS report to PDF have you ever come across the PDF report have blank pages? Here is a trick to solve this issue. I never thought Report properties have a solution for this unless I change the report margin size. You can choose the "ConsumeContainerWhitespace" property to True. By default this value is false. Remember to select your report and check this property under Report properties.

How to display multiple Image Data Type in SSRS Reports

When the images stored in the database in the form of Image data type, images can be easily displayed on the report.

Assume you have multiple records for the selection. Image 1, Image 2 , Image 3 etc...

You can't put all the images into a image item or tablix. Have you thought of how useful the Lists are?

Yes, you can use Lists and drag and drop image item from Toolbox and set the data set to the List. Then go to image properties and select Database as the image source and select the field where the column that image data has been stored. Select MIME type. 

When the query out put single record in the report list item will show only the image and when query brings multiple image records it will list the images in the report.

Enjoy database images.....

Select data from after consolidating tables' name

I have experienced a situation where part of the table name is stored in another table. All the tables in the databases have same prefix but remaining name part concatenates and creates the name of the table. However the nature of the application behaves it stores the suffix of the table name in a separate table. If i need to retrieve data from a table which is stored in another table which has only the  suffix , what i did was i concatenated the table prefix and suffix to select out data.

This is how i did it. I used EXEC command to run the select query.

tbl_FormDATA 

ID	Reference	Formname
1	112852	Customer
2	125369	Shopper

tbl_Customer

ID	Name	Address
1	Test	Test Address

tbl_Shopper

ID	Shop No
1	10-1

DECLARE @tble varchar(100);

SELECT @tble ='tbl_'+FormName

FROM tbl_FormDATA

WHERE reference = 112852;

EXEC('select * from ' + @tble);