Display a field onlt up to a Specific Character

Hi
Can someone please tell me if there is a function that can be used to print a field only up till a specific character. For ex: I'm trying to print all the student email Id's bu only the characters that fall before the "@." sign.
Thanks
ACleft(x, instr(x, '@.') -1)|||Hello
Thank you sooo much. It worked!!

Thanks again
Aparna

Disabling print and export options

Hi,

Obviusly RS wasn't created for this, but i have to ask.

It's posible disable print and export buttons for specific reports?
For example, reports in a specific directory.

Thanks.

Hi Dark_V

It is possible to hide the Toolbar. You can use the following as your url

The following example hides the HTML Viewer toolbar by setting therc:Toolbar parameter value tofalse:

http://servername/reportserver?/ReportName&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

|||

l0n3i200n wrote:

Hi Dark_V

It is possible to hide the Toolbar. You can use the following as your url

The following example hides the HTML Viewer toolbar by setting therc:Toolbar parameter value tofalse:

http://servername/reportserver?/ReportName&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false

Although, this is the best option I can think of, I just want to pointout that the user can remove the toolbar=false part to still access thetoolbar. I don't think there's any capability to keep the user fromprinting because they can still just print the page from the browser'smenu.

Disabling print and export options

Hi,

Obviusly RS wasn't created for this, but i have to ask.

It's posible disable print and export buttons for specific reports?
For example, reports in a specific directory.

Thanks.

This is not possible using the default viewer. You can hide or disable them entirely but having this logic would require you building your own viewer.

|||

Thanks,

I can't find any component or viewer code with this features.

Someone find something with this functions?

Thanks

Disable update to a table

I want to be able to disable updates to a specific table from the SQL prompt
i.e the Query Analyzer. This table can only be update from the front end
screens. How do I accomplish this?
VJDon't give the users who have QA permissions to update that table.
Andrew J. Kelly
SQL Server MVP
"VJ" <vijaybalki@.yahoo.com> wrote in message
news:OpI6o0b8DHA.1636@.TK2MSFTNGP12.phx.gbl...
> I want to be able to disable updates to a specific table from the SQL
prompt
> i.e the Query Analyzer. This table can only be update from the front end
> screens. How do I accomplish this?
> VJ
>|||>> I want to be able to disable updates to a specific table
> Don't give the users who have QA permissions to update that table.
If updates = data changes, you may also try APP_NAME() +
UPDATE/INSERT/DELETE triggers, allowing you to trap these operations and
react to them.
If updates = table schema changes, in Yukon you may also try APP_NAME() +
Data Definition Language (DDL) triggers, allowing you to trap DDL operations
and react to them, optionally rolling back the activity.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
You can try application roles . which will allow user access specific to
your application . You can restrict query analyzer .
Regards
Ajay
"Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
in message news:OHXqzYc8DHA.488@.TK2MSFTNGP12.phx.gbl...
> If updates = data changes, you may also try APP_NAME() +
> UPDATE/INSERT/DELETE triggers, allowing you to trap these operations and
> react to them.
> If updates = table schema changes, in Yukon you may also try APP_NAME() +
> Data Definition Language (DDL) triggers, allowing you to trap DDL
operations
> and react to them, optionally rolling back the activity.
> sincerely,
> --
> Sebastian K. Zaklada
> Skilled Software
> http://www.skilledsoftware.com
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Yet another method is to create an instead of trigger for update on the
table and do nothing in that trigger.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Aju" <ajuonline@.yahoo.com> wrote in message
news:ORhLk1f8DHA.2028@.TK2MSFTNGP10.phx.gbl...
> Hi ,
> You can try application roles . which will allow user access specific to
> your application . You can restrict query analyzer .
> Regards
> Ajay
> "Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
> in message news:OHXqzYc8DHA.488@.TK2MSFTNGP12.phx.gbl...
+
> operations
> rights.
>

Disable update to a table

I want to be able to disable updates to a specific table from the SQL prompt
i.e the Query Analyzer. This table can only be update from the front end
screens. How do I accomplish this?
VJDon't give the users who have QA permissions to update that table.
--
Andrew J. Kelly
SQL Server MVP
"VJ" <vijaybalki@.yahoo.com> wrote in message
news:OpI6o0b8DHA.1636@.TK2MSFTNGP12.phx.gbl...
> I want to be able to disable updates to a specific table from the SQL
prompt
> i.e the Query Analyzer. This table can only be update from the front end
> screens. How do I accomplish this?
> VJ
>|||>> I want to be able to disable updates to a specific table
> Don't give the users who have QA permissions to update that table.
If updates = data changes, you may also try APP_NAME() +
UPDATE/INSERT/DELETE triggers, allowing you to trap these operations and
react to them.
If updates = table schema changes, in Yukon you may also try APP_NAME() +
Data Definition Language (DDL) triggers, allowing you to trap DDL operations
and react to them, optionally rolling back the activity.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
You can try application roles . which will allow user access specific to
your application . You can restrict query analyzer .
Regards
Ajay
"Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
in message news:OHXqzYc8DHA.488@.TK2MSFTNGP12.phx.gbl...
> >> I want to be able to disable updates to a specific table
> > Don't give the users who have QA permissions to update that table.
> If updates = data changes, you may also try APP_NAME() +
> UPDATE/INSERT/DELETE triggers, allowing you to trap these operations and
> react to them.
> If updates = table schema changes, in Yukon you may also try APP_NAME() +
> Data Definition Language (DDL) triggers, allowing you to trap DDL
operations
> and react to them, optionally rolling back the activity.
> sincerely,
> --
> Sebastian K. Zaklada
> Skilled Software
> http://www.skilledsoftware.com
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Yet another method is to create an instead of trigger for update on the
table and do nothing in that trigger.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Aju" <ajuonline@.yahoo.com> wrote in message
news:ORhLk1f8DHA.2028@.TK2MSFTNGP10.phx.gbl...
> Hi ,
> You can try application roles . which will allow user access specific to
> your application . You can restrict query analyzer .
> Regards
> Ajay
> "Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
> in message news:OHXqzYc8DHA.488@.TK2MSFTNGP12.phx.gbl...
> > >> I want to be able to disable updates to a specific table
> > > Don't give the users who have QA permissions to update that table.
> >
> > If updates = data changes, you may also try APP_NAME() +
> > UPDATE/INSERT/DELETE triggers, allowing you to trap these operations and
> > react to them.
> >
> > If updates = table schema changes, in Yukon you may also try APP_NAME()
+
> > Data Definition Language (DDL) triggers, allowing you to trap DDL
> operations
> > and react to them, optionally rolling back the activity.
> >
> > sincerely,
> > --
> > Sebastian K. Zaklada
> > Skilled Software
> > http://www.skilledsoftware.com
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
>

Disable links for totals

Hi,
I have a crosstab report that displays the totals of specific data. I have
totals on my groupings(rows). I also have made these totals a hyperlink to
allow the user to drilldown to see the detail of the count. However, I do not
want the totals to be a hyperlink, I need them to be just plain text. How do
I accomplish this in SRS? It seems as though SRS just makes all data items a
hyperlink, whether its the count the total of the figures. I really need to
make these totals plain text.
Any help is much appreciated.
KevinSorry, when I said crosstab, I meant matrix :)
"Kevin" wrote:
> Hi,
> I have a crosstab report that displays the totals of specific data. I have
> totals on my groupings(rows). I also have made these totals a hyperlink to
> allow the user to drilldown to see the detail of the count. However, I do not
> want the totals to be a hyperlink, I need them to be just plain text. How do
> I accomplish this in SRS? It seems as though SRS just makes all data items a
> hyperlink, whether its the count the total of the figures. I really need to
> make these totals plain text.
> Any help is much appreciated.
> Kevin

Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.

Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.

Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.
I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.