Hide only export dropdown list and "Export" link button from report toolbar in sql rep

Hi All

I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so ,

Please help me in this

Thanks

Alpesh

I think that this url can be helpuff:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

Hide only export dropdown list and "Export" link button from report toolbar in sql

Hi All

I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so ,

Please help me in this

Thanks

Alpesh

I think that this url can be helpuff:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

sql

Hide Find/Next, View report and some export formats in report view

Hi,
1. As Chris G asked 9/7/2006 it is not possible to change text on "view
report" and "Find/Next", but is it possible to hide those fields (or at least
find/next) for all users. (this a language issue, better for us to hide
fields than show them in english).
2. Is it possible to hide som export formats to alla users, we only use PDF
and excel, and also change text "Select a format" ?
/JeromeYou only need to change in one place, rsreportserver.config (Save a copy of
the file before making any changes). Reboot after the change. The below
shows commenting out the existing CSV export.
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
The above shows how you comment out a section. If you do the above then CSV
would not be available. However, you might want to leave CSV in. Sometimes
for a large amout of data CSV is faster than Excel. If you comment out like
above and put this in:
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
It will change CSV export so it uses ASCII instead of Unicode. This allows
Excel to automatically open up properly for the CSV. With Unicode it all
gets put into one column and then you have to split the data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:C1F26C7C-C276-4CD7-B9FD-D7D8B134DC80@.microsoft.com...
> Hi,
> 1. As Chris G asked 9/7/2006 it is not possible to change text on "view
> report" and "Find/Next", but is it possible to hide those fields (or at
> least
> find/next) for all users. (this a language issue, better for us to hide
> fields than show them in english).
> 2. Is it possible to hide som export formats to alla users, we only use
> PDF
> and excel, and also change text "Select a format" ?
> /Jerome|||Great, thank you...
Any ideas how to hide (or translate) the "View Report"-button,
"Find/Next"-fields and "Select a format"-text ? The Refresh icon or the
"Enter"-key is enough for refreshing, and Find/Next is a standard feature in
the browser menue.
/J
"Bruce L-C [MVP]" wrote:
> You only need to change in one place, rsreportserver.config (Save a copy of
> the file before making any changes). Reboot after the change. The below
> shows commenting out the existing CSV export.
> <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> The above shows how you comment out a section. If you do the above then CSV
> would not be available. However, you might want to leave CSV in. Sometimes
> for a large amout of data CSV is faster than Excel. If you comment out like
> above and put this in:
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
> It will change CSV export so it uses ASCII instead of Unicode. This allows
> Excel to automatically open up properly for the CSV. With Unicode it all
> gets put into one column and then you have to split the data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
> news:C1F26C7C-C276-4CD7-B9FD-D7D8B134DC80@.microsoft.com...
> > Hi,
> >
> > 1. As Chris G asked 9/7/2006 it is not possible to change text on "view
> > report" and "Find/Next", but is it possible to hide those fields (or at
> > least
> > find/next) for all users. (this a language issue, better for us to hide
> > fields than show them in english).
> > 2. Is it possible to hide som export formats to alla users, we only use
> > PDF
> > and excel, and also change text "Select a format" ?
> >
> > /Jerome
>
>|||Sorry, no.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:83377ADE-3AF9-4614-AB2D-9D9CDF9B747F@.microsoft.com...
> Great, thank you...
> Any ideas how to hide (or translate) the "View Report"-button,
> "Find/Next"-fields and "Select a format"-text ? The Refresh icon or the
> "Enter"-key is enough for refreshing, and Find/Next is a standard feature
> in
> the browser menue.
> /J
> "Bruce L-C [MVP]" wrote:
>> You only need to change in one place, rsreportserver.config (Save a copy
>> of
>> the file before making any changes). Reboot after the change. The below
>> shows commenting out the existing CSV export.
>> <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> The above shows how you comment out a section. If you do the above then
>> CSV
>> would not be available. However, you might want to leave CSV in.
>> Sometimes
>> for a large amout of data CSV is faster than Excel. If you comment out
>> like
>> above and put this in:
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>> It will change CSV export so it uses ASCII instead of Unicode. This
>> allows
>> Excel to automatically open up properly for the CSV. With Unicode it all
>> gets put into one column and then you have to split the data.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
>> news:C1F26C7C-C276-4CD7-B9FD-D7D8B134DC80@.microsoft.com...
>> > Hi,
>> >
>> > 1. As Chris G asked 9/7/2006 it is not possible to change text on
>> > "view
>> > report" and "Find/Next", but is it possible to hide those fields (or at
>> > least
>> > find/next) for all users. (this a language issue, better for us to hide
>> > fields than show them in english).
>> > 2. Is it possible to hide som export formats to alla users, we only use
>> > PDF
>> > and excel, and also change text "Select a format" ?
>> >
>> > /Jerome
>>

Hide Fields on Export

When I export to a file, say excel, I want certain textboxes to not show up.
How can I hide them on export?
bradSorry, this is not possible. You can only hide based on e.g. report
parameters.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"bradtm" <bradtm@.discussions.microsoft.com> wrote in message
news:9145ACFB-54E5-4BFC-82B4-0368B7AFA0FE@.microsoft.com...
> When I export to a file, say excel, I want certain textboxes to not show
> up.
> How can I hide them on export?
> brad|||Don't forget, though, if you use your own "export" button through a
custom interface, setting the rs:FORMAT=PDF or similar, you can set a
report parameter that can be referenced to show or hide selected fields.

Hidding rows disappearing in Excel export

I have a report that looks fine in Report Server, but when I export to
Excel, I lose data.
I have a group that I am repeating the group footer 3 times. The
original footer is the toggle. when I hit the + in Rep Services, it
expands with no problem, showing all of my hidden rows.
when I export it to excel and hit the toggle, it only shows the first
hidden row and loses the other two.
Any ideas?What version of Report Server and Office do you have?
daw
"M@." wrote:
> I have a report that looks fine in Report Server, but when I export to
> Excel, I lose data.
> I have a group that I am repeating the group footer 3 times. The
> original footer is the toggle. when I hit the + in Rep Services, it
> expands with no problem, showing all of my hidden rows.
> when I export it to excel and hit the toggle, it only shows the first
> hidden row and loses the other two.
> Any ideas?
>|||Microsoft SQL Server Reporting Services Version 8.00.1038.00
Excel 2003
thx,
M@.
On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> What version of Report Server and Office do you have?
> daw
> "M@." wrote:
> > I have a report that looks fine in Report Server, but when I export to
> > Excel, I lose data.
> > I have a group that I am repeating the group footer 3 times. The
> > original footer is the toggle. when I hit the + in Rep Services, it
> > expands with no problem, showing all of my hidden rows.
> > when I export it to excel and hit the toggle, it only shows the first
> > hidden row and loses the other two.
> > Any ideas?|||Are you sure that the rows are not just hidden rows in Excel? Are the row
numbers consecutive?
"M@." wrote:
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> Excel 2003
> thx,
> M@.
> On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > What version of Report Server and Office do you have?
> >
> > daw
> >
> > "M@." wrote:
> > > I have a report that looks fine in Report Server, but when I export to
> > > Excel, I lose data.
> >
> > > I have a group that I am repeating the group footer 3 times. The
> > > original footer is the toggle. when I hit the + in Rep Services, it
> > > expands with no problem, showing all of my hidden rows.
> >
> > > when I export it to excel and hit the toggle, it only shows the first
> > > hidden row and loses the other two.
> >
> > > Any ideas?
>
>|||I have a group footer (group1) that I repeat. The first line is the
toggle, lines 2-5 are details. I'm using running values. Row 1 is
the sum. Row2 is a sum when a field = PRV, Row3 is a sum when a field
= MCD and so on.
It looks fine in Reporting Services, but if I export it to excel and
hit the toggle, only the first hidden row pops in.
Yeah, the row numbers are consecutive.
On Mar 21, 4:32 pm, daw <d...@.discussions.microsoft.com> wrote:
> Are you sure that the rows are not just hidden rows in Excel? Are the row
> numbers consecutive?
>
> "M@." wrote:
> > Microsoft SQL Server Reporting Services Version 8.00.1038.00
> > Excel 2003
> > thx,
> > M@.
> > On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > > What version of Report Server and Office do you have?
> > > daw
> > > "M@." wrote:
> > > > I have a report that looks fine in Report Server, but when I export to
> > > > Excel, I lose data.
> > > > I have a group that I am repeating the group footer 3 times. The
> > > > original footer is the toggle. when I hit the + in Rep Services, it
> > > > expands with no problem, showing all of my hidden rows.
> > > > when I export it to excel and hit the toggle, it only shows the first
> > > > hidden row and loses the other two.
> > > > Any ideas... Hide quoted text -
> - Show quoted text -

hidden views

hi ,
i have created views in database Test, in sqlServer.when i had to export Test to another database Test1, the views become hiddden.
i can't see the views and when i try to create them again, i get this msg:
There is already an object named 'view1' in the database.
so how can i resolve this problem?

thanks,

when u export view from one database to another the view is created as table in the target database. To migrate view , create script of the view and run that script in Target DB... ... do not select view in Export wizards only select tables...

if you are getting View1 already exists then :-

Check in Tables there will be a table called View1 , first drop that and run the script for view1 to create...

Madhu

|||When you choose to Generate script for the database objects, then it should have that value to drop the object before creating it, follow as suggested.|||

Well, thanks!

As u said, the views were created as tables in the target DB. So i droped them and made a new script for the views.

Myra

|||

thanks for ur help!

myra

Hidden columns showing on export

I am allowing users to specify through a parameter whether they want a column
to be visible or not. If they specify visible = false, the column does not
show on the report. However, when that same report is exported, the column is
visible in the export.
Does anyone have a solution for this?Hello.
I am having a similar problem. I'm trying to make some table columns hidden
(collapsed). The regular online report view is fine and the hidden columns
are hidden and propery collapsed. However, when I export (to pdf) the hidden
columns are blank but not collapsed, except for the table footer row, so the
table footer is misaligned with the rest of the table. The columns in the
table footer row collapsed propery, but the rest of the table's hidden
columns are blank but did not collapse. So I end up with a table with more
header and detail columns than footer columns.
Any idea what is happening?
Thanks,
Brian.
"khonerka" wrote:
> I am allowing users to specify through a parameter whether they want a column
> to be visible or not. If they specify visible = false, the column does not
> show on the report. However, when that same report is exported, the column is
> visible in the export.
> Does anyone have a solution for this?

Hidden columns exporting in CSV

I am writing a report to export columns dynamically. The column's Hidden
property is controlled by an expression (=Cbool(parameters.hidecol.value))
which works ok in Excel and PDF export. However, whenever I export in CSV,
this property is ignored and the column is never exported.
Is this a bug in reporting service or is it by design?
I have SQL reporting service 2005 with SP1 and all the hotfixes.Imran,
I got a reply from a MS contact on msdn. Here is his reply for anyone
else with the same problem...
John,
You can't conditionally hide and show data in data renderers (CSV,
XML). This is by design. If you have an expression in the Hidden field
and 'Auto' in DataOutput tab for text boxes in the column, your data
will not be rendered into CSV or XML.
You can set DataElementOutput to Output for textboxes in the cells and
in the header, and the coulmn will always be in the output file.
Thanks!
----
- DenisL (SQL RS Team)
Imran wrote:
> I am writing a report to export columns dynamically. The column's Hidden
> property is controlled by an expression (=Cbool(parameters.hidecol.value))
> which works ok in Excel and PDF export. However, whenever I export in CSV,
> this property is ignored and the column is never exported.
> Is this a bug in reporting service or is it by design?
> I have SQL reporting service 2005 with SP1 and all the hotfixes.|||Actually I was expecting a solution rather than a refresher on "status quo"
from Microsoft. Ofcourse I am aware of this issue and there are several
codable workaround for this... Was curious if someone had already done this
or if another hotfix is on its way to resolve this.
Imran
"johnburns007@.gmail.com" wrote:
> Imran,
> I got a reply from a MS contact on msdn. Here is his reply for anyone
> else with the same problem...
> John,
> You can't conditionally hide and show data in data renderers (CSV,
> XML). This is by design. If you have an expression in the Hidden field
> and 'Auto' in DataOutput tab for text boxes in the column, your data
> will not be rendered into CSV or XML.
> You can set DataElementOutput to Output for textboxes in the cells and
> in the header, and the coulmn will always be in the output file.
> Thanks!
>
> ----
> - DenisL (SQL RS Team)
>
> Imran wrote:
> > I am writing a report to export columns dynamically. The column's Hidden
> > property is controlled by an expression (=Cbool(parameters.hidecol.value))
> > which works ok in Excel and PDF export. However, whenever I export in CSV,
> > this property is ignored and the column is never exported.
> >
> > Is this a bug in reporting service or is it by design?
> >
> > I have SQL reporting service 2005 with SP1 and all the hotfixes.
>

HELP: Exporting for use in MySQL

Ok, anyone know anything about MySQL? The only way I see to use data within
tables for use in MySQL is to export as text file but I dont see a way to
import the data from the MySQL Console Manager.
Then my next consideration would be a query to create the tables and insert
it into te MySQL database.
Thoughts anyone?
"Matrix"
Vice President
Permian Basin Chapter
Bikers Against Child AbuseLots on MySQL here:
http://www.mysql.com/documentation/index.html
--
David Portas
--
Please reply only to the newsgroup
--
"Matrix" <matrix@.!nospam.visualsun.ws> wrote in message
news:vnjs143fb0q9a1@.corp.supernews.com...
> Ok, anyone know anything about MySQL? The only way I see to use data
within
> tables for use in MySQL is to export as text file but I dont see a way to
> import the data from the MySQL Console Manager.
> Then my next consideration would be a query to create the tables and
insert
> it into te MySQL database.
> Thoughts anyone?
> "Matrix"
> Vice President
> Permian Basin Chapter
> Bikers Against Child Abuse
>