can you upload your report (with an embedded SQL statement?)

hard to tell from here.

The problem is that you have to remove the duplicates before you insert the batch of records.

This is one option:

insert into table_2 (col1,col2,col3)

select DISTINCT col1,col2,col3

from table_1 t1

where not exists (select...

Are you sure that's the output you're expecting? Don't you mean you just want a normal output that you get from a comma-separated list of column names? Shouldn't the...

Could you post some consumable sample data? It would make it a lot easier to answer your question. And include the correct answer based on the data provided.

Here[/url]...

can you post the CREATE TABLE and INSERT scripts so we can reproduce the problem?

You need to have two data values on your graph. In my example, I had two bars in my bar chart because I had two value fields.

In design mode,...

That's basically what I was trying to point out. I would explain to the person requesting this the kinds of issues this kind of design will cause. Like...

Exercise your google-fu.

http://www.c-sharpcorner.com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/

The reason I prefer them as separate stored procedures is that I can grant rights to the SELECTS to one group, the INSERTS to another, etc. If you lump them...

If you lump all the CRUD into one stored procedure, how do you control who can do what? If the objects are separate, you can add them to the proper...

It's just my opinion, but why would you want one stored procedure per table? The problem this will cause down the road is if you want to deny one of...

I did it with a plain Tablix, but you're missing the consumable data part. And how is 180+180+180=180?

So I'm not sure how to do this with a Matrix... (or...

Terry,

before you do much of anything, I would recommend reading Jeff Moden's article[/url] (and borrow his code) for his DelimitedSplit8K TVF. It will split your data up really easily...

Here's...

It's better to include the entire problem in your description, as well as any SQL necessary to reproduce your setup/problem. If you give people enough information to easily answer...

One option might be to add a calculated field that returns just the date (no time) to your dataset and then use that to filter your dates.

=DateValue(Fields!orderdate.Value)