Issues Filtering a chart

I am trying to filter a series in a chart by specifying
a paramter. I am showing a chart where the data
returned from the SP has many employees, but I only
want the employee specified in the parameter. However,
when I enter the following:

=Parameters!employee_id.Value

into the filters tab for the employee series, the chart
is blank and I know for sure that there is data for the
employee I have specified in the parameter because
when I remove the filter, that employee shows up in
the legend along with 20 others.

This should be simple and it's driving me nuts!
Can someone point out what I'm doing wrong?

Turns out the SSRS "like" operator does not
ignore spaces like SQL does. I had spaces
coming back at the end of each employee so
I had to modify the above as follows:
=Parameters!employee_id.Value + "*"

Issue with inserting chart into table's cell

Hello, look at this one

I've formed table with grouping

+ Group 1 | Sum(field1) | Chart
Elem1 | field1 | "Cannot place a chart at this location in the table"

Why I cannot insert chart at this place?

Thanks

It sounds like you are trying to place the chart into the table detail area. I.e. for every detail data row, you would one chart instance - so every chart instance has just one data point.

Instead, put the chart into the group header or group footer.

-- Robert

|||I get a similar error when trying to paste a table in a detail cell of another table. "Cannot place a Table at this location in the Table" Yet I can insert a new table into that table cell from the toolbox. The table I want to paste is based on a single data point from the parent table. I can recreate it, but it would be a lot easier to paste it from another report.

Issue charting data over last 24 hours...

I have a table which contains data regarding calls to the Help Desk, I want to chart this using a simple line chart in SSRS 2005 with the chart displaying the number of cases opened by the help desk each hour for the last 24 hours. Although our Help Desk provides 24/7 support, there are periods of an hour in which no calls are received. The issue I'm having is I want the chart to still display these hour periods of time even though there are no records created in the time span. I want the x-axis to display every hour for the last 24 hours.

Anyone have any suggestion on how I can accomplish this? The only idea I've come up with is creating a new table containing a list of every hour in a day and referencing this to build the x-axis...but it seems as though it should be easier than that?

Thanks in advance for any input or assistance.

>>The only idea I've come up with is creating a new table containing a list of every hour in a day and referencing this to build the x-axis

I have to do the same thing a lot, except on the calendar level rather than the hour level.

Although maybe it *should* be easier, I don't know a better way to do it.

Because the calendar is a bit more dynamic, I don't store the data in a table but rather generate it on the fly. In your case, it's static (there are always 24 hours) so it makes some sense to just store the data in a table, in the form you need it --

However you *can* generate it on the fly pretty easily if you wish.

Pick some table that always has >= 24 rows for this task -- I'll use master.dbo.spt_values here --

Code Snippet

SELECT TOP 24 ROW_NUMBER() OVER (ORDER BY name) FROM dbo.spt_values

... put this in a table-valued udf, reference the udf in your query...

HTH,

>L<