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.

Advertisements

Formatting SSRS Footer

Hi..

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:

ssrs6_2

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

ssrs6ssrs6_1

That’s all for the day..

 

Applying Styles to SSRS 1

Hi..

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..

SSRS Formatting : Line Height

Hi..

I was working on SSRS reports where one of my reports have multiple text boxes with lot of texts inside. It was working fine when I was testing locally but when deployed on reports server few text boxes show text in 1 pt where as I set its font size to some value like 12 pt. After deployment, I reopened the same report in my local system and verified the properties and found that Line Height property of text box was set and hence its text was displayed in 1 pt only. It works fine locally but identified only on report server. The image of the property of Line height is shown as:

ssrs4

Do not set any value to this property which works well.

Thanks.

Creating Report Headers and Footers In SSRS.

Hi,

Today we learn how to create SSRS Report Headers and Footers which are pretty easy but remember SSRS have Report Header only but not Page Headers as available in Crystal Reports.

Let’s quickly make a sample report with Header and Footer. Right click anywhere in report and click  Add Page Header and type the header as you wish by adding textbox in it as shown below:

report11

report14

report12

Now let’s create page footer by clicking on Add Page Footer. Here too can be added text box and type the text as you want. But I want Date on right bottom side, page no. on left bottom side of page to be displayed.

To achieve it we need to add formula fields in the text boxes added in page footer also I made some more changes to report by right clicking in Report Header section and then selecting Header Properties and fill the background color as dark green and repeated the same for report footer as shown below:

report17

report15report16

That’s it for the day..Enjoy

Creating Static Headers on SSRS reports.

Hi,

Today we gonna learn how to create static headers on every page of SSRS reports which are not report headers. Observe the below report page 2 which does not have report header since it is visible only on page 1.

report6

To make header visible on every page, follow the below steps:

  1. Click the Columns Group à Click Advanced Mode as shown below:report9
  2. After clicking on Advanced Mode, you find multiple entries in Row Groups and Column Groups as shown below:report10

    Click on Static which is present in Row Groups and browse the tablix member properties named as RepeatOnNewPage = true, KeepWithGroup = After.That’s it. Now execute the report and it is as shown Page1 and page2.

    report7report8That’s it for the day. Enjoy..:)

Formatting SSRS in Simple ways

Assalamualaykum Wr Br.

Today we discuss few more things of SSRS formatting which pretty simple but I want it to be here for future references.

Lets have a look on below report where report have three columns with name SID, SNAME, STANDARDID which are marked in blue color.

report1

The values of Sid column are at right side which is because of the following property as shown below:

report2

Right click the column and select properties – > Alignment Tab -> Horizontal =Right .

For which all values of Sid and StandardId are aligned to right of the text box.

Now I would change this value to center and which impacts on reports as shown below:

report3

Observe the values of all columns which are aligned to center of each text box of table.

I did the same to headers where alignment property set as “Center” as shown below:

report4

Now observe that there are borders to each cell. There are most reports which does not have borders to each cell. To achieve it,  right click the cell -> textbox properties -> Boders -> click on None button as shown below:

report5

After Clicking on OK. The report will be visible as below:

report7

report6

That’s it for now. Enjoy..:)