Repostition Parameters

I would like to know if it's possible and, if it is, how to reposition
parameters when viewing reports accessed through URL reporting and using the
Report Viewer. For example, we have 5 parameters on a report. One is a drop
down dynamic list of customer names, two are dates (start and end) and 2 are
radio buttons. We would like the list of customer names to be first with
nothing to the right of it. Then the two date parameters on the next line.
And lastly, the 2 radio button parameters displayed on the last line. I
cannot find a way to do this within SSRS or by using CSS. I fear it may be
totally controlled by SSRS with no chance for reformating or customization.
Thank you
--
Jeff Loebick
SQL Developer
ProformaOn Mar 14, 12:52 pm, Jeff Loebick
<JeffLoeb...@.discussions.microsoft.com> wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma
As far as I know, you are correct. That said, you can change ordering
of the parameters (i.e., which one is 1st, 2nd, and so on). That would
be done from the Report tab (at the top) -> Report Parameters dialog w/
the up and down arrows. Sorry that I could not be of further
assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||If time permits, you can write your custom screen for all your entry needs
and integrate with reports using web services. Having said that, its not so
easy to write on the fly, but pretty simple if you have some time to write, I
have been using this web services for long and believe me its good. To start
with you can go through some samples available in BOl and pickup the same pgm
and change according to your needs, that will make your development faster.
Amarnath, MCTS
"Jeff Loebick" wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma

Repositioning a large table column

I need to reposition a column on a large table
but everytime the EM will time out. Am I not
waiting long enough and if so how long do I have
to wait. Is there a better way to go about this ?Don't do it. You can query the columns in the order you want them.
In EM when you do this, it is actually dropping and recreating the table.
You can imagine how much work this is for a large table.
If you beleive that you have a good reason to do this, post it and maybe
someone can convince you of the errors of your ways. :-)
"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:5f8b01c524be$f7f60990$a601280a@.phx.gbl...
>I need to reposition a column on a large table
> but everytime the EM will time out. Am I not
> waiting long enough and if so how long do I have
> to wait. Is there a better way to go about this ?|||Why does it matter what "position" the column is in?
You can select the data any way you want:
SELECT ColA, ColB
FROM Tbl
or
SELECT ColB, ColA
FROM Tbl
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:5f8b01c524be$f7f60990$a601280a@.phx.gbl...
> I need to reposition a column on a large table
> but everytime the EM will time out. Am I not
> waiting long enough and if so how long do I have
> to wait. Is there a better way to go about this ?|||EM recreate the table (create a new table, move data, constraints, etc. and
then rename the table) in order to do this. Doing this in a large table will
consume time.
Why do you need to do this?
AMB
"Phil396" wrote:

> I need to reposition a column on a large table
> but everytime the EM will time out. Am I not
> waiting long enough and if so how long do I have
> to wait. Is there a better way to go about this ?
>|||Create a new table populate it with the old data and then drop the old
table. That is what EM is doing behind the scenes.
Why do you want to reposition a column? Sometimes that's handy in
development but on a production system it shouldn't matter. Column
order is determined by the order the columns are listed in a SELECT
statement, not by the physical order in the table. Don't use SELECT *
in production code and you won;t have to worry about column order.
David Portas
SQL Server MVP
--|||I could give a ___ ____ ____ what position the columns
are in but my boss ( this is the guy who signs my
paycheck ) would like it positioned in the database in a
certain order. Please if you have a sesame street answer
for this problem please keep it to yourself.

>--Original Message--
>Why does it matter what "position" the column is in?
>You can select the data any way you want:
>SELECT ColA, ColB
>FROM Tbl
>or
>SELECT ColB, ColA
>FROM Tbl
>
>--
>Adam Machanic
>SQL Server MVP
>http://www.sqljunkies.com/weblog/amachanic
>--
>
>"Phil396" <anonymous@.discussions.microsoft.com> wrote in
message
>news:5f8b01c524be$f7f60990$a601280a@.phx.gbl...
>
>.
>|||"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:5ff501c524c7$709c4af0$a601280a@.phx.gbl...
> I could give a ___ ____ ____ what position the columns
> are in but my boss ( this is the guy who signs my
> paycheck ) would like it positioned in the database in a
> certain order. Please if you have a sesame street answer
> for this problem please keep it to yourself.
Maybe you can create a view for your boss to look at and then get back to
doing real work?
As other posters mentioned, the only way to do this is to drop the table,
create a new one, and insert all the rows -- that's what EM does, and that's
why it's incredibly slow.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||Yes I was afraid something like this was going on.
We have hundreds of tables and many with too
many columns. That is not to metion the a billion rows
of data in those tables. In SQL Server 2005 this problem
should be address a better way because we have a lot of
contractors who will come in and get lost because cetain
columns will be located not were you expect them to be.
Thanks

>--Original Message--
>"Phil396" <anonymous@.discussions.microsoft.com> wrote in
message
>news:5ff501c524c7$709c4af0$a601280a@.phx.gbl...
a
answer
>Maybe you can create a view for your boss to look at and
then get back to
>doing real work?
>As other posters mentioned, the only way to do this is
to drop the table,
>create a new one, and insert all the rows -- that's what
EM does, and that's
>why it's incredibly slow.
>
>--
>Adam Machanic
>SQL Server MVP
>http://www.sqljunkies.com/weblog/amachanic
>--
>
>.
>|||you should really try to reason with your boss - or implement Adam's clever
solution.. but if neither works - and i really don't think it's something
you should do, but nevertheless.. you can update colid column in syscolumns
directly. first, set 'allow updates' option on:
exec sp_configure 'allow updates', 1
reconfigure with override
and then you can:
update syscolumns set colid=xx where id=object_id('table_name') and
name='column_name'
there is a unique constraint on id and colid, so you will have to be
creative when swapping colids :)
make sure you turn 'allow updates' off when done. and really, really, try
other solutions before doing this.
dean
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23vco%23gMJFHA.2356@.TK2MSFTNGP14.phx.gbl...
> "Phil396" <anonymous@.discussions.microsoft.com> wrote in message
> news:5ff501c524c7$709c4af0$a601280a@.phx.gbl...
> Maybe you can create a view for your boss to look at and then get back to
> doing real work?
> As other posters mentioned, the only way to do this is to drop the table,
> create a new one, and insert all the rows -- that's what EM does, and
that's
> why it's incredibly slow.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>|||From BOL:
System tables should not be altered directly by any user. For example, do
not attempt to modify system tables with DELETE, UPDATE, or INSERT
statements, or user-defined triggers.
"Dean" <dvitner@.nospam.gmail.com> wrote in message
news:uUi69aNJFHA.580@.TK2MSFTNGP15.phx.gbl...
> you should really try to reason with your boss - or implement Adam's
> clever
> solution.. but if neither works - and i really don't think it's something
> you should do, but nevertheless.. you can update colid column in
> syscolumns
> directly. first, set 'allow updates' option on:
> exec sp_configure 'allow updates', 1
> reconfigure with override
> and then you can:
> update syscolumns set colid=xx where id=object_id('table_name') and
> name='column_name'
> there is a unique constraint on id and colid, so you will have to be
> creative when swapping colids :)
> make sure you turn 'allow updates' off when done. and really, really, try
> other solutions before doing this.
> dean
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:%23vco%23gMJFHA.2356@.TK2MSFTNGP14.phx.gbl...
> that's
>

Reposition Subtotals

Hi,
I have created a very simple tabular report with only one row group which I
have enabled subtotals on. What I am not enjoying is that the subtotals
seem to HAVE to be at the top of the group:
Below is an example. The DEPT header is the row group.
DEPT |INV_NO |VALUE
--
TX10 | - | £600.00
| SI123456 | £200.00
| SI123457 | £200.00
| SI123458 | £200.00
MX10 | - | £900.00
| SI123456 | £300.00
| SI123457 | £300.00
| SI123458 | £300.00
HX10 | - | £300.00
| SI123456 | £100.00
| SI123457 | £100.00
| SI123458 | £100.00
In the above example the subtotal for the group is in the same line as the
row name. Is there a way of getting it to be positioned at the bottom? For
example:
DEPT |INV_NO |VALUE
--
TX10 | - |
| SI123456 | £200.00
| SI123457 | £200.00
| SI123458 | £200.00
| | £600.00
TIA,
JarrydWhen you define a group, by default it shows you the group header, detail
line and group footer.
Have you tried to put subtotals in the group footer?
"Jarryd" <jarryd@.community.nospam> escribió en el mensaje
news:uUWbDFEKIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have created a very simple tabular report with only one row group which
> I have enabled subtotals on. What I am not enjoying is that the subtotals
> seem to HAVE to be at the top of the group:
> Below is an example. The DEPT header is the row group.
> DEPT |INV_NO |VALUE
> --
> TX10 | - | £600.00
> | SI123456 | £200.00
> | SI123457 | £200.00
> | SI123458 | £200.00
> MX10 | - | £900.00
> | SI123456 | £300.00
> | SI123457 | £300.00
> | SI123458 | £300.00
> HX10 | - | £300.00
> | SI123456 | £100.00
> | SI123457 | £100.00
> | SI123458 | £100.00
> In the above example the subtotal for the group is in the same line as the
> row name. Is there a way of getting it to be positioned at the bottom?
> For example:
> DEPT |INV_NO |VALUE
> --
> TX10 | - |
> | SI123456 | £200.00
> | SI123457 | £200.00
> | SI123458 | £200.00
> | | £600.00
> TIA,
> Jarryd
>|||GENIUS!! I knew it had to be something simple. Thanks a mil!
Jarryd
"Mónica" <monica.diaz@.augure.com> wrote in message
news:ejsd0hEKIHA.4752@.TK2MSFTNGP05.phx.gbl...
> When you define a group, by default it shows you the group header, detail
> line and group footer.
> Have you tried to put subtotals in the group footer?
>
> "Jarryd" <jarryd@.community.nospam> escribió en el mensaje
> news:uUWbDFEKIHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I have created a very simple tabular report with only one row group which
>> I have enabled subtotals on. What I am not enjoying is that the
>> subtotals seem to HAVE to be at the top of the group:
>> Below is an example. The DEPT header is the row group.
>> DEPT |INV_NO |VALUE
>> --
>> TX10 | - | £600.00
>> | SI123456 | £200.00
>> | SI123457 | £200.00
>> | SI123458 | £200.00
>> MX10 | - | £900.00
>> | SI123456 | £300.00
>> | SI123457 | £300.00
>> | SI123458 | £300.00
>> HX10 | - | £300.00
>> | SI123456 | £100.00
>> | SI123457 | £100.00
>> | SI123458 | £100.00
>> In the above example the subtotal for the group is in the same line as
>> the row name. Is there a way of getting it to be positioned at the
>> bottom? For example:
>> DEPT |INV_NO |VALUE
>> --
>> TX10 | - |
>> | SI123456 | £200.00
>> | SI123457 | £200.00
>> | SI123458 | £200.00
>> | | £600.00
>> TIA,
>> Jarryd
>