Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Report Query
- Thread starter phzero
- Start date
Are you going via a DataEnvironment or setting your Datareport DataSource in code?
If you're doing it in code, then use the parameters to change your DataSource, then re-assign.
dr1.DataSource = myNewRst
If you're using a DataEnvironment, then select the command that you want to use, click the SQL statement checkbox on the properties|General tab and type your complete SQL statement in there, e.g.:
SELECT Add1, Add2, Add3, ClientName, sold FROM tblClients WHERE (ClientName LIKE input1)
Now when you click on the Parameters tab, you'll find Input1 on the list. You can set it's name (as seen outside) and it's properties as required.
Then in code call it as e.g.:
strParam1 = "%" & Text3.Text & "%"
With de1
If .Connection2.State <> 0 Then .Connection2.Close
DoEvents
.Connection2.Open
.Command1 (strParam1)
End With
dr1.Show
In the example text3 contains the parameter, de1 is the name of the DataEnvironment, dr1 is the name of the DataReport and I'm using Command1 in Connection2 of the DatEnvironment
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
If you're doing it in code, then use the parameters to change your DataSource, then re-assign.
dr1.DataSource = myNewRst
If you're using a DataEnvironment, then select the command that you want to use, click the SQL statement checkbox on the properties|General tab and type your complete SQL statement in there, e.g.:
SELECT Add1, Add2, Add3, ClientName, sold FROM tblClients WHERE (ClientName LIKE input1)
Now when you click on the Parameters tab, you'll find Input1 on the list. You can set it's name (as seen outside) and it's properties as required.
Then in code call it as e.g.:
strParam1 = "%" & Text3.Text & "%"
With de1
If .Connection2.State <> 0 Then .Connection2.Close
DoEvents
.Connection2.Open
.Command1 (strParam1)
End With
dr1.Show
In the example text3 contains the parameter, de1 is the name of the DataEnvironment, dr1 is the name of the DataReport and I'm using Command1 in Connection2 of the DatEnvironment
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Thread starter
- #3
Hi johnwm,
Thank you so much for the reply, but it does not work for me. I am using a DataEnv. My command is called cmdMembers with this SQL statement:
select * from members where (memid = input1), but when I go to the Parameters Tab, input1 does not show up there. Am I missing something? Please help. Thanks in advance.
Thank you so much for the reply, but it does not work for me. I am using a DataEnv. My command is called cmdMembers with this SQL statement:
select * from members where (memid = input1), but when I go to the Parameters Tab, input1 does not show up there. Am I missing something? Please help. Thanks in advance.
I'm sorry but I can't duplicate your result. Any change to the parameters in the SQL statement on the General tab are immediately reflected on the Parameters tab.
Try using the SQL builder button, otherwise it sounds like a re-install of VB!
Good Luck
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
Try using the SQL builder button, otherwise it sounds like a re-install of VB!
Good Luck
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Thread starter
- #5
- Thread starter
- #6
Hi Johnwm,
After browsing the MSDN site extensively, I have found my answer. Actually, instead of putting "input1" in the query, I replaced it with a question mark "?" upon which param1 showed up on my Parameters Tab. Thanks for all the help though, I really do appreciate it. Keep well. Here is the URL: Search for "Parameterized DataReport". Article number is: Microsoft Knowledge Base Article - 244779
After browsing the MSDN site extensively, I have found my answer. Actually, instead of putting "input1" in the query, I replaced it with a question mark "?" upon which param1 showed up on my Parameters Tab. Thanks for all the help though, I really do appreciate it. Keep well. Here is the URL: Search for "Parameterized DataReport". Article number is: Microsoft Knowledge Base Article - 244779
- Status
Similar threads
- Locked
- Question
