Can I get the text you provided for the datasource.

Also just check in the where condition you have given @parametername same as the name you have given for the report...

Thanks a lot for the reply Jeff.

Hi Jeff,

I would like to know how you will approach this if the values are not hard coded, say it is from some table or it is a string with...

If you don't mind can you explain the exact requirement. 🙂

In the first part you have mentioned, if client ID is not selected it should retrieve data for ALL the...

No no, you don't have to check the box for Allow NULL , you keep it unchecked and in the Default value option make it nonqueried , and give the...

Hi,

I think you can do this , just refer the below link, which I have replied for another friend.

http://www.sqlservercentral.com/Forums/Topic915160-150-1.aspx

So I assume the above solution worked for you..

Regarding the border, I don't think we can control this. Probably you can check the boxes foe side margin for X and...

I agree with you Jeff.

If it is hard coded, I'm thinking as below.

SELECT *

FROM InvoiceDetails

WHERE InvoiceNo IN ('1248','1063','963','1524')

ORDER BY CASE InvoiceNo

WHEN '1248' THEN 1

WHEN '1063' THEN 2

WHEN '963'...

Hi,

Can you jut try this expression and see how it goes.

="Total Count" + chr(10) +"_________"+ chr(10) + chr(10) + "Total Revenue"

Sorry,

My assumption was the table was empty(no data). It looks like it has some data. In such cases while adding new columns by default it will take NULL values in...

Hi friend,

Assume you have 3 parameters (P1,P2 and P3) and 3 Datasets (D1,D2 and D3 ) such that P1 is populated by D1 , P2 by D2 and P3 by...

Hi

You have to do it like this:

The query which populates the ClientList dropdown you have to change such that it has the value <all> as the first value, then in...

Hi ,

Make like this

ALTER TABLE Job_title

Add MinSalary money not null

Go

ALTER TABLE Job_title

Add MaxSalary money not null

Hi friend,

I don't think it is correct.The WHERE condition should be how I have specified in the above section.