1. 

   myDBR Team, Key Master

   You should notice that the query format for multiseries charts is:

   select Category, SeriesName, SeriesValue
   from mydb.Data;

   ,where in your case the
   Category = omschrijving
   SeriesName = Q1_2009, Q2_2009, Q3_2009, Q4_2009
   SeriesValue = Doelstelling

   Now that you have the quarterly targets in different tables, you should do union between the queries to get them in same chart. You might want to consider that if you can put the quarterly targets in one table, the report would be much simpler.

   --
   myDBR Team

Reply

You must log in to post.