locked
Date range selection report RRS feed

  • Question

  • User2028249543 posted

    Hi,

    I need some help on how to get the date from and to on a certain subject code who are enrolled on a particular date.

    For instance, if a user selects a subject from a dropdown list and then selects date from and to it will show off all students info who are enrolled on that specific month.

    Simulation:

    Subject Code: <Math>

    From: <02/01/2012> To: <02/28/2012>

    ........

    Show all infomation on a report.

    Please help. Thanks.

    Friday, February 17, 2012 9:19 PM

All replies

  • User-152734399 posted

    u need to that thru back end u cant do it from front end ! 

    Saturday, February 18, 2012 12:10 AM
  • User-1344176646 posted

    please try this...

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
            TextBox3.Text = Convert.ToString(DateDiff(DateInterval.Day, Calendar1.SelectedDate.Date, Calendar2.SelectedDate.Date))
        End Sub
    
    
    <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Cal.aspx.vb" Inherits="Cal" %>
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>Untitled Page</title>
    </head>
    <body>
        <form id="form1" runat="server">
            <div>
                <asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
                <asp:Calendar ID="Calendar2" runat="server"></asp:Calendar>
                <asp:Button ID="Button1" runat="server" Text="Button" /></div>
            <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
        </form>
    </body>
    </html>
    Saturday, February 18, 2012 1:07 AM
  • User2028249543 posted

    @venkatmca008,

    thanks for your thoughts however can you please provide some sample for crystal report code behind for this. Thanks.

    Saturday, February 18, 2012 1:20 AM