Line Column Charts

Is it possible to generate a line column chart in Reporting services.
It is possible in Excel. But I haven't found a way in reporting
services.Please check this previous posting (it also contains a sample RDL):
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> Is it possible to generate a line column chart in Reporting services.
> It is possible in Excel. But I haven't found a way in reporting
> services.|||Thanks Robert
Next question is how does one add a secondary Y axis scale and title
like it is possible in Excel.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Please check this previous posting (it also contains a sample RDL):
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DavidR" <david.reller@.ato.gov.au> wrote in message
> news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > Is it possible to generate a line column chart in Reporting services.
> > It is possible in Excel. But I haven't found a way in reporting
> > services.|||Secondary Y-axis is not natively supported in RS 2000, but is on the list
for inclusion in a future release. Some workarounds for RS 2000 are
discussed here:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=687c54df-a60c-4484-8d2b-3159cbc924d1&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"DavidR" <david.reller@.ato.gov.au> wrote in message
news:49eca18c.0409142149.7a9dc1d2@.posting.google.com...
> Thanks Robert
> Next question is how does one add a secondary Y axis scale and title
> like it is possible in Excel.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:<OwzDi8gmEHA.324@.TK2MSFTNGP11.phx.gbl>...
> > Please check this previous posting (it also contains a sample RDL):
> >
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "DavidR" <david.reller@.ato.gov.au> wrote in message
> > news:49eca18c.0409131955.7fe6de8e@.posting.google.com...
> > > Is it possible to generate a line column chart in Reporting services.
> > > It is possible in Excel. But I haven't found a way in reporting
> > > services.

Line Chart Help

Unfortunately this isn't as easy as it sounds. I am trying to build a chart just like the one in the attachment (I made it in Excel to show what I want). It's a simple line chart that reflects a trend of data over a period of time. However, there may be multiple entries on one day (such as the 24th in the example), but a single entry on another day.

Crystal wants to summarize the data and present ONE value for ONE day even if there are multiple entries in a day. How can I make it stop doing this? Are there any 3rd party vendors that have additional charts that can be installed?

Check out the attachments:
Chart.jpg - Excel Chart
cry_chart.jpg - Crystal Chart (notice 2 values for 7/23, but Crystal only shows 1 on the chart)

FYIIm running 8.5 because thats the only version my app will support.

I'd appreciate any help!Actually, CR not just shows you 1 value for 7/23/07 on the chart, it returns you sum of those 2 values for that date:

HGB ..... 10.3 .... 7/23/07
HGB ..... 7.9 ..... 7/23/07

If your Date field containes only date, I don't think you can get CR to show your values separately. But if this is a date_time field just formatted as date you can do next:
Open your Chart Expert ->Data. In the 'On change of' section, highlight your date_time field, then click the 'Order' button. I believe you have 'for each day' selected for the 'The section will be printed'.
Set it 'for each second' then you will get your desired result.|||That's what I meant when I said that Crystal sumarizes the data for one day and only shows one value.

Cool man. I'll try that and see if it works. I appreciate it!|||This worked! Thanks for the help.