on 11-17-2007 6:30 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.