Hi can you please post the scripts to create the tables you need help with, and some insert statements to populate data into these tables.

And also what the output...

Actually I've just realised that my question to you was pretty pointless. I can't help you unless I can actually see the .rdl file. Sorry. Maybe it would help if...

It would be nice if you could show us what you mean to do. Can you give us the create table statement and inserts of data for the table you...

Do you get the blank pages when you try and view the report or when you try and print the report?

Hi Bhargav Patel,

I'm not sure I'd agree with you. Temporary tables can be indexed, whereas CTE's cannot. It might be quicker in terms of coding turn around time, but performance...

Hi, what is the question?

You are going to think I'm crazy... :w00t:

AAAANNNNYYYYWWAAAAAYYYY the code below is based on what i think a report user table would look like. Basically I'm thinking it looks something...

I'd just like to say that if you want help and quickly then in future you should post your code like I've done at the end of this post. I...

Hi Paula,

You need to include your CASE statements in your group by clause for your query to work. eg:

SELECT TOP 10

[VOLUME] = count(1),

[ISVALID] =

CASE BOT_DR_CLIENT_NO

WHEN 1 THEN 'YES' ELSE...

Ok, I dragged a textbox onto one of my existing reports and captured "C:\MyFile.txt" in it.

Then I created the file itself on my C:. In the file I put...

What requirement needs to be done in SQL server?

In that case my answer to you question would be "don't do it".

Tell us a bit more about the server you are running the package on. What applications does it have running other than Integration Services? Give us a bit more to...

When there are more than one packages executing at the same time, I want one package to be executed at a single time while rest of the packages waiting for...

Well what you could try is store the list of file names that you have already imported in a table. Then once a week your SSIS package can run, check...