Skip to Content
author's profile photo Former Member
Former Member

Creating Report

Hai To All,

Using Query Gerenator i have created the report but now my lighting is that while generating report it want to ask the input for me how i can do it in query?

Reagards,

Anitha

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2007 at 10:31 PM

    Hello Ani,

    You can specify input parameters by using Field = '[%0]', Field = '[%1]'

    Example:

    SELECT T0.DocNum, T0.CardCode, T0.CardName, T0.DocDate, T0.DocTotal

    FROM [dbo].[ORDR] T0

    WHERE T0.CardName = '[%0]'

    In the above query I have used T0.CardName = '[%0]' in the Parameter Selection where the query will prompt the user to Select the CardName and show all results matching the CardName.

    You could also use criteria <b>T0.CardName LIKE '%[%0]%'</b>

    or

    T0.CardName = '[%0]' AND T0.DocDate = '[%1]'

    For each additional parameter you would use a different %number

    Hope it helps

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 12:44 PM

    Hi Ani,

    plz clear me that r u using Visual Studio 2005 with SQL Server 2005 or something else?

    Bcz i used this configuration.....so in this regard i ll be able to short out your problem.

    Kind Regards

    Yogesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.