I don't think Expressions are valid in Location Property as i tried once.But i am not sure How to express in VB? I am Glad if you can post a...

I don't think Expressions are valid in Location Property as i tried once.But i am not sure How to express in VB? I am Glad if you can post a...

Hi martin,

thanks for your reply,can you pls let me know How to keep the interval between days to be variable. i feel i didn't find any option to keep the...

hi dan,

Why don't you find the difference between the two sub reports.when you say both are working individually..interchange the two queries as they look similar and just check whether...

Try Hidden and internal parameters in the report parametres dialogue box.

if you can explain me the exact scenario you are searching for, i can help you.i am not clear...

Try this

= DateAdd(dateinterval.year,-1,Today)

Regards

Raj Deep.A

Dont we have any thing to fix the table size per page in reporting Services

No body had an idea.I was waiting for the reply.pls.........

Regards

Raj Deep.A

Why don't you write a stored procedure which displays a variable that is made to store each and every row in the column to concatenate with it selves seperated...

you are not granted permission to view the content.

I mean even though you installed report manager, the user from which you are trying to connect the system is not given...

Try this

=iif(RowNumber(Nothing) Mod 2,"White","PeachPuff")

Set the Dataconnection.assuming you are using reportmanager. i would like to say this

Go to properties --> datasources-->Shared Datasource or Connection String.This may solve your Problem.

Thanks

Raj Deep.A

If you can post the queries which you ran on query analyser and report .it would be helpful to us to evaluate the problem.Post the values you are trying...

Give like this

for listing the values in the dataset

Select null your_column from your_table

union

select yourcolumn your_column from your_table

it wont ask for null

as now null is the part...

Hi All

so What i thought is i can use isnull(@paramvalue,columnname) in the where clause.

The above all will work ,when and only when the Allow Null value is enabled in the...