.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL statement using BETWEEN within a report

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :ASP.Net
Hi, I'm trying to create a report which allow the user to choose a starting month and a starting year, then it will also allow the user to choose a ending month and ending year. My problem is: - for example, the starting month and starting year is June, 2010 ; the ending month and ending year is September 2011. The report should be able to display all the data within the range by uisng BETWEEN...AND, here is my sql statement: (MONTH(Maintenance_DateTime) BETWEEN @startmonth AND @endmonth) AND (YEAR(Maintenance_DateTime) BETWEEN @startyear AND @endyear) I'm using this sql statement and it ends up not displaying the data with the month October year 2010. If I choose the ending month to be October and the ending year 2011, then the report will only display the data with the month October year 2010. Can anyone help me to check what is wrong with my sql statement? Thank you.

View Complete Post

More Related Resource Links

Dynamic SQL statement for a multilevel hierarchy report

Basically I have a requirement from the functional team that need to show a multilevel hierarchy report.   ID ParentID A NULL B A C A D B E C F C G F   The above is the sample of the table.   I need to show the cascading relationship dynamically base on the available level. The issue was we would not know how deep the relationship in the table.   Target Result:   ID Parent Level 1 Parent Level 2 Parent Level 3 A NULL NULL NULL B A NULL NULL C A NULL NULL D B A NULL E C A NULL F C A NULL G F C A

Can I change report SQL Statement at runtime?

I need to change  report SQL Statement  at runtime. I need to do this because I have too much parameters and it's simple to me to change SQL statement.

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

Passing Linq Statement between master and content page


I usually work with windows forms, and am just starting to work with ASP.Net, so appologies if this is a dumb question!

I have a master page which has a search button on it. The results of this are built up using a Linq statement and if there are any results, I want to display the results in a contents page.

On the masterpage, I have the following code:

Private _res

    Public Overridable ReadOnly Property SearchRes()
            Return _res
        End Get
    End Property

 Private Sub DoSearch()
   'some code to get a linq result

    If res.Any Then
            _res = res
            Server.Transfer("SearchResults.aspx", True)
            'no results
            LabelNoRes.Visible = True
        End If
 End Sub

On the SearchResults.aspx page I have this code.

Dim m As pxSite = CType(Page.Master, MasterPage)
        If m.SearchRes IsNot Nothing Then
            Label1.Text = "Results found = " & m.SearchRes.Count
        End If

m.searchRes is always nothing. 

What am I doing wrong here?


How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


populate report viewer by code


Hi all

I have a button "Show Report" to show some data from table

what I should write under this button to populate the reports ?

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


May i use the collapse and expand feature (like tree menu) in Report ?


HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .


I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
If any one have experince before please share the ideas.


Best Regards

Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

ReportViewer :: Failed to enable constraints. But my statement is valid!!

  • A
  • n error has occurred during report processing.
      • Exception has been thrown by the target of an invocation.
        • Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

    Why do I keep getting this error, even when not using any data on the report. When I run the query in SQL server I get a resultset. However when I try to render the report I get this error.


    Dynamic Report in reportviewer


    HI I m sorry to say this But this task too urgent.

     Ex- i have two tables in my db name called Comdetails, deptdetails.

    TCS is a one company name stored in ComDetails and Company_ID took as primany key,

    TCS having 10 department stored in deptdetails and Company_ID as foreign key.

    so now in DB we have available one company with 10 departments.

    so now i need to generate report , i m using report.rdlc and reportviewer.

    i hope upto now its clear.

    my task-

    1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re

    Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


    how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


    Thanks in advance

    Report viewer error


    • An error has occurred during report processing.
      • A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1".

    • i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help

    Printing crystal report from webservice



    I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in crystalreportviewer by passing the webservice call to datasource. However, is there anyway, I can print directly without showing the report?

    Alternatively, I was trying return ReportDocument object from webservice, which would solve my problem, but I was unable to return the ReportDocument because of serialization issue. Is it even possible? Thank you


    Load Report Failed


    Hi All,

    I created a simple crystal report using visual studio 2008 (GAC INSTALLED VERSION 10.5.3700.0) . It is working fine locally. When I deploy it to the server when I click on the report I am seeing the empty report with  "LOAD REPORT FAILED" Text. How can I resolve this Issue?

    I checked the GAC and made sure that Both are using the same version of Crystal reports . Can some one help me how to resolve this issue?

    Correct me with report.setDatabaseLogon and .setDataSource


    Hi All,

    I was getting a load report failed error on the server before (locally it was working fine). I tried everything one of the solutions that helped me partially was adding below lines to the code.

     ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");

    When I add the above Line to Local Mechine it is working fine and returning data.(Records)

    But When I publish this code to server I am getting a screen that has

    Server Name : Filled

    DataBaseName : EMPTY

    UserName :Filled


    screen and I am unable to enter the databaseName.

    Scenario 2:


    ext.SetDatabaseLogon("UserId", "Password","DataBaseTest","ServerName");

     When I add these 2 lines to local mechine all the crystal report with heading and date is coming up but the data from the sql server is not appearing. Actually this is loading the report correctly but unable to get the data from the data base. (Not displaying any records although it is supposed to display 100 Recs)

    When I deploy it to the server it is acting the same way.Displaying the record with heading , date, page number etc, but no data

    Do you know what should I do to

    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend