DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005

    MS SQL Reporting Services in dotNet

    aside from creating stored procedure to filter data in the database how can we filter data that is inputted from the user...

    in MS ACCESS this is the code...
    PARAMETERS [Beginning Date] DateTime, [Ending Date] DateTime;

    SELECT DISTINCTROW Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, [Order Subtotals].Subtotal AS SaleAmount

    FROM Employees INNER JOIN (Orders INNER JOIN [Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID) ON Employees.EmployeeID = Orders.EmployeeID

    WHERE (((Orders.ShippedDate) Between [Beginning Date] And [Ending Date]));

    the [Beginning Date] and the [Ending Date] is a user input to querry data from the database...

    but in dotNet they no longer support this method... so any help would be great...

  2. #2
    Join Date
    Dec 2003
    What do you mean by saying it isn't supported? How are you trying to use the below SQL statement?
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Jul 2005
    what i mean is about this "PARAMETERS [Beginning Date] DateTime, [Ending Date] DateTime;" the MS SQL do not support this method they only use "DECLARE [Beginning date].... i know how to create filter in stored procedure what i want to know is when you filter it in dotNET when you create MS SQL Reporting Services and filter the data which is user defined... i also know that dotNET can filter in the data section but it is not user defined i just wanted to prompt the user what will be displayed... in Visual Basic the code would look like this...

    SQL = "Select * From vselInvoice Where dateShip like ' & text1.text & '";

    in dotNET what would the could look like if your making an MS SQL Reporting Services... btw have you ever used one? because if you do you'll know what im talking about....

  4. #4
    Join Date
    Dec 2003
    I've not used Reporting Services before but the below link seems to demonstrate how to use query parameters:

    Using Parameters in a Report
    Microsoft MVP (Visual Basic)

  5. #5
    Join Date
    Sep 2004

    Parameters in MSSQL

    Hi there,

    I don't really know about Reporting Services, except that the parameters for a report are built into the report, which are filled or selected from while a report is executing, from wizards and menu options while you are building a report. Also, whether sql batch or stored procedure, you are likely to use @ variables as parameters inside sql statements. In MSSQL, for example, parameters look like this:

    create procedure test123 as
    varchar @aParameter input,
    integer @result output

    --and so on

    I think it is better to send parameters to a SP in sql server.


    "What you think doesn't matters! What matters is evidence..."

Similar Threads

  1. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  2. Blocking problem with DSN-less connection
    By Adam Dawes in forum VB Classic
    Replies: 3
    Last Post: 12-21-2000, 11:50 AM
  3. Problem with SQL Server OLAP Services SP2
    By William in forum Database
    Replies: 0
    Last Post: 07-28-2000, 05:00 AM
  4. SQL server administrative knowledge
    By Becky in forum Database
    Replies: 1
    Last Post: 07-11-2000, 03:27 PM
  5. Re: ODBC error
    By Devaraj in forum Enterprise
    Replies: 0
    Last Post: 05-11-2000, 12:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.