Crosstab Graph Report not showing Parameters in text box
in [Reports]
|
From: Alaska1 on 7 Jun 2010 13:30 I have a report using a crosstab query in a graph. The query is asking for parameters. When I try to pass the parameters to a text box on the graph they will not pass through. I am building it in text box in an expression. Any suggestions?
From: Duane Hookom on 7 Jun 2010 15:11 I would expec the parameters to come from controls on a form. You should be able to add text boxes to the report near the graph with control sources like: =Forms!frmParameters!txtStartDate -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads? "Alaska1" wrote: > I have a report using a crosstab query in a graph. The query is asking for > parameters. When I try to pass the parameters to a text box on the graph > they will not pass through. I am building it in text box in an expression. > Any suggestions?
From: Alaska1 on 7 Jun 2010 15:26 The data is actually in table and in the query. I do not have that data displaying on the form. Only in the table and the query. "Duane Hookom" wrote: > I would expec the parameters to come from controls on a form. You should be > able to add text boxes to the report near the graph with control sources like: > =Forms!frmParameters!txtStartDate > -- > Duane Hookom > Microsoft Access MVP > > NOTE: These public News Groups are ending June 1st. Consider asking > questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads? > > > "Alaska1" wrote: > > > I have a report using a crosstab query in a graph. The query is asking for > > parameters. When I try to pass the parameters to a text box on the graph > > they will not pass through. I am building it in text box in an expression. > > Any suggestions?
From: Duane Hookom on 7 Jun 2010 17:13 If your criteria values are stored in a table, you can either use the table in the record source of a report/subreport or use DLookup() or use code. -- Duane Hookom Microsoft Access MVP NOTE: These public News Groups are ending June 1st. Consider asking questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads? "Alaska1" wrote: > The data is actually in table and in the query. I do not have that data > displaying on the form. Only in the table and the query. > > "Duane Hookom" wrote: > > > I would expec the parameters to come from controls on a form. You should be > > able to add text boxes to the report near the graph with control sources like: > > =Forms!frmParameters!txtStartDate > > -- > > Duane Hookom > > Microsoft Access MVP > > > > NOTE: These public News Groups are ending June 1st. Consider asking > > questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads? > > > > > > "Alaska1" wrote: > > > > > I have a report using a crosstab query in a graph. The query is asking for > > > parameters. When I try to pass the parameters to a text box on the graph > > > they will not pass through. I am building it in text box in an expression. > > > Any suggestions?
|
Pages: 1 Prev: Automatically name a report when exporting to PDF Next: First Letter of each word |