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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic SQL for Chart

Status
Not open for further replies.
rejoice

rejoice

MIS
Jun 5, 2002
42
MY
Can any one help me...

I have created a line graph to show progress of different items within a period of time. Sometime user might want to show several item instead of all; OR, they want to set different date range.

I can do this nicely in FORM, but when come to REPORT, it does not allow me to change the SQL in its ROW SOURCE properties. What can I do for this?

Thanks.
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
502
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
358
sxschech
sxschech
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
195
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Report Header and Column Formatting Issue 1
Replies
2
Views
631
BallunarCrew
BallunarCrew
PLCBeetle
  • Locked
  • Question
Pass Form value to Report Record Source
Replies
4
Views
236
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top