Bit of a newbie in the CR design front.  Hope you can help or point me to some useful posts.

 

CR XI, I have a stored proc which returns 3 columns of data which can go into the thousands.

 

I would like to create a chart based on the stored proc but limited to say only the top 20 based on an ordering of one of the columns.  I would like to do this without alterting the stored proc because I would like to present all the data as well.

 

I have been able to present the data and the top 20 in the details section, so i can see what I would like to chart, but I guess doing a standard "create chart" will base it's source in the full data from the proc rather than what is seen on the details page(?).

 

Any ideas?  Is there a way I can "filter" the data out only for charting without again altering the stored proc?  The data from the stored proc is just returning out, and not being placed into a permanent table.

 

I could change the way to do this, i.e create sub reports and alter the stored proc to be called numerous times with "top" filtering, but I would like to expand my CR knowledge to see if it can be done in the report creator first.

 

Many thanks for any advice.

 

Regards.