Hi Tracy...

You have mentioned that you are unable to view report(s) on report server....But you are able to view other default settings...it seems that report server is running fine....and I...

Hi.........

So...It means that you wish to create reports which are offline and not sharing the data source between them...They must be using individual data sources...Its very much possible that you...

Hi..

Place a rectangle after the table footer and make settings for a page break at end as True...

I think..it should work...:)

Thanks...

Niraj

Hi...

Please try putting a rectangle after table footer and set Page Break on it....

It should work..as per your wish...!!

You can select "True" for Repeat Header option so that all pages...

My pleasure....

You can try this...

=IIf((Field!val1.Value/Field!val2.Value)>0,Format((Field!val1.Value/Field!val2.Value)),"#0.00000"),"0.00000")

..Let me knw...if it works..

Thanks...

Hello...

Please try this once and let me knw if it helps...

=Format(Sum(Fields!a.Value)/Sum(Fields!b.Value),"#.#####");

Thanks,

Hi Jim,

I think it can be acheived by calling the sub reports parameters from the main report...If the main report and sub reports depends on a common parameter (S),...

Hi...

The foremost thing is...it is essential to store credentials on Report Server for subscriptions to work..

Now..if your report datasource is Sql Server DB..then just put user name and password info...

Hi Luke...

You have done absolutely correct...There is no need to include seperate List control for every following sub reports...within a single list control only...we can perform the same operation...

Please let...

Hi Suman,

Go to directory settings and try unchecking "Anonymous Access"....checkbox...

I hope...it will help to some extent...

Thanks...

Niraj

Hi Suman...

Instead of Report Footer...try once using a textbox...after the table...

So...it will not be repeated on every page...it will come after whole data gets printed...

And if you wish to print...

Hi Shikha...

Please try this;

...instead of using...where trim(Reg_De) =@Region;

try...where trim(Reg_De) In (@Region)....

I hope...it will work...:)

Thanks...

Niraj

Hi...

I think...your sub reports requires parameter(s) to run...So..please provide parameters frm main report so that your sub report should execute..properly...

Thanks..

Niraj

Hi...

Please try this...expression...

=IIf(RowNumber(Nothing) Mod 2 = 0, "Color1","Color2") Or

=IIf(RowNumber("DataSet1") Mod 2 = 0, "Color1","Color2")

Thanks...

Niraj

Hi...

Please try this...expression...

=IIf(RowNumber(Nothing) Mod 2 = 0, "Color1","Color2") Or

=IIf(RowNumber("DataSet1") Mod 2 = 0, "Color1","Color2")

Thanks...

Niraj