What is the easiest way to ftp a reporting services report out to a ftp site ?
Any ideas greatly appreciated.
Thanks.Using ftp at command prompt:
C:\>ftp
ftp>open <FtpServerName>
ftp>user <MyUserName> then enter password if required
ftp>lcd <LocalMachineDirectory>
ftp>cd <FtpServerDirectory>
ftp>put <MyReport.rdlFileName>
ftp>close
ftp>quit
C:\>
"steve" wrote:
> What is the easiest way to ftp a reporting services report out to a ftp site ?
> Any ideas greatly appreciated.
> Thanks.|||Hi magendo_man and thanks for the reply. Have no problem with the ftp syntax
the question i should have posted is how do you do this from reporting
services? Do you create a subscription ? etc. Only see an option to email to
an address in a unique format. These reports are great and need to provide a
copy of the report to a ftp site.
Thanks
"magendo_man" wrote:
> Using ftp at command prompt:
> C:\>ftp
> ftp>open <FtpServerName>
> ftp>user <MyUserName> then enter password if required
> ftp>lcd <LocalMachineDirectory>
> ftp>cd <FtpServerDirectory>
> ftp>put <MyReport.rdlFileName>
> ftp>close
> ftp>quit
> C:\>
> "steve" wrote:
> > What is the easiest way to ftp a reporting services report out to a ftp site ?
> > Any ideas greatly appreciated.
> >
> > Thanks.|||You could get the report published as a pdf/xls/... to a file share and then
set up an ftp script as a scheduled task.
HTH,
Magendo_man
"steve" wrote:
> Hi magendo_man and thanks for the reply. Have no problem with the ftp syntax
> the question i should have posted is how do you do this from reporting
> services? Do you create a subscription ? etc. Only see an option to email to
> an address in a unique format. These reports are great and need to provide a
> copy of the report to a ftp site.
> Thanks
> "magendo_man" wrote:
> > Using ftp at command prompt:
> >
> > C:\>ftp
> >
> > ftp>open <FtpServerName>
> > ftp>user <MyUserName> then enter password if required
> > ftp>lcd <LocalMachineDirectory>
> > ftp>cd <FtpServerDirectory>
> > ftp>put <MyReport.rdlFileName>
> > ftp>close
> > ftp>quit
> >
> > C:\>
> >
> > "steve" wrote:
> >
> > > What is the easiest way to ftp a reporting services report out to a ftp site ?
> > > Any ideas greatly appreciated.
> > >
> > > Thanks.
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Monday, March 26, 2012
FT Searching in SQL Server Database
We've got a small Windows SharePoint Services site that stores content
in a remote SQL Server Database. Over the last couple of weeks I've
been trying to get the Search Service working to no avail - no results
are being returned when a search is being performed.
I've posted this to the Windows Sharepoint Group, but I suspect the
problem may be with the SQL Server installation. Here's a summary of
the setup/things checked... any pointers would be appreciated!
1. I'm running SQL Server 2000 with SP3
2. The Full Text component of SQL Server is installed
3. The Microsoft Search Service is running and logged in using local
system admin account
4. There are no errors reported in the Event Log
A clean install of WSS was performed and the FT Search and Indexing
option for the site under SharePoint is all configured correctly.
When I look at the WSS Installation Guide it talks about an empty
index being created called ix_<databasename> when WSS is installed. I
have very little experience of SQL Server, but I did check this using
Enterprise Manager and nothing exists under the Full Text Catalogs
node. Is it possible to recreat this manually?
Thanks.Steve,
Windows SharePoint Services or WSS as it's sometimes called, can use SQL
Server's Full-Text Search (FTS) components. However, you need to do a couple
of things when you migrate or upgrade from WMSDE (a special Windows 2003
version of MSDE) to SQL Server. Specifically, for your named instance
"SHAREPOINT", when you upgraded to SQL Server, under Server Components, did
you elect the Full-text Search check box?
Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John
"Steve" <bennett_s_nospam@.yahoo.com> wrote in message
news:190ea2c6.0312031335.630fc2dc@.posting.google.com...
> We've got a small Windows SharePoint Services site that stores content
> in a remote SQL Server Database. Over the last couple of weeks I've
> been trying to get the Search Service working to no avail - no results
> are being returned when a search is being performed.
> I've posted this to the Windows Sharepoint Group, but I suspect the
> problem may be with the SQL Server installation. Here's a summary of
> the setup/things checked... any pointers would be appreciated!
> 1. I'm running SQL Server 2000 with SP3
> 2. The Full Text component of SQL Server is installed
> 3. The Microsoft Search Service is running and logged in using local
> system admin account
> 4. There are no errors reported in the Event Log
>
> A clean install of WSS was performed and the FT Search and Indexing
> option for the site under SharePoint is all configured correctly.
> When I look at the WSS Installation Guide it talks about an empty
> index being created called ix_<databasename> when WSS is installed. I
> have very little experience of SQL Server, but I did check this using
> Enterprise Manager and nothing exists under the Full Text Catalogs
> node. Is it possible to recreat this manually?
> Thanks.
in a remote SQL Server Database. Over the last couple of weeks I've
been trying to get the Search Service working to no avail - no results
are being returned when a search is being performed.
I've posted this to the Windows Sharepoint Group, but I suspect the
problem may be with the SQL Server installation. Here's a summary of
the setup/things checked... any pointers would be appreciated!
1. I'm running SQL Server 2000 with SP3
2. The Full Text component of SQL Server is installed
3. The Microsoft Search Service is running and logged in using local
system admin account
4. There are no errors reported in the Event Log
A clean install of WSS was performed and the FT Search and Indexing
option for the site under SharePoint is all configured correctly.
When I look at the WSS Installation Guide it talks about an empty
index being created called ix_<databasename> when WSS is installed. I
have very little experience of SQL Server, but I did check this using
Enterprise Manager and nothing exists under the Full Text Catalogs
node. Is it possible to recreat this manually?
Thanks.Steve,
Windows SharePoint Services or WSS as it's sometimes called, can use SQL
Server's Full-Text Search (FTS) components. However, you need to do a couple
of things when you migrate or upgrade from WMSDE (a special Windows 2003
version of MSDE) to SQL Server. Specifically, for your named instance
"SHAREPOINT", when you upgraded to SQL Server, under Server Components, did
you elect the Full-text Search check box?
Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John
"Steve" <bennett_s_nospam@.yahoo.com> wrote in message
news:190ea2c6.0312031335.630fc2dc@.posting.google.com...
> We've got a small Windows SharePoint Services site that stores content
> in a remote SQL Server Database. Over the last couple of weeks I've
> been trying to get the Search Service working to no avail - no results
> are being returned when a search is being performed.
> I've posted this to the Windows Sharepoint Group, but I suspect the
> problem may be with the SQL Server installation. Here's a summary of
> the setup/things checked... any pointers would be appreciated!
> 1. I'm running SQL Server 2000 with SP3
> 2. The Full Text component of SQL Server is installed
> 3. The Microsoft Search Service is running and logged in using local
> system admin account
> 4. There are no errors reported in the Event Log
>
> A clean install of WSS was performed and the FT Search and Indexing
> option for the site under SharePoint is all configured correctly.
> When I look at the WSS Installation Guide it talks about an empty
> index being created called ix_<databasename> when WSS is installed. I
> have very little experience of SQL Server, but I did check this using
> Enterprise Manager and nothing exists under the Full Text Catalogs
> node. Is it possible to recreat this manually?
> Thanks.
FRX reports
I understand the designer in Reporting Services can import Access reports.
Today a customer asked me if it's possible to import reports on Great Plains
data written using FRX. Anybody know?
JimJames,
The FRX file is a Visual Fox file which is really a table. The format is
well documented but I am not aware of a direct conversion tool at this time.
I would suggest a repost on the Visual Fox newsgroup
microsoft.public.fox.vfp.reports.printing.
Best Regards,
--
David W. Grigsby
Grigsby Consulting LLC
http://www.grigsbyconsultingllc.com
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Foye" <jimfoye2@.hotmail.com> wrote in message
news:%23Yo074YfEHA.3964@.TK2MSFTNGP12.phx.gbl...
> I understand the designer in Reporting Services can import Access reports.
> Today a customer asked me if it's possible to import reports on Great
Plains
> data written using FRX. Anybody know?
> Jim
>
Today a customer asked me if it's possible to import reports on Great Plains
data written using FRX. Anybody know?
JimJames,
The FRX file is a Visual Fox file which is really a table. The format is
well documented but I am not aware of a direct conversion tool at this time.
I would suggest a repost on the Visual Fox newsgroup
microsoft.public.fox.vfp.reports.printing.
Best Regards,
--
David W. Grigsby
Grigsby Consulting LLC
http://www.grigsbyconsultingllc.com
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Foye" <jimfoye2@.hotmail.com> wrote in message
news:%23Yo074YfEHA.3964@.TK2MSFTNGP12.phx.gbl...
> I understand the designer in Reporting Services can import Access reports.
> Today a customer asked me if it's possible to import reports on Great
Plains
> data written using FRX. Anybody know?
> Jim
>
Frustration.. slow performace when editing a DTS
I have tried many things and even the worst case thing which I was trying to avoid i.e. uninstalled MSDE SP3 and Analysis Services and service packs but the problem is still not solved...
Whenever I open a DTS in design view and double click on the link (the line connecting the two) between the source and destination servers the PC goes to sleep and comes back after a long time and then the same problem occurs when I press on the transformation tab...
I know this may sound weird but that really is the case :eek:
Please help :oSounds like the DTS designer can not connect to one of the machines that the Data Transform Task is moving data to and/or from. Check the connection parameters, and make sure you can connect to all of the machines.|||Thanks for the reply.
The source is a MS-SQL server on the LAN while the destination is MSDE SP3 on my box. I have been doing similar data importing related tasks (with the same settings, source, and destination) in the past but never experienced this problem. I can connect to both machines so that part is also covered.
Connection parameters is new for me so can you please guide how to go about checking the connection parameters i.e. from where are these defined and what should be the settings??|||While still trying to solve the problem, I brought up task manager and I have concluded that everytime the problem happens the MMC.EXE process is choking the CPU...
Does this provide any clues?|||Connection parameters is new for me so can you please guide how to go about checking the connection parameters i.e. from where are these defined and what should be the settings??
Just double-click on the connections and check the login, machine name, and database. If all are good, then it is something else.
Whenever I open a DTS in design view and double click on the link (the line connecting the two) between the source and destination servers the PC goes to sleep and comes back after a long time and then the same problem occurs when I press on the transformation tab...
I know this may sound weird but that really is the case :eek:
Please help :oSounds like the DTS designer can not connect to one of the machines that the Data Transform Task is moving data to and/or from. Check the connection parameters, and make sure you can connect to all of the machines.|||Thanks for the reply.
The source is a MS-SQL server on the LAN while the destination is MSDE SP3 on my box. I have been doing similar data importing related tasks (with the same settings, source, and destination) in the past but never experienced this problem. I can connect to both machines so that part is also covered.
Connection parameters is new for me so can you please guide how to go about checking the connection parameters i.e. from where are these defined and what should be the settings??|||While still trying to solve the problem, I brought up task manager and I have concluded that everytime the problem happens the MMC.EXE process is choking the CPU...
Does this provide any clues?|||Connection parameters is new for me so can you please guide how to go about checking the connection parameters i.e. from where are these defined and what should be the settings??
Just double-click on the connections and check the login, machine name, and database. If all are good, then it is something else.
Friday, March 23, 2012
Frustrating Reporting Services problem. New machine fails to deploy reports to report serv
Hi All,
I got a new machine. On my old machine, I had no problem using VS
.Net to deploy Report Projects to our Report Server.
On my new machine, I installed IIS, installed VS .Net, enabled
ASP.Net, performed a Report Designer installation of Reporting
Services.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
I found the following USENET thread that describes my problem, but I'm
not sure the solution there is the same for me:
http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
All help appreciated.
Thanks a lot,
ChuckCan you navigate to the report manager?
http://MyRServerName/Reports
That is a good troubleshooting step.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> Hi All,
> I got a new machine. On my old machine, I had no problem using VS
> .Net to deploy Report Projects to our Report Server.
> On my new machine, I installed IIS, installed VS .Net, enabled
> ASP.Net, performed a Report Designer installation of Reporting
> Services.
> After I create my report in VS .Net and try to deploy it, I get the
> following error message:
> A connection could not be made to the report server
> http://MyRServerName/ReportServer
> I am a local admin of the machine that the report server is on and I
> have no problem navigating to http://MyRServerName/ReportServer using
> Internet Explorer.
> I found the following USENET thread that describes my problem, but I'm
> not sure the solution there is the same for me:
> http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> All help appreciated.
> Thanks a lot,
> Chuck|||Try running this from command prompt -
rsconfig -c -s127.0.0.1 -dreportserver -aSql -usa -p(your sa password)
"Jeff A. Stucker" wrote:
> Can you navigate to the report manager?
> http://MyRServerName/Reports
> That is a good troubleshooting step.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
> news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> > Hi All,
> >
> > I got a new machine. On my old machine, I had no problem using VS
> > .Net to deploy Report Projects to our Report Server.
> >
> > On my new machine, I installed IIS, installed VS .Net, enabled
> > ASP.Net, performed a Report Designer installation of Reporting
> > Services.
> >
> > After I create my report in VS .Net and try to deploy it, I get the
> > following error message:
> >
> > A connection could not be made to the report server
> > http://MyRServerName/ReportServer
> >
> > I am a local admin of the machine that the report server is on and I
> > have no problem navigating to http://MyRServerName/ReportServer using
> > Internet Explorer.
> >
> > I found the following USENET thread that describes my problem, but I'm
> > not sure the solution there is the same for me:
> >
> > http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> >
> > All help appreciated.
> >
> > Thanks a lot,
> >
> > Chuck
>
>|||I can navigate to http://MyRServerName/Reports using Internet
Explorer. However, the problem remains that I cannot deploy a report
using VS .Net on my new computer.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
I got a new machine. On my old machine, I had no problem using VS
.Net to deploy Report Projects to our Report Server.
On my new machine, I installed IIS, installed VS .Net, enabled
ASP.Net, performed a Report Designer installation of Reporting
Services.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
I found the following USENET thread that describes my problem, but I'm
not sure the solution there is the same for me:
http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
All help appreciated.
Thanks a lot,
ChuckCan you navigate to the report manager?
http://MyRServerName/Reports
That is a good troubleshooting step.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> Hi All,
> I got a new machine. On my old machine, I had no problem using VS
> .Net to deploy Report Projects to our Report Server.
> On my new machine, I installed IIS, installed VS .Net, enabled
> ASP.Net, performed a Report Designer installation of Reporting
> Services.
> After I create my report in VS .Net and try to deploy it, I get the
> following error message:
> A connection could not be made to the report server
> http://MyRServerName/ReportServer
> I am a local admin of the machine that the report server is on and I
> have no problem navigating to http://MyRServerName/ReportServer using
> Internet Explorer.
> I found the following USENET thread that describes my problem, but I'm
> not sure the solution there is the same for me:
> http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> All help appreciated.
> Thanks a lot,
> Chuck|||Try running this from command prompt -
rsconfig -c -s127.0.0.1 -dreportserver -aSql -usa -p(your sa password)
"Jeff A. Stucker" wrote:
> Can you navigate to the report manager?
> http://MyRServerName/Reports
> That is a good troubleshooting step.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
> news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> > Hi All,
> >
> > I got a new machine. On my old machine, I had no problem using VS
> > .Net to deploy Report Projects to our Report Server.
> >
> > On my new machine, I installed IIS, installed VS .Net, enabled
> > ASP.Net, performed a Report Designer installation of Reporting
> > Services.
> >
> > After I create my report in VS .Net and try to deploy it, I get the
> > following error message:
> >
> > A connection could not be made to the report server
> > http://MyRServerName/ReportServer
> >
> > I am a local admin of the machine that the report server is on and I
> > have no problem navigating to http://MyRServerName/ReportServer using
> > Internet Explorer.
> >
> > I found the following USENET thread that describes my problem, but I'm
> > not sure the solution there is the same for me:
> >
> > http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> >
> > All help appreciated.
> >
> > Thanks a lot,
> >
> > Chuck
>
>|||I can navigate to http://MyRServerName/Reports using Internet
Explorer. However, the problem remains that I cannot deploy a report
using VS .Net on my new computer.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
Wednesday, March 21, 2012
front end tool against reporting services?
Hi,
I'm looking for a list of tools which can be used in front of reporting
services to create reports without using visual studio.
In my current list there is RSInteract and report builder.
SQL 2008 will also have a client report generator.
do you have any other tools for me?
ideally the application is web based and can be used in sharepoint
integrated mode.
Thanks.
Jerome.On Feb 8, 5:43 am, "Jeje" <willg...@.hotmail.com> wrote:
> Hi,
> I'm looking for a list of tools which can be used in front of reporting
> services to create reports without using visual studio.
> In my current list there is RSInteract and report builder.
> SQL 2008 will also have a client report generator.
> do you have any other tools for me?
> ideally the application is web based and can be used in sharepoint
> integrated mode.
> Thanks.
> Jerome.
Since RDL is a form of XML, technically you could build a custom
application in ASP.NET/etc that can create the .rdl file (XML) and
datasource file, etc for you based on some user input, etc. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I know,
I'm looking for existing, easy to use and professional products.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:0b1ffc0c-9a7b-4283-82fc-4096f2e576c2@.s8g2000prg.googlegroups.com...
> On Feb 8, 5:43 am, "Jeje" <willg...@.hotmail.com> wrote:
>> Hi,
>> I'm looking for a list of tools which can be used in front of reporting
>> services to create reports without using visual studio.
>> In my current list there is RSInteract and report builder.
>> SQL 2008 will also have a client report generator.
>> do you have any other tools for me?
>> ideally the application is web based and can be used in sharepoint
>> integrated mode.
>> Thanks.
>> Jerome.
>
> Since RDL is a form of XML, technically you could build a custom
> application in ASP.NET/etc that can create the .rdl file (XML) and
> datasource file, etc for you based on some user input, etc. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Feb 8, 6:32=A0pm, "Jeje" <willg...@.hotmail.com> wrote:
> I know,
> I'm looking for existing, easy to use and professional products.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:0b1ffc0c-9a7b-4283-82fc-4096f2e576c2@.s8g2000prg.googlegroups.com...
>
> > On Feb 8, 5:43 am, "Jeje" <willg...@.hotmail.com> wrote:
> >> Hi,
> >> I'm looking for a list of tools which can be used in front of reporting=
> >> services to create reports without using visual studio.
> >> In my current list there is RSInteract and report builder.
> >> SQL 2008 will also have a client report generator.
> >> do you have any other tools for me?
> >> ideally the application is web based and can be used in sharepoint
> >> integrated mode.
> >> Thanks.
> >> Jerome.
> > Since RDL is a form of XML, technically you could build a custom
> > application in ASP.NET/etc that can create the .rdl file (XML) and
> > datasource file, etc for you based on some user input, etc. Hope this
> > helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
SoftArtisans has a product that creates RS reports from excel and word
docs
I'm looking for a list of tools which can be used in front of reporting
services to create reports without using visual studio.
In my current list there is RSInteract and report builder.
SQL 2008 will also have a client report generator.
do you have any other tools for me?
ideally the application is web based and can be used in sharepoint
integrated mode.
Thanks.
Jerome.On Feb 8, 5:43 am, "Jeje" <willg...@.hotmail.com> wrote:
> Hi,
> I'm looking for a list of tools which can be used in front of reporting
> services to create reports without using visual studio.
> In my current list there is RSInteract and report builder.
> SQL 2008 will also have a client report generator.
> do you have any other tools for me?
> ideally the application is web based and can be used in sharepoint
> integrated mode.
> Thanks.
> Jerome.
Since RDL is a form of XML, technically you could build a custom
application in ASP.NET/etc that can create the .rdl file (XML) and
datasource file, etc for you based on some user input, etc. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I know,
I'm looking for existing, easy to use and professional products.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:0b1ffc0c-9a7b-4283-82fc-4096f2e576c2@.s8g2000prg.googlegroups.com...
> On Feb 8, 5:43 am, "Jeje" <willg...@.hotmail.com> wrote:
>> Hi,
>> I'm looking for a list of tools which can be used in front of reporting
>> services to create reports without using visual studio.
>> In my current list there is RSInteract and report builder.
>> SQL 2008 will also have a client report generator.
>> do you have any other tools for me?
>> ideally the application is web based and can be used in sharepoint
>> integrated mode.
>> Thanks.
>> Jerome.
>
> Since RDL is a form of XML, technically you could build a custom
> application in ASP.NET/etc that can create the .rdl file (XML) and
> datasource file, etc for you based on some user input, etc. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Feb 8, 6:32=A0pm, "Jeje" <willg...@.hotmail.com> wrote:
> I know,
> I'm looking for existing, easy to use and professional products.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:0b1ffc0c-9a7b-4283-82fc-4096f2e576c2@.s8g2000prg.googlegroups.com...
>
> > On Feb 8, 5:43 am, "Jeje" <willg...@.hotmail.com> wrote:
> >> Hi,
> >> I'm looking for a list of tools which can be used in front of reporting=
> >> services to create reports without using visual studio.
> >> In my current list there is RSInteract and report builder.
> >> SQL 2008 will also have a client report generator.
> >> do you have any other tools for me?
> >> ideally the application is web based and can be used in sharepoint
> >> integrated mode.
> >> Thanks.
> >> Jerome.
> > Since RDL is a form of XML, technically you could build a custom
> > application in ASP.NET/etc that can create the .rdl file (XML) and
> > datasource file, etc for you based on some user input, etc. Hope this
> > helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
SoftArtisans has a product that creates RS reports from excel and word
docs
From RS2000 to RS2005. How to?
Hello,
I would appreciate if someone can advice me:
We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005.
There are a lot of reports, few datasources and very complex security on folder and report levels.
As I understood all reports should be manually upgraded (click and deploy), but what with datasources,
folder structure and security roles?
Kind regards,
ZoranHi,
There is a free Reporting Services scripting tool "Reporting Services
Scripter" http://www.sqldbatips.com/showarticle.asp?ID=62.
You can script folders' structure using this tool and folders' security
(including data sources folders) and then you can deploy you upgraded reports.
You will need to reenter passwords for the data sources.
"Zoran" wrote:
> Hello,
> I would appreciate if someone can advice me:
> We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005.
> There are a lot of reports, few datasources and very complex security on folder and report levels.
> As I understood all reports should be manually upgraded (click and deploy), but what with datasources,
> folder structure and security roles?
> Kind regards,
> Zoran
>
I would appreciate if someone can advice me:
We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005.
There are a lot of reports, few datasources and very complex security on folder and report levels.
As I understood all reports should be manually upgraded (click and deploy), but what with datasources,
folder structure and security roles?
Kind regards,
ZoranHi,
There is a free Reporting Services scripting tool "Reporting Services
Scripter" http://www.sqldbatips.com/showarticle.asp?ID=62.
You can script folders' structure using this tool and folders' security
(including data sources folders) and then you can deploy you upgraded reports.
You will need to reenter passwords for the data sources.
"Zoran" wrote:
> Hello,
> I would appreciate if someone can advice me:
> We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005.
> There are a lot of reports, few datasources and very complex security on folder and report levels.
> As I understood all reports should be manually upgraded (click and deploy), but what with datasources,
> folder structure and security roles?
> Kind regards,
> Zoran
>
Monday, March 19, 2012
From Excel to Analysis Services
Have any of you heard of an application that makes it possible for normal business people with no IT knowledge to directly from Excel “publish” a table to SQL Server and Analysis Services?
I’m searching for an Excel add-in that sends the data in a normal Excel table with a few dimensions and some measures, as a data set (preferably via a web service over https) to a server application. The server creates a table in a specific SQL Server database, and automatically creates a cube in a specific analysis service database. The cube on the server is automatically processed and the data is available to all users in the company using their BI GUI.
Any ideas where to find such tool?
/Erik
I don't know any turnkey solution which can solve your entire problem. But there are enough off-the-shelf technologies, such as SQL Server Integration Service, out there from which you can build your own solution.
Alternatively, take a look at the Visual Studio Tools for Office (the .Net interop assemblies for Office essenially) as you can pretty easily write some code behind your XL spreadsheet (or as an XL add-in) yourself that can pull data off the sheet into an ADO.Net recordset which you can then push to SQL Server (or XML or many other formats for that matter).
|||You can also use pivot tables in excel and publish cubes on the web using OWC.|||That is exactly what I would prefer. I use OWC for publishing Aanalysis Services Cube data thru Excel onto Http:// - a basic publication site. It works fine for IT and Biz community with no maintenace. - raj
Monday, March 12, 2012
Fresh Starter in ReportViewer Needs Some Guidance
Hi,
I just started to learn ReportViewer and Reporting Services recently. A few days ago, I created a report project with some reports in it. A few moments ago, I tried to create a page with a ReportViewer in it by using Visual Studio. In smart tag of this ReportViewer, I set the Report Server Url and the Report Path so the ReportViewer refers the reports that I made previously. When I run my application, I receive "The permissions granted to user 'IT-HARIS\IUSR_IT-HARIS' are insufficient for performing this operation. (rsAccessDenied)" message. What should I do next? How to set the permission of a user so he / she is authorized to do an action?
Thanks in advance
Try this cool linkhttp://www.gotreportviewer.com/
|||Hi,
From your description, it seems that the "IT-HARIS\IUSER_IT-HARIS" is the anonymous user in IIS you set, right?
If so, I think that you should disable the anonymous visiting in your IIS first. And then try to open the SQL reporting service configuration, try to make sure that the user registered in web service identity has been in theSQLServer2005ReportingServiceWebServiceUsers$UserName$XXX andSQLServer2005ReportServerUser$UserName$XXX group, if not, add the user into these two groups.
Thanks.
Friday, March 9, 2012
Freeze panes like excel
Is there a chance that columns used in sql reporting services can be freezed
as in excel work sheet.
Is it not implemented till date, if they implement when can we expect that
to happen for sql reporting services.
Freezin pane is one part they even want to freeze there own columns
dynamically.
Is there a chance in near future we have this provision, if we have it would
be great.
Any thought of when can we expect it.
Askin a lot :-)
NavinNavin,
There is a setting in RS that you can apply per object (matrix, table), in
which you can specifiy whether you want the header to remain visible when
scrolling. Look for this on the general tab. Name of the setting is "Header
should remain visible when scrolling".
(this is in RS2005)
regards,
Perry
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:9E12F763-4546-4C89-9347-C2E7F479E1B0@.microsoft.com...
> Is there a chance that columns used in sql reporting services can be
> freezed
> as in excel work sheet.
> Is it not implemented till date, if they implement when can we expect that
> to happen for sql reporting services.
> Freezin pane is one part they even want to freeze there own columns
> dynamically.
> Is there a chance in near future we have this provision, if we have it
> would
> be great.
> Any thought of when can we expect it.
> Askin a lot :-)
> Navin|||Freezing columns is big priority for us as well, and I've asked about
about it several times, but the feature is not available.
And I wouldn't expect it in a subsequent release, just based on the
technical issues to implement it, but maybe I'll be surprised.
NAVIN.D wrote:
> Is there a chance that columns used in sql reporting services can be freezed
> as in excel work sheet.
> Is it not implemented till date, if they implement when can we expect that
> to happen for sql reporting services.
> Freezin pane is one part they even want to freeze there own columns
> dynamically.
> Is there a chance in near future we have this provision, if we have it would
> be great.
> Any thought of when can we expect it.
> Askin a lot :-)
> Navin|||Seems certain part of my question solved, look forward for dynamic selection
as well, Thank for the info Perry
"Perry" wrote:
> Navin,
> There is a setting in RS that you can apply per object (matrix, table), in
> which you can specifiy whether you want the header to remain visible when
> scrolling. Look for this on the general tab. Name of the setting is "Header
> should remain visible when scrolling".
> (this is in RS2005)
> regards,
> Perry
>
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:9E12F763-4546-4C89-9347-C2E7F479E1B0@.microsoft.com...
> > Is there a chance that columns used in sql reporting services can be
> > freezed
> > as in excel work sheet.
> >
> > Is it not implemented till date, if they implement when can we expect that
> > to happen for sql reporting services.
> >
> > Freezin pane is one part they even want to freeze there own columns
> > dynamically.
> >
> > Is there a chance in near future we have this provision, if we have it
> > would
> > be great.
> >
> > Any thought of when can we expect it.
> >
> > Askin a lot :-)
> >
> > Navin
>
>|||unfortunatly it dont work the way i intended i want column to be scrolled as
well not only headers, supose i have 20 columns i want only two columns to be
freezed. and as i traversve through other columns the 2 columns which are
freezed still exists.
"Perry" wrote:
> Navin,
> There is a setting in RS that you can apply per object (matrix, table), in
> which you can specifiy whether you want the header to remain visible when
> scrolling. Look for this on the general tab. Name of the setting is "Header
> should remain visible when scrolling".
> (this is in RS2005)
> regards,
> Perry
>
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:9E12F763-4546-4C89-9347-C2E7F479E1B0@.microsoft.com...
> > Is there a chance that columns used in sql reporting services can be
> > freezed
> > as in excel work sheet.
> >
> > Is it not implemented till date, if they implement when can we expect that
> > to happen for sql reporting services.
> >
> > Freezin pane is one part they even want to freeze there own columns
> > dynamically.
> >
> > Is there a chance in near future we have this provision, if we have it
> > would
> > be great.
> >
> > Any thought of when can we expect it.
> >
> > Askin a lot :-)
> >
> > Navin
>
>|||Header scrolling dont work for matrix, only table header got that option.
"cowznofsky" wrote:
> Freezing columns is big priority for us as well, and I've asked about
> about it several times, but the feature is not available.
> And I wouldn't expect it in a subsequent release, just based on the
> technical issues to implement it, but maybe I'll be surprised.
> NAVIN.D wrote:
> > Is there a chance that columns used in sql reporting services can be freezed
> > as in excel work sheet.
> >
> > Is it not implemented till date, if they implement when can we expect that
> > to happen for sql reporting services.
> >
> > Freezin pane is one part they even want to freeze there own columns
> > dynamically.
> >
> > Is there a chance in near future we have this provision, if we have it would
> > be great.
> >
> > Any thought of when can we expect it.
> >
> > Askin a lot :-)
> >
> > Navin
>
as in excel work sheet.
Is it not implemented till date, if they implement when can we expect that
to happen for sql reporting services.
Freezin pane is one part they even want to freeze there own columns
dynamically.
Is there a chance in near future we have this provision, if we have it would
be great.
Any thought of when can we expect it.
Askin a lot :-)
NavinNavin,
There is a setting in RS that you can apply per object (matrix, table), in
which you can specifiy whether you want the header to remain visible when
scrolling. Look for this on the general tab. Name of the setting is "Header
should remain visible when scrolling".
(this is in RS2005)
regards,
Perry
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:9E12F763-4546-4C89-9347-C2E7F479E1B0@.microsoft.com...
> Is there a chance that columns used in sql reporting services can be
> freezed
> as in excel work sheet.
> Is it not implemented till date, if they implement when can we expect that
> to happen for sql reporting services.
> Freezin pane is one part they even want to freeze there own columns
> dynamically.
> Is there a chance in near future we have this provision, if we have it
> would
> be great.
> Any thought of when can we expect it.
> Askin a lot :-)
> Navin|||Freezing columns is big priority for us as well, and I've asked about
about it several times, but the feature is not available.
And I wouldn't expect it in a subsequent release, just based on the
technical issues to implement it, but maybe I'll be surprised.
NAVIN.D wrote:
> Is there a chance that columns used in sql reporting services can be freezed
> as in excel work sheet.
> Is it not implemented till date, if they implement when can we expect that
> to happen for sql reporting services.
> Freezin pane is one part they even want to freeze there own columns
> dynamically.
> Is there a chance in near future we have this provision, if we have it would
> be great.
> Any thought of when can we expect it.
> Askin a lot :-)
> Navin|||Seems certain part of my question solved, look forward for dynamic selection
as well, Thank for the info Perry
"Perry" wrote:
> Navin,
> There is a setting in RS that you can apply per object (matrix, table), in
> which you can specifiy whether you want the header to remain visible when
> scrolling. Look for this on the general tab. Name of the setting is "Header
> should remain visible when scrolling".
> (this is in RS2005)
> regards,
> Perry
>
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:9E12F763-4546-4C89-9347-C2E7F479E1B0@.microsoft.com...
> > Is there a chance that columns used in sql reporting services can be
> > freezed
> > as in excel work sheet.
> >
> > Is it not implemented till date, if they implement when can we expect that
> > to happen for sql reporting services.
> >
> > Freezin pane is one part they even want to freeze there own columns
> > dynamically.
> >
> > Is there a chance in near future we have this provision, if we have it
> > would
> > be great.
> >
> > Any thought of when can we expect it.
> >
> > Askin a lot :-)
> >
> > Navin
>
>|||unfortunatly it dont work the way i intended i want column to be scrolled as
well not only headers, supose i have 20 columns i want only two columns to be
freezed. and as i traversve through other columns the 2 columns which are
freezed still exists.
"Perry" wrote:
> Navin,
> There is a setting in RS that you can apply per object (matrix, table), in
> which you can specifiy whether you want the header to remain visible when
> scrolling. Look for this on the general tab. Name of the setting is "Header
> should remain visible when scrolling".
> (this is in RS2005)
> regards,
> Perry
>
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:9E12F763-4546-4C89-9347-C2E7F479E1B0@.microsoft.com...
> > Is there a chance that columns used in sql reporting services can be
> > freezed
> > as in excel work sheet.
> >
> > Is it not implemented till date, if they implement when can we expect that
> > to happen for sql reporting services.
> >
> > Freezin pane is one part they even want to freeze there own columns
> > dynamically.
> >
> > Is there a chance in near future we have this provision, if we have it
> > would
> > be great.
> >
> > Any thought of when can we expect it.
> >
> > Askin a lot :-)
> >
> > Navin
>
>|||Header scrolling dont work for matrix, only table header got that option.
"cowznofsky" wrote:
> Freezing columns is big priority for us as well, and I've asked about
> about it several times, but the feature is not available.
> And I wouldn't expect it in a subsequent release, just based on the
> technical issues to implement it, but maybe I'll be surprised.
> NAVIN.D wrote:
> > Is there a chance that columns used in sql reporting services can be freezed
> > as in excel work sheet.
> >
> > Is it not implemented till date, if they implement when can we expect that
> > to happen for sql reporting services.
> >
> > Freezin pane is one part they even want to freeze there own columns
> > dynamically.
> >
> > Is there a chance in near future we have this provision, if we have it would
> > be great.
> >
> > Any thought of when can we expect it.
> >
> > Askin a lot :-)
> >
> > Navin
>
Freeze Panes in Excel
Is there anything I can do so that when my users export their report from
reporting services to Excel that it freezes the columns'
I also need to set a default zoom %
Is there anyway to do this - thanksI also have that problem. Because when it expands, it can be really time
consuming..
"dragon" wrote:
> Is there anything I can do so that when my users export their report from
> reporting services to Excel that it freezes the columns'
> I also need to set a default zoom %
> Is there anyway to do this - thanks
>
reporting services to Excel that it freezes the columns'
I also need to set a default zoom %
Is there anyway to do this - thanksI also have that problem. Because when it expands, it can be really time
consuming..
"dragon" wrote:
> Is there anything I can do so that when my users export their report from
> reporting services to Excel that it freezes the columns'
> I also need to set a default zoom %
> Is there anyway to do this - thanks
>
Freeze Pane functionality during Export to Excel
Hi All,
I have created a Report using Sql Server 2005 Reporting Services.
When I export the report to excel, I want to freeze the pane of the headers in the exported excel.
Any pointers on how to achieve this will greatly help me.
Thanks,
S Suresh
There is no way to tell the Excel renderer to freeze an arbitrary pane. However, the renderer does set a freeze pane for the page headers (not the table headers), so that might be a possibility for you.|||Will you please tell me how to set a freeze pane fo rthe page headers? We do not want to export the page headers to the excel because it merges servera columns for one actual data column. That makes it impossible to change the sorting columns. Thanks,|||I'm not sure I understand what you mean, but the only thing exported to a freeze pane is the page headers. There is no way to put any other part of the report into a freeze pane.If you are trying to have the headers not show up in Excel, you can have them export as "simple" headers. This would put them into Excel as actual Excel headers, and not as part of the worksheet. To do this, you need to set the SimplePageHeaders device info setting:
http://msdn2.microsoft.com/en-us/library/ms155069.aspx
Hope that helps...|||
Thanks a lot for your reply.
What I want to do is exactly what you said not to put page headers into the excel. My page header has two textboxes, so I do not know if that working. I will try your suggestion tomorrow. Thanks again!
|||Geoff,
Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway.
I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code? Below is the code, please help me out. Thank you very much for your help!
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Render>
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ImageReport,Microsoft.ReportingServices.ExcelRendering">
<Configuration> <DeviceInfo>
<SimplePageHeaders>True</SimplePageHeaders>
</DeviceInfo> </Configuration> </Extension>
</Render>
<PageHeader>
<ReportItems>
<Textbox Name="textbox7">
Error message:
c:\catsreports\catsreports\Contractor.rdl(4): Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report' has invalid child element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Render'. An error occurred at , (4, 4).
Freeze Pane functionality during Export to Excel
Hi All,
I have created a Report using Sql Server 2005 Reporting Services.
When I export the report to excel, I want to freeze the pane of the headers in the exported excel.
Any pointers on how to achieve this will greatly help me.
Thanks,
S Suresh
There is no way to tell the Excel renderer to freeze an arbitrary pane. However, the renderer does set a freeze pane for the page headers (not the table headers), so that might be a possibility for you.|||Will you please tell me how to set a freeze pane fo rthe page headers? We do not want to export the page headers to the excel because it merges servera columns for one actual data column. That makes it impossible to change the sorting columns. Thanks,|||I'm not sure I understand what you mean, but the only thing exported to a freeze pane is the page headers. There is no way to put any other part of the report into a freeze pane.If you are trying to have the headers not show up in Excel, you can have them export as "simple" headers. This would put them into Excel as actual Excel headers, and not as part of the worksheet. To do this, you need to set the SimplePageHeaders device info setting:
http://msdn2.microsoft.com/en-us/library/ms155069.aspx
Hope that helps...|||
Thanks a lot for your reply.
What I want to do is exactly what you said not to put page headers into the excel. My page header has two textboxes, so I do not know if that working. I will try your suggestion tomorrow. Thanks again!
|||Geoff,
Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway.
I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code? Below is the code, please help me out. Thank you very much for your help!
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Render>
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ImageReport,Microsoft.ReportingServices.ExcelRendering">
<Configuration> <DeviceInfo>
<SimplePageHeaders>True</SimplePageHeaders>
</DeviceInfo> </Configuration> </Extension>
</Render>
<PageHeader>
<ReportItems>
<Textbox Name="textbox7">
Error message:
c:\catsreports\catsreports\Contractor.rdl(4): Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report' has invalid child element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Render'. An error occurred at , (4, 4).
Sunday, February 26, 2012
Free Tutorial Source with from A to Z examples
Hi
I read alot of theoretical explanation of Notification Services.
I need a source for examples that explain Notification Services from A to Z.
Thank you.
Bishoy
Hi Bishoy -
Here's a copy/paste from my reply to your newsgroup posting.
I'd defiinitely suggest going through the walkthrough example included
in BOL as a good starting point. Additionally, examining the other
sample apps included in would be beneficial.
Beyond that, Shyam Pather has a book on the subject that is really
quite comprehensive. I've got one out there as well; mine is designed
to get you up to speed on SQLNS very quickly.
As for other resources, I haven't found anything specifically devoted
to SQLNS, only a few article here and there on the subject - some on
MSND, some on blogs, some on community sites.
I regularly blog on the topic (www.sqlns.com) and occasionally write
articles for SQL Server Central and Red-Gate's Simple-Talk sites.
BTW - here's an article that was adapted from on of the chapters of my
book.
http://sqlns.blogspot.com/2005/11/sqlns-architecture-article-on.html
Hope this helps.
Free SQL Reporting Services or license?
I had attended course 2030 creating report using MS SQL Server Reporting
Service and I wonder how do I get this tool? Free or license?
I had license MS SQL Server 2000 and do I need to purchase or request MS SQL
Server 2000 Reporting Service?
Please advise.I have heard a couple ways to get Reporting Services. RS is free to use
with your SQL Server license.
1. From the vendor where you got your SQL server.
2. From MSDN
3. From Microsoft directly, but I do not know how.
There might be other ways, but that is what I have seen so far.
--
| From: "sam" <samuellai@.ajikl.com.my>
| Subject: Free SQL Reporting Services or license?
| Date: Thu, 7 Jul 2005 11:06:43 +0800
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#sj67DqgFHA.824@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 211.24.171.163
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47538
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I had attended course 2030 creating report using MS SQL Server Reporting
| Service and I wonder how do I get this tool? Free or license?
|
| I had license MS SQL Server 2000 and do I need to purchase or request MS
SQL
| Server 2000 Reporting Service?
|
| Please advise.
|
|
|
Service and I wonder how do I get this tool? Free or license?
I had license MS SQL Server 2000 and do I need to purchase or request MS SQL
Server 2000 Reporting Service?
Please advise.I have heard a couple ways to get Reporting Services. RS is free to use
with your SQL Server license.
1. From the vendor where you got your SQL server.
2. From MSDN
3. From Microsoft directly, but I do not know how.
There might be other ways, but that is what I have seen so far.
--
| From: "sam" <samuellai@.ajikl.com.my>
| Subject: Free SQL Reporting Services or license?
| Date: Thu, 7 Jul 2005 11:06:43 +0800
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#sj67DqgFHA.824@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 211.24.171.163
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47538
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I had attended course 2030 creating report using MS SQL Server Reporting
| Service and I wonder how do I get this tool? Free or license?
|
| I had license MS SQL Server 2000 and do I need to purchase or request MS
SQL
| Server 2000 Reporting Service?
|
| Please advise.
|
|
|
Friday, February 24, 2012
Free Barcode Font For RS 2000
Anybody know of a Free Barcode Font that is compatible with Reporting Services 2000?
Thanks!
Since Reporting Services runs off of the server, I'd imagine if you can get any free font, it would work. Just install the font on your development machine and on the server.
Subscribe to:
Posts (Atom)