Search

Custom Search

Subscribe via email

Enter your email address:

Delivered by FeedBurner

Showing posts with label reportviewer. Show all posts
Showing posts with label reportviewer. Show all posts

Wednesday, October 20, 2010

Auto increment in GV and Reportviewer starting at 1

In reportviewer add a col in report and set it as =Rownumber(Nothing)
no need to add the primary key col cause it starts from 0.
In reportviewer add col based on PRIMARY KEY of the table which will create an auto increment col. For it to start at one open code of xsd file and add msdata:AutoIncrement="1 in
<xs:complexType>
            <xs:sequence>
              <xs:element name="Autokey" msdata:ReadOnly="true" msdata:AutoIncrement="1"  msprop:Generator_UserColumnName="Autokey" msprop:Generator_ColumnVarNameInTable="columnAutokey" msprop:Generator_ColumnPropNameInRow="Autokey" msprop:Generator_ColumnPropNameInTable="AutokeyColumn" type="xs:int" />
              <xs:element name="Province" msprop:Generator_UserColumnName="Province" msprop:Generator_ColumnVarNameInTable="columnProvince" msprop:Generator_ColumnPropNameInRow="Province" msprop:Generator_ColumnPropNameInTable="ProvinceColumn" minOccurs="0">
                <xs:simpleType>
In gridview add a col in aspx
  <asp:TemplateField HeaderText="S_No">
                <ItemTemplate>
                    <%# Container.DataItemIndex + 1 %>
                </ItemTemplate>
            </asp:TemplateField>
--

Selecting NULLS in reportviewer individual textbox fields

In order to eliminate 0 in integer fields and 01 jan 1900 in datetime fields that are gathered from the objectdatasource select statement, we set reportviewer textbox field expression as:
=IIF(Fields!No_of_Daigs.Value = 0, Nothing, Fields!No_of_Daigs.Value)

adding parameters in reportviewer

make sure to add parameters by selecting the xsd and then looking at the properties of DataTableAdapter. Choose the dots on Parameters in properties and add a new one making sure AllowDBNULL = true, providertype = nvarchar, dbtype=string.

Configuring reportviewer for filter

modify objectdatasource in aspx
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData"
            TypeName="DataSet1TableAdapters.DataTableAdapter" FilterExpression = "(Province LIKE '{0}')" >
            <FilterParameters>
            <asp:controlparameter name="Province" controlid="FTR_Province"/>
        </FilterParameters>
        </asp:ObjectDataSource>
-----------
add    ReportViewer1.LocalReport.Refresh() in page_load of the aspx

Tuesday, October 19, 2010

Format currency in reportviewer, Gridview and Formview

--- Formview---


REM -- Currency Field Daily_Cost_Per_PersonLabel
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As Label
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = CType(FormView1.FindControl("Daily_Cost_Per_PersonLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = ""
            Else
                REM Putting Rs. Currency Symbol in front of FV row text
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = "Rs. " + tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            End If
Full text:
Protected Sub FormView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.DataBound
        'FormView1.ChangeMode(FormViewMode.Edit)
        ' If FormView1.Visible = True Then
        ' FormView1.Visible = True
        REM Setting Integer and Date textfields in Item view of Formview to BLANK
        REM In Readonly Mode
        If FormView1.CurrentMode = FormViewMode.ReadOnly Then
            REM -- DateTime Field Date_of_EntryLabel
            Dim tmp_FV_Item__Temp_Date_of_EntryLabel As Label
            tmp_FV_Item__Temp_Date_of_EntryLabel = CType(FormView1.FindControl("Date_of_EntryLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Date_of_EntryLabel As String = tmp_FV_Item__Temp_Date_of_EntryLabel.Text
            If str_tmp_FV_Item__Temp_Date_of_EntryLabel = "01 Jan 1900" Then
                tmp_FV_Item__Temp_Date_of_EntryLabel.Text = ""
            End If
            REM -- Integer Field No_of_DaigsLabel
            Dim tmp_FV_Item__Temp_No_of_DaigsLabel As Label
            tmp_FV_Item__Temp_No_of_DaigsLabel = CType(FormView1.FindControl("No_of_DaigsLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_DaigsLabel As String = tmp_FV_Item__Temp_No_of_DaigsLabel.Text
            If str_tmp_FV_Item__Temp_No_of_DaigsLabel = "0" Then
                tmp_FV_Item__Temp_No_of_DaigsLabel.Text = ""
            End If
            REM -- Integer Field No_of_RotisLabel
            Dim tmp_FV_Item__Temp_No_of_RotisLabel As Label
            tmp_FV_Item__Temp_No_of_RotisLabel = CType(FormView1.FindControl("No_of_RotisLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_RotisLabel As String = tmp_FV_Item__Temp_No_of_RotisLabel.Text
            If str_tmp_FV_Item__Temp_No_of_RotisLabel = "0" Then
                tmp_FV_Item__Temp_No_of_RotisLabel.Text = ""
            End If
            REM -- Integer Field No_of_Bene_MaleLabel
            Dim tmp_FV_Item__Temp_No_of_Bene_MaleLabel As Label
            tmp_FV_Item__Temp_No_of_Bene_MaleLabel = CType(FormView1.FindControl("No_of_Bene_MaleLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_MaleLabel As String = tmp_FV_Item__Temp_No_of_Bene_MaleLabel.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_MaleLabel = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_MaleLabel.Text = ""
            End If
            REM -- Integer Field No_of_Bene_FemaleLabel
            Dim tmp_FV_Item__Temp_No_of_Bene_FemaleLabel As Label
            tmp_FV_Item__Temp_No_of_Bene_FemaleLabel = CType(FormView1.FindControl("No_of_Bene_FemaleLabel"), Label)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_FemaleLabel As String = tmp_FV_Item__Temp_No_of_Bene_FemaleLabel.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_FemaleLabel = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_FemaleLabel.Text = ""
            End If
            REM -- Currency Field Daily_Cost_Per_PersonLabel
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As Label
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = CType(FormView1.FindControl("Daily_Cost_Per_PersonLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = ""
            Else
                REM Putting Rs. Currency Symbol in front of FV row text
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text = "Rs. " + tmp_FV_Item__Temp_Daily_Cost_Per_PersonLabel.Text
            End If
            REM -- Integer Field Acc_ExpLabel
            Dim tmp_FV_Item__Temp_Acc_ExpLabel As Label
            tmp_FV_Item__Temp_Acc_ExpLabel = CType(FormView1.FindControl("Acc_ExpLabel"), Label)
            Dim str_tmp_FV_Item__Temp_Acc_ExpLabel As String = tmp_FV_Item__Temp_Acc_ExpLabel.Text
            If str_tmp_FV_Item__Temp_Acc_ExpLabel = "0" Then
                tmp_FV_Item__Temp_Acc_ExpLabel.Text = ""
            End If
        End If
        REM In Insert Mode
        If FormView1.CurrentMode = FormViewMode.Insert Then
            REM -- DateTime Field Date_of_EntryText
            Dim tmp_FV_Item__Temp_Date_of_EntryText As TextBox
            tmp_FV_Item__Temp_Date_of_EntryText = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Date_of_EntryText As String = tmp_FV_Item__Temp_Date_of_EntryText.Text
            If str_tmp_FV_Item__Temp_Date_of_EntryText = "01 Jan 1900" Then
                tmp_FV_Item__Temp_Date_of_EntryText.Text = ""
            End If
            REM -- Integer Field No_of_DaigsText
            Dim tmp_FV_Item__Temp_No_of_DaigsText As TextBox
            tmp_FV_Item__Temp_No_of_DaigsText = CType(FormView1.FindControl("No_of_DaigsTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_DaigsText As String = tmp_FV_Item__Temp_No_of_DaigsText.Text
            If str_tmp_FV_Item__Temp_No_of_DaigsText = "0" Then
                tmp_FV_Item__Temp_No_of_DaigsText.Text = ""
            End If
            REM -- Integer Field No_of_RotisText
            Dim tmp_FV_Item__Temp_No_of_RotisText As TextBox
            tmp_FV_Item__Temp_No_of_RotisText = CType(FormView1.FindControl("No_of_RotisTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_RotisText As String = tmp_FV_Item__Temp_No_of_RotisText.Text
            If str_tmp_FV_Item__Temp_No_of_RotisText = "0" Then
                tmp_FV_Item__Temp_No_of_RotisText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_MaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_MaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_MaleText = CType(FormView1.FindControl("No_of_Bene_MaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_MaleText As String = tmp_FV_Item__Temp_No_of_Bene_MaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_MaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_MaleText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_FemaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_FemaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_FemaleText = CType(FormView1.FindControl("No_of_Bene_FemaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_FemaleText As String = tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_FemaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text = ""
            End If
            REM -- Currency Field Daily_Cost_Per_PersonText
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As TextBox
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = CType(FormView1.FindControl("Daily_Cost_Per_PersonTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text = ""
            End If
            REM -- Integer Field Acc_ExpText
            Dim tmp_FV_Item__Temp_Acc_ExpText As TextBox
            tmp_FV_Item__Temp_Acc_ExpText = CType(FormView1.FindControl("Acc_ExpTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Acc_ExpText As String = tmp_FV_Item__Temp_Acc_ExpText.Text
            If str_tmp_FV_Item__Temp_Acc_ExpText = "0" Then
                tmp_FV_Item__Temp_Acc_ExpText.Text = ""
            End If
        End If
        REM In Edit Mode setting integer and datetime fields to blank
        If FormView1.Visible = True And FormView1.CurrentMode = FormViewMode.Edit Then
            REM -- DateTime Field Date_of_EntryText
            Dim tmp_FV_Item__Temp_Date_of_EntryText As TextBox
            tmp_FV_Item__Temp_Date_of_EntryText = CType(FormView1.FindControl("Date_of_EntryTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Date_of_EntryText As String = tmp_FV_Item__Temp_Date_of_EntryText.Text
            If str_tmp_FV_Item__Temp_Date_of_EntryText = "01 Jan 1900" Then
                tmp_FV_Item__Temp_Date_of_EntryText.Text = ""
            End If
            REM -- Integer Field No_of_DaigsText
            Dim tmp_FV_Item__Temp_No_of_DaigsText As TextBox
            tmp_FV_Item__Temp_No_of_DaigsText = CType(FormView1.FindControl("No_of_DaigsTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_DaigsText As String = tmp_FV_Item__Temp_No_of_DaigsText.Text
            If str_tmp_FV_Item__Temp_No_of_DaigsText = "0" Then
                tmp_FV_Item__Temp_No_of_DaigsText.Text = ""
            End If
            REM -- Integer Field No_of_RotisText
            Dim tmp_FV_Item__Temp_No_of_RotisText As TextBox
            tmp_FV_Item__Temp_No_of_RotisText = CType(FormView1.FindControl("No_of_RotisTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_RotisText As String = tmp_FV_Item__Temp_No_of_RotisText.Text
            If str_tmp_FV_Item__Temp_No_of_RotisText = "0" Then
                tmp_FV_Item__Temp_No_of_RotisText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_MaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_MaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_MaleText = CType(FormView1.FindControl("No_of_Bene_MaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_MaleText As String = tmp_FV_Item__Temp_No_of_Bene_MaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_MaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_MaleText.Text = ""
            End If
            REM -- Integer Field No_of_Bene_FemaleText
            Dim tmp_FV_Item__Temp_No_of_Bene_FemaleText As TextBox
            tmp_FV_Item__Temp_No_of_Bene_FemaleText = CType(FormView1.FindControl("No_of_Bene_FemaleTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_No_of_Bene_FemaleText As String = tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text
            If str_tmp_FV_Item__Temp_No_of_Bene_FemaleText = "0" Then
                tmp_FV_Item__Temp_No_of_Bene_FemaleText.Text = ""
            End If
            REM -- Currency Field Daily_Cost_Per_PersonText
            Dim tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As TextBox
            tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = CType(FormView1.FindControl("Daily_Cost_Per_PersonTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText As String = tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text
            If str_tmp_FV_Item__Temp_Daily_Cost_Per_PersonText = "0.00" Then
                tmp_FV_Item__Temp_Daily_Cost_Per_PersonText.Text = ""
            End If
            REM -- Integer Field Acc_ExpText
            Dim tmp_FV_Item__Temp_Acc_ExpText As TextBox
            tmp_FV_Item__Temp_Acc_ExpText = CType(FormView1.FindControl("Acc_ExpTextBox"), TextBox)
            Dim str_tmp_FV_Item__Temp_Acc_ExpText As String = tmp_FV_Item__Temp_Acc_ExpText.Text
            If str_tmp_FV_Item__Temp_Acc_ExpText = "0" Then
                tmp_FV_Item__Temp_Acc_ExpText.Text = ""
            End If
        End If
        'End If
    End Sub

--- Gridview---


REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "0.00" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = ""
            Else
                REM Putting Rs. Currency Symbol in front of the row text
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "Rs. " + CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text()
FUll listing:
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
        REM Assigning EMPTY values to integer and datetime labels in GV
        REM Note that it will not involve any text fields
        REM Taking total rows in GV
        Dim tmp_Total_GV_Rows As String = GridView1.Rows.Count
        REM Recursively going through each GV row, last recursion inside will be at 0 therefore > 0 is necessary
        While tmp_Total_GV_Rows > 0
            REM Decreasing value of row holder to cover all rows, must be on top to start indexing appropriately since it goes from 0 onwards.
            tmp_Total_GV_Rows = tmp_Total_GV_Rows - 1
            'CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text.ToString("dd MMM yyyy, ddd")
            REM --DateTime Field GV_LBL_Date_of_Entry--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = "01 Jan 1900" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(5).FindControl("GV_LBL_Date_of_Entry"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Daigs--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(6).FindControl("GV_LBL_No_of_Daigs"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(6).FindControl("GV_LBL_No_of_Daigs"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Rotis--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(7).FindControl("GV_LBL_No_of_Rotis"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(7).FindControl("GV_LBL_No_of_Rotis"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Bene_Male--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(8).FindControl("GV_LBL_No_of_Bene_Male"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(8).FindControl("GV_LBL_No_of_Bene_Male"), Label).Text() = ""
            End If
            REM --Integer Field GV_LBL_No_of_Bene_Female--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(9).FindControl("GV_LBL_No_of_Bene_Female"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(9).FindControl("GV_LBL_No_of_Bene_Female"), Label).Text() = ""
            End If
            REM --Currency Field GV_LBL_Daily_Cost_Per_Person--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "0.00" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = ""
            Else
                REM Putting Rs. Currency Symbol in front of the row text
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text() = "Rs. " + CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(10).FindControl("GV_LBL_Daily_Cost_Per_Person"), Label).Text()
            End If
            REM --Integer Field GV_LBL_Acc_Exp--
            REM Seeing if the item contains the value in question
            If CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(11).FindControl("GV_LBL_Acc_Exp"), Label).Text() = "0" Then
                REM Changing the value in question
                CType(GridView1.Rows(tmp_Total_GV_Rows).Cells(11).FindControl("GV_LBL_Acc_Exp"), Label).Text() = ""
            End If
        End While
    End Sub

--- Reportviewer ---

=Format(Fields!Daily_Cost_Per_Person.Value, "Rs.00")
Common VB functions are applied.
For some reason the integer is not to be denoted by anything, only the zeros are dot. It works.

Reportviewer Changes to make it work for VWD 2005

http://forums.asp.net/t/1362315.aspx
dear friend
I had this problem and solve it by this :
I delete all of Temporary Asp files on : C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
and then ( optional ) you can delete you user Temporary Internet Files on : C:\Documents and Settings\YourUserName\Local Settings\temporary internet files
base solution : put these line of code to your web.config file
<add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
you also should comment your previous assembly version on <asssembly> section like :
<!--<add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>-->
<!--<add assembly="Microsoft.Reporting.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>-->
and you may have some other related assemlby to version 8.0.0 ,  like
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
change them to version 9.0.0 ,
please let me know was it helpful for you or not , please mark this as answer if it worked for following users , thank you

Report server link VWD 2005

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_ReportAddin.msi

Saturday, October 16, 2010

INSTRUCTIONS: PUBLISH WEBSITE to DLLs / OBFUSCATOR to protect code

Publish into DLL
use vs 2008 or 2005 (not VWD) and use menu command Build -> Publish website command.
Run it two times if fails.
-uncheck "allow this precompiled site to be updatable"
-check "use fixed naming and single..."
-usually published in directory e.g C:\Documents and Settings\sh\My Documents\Visual Studio 2008\Projects\Lungar Project Website\PrecompiledWeb\Lungar Project Website
-make that after publish you copy all report files as is in the published compiled directory because reports dont seem to run in dlls.
-also copy reportviewer files (dlls) into code directory.
---- to deploy into single dll ---
http://www.microsoft.com/downloads/details.aspx?FamilyId=0AA30AE8-C73B-4BDD-BB1B-FE697256C459&displaylang=en
http://forums.asp.net/t/1071783.aspx
------------------------
http://forums.asp.net/t/1071783.aspx
http://msdn.microsoft.com/en-us/library/1y1404zt%28VS.80%29.aspx
---
obfuscators
http://www.ssware.com/cryptolicensing/downloadnet.htm
http://www.babelfor.net/

Putting image in reportviewer, issues regarding sizing

-keep width of 1024 pixels in paint.net image dimensions
-make sure to select top report menu and embed again
-set Sizing property of image to Autosize preferably
-if in doubt use http://auctionrepair.com/pixels.html to convert image to pixels and vice versa

adding newline character in reportviewer textbox

="Served So Far" & vbcrlf & SUM(CInt(Fields!Total_Bene.Value))
this is done in the expression editor
--

inserting image in reportviewer

put it in report header
select top menu report, choose embedded images, add the image by browsing.
drop the image control onto the header from the toolbox
set image control property Source=Embedded and select the picture name in the dropdownlist of property Value.

Labels

.ico (1) acunetix (1) adding controls dynamically (1) adding list item programatically (1) adding parameters (1) aligning (2) aligning buttons (1) and Bind() can only be used in the context (1) anonymous access (1) appending static dropdownlist items (1) asciibetical sort (1) asp.net (101) assembly (1) asterisk (1) auto increment (1) autopostback (1) autosize (1) aztech (5) behavior (1) boundfield (1) browser tab icon (1) busybox (1) bypass proxy (1) calculate totals in reportviewer (2) cangrow (1) cascading style sheets (1) case (1) CDbl (1) changemode (1) checkbox (1) columns (1) comments (1) comparing all values (1) comparing integer values (2) comparison (2) conditional IIF (1) confirmation box on delete (1) connection string (1) control (1) controlID (1) controlparameter (1) convert (1) convert format of currency or float or 0.0000 to 0.00 (1) convert image to pixels (1) converting dates (2) css (1) ctype (1) culture (1) currency (1) current date (1) current ports (1) data typeconversion (1) database (2) databind (1) databound (5) dataformatstring (1) date column (1) date format (3) date sort in gridview (1) db_datareader (1) db_datawriter (1) dd MMM yyyy (1) defaultmode (1) delete button (1) deleting (1) deleting rows (1) deploying website to IIS (3) deployment error (1) deployment to IIS (4) detecting formview move (3) difference between filterexpression and selectexpression (2) difference between publish and build in visual studio (1) directory security (1) display error on no data in reportviewer (2) distinct (1) DLL (1) DMZ (1) double value (1) double quotes in javascript (1) download reportviewer (5) download visual web developer (3) drill down (1) drilldown (1) drilldown dropdownlist (1) dropdownlist (4) dropdownlist showing double values on postback (2) DSL 605EU (5) dynamic DNS (1) dyndns (1) e.values (1) edit mode (1) embedded images (1) emptydatatemplate (1) enableclientscript (1) enableviewstate (1) error during selection in filter of non matching values (1) Eval() (1) event manager (1) excel to sql server (2) executiontime (1) expression (2) F5 key refresh (1) failed to load viewstate (1) favicon (1) favicon.ico (1) feedback (1) feedback module (1) field expression (1) file permissions (1) filter (3) filterexpression (2) filterparameters (1) findcontrol (1) firefox (1) firefox password problem (1) firewall (1) float (1) focus (1) font (1) footerrow (1) format currency (1) formatting date in reportviewer (1) formview (11) formviewmode (2) freeze screen (1) global ip (2) globals (1) gotreportviewer (1) grand total (1) gridview (18) gridview labels (3) handling dates (6) handling nulls (5) html (1) htmlencode (1) httphandler (1) icon in address bar (1) icon in browser (1) IIS (6) IIS 5 (2) IIS 7 (1) IIS admin tool (1) IIS error (1) iis installation (1) IIS manager (3) IIS personalization (1) IIS pool (3) IIS setup (1) IIS Unexpected error 0x8ffe2740 (1) image control (1) image sizing in reportviewer (1) importing html into excel (1) index was out of range (1) insert (4) insert image in reportviewer (1) inserting (1) insertparameters (1) integer (1) integer column (2) intellisense (1) iteminserted (1) iteminserting (2) itemupdating (2) javascript (6) javascript and smartnavigation (1) javascript intellisense (1) label (1) left align pagerstyle (1) listitem (1) live ip (2) load (1) maintain cursor on field after postback (1) maintainscrollbackposition (2) managing deletion (1) microsoft (2) modechanged (1) modechanging (1) money column (1) money field (1) monitor IIS errors (1) monitoring ports (1) ms excel (1) ms word (1) multiple values shown (1) natural sort (1) network service (3) newline character in reportviewer textbox (1) newmode (1) nirsoft (1) no data (1) non focus (1) non null (1) norows property (1) obfuscate (1) obfuscator (1) objectdatasource (3) onclientclick (1) onfocus (3) onkeyup (1) page expiry (1) page margins (1) page_load (1) pageindex (1) panel (1) parameterized query (1) pdf (1) permissions (2) port forwarding (2) port scanner (1) ports (2) postback losing focus problem (1) pre-compile tasks visual studio (1) prevent insert on refresh (1) prevent multiple records being added (1) preventing doubleclick (1) preventing multiple clicks (1) primary key (1) primary key column (1) profile (2) programming (1) protect asp.net code (2) publickeytoken (1) publish to DLL (2) publish website (2) putting blanks in formview (1) reboot router (1) referencing values of selectcommand (1) register asp.net (1) registerstartupscript (2) remove focus (1) removing a textbox (2) report header (1) reportaddin.msi (2) reporting services (3) reportviewer (11) reportviewer formatting A4 size PDF (1) reportviewer formatting for A4 size PDF (1) reportviewer header scroll problem (1) reportviewer showing header (1) reportviewer showing header constantly (1) reset autokeys (1) restart router (1) router (6) router interface (1) rows (1) schema (1) scriptmanager (1) scroll function (1) scroll to window location with javascript (1) scrolling scrollbar with javascript (1) selectcommand (1) selectedindexchanged (1) selectedrowstyle (1) selectedvalue (1) selectexpression (1) selecting control inside gridview (1) selecting null as 0 (1) selecting null as zero (1) selecting nulls (3) selecting row (1) selecting totals in t-sql using subquery (2) selecting week (1) server application unavailable (1) session state (2) session timeout (1) set focus on control on page load (1) setting tab order of controls (1) setup firewall (1) showtime (2) single quotes in javascript (1) sizing property (1) skype port 80 conflict (1) smartnavigation (3) smartnavigation errors (1) smartnavigation problems (2) smartnavigation solutions (1) sorting (1) sql server (47) sqldatasource (9) SSRS (5) start primary key column from 1 (1) static ip (1) string value (1) stylesheet (1) subquery (2) summary (1) system.web (1) t-sql (22) tab index (2) tab order (2) table (1) table of contents (1) table wrap (1) tables (1) tcp port (1) TD (1) telnet (1) templatefields (2) ternary IIF operator (2) textbox (4) textchanged (1) timeout (1) top row (1) totals in gridview footer (2) TR-068 WAN Access (1) trimming values (1) truncate table (1) try catch block (1) updating (1) validation (1) validationsummary (1) vb (76) version (1) viewstate (1) viewstate error (1) virtual directory (1) visiblefalse (1) visual studio 2008 (4) visual web developer (5) visual web developer 2005 (3) vwd (2) watch activity (1) watermark (1) web tunnel proxy (1) web.config (4) webforms (1) webserver (1) Website Vulnerabilities (1) where clause (1) windows CD (1) windows server (3) windows vista (2) windows xp (1) wrap line (2) wrapping text in reportviewer textbox (1) xp (2) XPath() (1)