显示标签为“components”的博文。显示所有博文
显示标签为“components”的博文。显示所有博文

2012年3月19日星期一

BCP install

Hi,

I need to have on a client machine the bcp.exe installed. What components do I need to install from SQL Server 2005. I would like to have the absolute minimal installed on this machine.


Thanks.

Solved the problem:

download the SQLEXPR_TOOLKIT.EXE and installed only the connections component.

2012年2月9日星期四

basic RS questions

Hi,
those things I can't find out:
1. What means "Export" to "HTML with Office web components"? It looks just
like the orginal report viewer to me, ie confusing as the first export format.
2. Is it possible to re-sort a report table on "any" report column in the
report viewer or do I have to export to excel ?
3. Where do I declare "document map pane" items ? Can't find any props.
4. Can History page be hidden in the viewer when props for this report says
it can't generate History ?
5. Is it possible to stop users (in security) to do subscriptions and if so,
will those pages/buttons dissappear in the viewer ?
/Jerome KI can help with some of this... see inline
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:0C8E29BE-0140-4F67-AC3A-358FC894CA94@.microsoft.com...
> Hi,
> those things I can't find out:
> 1. What means "Export" to "HTML with Office web components"? It looks just
> like the orginal report viewer to me, ie confusing as the first export
> format.
This exports to a file that you can place on some other web site...
> 2. Is it possible to re-sort a report table on "any" report column in the
> report viewer or do I have to export to excel ?
If there are no groupings you can do this... Ihave some examples using SQL
2000 at www.msbicentral.com It is kind of a pain to do in SQL 2k , but SQL
2005 makes it easy. (If there are groupings you can still do it, but it
becomes more complicated.)
> 3. Where do I declare "document map pane" items ? Can't find any props.
right click on any Group, text box etc. and when the dialog box opens, go to
the navigation tab... use the document map box to enter the field info.
> 4. Can History page be hidden in the viewer when props for this report
> says
> it can't generate History ?
I Don't know..
> 5. Is it possible to stop users (in security) to do subscriptions and if
> so,
> will those pages/buttons dissappear in the viewer ?
Yes it is possible to NOT allow subscriptions, RS is role based security and
one of the privileges is whether or not a user can make subscriptions...
Simply create a new role (BrowserNoSuscriptions)... and add every permission
that a Browser role has except subscriptions and you will be good.
I do not know if the buttons disappear or not... You'll have to test it and
see.
> /Jerome K
>