How to call just once for multiple report....

Hi all,
I will have to make it possible for one administrator to see one hundred
user's report in just one time.
What I have done is that I just embedded the module which was passing the
parameter to sql reporting server in C# programming code by using looping
statement .
However,if it is the only way, consequently I will have to call sproc as
many as user's count. What it means the performance will be very poor.
I am really curious to hear that. Please could you give me any comment on it?Have another report, fetch for all users and group by user.

How to call job step X from job step Y:

I have a SQL Server Agent job with multiple steps. I want
to be able to goto a specific job steps by choice from a
step within the job. How do I make a acll to another step
from a job step.
For example, based on data returned in step 5, I could go
to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
good enough in the given scenario. I don't want to use
sp_start_job to start the job at a specific step because
the job is already running and I just want to set the
control-of-flow to a different step.
Thanks
Abdul Gill
DBA/Royal Caribbean Cruise LimitedHi Abdul
Job Step control does limit your options for controlling process flow, so
how about using a DTS package? DTS gives you easy control over process flow
& can be scheduled into a SQL Agent Job as well. The tools for implementing
complex processes are far more advanced in DTS, there's even a GUI to
support visualisation of the process logic..
Regards,
Greg Linwood
SQL Server MVP
"Abdul M. Gill" <agill@.rccl.com> wrote in message
news:1474e01c41381$3b8f6a20$a101280a@.phx
.gbl...
> I have a SQL Server Agent job with multiple steps. I want
> to be able to goto a specific job steps by choice from a
> step within the job. How do I make a acll to another step
> from a job step.
> For example, based on data returned in step 5, I could go
> to step 1, 2, 3 or 4. 'OnSuccess', OnFailure' flow is not
> good enough in the given scenario. I don't want to use
> sp_start_job to start the job at a specific step because
> the job is already running and I just want to set the
> control-of-flow to a different step.
> Thanks
> Abdul Gill
> DBA/Royal Caribbean Cruise Limited

How to bulk deploy reports to multiple servers?

Hi,

I'm just wondering if there is any easy way to deploy reports to multiple servers. My current issue is that I need to deploy tens of reports onto tens of production server. Does anyone know how to do that?

Thanks a lot.

Cheers,

You can do that by using the command prompt utility and rss files. Look into the following link for more details:

http://msdn2.microsoft.com/en-us/library/ms162839.aspx

Then you can put multiple rs command lines in one single batch file (.bat) and then execute that file for deploying to multiple servers.

Shyam

How to build a table which holds varying numbers of fields?

I'm using a stored procedure with multiple parameters, and depending on
the parameters offered, tables with varying fields are returned.
How can I create a table in the layout window which will accomadate
these variations?
Thanks!Only matrixes have dynamic fields... however
for list or table, create the list or table with ALL of the fields, then
conditionally hide/show the fields at run time using the visibility
attribute..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Balding by the handful" wrote:
> I'm using a stored procedure with multiple parameters, and depending on
> the parameters offered, tables with varying fields are returned.
> How can I create a table in the layout window which will accomadate
> these variations?
> Thanks!
>