Date formats on SSRS

If you need to display date format on report as DD-MMM-YYYY(01-Jun-2017). This can be achieved by several ways among which here is one.

=Left(MonthName(fields!begin date. Value), 3)




Report data Explorer is like solution Explorer which is available in visual studio. Report data have awesome stuff which is very basic to build reports which db queries linked. This will have few things

1.Built-in Fields



4.Data Sources


This can be accessed from main menu view – >Report Data. There are several scenarios where this option will not be seen hence there is a short cut key board commands helpful to access it.

Shift +Alt+D.

1. Selenium


Today we focus on Selenium simple program which open Browser and redirects to using language code.

  1. Open Visual Studio and Create new Console Application also add references of OpenQA dlls as shown below:Selenium_1

Click on Add Reference then following window appears where you need to browse and add reference.Selenium_2

Start writing the below code which opens browser.


when you execute this program you may encountered error as below:


This is because geckodriver is not available in bin/debug directory of project which needs to be downloaded from site and paste it in /bin/debug/ directory of project.

Once you execute it you may find the page as below:



That’s all for the day.




Invalid parameter binding

You may encounter this error when you provide parameter/parameters type in your application data access files mismatch with the actual parameter/parameters type of database procedure.

For example, there is a parameter name model in data access file with type raw which is actually varchar type in database procedure.

Hence encountered invalid parameter binding which can be corrected when

changing type from raw to string in data access file.

That’s all for the day.

Resolved: … is not allowed here because it does not extend class “System. Web. UI. Page”

Whenever you see such error while building websites, web applications or migration from previous versions to higher where mostly encounters.

Don’t panic it is pretty simple but needs attention.

The issue is only in one line of code where you find page directive.

To be more specific I mostly observe this error encountered because of inherits attribute of page directive tag of markup page.

For an instance, adding a aspx page to existing project having multiple directories like registration, sales, services, logs, geographies.

I need to add aspx page to geographies directory of web project. To do it I just right click on geographies directory and click add new item then give name to it and save.

Before you start execution have a look on page directive where you may find improper directive, may be as below:

<%language =vb code behind = page name. Aspx. Vb inherits =forex. Webapp. Pagename. Aspx%>

And this causes error as mentioned in title of post. To get rid of it, it is needed to verify the line as below

<%language =vb code behind = page name. Aspx. Vb inherits =forex. Webapp. Geographies. Pagename. Aspx%>

Hope it may be useful to other geeks.

Formatting SSRS Footer


Today we explore the SSRS footer from the previous report as per the requirement. Requirement is to print not just page number on right bottom of report but also display total no. of pages, eg: Page 1 Of 2 to achieve it just double click the text box, cursor will appear the type Page then right click and add Create Placeholder and provide formula of PageNumber then type Of add placeholder then add formula of TotalPages and follow as shown:


After making above changes, execute the report and will see as below:


That’s all for the day..


Applying Styles to SSRS 1


As you have seen in last post that report footer displays date time as per the system in simple format. Lets try to modify it as per our requirement. My requirement is to display it in Day, date month year eg: Sunday, 16 July 2017. To achieve it follow below steps:

  1. Go to Properties of textbox in footer, Provide the value as shown in expression.ssrs5
  2. Then click ok, set the properties of text box with tab name as Number and select the format as per requirement as shown below:ssrs5_1
  3. Click ok, the preview the report and find the report footer as expected.SSRS5_2

That’s it for the day..