Gaining control over report parameters

Hi All,

I have not heard any news on this topic elsewhere so thought I would ask here....

I would like to gain control over parameters in terms of:

1. Parameter placement as in how many parameters on a row, not just 2. It would be nice to be able to specify a row number in the defintiion of a parameter for example.

2. Access to the parameter text via a custom assembly to support multi-langauge reports.

I know other folks have talked about these things and some of us 'hope they are coming one day'...I was wondering if that day might be any closer now?

Thanks

hhhmmm....seems like this is not happening any time soon....

Anyone heard any news about this? It's been 7 months since I asked...

Thanks

Peter

|||

Funny... I was asked if this was possible today , and havent seen anything to date....

|||

Hi Mark,

this topic is discussed at length in the hitch hikers guide to report services...which is a very good book by the way...not sure if they are doing one for 2005.....

The authors said it would be a 6 month job to be able to write something useful to control how many parameters appear on a line....and it would seem obvious that if some clever person did that and it was popular it would just go into the next release of RS...so it seemed to them (and to me) that the most sensible people to write this functionality is MSFT.

What I am looking for is to be able to tell the report how many parameters to place on the line so that parameters that should be grouped together are....and also expose the text of the parameters to custom assemblies so a single report can be written in multiple languages....since the parameters are text, they cannot be written into multiple languages in the 'out of the box' version of the report browser...

From the looks of it..we will just have to wait...

Gaining control over report parameters

Hi All,

I have not heard any news on this topic elsewhere so thought I would ask here....

I would like to gain control over parameters in terms of:

1. Parameter placement as in how many parameters on a row, not just 2. It would be nice to be able to specify a row number in the defintiion of a parameter for example.

2. Access to the parameter text via a custom assembly to support multi-langauge reports.

I know other folks have talked about these things and some of us 'hope they are coming one day'...I was wondering if that day might be any closer now?

Thanks

hhhmmm....seems like this is not happening any time soon....

Anyone heard any news about this? It's been 7 months since I asked...

Thanks

Peter

|||

Funny... I was asked if this was possible today , and havent seen anything to date....

|||

Hi Mark,

this topic is discussed at length in the hitch hikers guide to report services...which is a very good book by the way...not sure if they are doing one for 2005.....

The authors said it would be a 6 month job to be able to write something useful to control how many parameters appear on a line....and it would seem obvious that if some clever person did that and it was popular it would just go into the next release of RS...so it seemed to them (and to me) that the most sensible people to write this functionality is MSFT.

What I am looking for is to be able to tell the report how many parameters to place on the line so that parameters that should be grouped together are....and also expose the text of the parameters to custom assemblies so a single report can be written in multiple languages....since the parameters are text, they cannot be written into multiple languages in the 'out of the box' version of the report browser...

From the looks of it..we will just have to wait...

Gaining control over report parameters

Hi All,

I have not heard any news on this topic elsewhere so thought I would ask here....

I would like to gain control over parameters in terms of:

1. Parameter placement as in how many parameters on a row, not just 2. It would be nice to be able to specify a row number in the defintiion of a parameter for example.

2. Access to the parameter text via a custom assembly to support multi-langauge reports.

I know other folks have talked about these things and some of us 'hope they are coming one day'...I was wondering if that day might be any closer now?

Thanks

hhhmmm....seems like this is not happening any time soon....

Anyone heard any news about this? It's been 7 months since I asked...

Thanks

Peter

|||

Funny... I was asked if this was possible today , and havent seen anything to date....

|||

Hi Mark,

this topic is discussed at length in the hitch hikers guide to report services...which is a very good book by the way...not sure if they are doing one for 2005.....

The authors said it would be a 6 month job to be able to write something useful to control how many parameters appear on a line....and it would seem obvious that if some clever person did that and it was popular it would just go into the next release of RS...so it seemed to them (and to me) that the most sensible people to write this functionality is MSFT.

What I am looking for is to be able to tell the report how many parameters to place on the line so that parameters that should be grouped together are....and also expose the text of the parameters to custom assemblies so a single report can be written in multiple languages....since the parameters are text, they cannot be written into multiple languages in the 'out of the box' version of the report browser...

From the looks of it..we will just have to wait...

Gaining complete exclusive access to a given table

Hi Group
While I'm fully aware that there are transations and that stuff like
this should be left to the server administration tools etc. I'm still
facing the problem of writing a middle ware where the existing,
unchangeabel upper layer application want's to get exclusive access
over a complete table and I have to emulate this behaviour in my
module. I figure I could select the complete table in a transaction to
do so, but I have a feeling that this might be pretty slow? Or is such
an apraoch sufficently fast? What better alternatives do I have?
TIA
MarkusWhat exactly are you trying to achieve?
Lock a table inside a transaction? Use locking hints or serializable
isolation level.
We can't give you an accurate answer to a vague question.
ML
http://milambda.blogspot.com/|||On Thu, 27 Apr 2006 15:47:12 +0200, Markus Zingg wrote:

>Hi Group
>While I'm fully aware that there are transations and that stuff like
>this should be left to the server administration tools etc. I'm still
>facing the problem of writing a middle ware where the existing,
>unchangeabel upper layer application want's to get exclusive access
>over a complete table and I have to emulate this behaviour in my
>module. I figure I could select the complete table in a transaction to
>do so, but I have a feeling that this might be pretty slow? Or is such
>an apraoch sufficently fast? What better alternatives do I have?
Hi Markus,
Check out the TABLOCK and HOLDLOCK update hints. They might be what
you're after.
(I assume that you *are* aware that implementing this instantly kills
any chance of ever scaling your app, are yoou?)
Hugo Kornelis, SQL Server MVPsql