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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart returns no data

Status
Not open for further replies.

loppster

Technical User
Dec 28, 2005
1
US
I am using Crystal 11 and I am creating a 13 month view of data for our different services in a bar chart. Some of the services do not have any data for the last 13 months, but we would like to at least show the 13 months as part of the chart details.

Any help would be appreciated!
 
Create a view or SP and create dummy rows, or create a period table and left outer join the period table to the current data.

Crystal doesn't fabricate data for you.

There are workarounds, but I'd suggest fixing it on the database side.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top