Help in Chosing the Software for Reporting Services

Hi All,

I have downloaded SQL Server 2005 Express Edition with Advanced Services SP2 from the following link

http://msdn.microsoft.com/vstudio/express/sql/download/

This I did after hearing Advanced Services provide Reporting Services tool with basic functionalities. After installion I am not able to find the SQL Server Business Intelligence Development Studio. Also there is no provision for installing the Reporting Services.

I already have Visual Studio Express installed.

Could someone tell me what else to download? Also it is asking for another software to be downloaded along with the existing one.

Regards

Karthik

In Visual Studio, when you try and create new projects, do you see a folder called "business intelligence"?|||

I am using Visual Web Developer 2005 Express Edition not Visual Studio. I don't have that option.

I was browsing through many other but couldn't understand clearly what is going wrong. Could you tell me the pre-requisites required for the installation?

|||http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx|||

Thanks for the link...

After lot of searching I figured out the option to install Reporting Services would not appear till IIS is installed. After doing this it is working fine now.

Could you please let me know if installation of SQL Server 2005 Express Edition with Advanced Services SP2 is possible in Vista Home Basic. Nowhere it is clearly explained if it can be done or not.

HELP I CANNOT DEPLOPY WITH REPORT SERVICES AND SQL SERVER 2005 EXPRES ADVANCE

Hi I had installed SQL Server 2005 Express Avanced and busines intellegence development studio express. in my windows XP profesional

I have ready my first report, and When I want deploy , the system say: Reporting Services Loign: User name & Password.

I don't know that user and password must write!!!

Please can someone help me!!!

thanks folks

david

spain

Moving to the Reporting Services forum.

Mike

sql

Help for 'EXCEPTION_ACCESS_VIOLATION'

Hi,
I have a linked server on a win2000 server SQL Server which is pointing to
Analyis Services server on another machine. We are using OPENQUERY to run
drillthroughs on the OLAP server from a stored procedure in the sql server.
At one time when several users were doing multiple drillthrough using the
linked server, each returning large amounts of data, we got an exception and
the sql server crashed. We badly need help for this as it happened in
production.
The dump that I got from the dba is pasted below:
Computer type is AT/AT COMPATIBLE.
Bios Version is IBM BIOS Ver 9.0
Current time is 10:45:47 11/07/03.
8 Intel x86 level 6, 899 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 3.
Memory
MemoryLoad = 99%
Total Physical = 7935 MB
Available Physical = 35 MB
Total Page File = 9841 MB
Available Page File = 1876 MB
Total Virtual = 3071 MB
Available Virtual = 6 MB
***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0002.txt
*
****************************************************************************
*
**
*
* BEGIN STACK DUMP:
* 11/07/03 10:45:47 spid 101
*
* Exception Address = 12246557
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000050AE
* s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75 00
* n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d 00
* s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00 53
37
* 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
44
* RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f 57
* S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f 6d
* [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72 65
* ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e
* [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26 5b
* 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00 34
09
* Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
04 d0
* 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
*
===================================================================== BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 8.00.760
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is IBM BIOS Ver 9.0
Current time is 10:45:47 11/07/03.
8 Intel x86 level 6, 899 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 3.
Memory
MemoryLoad = 99%
Total Physical = 7935 MB
Available Physical = 35 MB
Total Page File = 9841 MB
Available Page File = 1876 MB
Total Virtual = 3071 MB
Available Virtual = 6 MB
***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0002.txt
*
****************************************************************************
*
**
*
* BEGIN STACK DUMP:
* 11/07/03 10:45:47 spid 101
*
* Exception Address = 12246557
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000050AE
* s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75 00
* n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d 00
* s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00 53
37
* 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
44
* RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f 57
* S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f 6d
* [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72 65
* ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e
* [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26 5b
* 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00 34
09
* Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
04 d0
* 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
*
*
* MODULE BASE END SIZE
*
* Edi: 12286A45: 2D6A1075 06E8006A 5E000003 000CC25D 6AEC8B55
0875F
F01
* Esi: 0C1CCF2C: 121A9488 00000001 133EBC20 0D1A6AD8 189D3EF8
00000
001
* Eax: 000050AA:
* Ebx: 000050AA:
* Ecx: 0000003B:
* Edx: 00107C2C: 00103EC8 FFFFFFFF 00000000 00000000 00000000
00000
FA0
* Eip: 12246557: 0443B70F 7508453B 0C458B0F 75164339 E045C707
00000
001
* Ebp: 0C1CCF0C: 0C1CCF88 12246D85 0000015F 00008D3E 12286A45
133EB
C20
* SegCs: 0000001B:
* EFlags: 00010206: 004E0049 0054004E 0073005C 00730079 00650074
00330
06D
* Esp: 0C1CCC94: 189D3EF8 00000001 00000001 0000FFFF 189D0000
00001
378
* SegSs: 00000023:
*
****************************************************************************
*
Thanks for your help,
JGPYour problem is significantly larger than what newsgroup help can usually
offer. I strongly suggest opening a case with Microsoft Product Support
Services. If you don't have an agreement with them, I believe it is $245
per incident. They have the tools to analyze your crash and make
recommendations on how to avoid such a condition
in the future.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Chumma Dede" <deja.removethis@.chothu.mailshell.com> wrote in message
news:O4%239ewGsDHA.1744@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a linked server on a win2000 server SQL Server which is pointing to
> Analyis Services server on another machine. We are using OPENQUERY to run
> drillthroughs on the OLAP server from a stored procedure in the sql
server.
> At one time when several users were doing multiple drillthrough using the
> linked server, each returning large amounts of data, we got an exception
and
> the sql server crashed. We badly need help for this as it happened in
> production.
>
> The dump that I got from the dba is pasted below:
> Computer type is AT/AT COMPATIBLE.
> Bios Version is IBM BIOS Ver 9.0
> Current time is 10:45:47 11/07/03.
> 8 Intel x86 level 6, 899 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 3.
>
> Memory
> MemoryLoad = 99%
> Total Physical = 7935 MB
> Available Physical = 35 MB
> Total Page File = 9841 MB
> Available Page File = 1876 MB
> Total Virtual = 3071 MB
> Available Virtual = 6 MB
> ***Symbol load failed - Proceed to dump without any symbols
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0002.txt
> *
>
****************************************************************************
> *
> **
> *
> * BEGIN STACK DUMP:
> * 11/07/03 10:45:47 spid 101
> *
> * Exception Address = 12246557
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 000050AE
> * s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75
00
> * n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d
00
> * s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00
53
> 37
> * 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
> 44
> * RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f
57
> * S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f
6d
> * [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72
65
> * ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d
2e
> * [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26
5b
> * 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00
34
> 09
> * Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
> 04 d0
> * 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
> *
> =====================================================================> BugCheck Dump
> =====================================================================> This file is generated by Microsoft SQL Server 8.00.760
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
> Computer type is AT/AT COMPATIBLE.
> Bios Version is IBM BIOS Ver 9.0
> Current time is 10:45:47 11/07/03.
> 8 Intel x86 level 6, 899 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 3.
>
> Memory
> MemoryLoad = 99%
> Total Physical = 7935 MB
> Available Physical = 35 MB
> Total Page File = 9841 MB
> Available Page File = 1876 MB
> Total Virtual = 3071 MB
> Available Virtual = 6 MB
> ***Symbol load failed - Proceed to dump without any symbols
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0002.txt
> *
>
****************************************************************************
> *
> **
> *
> * BEGIN STACK DUMP:
> * 11/07/03 10:45:47 spid 101
> *
> * Exception Address = 12246557
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 000050AE
> * s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75
00
> * n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d
00
> * s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00
53
> 37
> * 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
> 44
> * RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f
57
> * S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f
6d
> * [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72
65
> * ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d
2e
> * [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26
5b
> * 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00
34
> 09
> * Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
> 04 d0
> * 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
> *
> *
> * MODULE BASE END SIZE
> *
> * Edi: 12286A45: 2D6A1075 06E8006A 5E000003 000CC25D 6AEC8B55
> 0875F
> F01
> * Esi: 0C1CCF2C: 121A9488 00000001 133EBC20 0D1A6AD8 189D3EF8
> 00000
> 001
> * Eax: 000050AA:
> * Ebx: 000050AA:
> * Ecx: 0000003B:
> * Edx: 00107C2C: 00103EC8 FFFFFFFF 00000000 00000000 00000000
> 00000
> FA0
> * Eip: 12246557: 0443B70F 7508453B 0C458B0F 75164339 E045C707
> 00000
> 001
> * Ebp: 0C1CCF0C: 0C1CCF88 12246D85 0000015F 00008D3E 12286A45
> 133EB
> C20
> * SegCs: 0000001B:
> * EFlags: 00010206: 004E0049 0054004E 0073005C 00730079 00650074
> 00330
> 06D
> * Esp: 0C1CCC94: 189D3EF8 00000001 00000001 0000FFFF 189D0000
> 00001
> 378
> * SegSs: 00000023:
> *
>
****************************************************************************
> *
>
>
> Thanks for your help,
> JGP
>sql

Help abt reporting services

Hi,
I have VS 2005 and SQL Server 2005 installed.How do i create reports
using Reporting Services '
I can't find any tab like " Reporting Services" under File | new |
project .
What should I do 'R wrote:
> Hi,
>
> I have VS 2005 and SQL Server 2005 installed.How do i create reports
> using Reporting Services '
> I can't find any tab like " Reporting Services" under File | new |
> project .
> What should I do '
In VS2005, Create an empty solution, then in this solution add a new
project.
Under project types you should see "Business Intelligence Projects"
under project types.
Select this, then you can select "Report Server Project"
You can then create your reports and data sources as required, and
deploy to your report server.|||Have you installed the client tools? If you installed SQL 2005 on your
computer that does not install the client tools. You have to run setup
separately for that.
If you installed the client tools prior to VS 2005 then you need to install
them again.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R" <rashmi.bhandarkar@.gmail.com> wrote in message
news:1166503957.547110.245550@.73g2000cwn.googlegroups.com...
> Hi,
>
> I have VS 2005 and SQL Server 2005 installed.How do i create reports
> using Reporting Services '
> I can't find any tab like " Reporting Services" under File | new |
> project .
> What should I do '
>

Help : I Can't Re-installed RS !

I uninstalled Reporting Services SP1 from the development environment.
My Database is on a distant Server.
I want to re-install Reporting Service and I have this message when I select
my Report Server Database (the same as before the uninstal) : "The Report
Server Database is a different version and cannot be used for this
installation."
Can you help me ?First you need to install RS and point to an new DB. After the install
upgrade RS to SP1. Once this is done you will need to run RSConfig to point
to the old DB. If you saved off your Symmetric key you will want to reapply
it using rskeymgmt.exe. If you did not you will need to run
rskeymgmt.exe -d. Doing this will delete all the encrypted content, meaning
you will have to reenter all of your report credentials.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> I uninstalled Reporting Services SP1 from the development environment.
> My Database is on a distant Server.
> I want to re-install Reporting Service and I have this message when I
select
> my Report Server Database (the same as before the uninstal) : "The Report
> Server Database is a different version and cannot be used for this
> installation."
> Can you help me ?
>
>|||Karine,
I have a step-by-step document that you may find useful:
http://prologika.com/blog/archive/2004/08/20/161.aspx
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> First you need to install RS and point to an new DB. After the install
> upgrade RS to SP1. Once this is done you will need to run RSConfig to
point
> to the old DB. If you saved off your Symmetric key you will want to
reapply
> it using rskeymgmt.exe. If you did not you will need to run
> rskeymgmt.exe -d. Doing this will delete all the encrypted content,
meaning
> you will have to reenter all of your report credentials.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Karine" <Karine@.discussions.microsoft.com> wrote in message
> news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > I uninstalled Reporting Services SP1 from the development environment.
> > My Database is on a distant Server.
> > I want to re-install Reporting Service and I have this message when I
> select
> > my Report Server Database (the same as before the uninstal) : "The
Report
> > Server Database is a different version and cannot be used for this
> > installation."
> >
> > Can you help me ?
> >
> >
> >
>|||Thanks.
I don't use your method because RS has allready uninstalled and so I can't
save my key.
I delete from my SQL Server the DataBase Report and the database
ReportserverTempDB. I run RS install, I select my SQL Server and I can
continu running the install.
I can deploy my reports so now ... all is good ...
"Teo Lachev" wrote:
> Karine,
> I have a step-by-step document that you may find useful:
> http://prologika.com/blog/archive/2004/08/20/161.aspx
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com : http://tinyurl.com/3l49j
> Home page and blog: http://www.prologika.com/
> ----
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> > First you need to install RS and point to an new DB. After the install
> > upgrade RS to SP1. Once this is done you will need to run RSConfig to
> point
> > to the old DB. If you saved off your Symmetric key you will want to
> reapply
> > it using rskeymgmt.exe. If you did not you will need to run
> > rskeymgmt.exe -d. Doing this will delete all the encrypted content,
> meaning
> > you will have to reenter all of your report credentials.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Karine" <Karine@.discussions.microsoft.com> wrote in message
> > news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > > I uninstalled Reporting Services SP1 from the development environment.
> > > My Database is on a distant Server.
> > > I want to re-install Reporting Service and I have this message when I
> > select
> > > my Report Server Database (the same as before the uninstal) : "The
> Report
> > > Server Database is a different version and cannot be used for this
> > > installation."
> > >
> > > Can you help me ?
> > >
> > >
> > >
> >
> >
>
>

HELP !!!!

Hey,

I've installed the reporting services with the SQL EXPRESS 2005.

I've succeed to make some reports, and now i want to deploy them.

When i'm trying to run the reporting services configuration manger, i get the message "bad namespace". ican't connect in the instalation window to any machine that i'm trying to connect.

iI've tried to connect my computer, other computers with SQLEXPRESS and with SQL 2000, but i didn't succed.

How i should configure the report server ?

please, help !

Please HELP S.O.S !!!!

HELP ! How to Print Through Network Printer

Hello All,
I have Sample printer deliver extension provided with Reporting
Services. This code works well when i use Local printer, but i want to
use network printer, for that i changed config file as -
<Printer>\\199.63.103.253\NB1OACHP5100</Printer>
but Reporting Services shows error - The printer
\\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
Can anybody help me how to solve this? Also can i print the report on
an trigger like in my application i use a button to print, and on click
this report get printed.
Please help me if you solved such problem or you know how to solve
this.
Thank You
Regards
RajAll printers you use from the server Must be defined to the server... This is
simply the control panel add printer stuff.
This is doc'd in books on line...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Hello All,
> I have Sample printer deliver extension provided with Reporting
> Services. This code works well when i use Local printer, but i want to
> use network printer, for that i changed config file as -
> <Printer>\\199.63.103.253\NB1OACHP5100</Printer>
> but Reporting Services shows error - The printer
> \\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
>
> Can anybody help me how to solve this? Also can i print the report on
> an trigger like in my application i use a button to print, and on click
> this report get printed.
> Please help me if you solved such problem or you know how to solve
> this.
> Thank You
> Regards
> Raj
>|||Thanks for reply Wayne, but i already defined the printer to the
server. It is installed on my machine where server is installed. And
also do anybody know how to print report without preview on click
event?
Thanks & Regards
Raj|||We've been trying to auto-print without the preview or dialog box that pops
up, the only thing we have found is by doing a subscription...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Thanks for reply Wayne, but i already defined the printer to the
> server. It is installed on my machine where server is installed. And
> also do anybody know how to print report without preview on click
> event?
> Thanks & Regards
> Raj
>|||The printer delivery sample indicates that the server name/address must be
included in the configuration for a Networked printer. This does not appear
to be true. All that is necessary here is that the name be exactly the
same (exact case also) as what is defined in the Control Panel for the
computer
on which the Report Server is running.
"Raj" wrote:
> Hello All,
> I have Sample printer deliver extension provided with Reporting
> Services. This code works well when i use Local printer, but i want to
> use network printer, for that i changed config file as -
> <Printer>\\199.63.103.253\NB1OACHP5100</Printer>
> but Reporting Services shows error - The printer
> \\199.63.103.253\NB1OACHP5100 is not currently installed on the server.
>
> Can anybody help me how to solve this? Also can i print the report on
> an trigger like in my application i use a button to print, and on click
> this report get printed.
> Please help me if you solved such problem or you know how to solve
> this.
> Thank You
> Regards
> Raj
>

Help ! Error after (windows update) of .NET Framework

Hi all,
today i updated my .NET framework to 1.1 SP 1 (via windows update).
After than, my reporting services failed with the error key
"rsReportServerDisabled".
I have just a german full error message, but it is something with
"...decode symetric key ...". I use Win XP Professional as operating system.
Please apologize my english.
Thank your help in advance.
ThomasMost likely the ASP.NET account got reset. If you have the encryption key
saved, you can restore it using rskeymgmt. If not, you will need to reset
the encryption via rskeymgmt -d.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
> Hi all,
> today i updated my .NET framework to 1.1 SP 1 (via windows update).
> After than, my reporting services failed with the error key
> "rsReportServerDisabled".
> I have just a german full error message, but it is something with
> "...decode symetric key ...". I use Win XP Professional as operating
> system.
> Please apologize my english.
> Thank your help in advance.
> Thomas
>
>|||I just tried it and you will probably also need to reconfigure the
connection string via rsconfig before you restore the encryption key.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
> Most likely the ASP.NET account got reset. If you have the encryption key
> saved, you can restore it using rskeymgmt. If not, you will need to reset
> the encryption via rskeymgmt -d.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
>> Hi all,
>> today i updated my .NET framework to 1.1 SP 1 (via windows update).
>> After than, my reporting services failed with the error key
>> "rsReportServerDisabled".
>> I have just a german full error message, but it is something with
>> "...decode symetric key ...". I use Win XP Professional as operating
>> system.
>> Please apologize my english.
>> Thank your help in advance.
>> Thomas
>>
>>
>|||OK, one more correction. :) I was told by the developers that you won't need
to restore the encryption key. After resetting the connection string, you
just need to do an rsactivate -r -c and things will start working again.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ePMQzNFlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I just tried it and you will probably also need to reconfigure the
>connection string via rsconfig before you restore the encryption key.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
>> Most likely the ASP.NET account got reset. If you have the encryption key
>> saved, you can restore it using rskeymgmt. If not, you will need to reset
>> the encryption via rskeymgmt -d.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
>> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
>> Hi all,
>> today i updated my .NET framework to 1.1 SP 1 (via windows update).
>> After than, my reporting services failed with the error key
>> "rsReportServerDisabled".
>> I have just a german full error message, but it is something with
>> "...decode symetric key ...". I use Win XP Professional as operating
>> system.
>> Please apologize my english.
>> Thank your help in advance.
>> Thomas
>>
>>
>>
>|||Thank you Brian !
I will try it at once...
Best regards from Germany
Thomas
"Brian Welcker [MSFT]" wrote:
> OK, one more correction. :) I was told by the developers that you won't need
> to restore the encryption key. After resetting the connection string, you
> just need to do an rsactivate -r -c and things will start working again.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ePMQzNFlEHA.3452@.TK2MSFTNGP15.phx.gbl...
> >I just tried it and you will probably also need to reconfigure the
> >connection string via rsconfig before you restore the encryption key.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:uCvrjDElEHA.3428@.TK2MSFTNGP14.phx.gbl...
> >> Most likely the ASP.NET account got reset. If you have the encryption key
> >> saved, you can restore it using rskeymgmt. If not, you will need to reset
> >> the encryption via rskeymgmt -d.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> >> news:D5EEE105-6F19-411C-A820-FBCE3940E699@.microsoft.com...
> >> Hi all,
> >> today i updated my .NET framework to 1.1 SP 1 (via windows update).
> >> After than, my reporting services failed with the error key
> >> "rsReportServerDisabled".
> >> I have just a german full error message, but it is something with
> >> "...decode symetric key ...". I use Win XP Professional as operating
> >> system.
> >> Please apologize my english.
> >>
> >> Thank your help in advance.
> >> Thomas
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Help - Multi values dimensions ?

Hello all
we developped a software with a data warehouse in sql server, without using
analysis services, and following the star design.
we are working with data about transactions, with caracteristics modeled in
dimensions. in general each transaction has one single value for each
caracteristic, but for one, it may have more than one or no value.
some solution we thought about:
-we use comma separated IDs (string) in the dimension in the fact table, but
it would hurt indexing
-or store the IDs in a separate table, but each query will require a join
my question is what is the best way to implement this feature ?
thank you for your help
its a standard "n-n" relationship.
1 caracteristic, can have 0 to N transacions
1 transaction can have 0 to N caracteristic
So, you'll have 3 tables:
Caracteristics 1 - n CaractToTransac n - 1 Transactions
The CaractToTransac table contain only 2 columns:
CaracteristicID and TransactionID
(maybe you can add a column called "sequence" if the order of your
caracteristics is important for you)
Now you have multi caracteristics for each transaction.
"r_samir" <r_samir@.discussions.microsoft.com> a crit dans le message de
news:8E2216BF-50D7-4FF6-89A3-C1995D83E3B5@.microsoft.com...
> Hello all
> we developped a software with a data warehouse in sql server, without
using
> analysis services, and following the star design.
> we are working with data about transactions, with caracteristics modeled
in
> dimensions. in general each transaction has one single value for each
> caracteristic, but for one, it may have more than one or no value.
> some solution we thought about:
> -we use comma separated IDs (string) in the dimension in the fact table,
but
> it would hurt indexing
> -or store the IDs in a separate table, but each query will require a join
> my question is what is the best way to implement this feature ?
> thank you for your help

Help - Loosing my Sanity

We are having a problem with our services (mainly SQL server) in that they loose/forget their passwords. So, even though the service is set to start automatically, it can't do to a logon failure. We must type over the password and then are able to start
the service. This is happening on multiple configurations.
Windows 2000 Advanced, SP2 & 3, SQL Server 2000
Windows 2000 Standard, SP4, SQL Server 2000
SQL Server 2000 is at SP3 with all the latest patches and fixes.
Any help would be greatly appreciated.
Have you checked the settings for the account itself? Make
sure the account is set up so that Password never expires is
selected and Must change password at next login is not
selected.
-Sue
On Tue, 25 May 2004 05:11:12 -0700, "Jenn"
<anonymous@.discussions.microsoft.com> wrote:

>We are having a problem with our services (mainly SQL server) in that they loose/forget their passwords. So, even though the service is set to start automatically, it can't do to a logon failure. We must type over the password and then are able to star
t the service. This is happening on multiple configurations.
>Windows 2000 Advanced, SP2 & 3, SQL Server 2000
>Windows 2000 Standard, SP4, SQL Server 2000
>SQL Server 2000 is at SP3 with all the latest patches and fixes.
>Any help would be greatly appreciated.
|||This is a known problem with version 818. Download the fix if you're
getting prompted for passwords.
826161 FIX: You Are Prompted for Password Confirmation After You Change a
http://support.microsoft.com/?id=826161
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Help - Loosing my Sanity

We are having a problem with our services (mainly SQL server) in that they l
oose/forget their passwords. So, even though the service is set to start au
tomatically, it can't do to a logon failure. We must type over the password
and then are able to start
the service. This is happening on multiple configurations.
Windows 2000 Advanced, SP2 & 3, SQL Server 2000
Windows 2000 Standard, SP4, SQL Server 2000
SQL Server 2000 is at SP3 with all the latest patches and fixes.
Any help would be greatly appreciated.Have you checked the settings for the account itself? Make
sure the account is set up so that Password never expires is
selected and Must change password at next login is not
selected.
-Sue
On Tue, 25 May 2004 05:11:12 -0700, "Jenn"
<anonymous@.discussions.microsoft.com> wrote:

>We are having a problem with our services (mainly SQL server) in that they loose/fo
rget their passwords. So, even though the service is set to start automatically, it
can't do to a logon failure. We must type over the password and then are able to s
tar
t the service. This is happening on multiple configurations.
>Windows 2000 Advanced, SP2 & 3, SQL Server 2000
>Windows 2000 Standard, SP4, SQL Server 2000
>SQL Server 2000 is at SP3 with all the latest patches and fixes.
>Any help would be greatly appreciated.|||This is a known problem with version 818. Download the fix if you're
getting prompted for passwords.
826161 FIX: You Are Prompted for Password Confirmation After You Change a
http://support.microsoft.com/?id=826161
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

HELP - Designing a Subscripion System for a Group of Reports

We're developing an ASP.NET 2.0 (C#) application that will act as a
front-end to SQL Server 2005 Reporting Services. We have an interesting
requirement that [we believe] can't be solved using RS out-of-the-box. So,
I'm writing today to get some ideas on possible solutions.
The requirement is that the app. needs to support, what we're calling, a
report group. A report group is simply a group of similar reports that can
be executed as a single unit (instead of having to execute each report
individually). This was not too bad to solve. We simply created our own
database tables that track which report group contains which reports.
The tricky part is that we now have to figure out a way to create a
subscription that executes the report group (thereby executing each
individual report in the report group automatically). Creating a
subscription for a single report is fairly straightforward, but it appears
this concept of a report group is not a part of RS.
Does anyone out there have any good ideas/suggestions on how we can
implement such functionality?
The best thought we have so far is to write another application that manages
the execution of each report in a report group. So, the SQL Server 2005 job
would call this additional little application, this additional app. would
lookup which reports are in the report group, and then it would loop through
all the reports and execute them one-by-one. But, this has some issues-like
how do we handle the output type (PDF, Excel, etc.) and how do we handle the
destination (e-mail, printer, etc.) of each report. Plus, it seems like we
would be somewhat reinventing the wheel as far as subscriptions go.
Thanks.Why aren't you using one master report with all the other reports as
sub-reports?
Tom Bizannes
oiduts wrote:
> We're developing an ASP.NET 2.0 (C#) application that will act as a
> front-end to SQL Server 2005 Reporting Services. We have an interesting
> requirement that [we believe] can't be solved using RS out-of-the-box. So,
> I'm writing today to get some ideas on possible solutions.
> The requirement is that the app. needs to support, what we're calling, a
> report group. A report group is simply a group of similar reports that can
> be executed as a single unit (instead of having to execute each report
> individually). This was not too bad to solve. We simply created our own
> database tables that track which report group contains which reports.
> The tricky part is that we now have to figure out a way to create a
> subscription that executes the report group (thereby executing each
> individual report in the report group automatically). Creating a
> subscription for a single report is fairly straightforward, but it appears
> this concept of a report group is not a part of RS.
> Does anyone out there have any good ideas/suggestions on how we can
> implement such functionality?
> The best thought we have so far is to write another application that manages
> the execution of each report in a report group. So, the SQL Server 2005 job
> would call this additional little application, this additional app. would
> lookup which reports are in the report group, and then it would loop through
> all the reports and execute them one-by-one. But, this has some issues-like
> how do we handle the output type (PDF, Excel, etc.) and how do we handle the
> destination (e-mail, printer, etc.) of each report. Plus, it seems like we
> would be somewhat reinventing the wheel as far as subscriptions go.
> Thanks.|||You could try setting up a shared schedule. It would still require
individual subscriptions for each report but they would all start
firing at the same scheduled time.

help

Hi
If i use select * from table...i get the following
10 Energy Energy Energy Equipment & Services Oil & Gas
Drilling 10101010
10 Energy Energy Energy Equipment & Services Oil & Gas
Equipment & Svcs 10101020
10 Energy Energy Oil & Gas Integrated Oil &
Gas 10102010
10 Energy Energy Oil & Gas Oil & Gas
Exploration & Prod 10102020
10 Energy Energy Oil & Gas Oil & Gas Refining
& Mktg 10102030
10 Energy Energy Oil & Gas Oil & Gas Storage
& Transpor 10102040
10 Energy Energy Oil & Gas Coal & Consumable
Fuels 10102050
15 Materials Materials Chemicals Commodity
Chemicals 15101010
15 Materials Materials Chemicals Diversified
Chemicals 15101020
15 Materials Materials Chemicals Fertilizers & Agri
Chemicals 15101030
15 Materials Materials Chemicals Industrial
Gases 15101040
15 Materials Materials Chemicals Specialty
Chemicals 15101050
15 Materials Materials Construction Materials Construction
Materials 15102010
15 Materials Materials Containers & Packaging Metal & Glass
Containers 15103010
15 Materials Materials Containers & Packaging Paper
Packaging 15103020
15 Materials Materials Metals & Mining
Aluminum 15104010
15 Materials Materials Metals & Mining Diversified Metals
& Mining 15104020
15 Materials Materials Metals & Mining Gold
15104030
15 Materials Materials Metals & Mining Precious Metals &
Minerals 15104040
15 Materials Materials Metals & Mining Steel
15104050
15 Materials Materials Paper & Forest Products Forest
Products 15105010
15 Materials Materials Paper & Forest Products Paper
Products 15105020
but my output should be as follows
10 Energy Energy Energy Equipment & Services Oil & Gas
Drilling 10101010
Oil & Gas
Equipment & Svcs 10101020
10 Energy Energy Oil & Gas Integrated Oil &
Gas 10102010
Oil & Gas
Exploration & Prod 10102020
Oil & Gas Refining
& Mktg 10102030
Oil & Gas Storage
& Transpor 10102040
Coal & Consumable
Fuels 10102050
15 Materials Materials Chemicals Commodity
Chemicals 15101010
Diversified
Chemicals 15101020
Fertilizers & Agri
Chemicals 15101030
Industrial Gases
15101040
Specialty
Chemicals 15101050
15 Materials Materials Construction Materials Construction
Materials 15102010
Containers & Packaging Metal & Glass
Containers 15103010
Paper Packaging
15103020
15 Materials Materials Metals & Mining
Aluminum 15104010
Diversified Metals
& Mining 15104020
Gold
15104030
Precious Metals &
Minerals 15104040
Steel
15104050
15 Materials Materials Paper & Forest Products Forest
Products 15105010
Paper Products
15105020
can anyone tell me how 2 query for abovehi,
The output format needed for you is not that clear. Still feels like you
need a groupby, like
10 Energy Energy Energy
10 Energy Energy Oil & Gas
15 Materials Materials Chemicals
15 Materials Materials Construction Materials
...........................
...........................
In this case you need to try a group by,
SELECT 1,2,3,SUM(ANY VALUE FEILD) FROM TABLE
GROUP BY 1,2,3
Not sure if this is what you what, if not give more details like tbale
structure and optut you needed in good format...
Thanks,
Sree
"kalikoi@.gmail.com" wrote:

> Hi
>
> If i use select * from table...i get the following
>
> 10 Energy Energy Energy Equipment & Services Oil & Gas
> Drilling 10101010
> 10 Energy Energy Energy Equipment & Services Oil & Gas
> Equipment & Svcs 10101020
> 10 Energy Energy Oil & Gas Integrated Oil &
> Gas 10102010
> 10 Energy Energy Oil & Gas Oil & Gas
> Exploration & Prod 10102020
> 10 Energy Energy Oil & Gas Oil & Gas Refining
> & Mktg 10102030
> 10 Energy Energy Oil & Gas Oil & Gas Storage
> & Transpor 10102040
> 10 Energy Energy Oil & Gas Coal & Consumable
> Fuels 10102050
> 15 Materials Materials Chemicals Commodity
> Chemicals 15101010
> 15 Materials Materials Chemicals Diversified
> Chemicals 15101020
> 15 Materials Materials Chemicals Fertilizers & Agri
> Chemicals 15101030
> 15 Materials Materials Chemicals Industrial
> Gases 15101040
> 15 Materials Materials Chemicals Specialty
> Chemicals 15101050
> 15 Materials Materials Construction Materials Construction
> Materials 15102010
> 15 Materials Materials Containers & Packaging Metal & Glass
> Containers 15103010
> 15 Materials Materials Containers & Packaging Paper
> Packaging 15103020
> 15 Materials Materials Metals & Mining
> Aluminum 15104010
> 15 Materials Materials Metals & Mining Diversified Metals
> & Mining 15104020
> 15 Materials Materials Metals & Mining Gold
> 15104030
> 15 Materials Materials Metals & Mining Precious Metals &
> Minerals 15104040
> 15 Materials Materials Metals & Mining Steel
> 15104050
> 15 Materials Materials Paper & Forest Products Forest
> Products 15105010
> 15 Materials Materials Paper & Forest Products Paper
> Products 15105020
>
> but my output should be as follows
>
> 10 Energy Energy Energy Equipment & Services Oil & Gas
> Drilling 10101010
> Oil & Gas
> Equipment & Svcs 10101020
> 10 Energy Energy Oil & Gas Integrated Oil &
> Gas 10102010
> Oil & Gas
> Exploration & Prod 10102020
> Oil & Gas Refining
> & Mktg 10102030
> Oil & Gas Storage
> & Transpor 10102040
> Coal & Consumable
> Fuels 10102050
> 15 Materials Materials Chemicals Commodity
> Chemicals 15101010
> Diversified
> Chemicals 15101020
> Fertilizers & Agri
> Chemicals 15101030
> Industrial Gases
> 15101040
> Specialty
> Chemicals 15101050
> 15 Materials Materials Construction Materials Construction
> Materials 15102010
> Containers & Packaging Metal & Glass
> Containers 15103010
> Paper Packaging
> 15103020
> 15 Materials Materials Metals & Mining
> Aluminum 15104010
> Diversified Metals
> & Mining 15104020
> Gold
> 15104030
> Precious Metals &
> Minerals 15104040
> Steel
> 15104050
> 15 Materials Materials Paper & Forest Products Forest
> Products 15105010
> Paper Products
> 15105020
>
> can anyone tell me how 2 query for above
>|||Best bet is to place your output on a web page and link to it from here.
Newsgroup posters/readers dont handle long lines/ line breaks very well, so
anything longer than 70 or 80 characters becomes an unreadable mess.
Also, post your table DDL, and try to explain what you want with words, in
addition to visuals.
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:E492AFA1-A434-4101-A4D3-F7FB71E03EBA@.microsoft.com...
> hi,
> The output format needed for you is not that clear. Still feels like you
> need a groupby, like
> 10 Energy Energy Energy
> 10 Energy Energy Oil & Gas
> 15 Materials Materials Chemicals
> 15 Materials Materials Construction Materials
> ...........................
> ...........................
> In this case you need to try a group by,
> SELECT 1,2,3,SUM(ANY VALUE FEILD) FROM TABLE
> GROUP BY 1,2,3
> Not sure if this is what you what, if not give more details like tbale
> structure and optut you needed in good format...
> Thanks,
> Sree
>
>
>
> "kalikoi@.gmail.com" wrote:
>|||I got four table structures as follows
CREATE TABLE [dbo].[Sector] (
[SectorID] [int] NOT NULL ,
[SectorName] [varchar] (50)
)
the data is as follows
--
10 Energy
CREATE TABLE [dbo].[GroupMaster] (
[SectorID] [int] NOT NULL ,
[GroupID] [int] NOT NULL ,
[GroupName] [varchar] (50)
)
the data is as follows
--
10 1010 Energy
CREATE TABLE [dbo].[IndustryMaster] (
[GroupID] [int] NOT NULL ,
[IndustryID] [numeric](6, 0) NOT NULL ,
[IndustryName] [varchar] (50)
)
the data is as follows
---
1010 101010 Energy Equipment & Services
1010 101020 Oil & Gas
CREATE TABLE [dbo].[SubIndustryMaster] (
[IndustryID] [numeric](6, 0) NOT NULL ,
[SubIndustryID] [numeric](8, 0) NOT NULL ,
[SubIndustryName] [varchar] (30)
)
the data is as follows
----
101010 10101010 Oil & Gas Drilling
101010 10101020 Oil & Gas Equipment & Svcs
101020 10102010 Integrated Oil & Gas
101020 10102020 Oil & Gas Exploration & Prod
101020 10102030 Oil & Gas Refining & Mktg
101020 10102040 Oil & Gas Storage & Transpor
101020 10102050 Coal & Consumable Fuels
Now i want a ADO DataShape command which results the following
Energy
Energy
Energy Equipment & Services
Oil & Gas Drilling
Oil & Gas Equipment & Svcs
Oil & Gas
Integrated Oil & Gas
Oil & Gas Exploration & Prod
Oil & Gas Refining & Mktg
Oil & Gas Storage & Transpor
Coal & Consumable Fuels

help

Hi

If i use select * from table...i get the following

10 Energy Energy Energy Equipment & Services Oil & Gas
Drilling10101010
10 Energy Energy Energy Equipment & Services Oil & Gas
Equipment & Svcs10101020
10 Energy Energy Oil & Gas Integrated Oil &
Gas10102010
10 Energy Energy Oil & Gas Oil & Gas
Exploration & Prod10102020
10 Energy Energy Oil & Gas Oil & Gas Refining
& Mktg10102030
10 Energy Energy Oil & Gas Oil & Gas Storage
& Transpor10102040
10 Energy Energy Oil & Gas Coal & Consumable
Fuels10102050
15 Materials Materials Chemicals Commodity
Chemicals15101010
15 Materials Materials Chemicals Diversified
Chemicals15101020
15 Materials Materials Chemicals Fertilizers & Agri
Chemicals15101030
15 Materials Materials Chemicals Industrial
Gases15101040
15 Materials Materials Chemicals Specialty
Chemicals15101050
15 Materials Materials Construction Materials Construction
Materials15102010
15 Materials Materials Containers & Packaging Metal & Glass
Containers15103010
15 Materials Materials Containers & Packaging Paper
Packaging15103020
15 Materials Materials Metals & Mining
Aluminum15104010
15 Materials Materials Metals & Mining Diversified Metals
& Mining15104020
15 Materials Materials Metals & Mining Gold15104030
15 Materials Materials Metals & Mining Precious Metals &
Minerals15104040
15 Materials Materials Metals & Mining Steel15104050
15 Materials Materials Paper & Forest Products Forest
Products15105010
15 Materials Materials Paper & Forest Products Paper
Products15105020

but my output should be as follows

10 Energy Energy Energy Equipment & Services Oil & Gas
Drilling10101010
Oil & Gas Equipment & Svcs10101020
10 Energy Energy Oil & Gas Integrated Oil &
Gas10102010
Oil & Gas Exploration & Prod10102020
Oil & Gas Refining & Mktg10102030
Oil & Gas Storage & Transpor10102040
Coal & Consumable Fuels10102050
15 Materials Materials Chemicals Commodity
Chemicals15101010
Diversified Chemicals15101020
Fertilizers & Agri Chemicals15101030
Industrial Gases15101040
Specialty Chemicals15101050
15 Materials Materials Construction Materials Construction
Materials15102010
Containers & Packaging Metal & Glass Containers15103010
Paper Packaging15103020
15 Materials Materials Metals & Mining
Aluminum15104010
Diversified Metals & Mining15104020
Gold15104030
Precious Metals & Minerals15104040
Steel15104050
15 Materials Materials Paper & Forest Products Forest
Products15105010
Paper Products15105020

can anyone tell me how 2 query for abovekalikoi@.gmail.com wrote:

> Hi
> If i use select * from table...i get the following
>
> 10 Energy Energy Energy Equipment & Services Oil & Gas
> Drilling10101010
> 10 Energy Energy Energy Equipment & Services Oil & Gas
> Equipment & Svcs10101020
> 10 Energy Energy Oil & Gas Integrated Oil &
> Gas10102010
> 10 Energy Energy Oil & Gas Oil & Gas
> Exploration & Prod10102020
> 10 Energy Energy Oil & Gas Oil & Gas Refining
> & Mktg10102030
> 10 Energy Energy Oil & Gas Oil & Gas Storage
> & Transpor10102040
> 10 Energy Energy Oil & Gas Coal & Consumable
> Fuels10102050
> 15 Materials Materials Chemicals Commodity
> Chemicals15101010
> 15 Materials Materials Chemicals Diversified
> Chemicals15101020
> 15 Materials Materials Chemicals Fertilizers & Agri
> Chemicals15101030
> 15 Materials Materials Chemicals Industrial
> Gases15101040
> 15 Materials Materials Chemicals Specialty
> Chemicals15101050
> 15 Materials Materials Construction Materials Construction
> Materials15102010
> 15 Materials Materials Containers & Packaging Metal & Glass
> Containers15103010
> 15 Materials Materials Containers & Packaging Paper
> Packaging15103020
> 15 Materials Materials Metals & Mining
> Aluminum15104010
> 15 Materials Materials Metals & Mining Diversified Metals
> & Mining15104020
> 15 Materials Materials Metals & Mining Gold15104030
> 15 Materials Materials Metals & Mining Precious Metals &
> Minerals15104040
> 15 Materials Materials Metals & Mining Steel15104050
> 15 Materials Materials Paper & Forest Products Forest
> Products15105010
> 15 Materials Materials Paper & Forest Products Paper
> Products15105020
>
> but my output should be as follows
>
> 10 Energy Energy Energy Equipment & Services Oil & Gas
> Drilling10101010
> Oil & Gas Equipment & Svcs10101020
> 10 Energy Energy Oil & Gas Integrated Oil &
> Gas10102010
> Oil & Gas Exploration & Prod10102020
> Oil & Gas Refining & Mktg10102030
> Oil & Gas Storage & Transpor10102040
> Coal & Consumable Fuels10102050
> 15 Materials Materials Chemicals Commodity
> Chemicals15101010
> Diversified Chemicals15101020
> Fertilizers & Agri Chemicals15101030
> Industrial Gases15101040
> Specialty Chemicals15101050
> 15 Materials Materials Construction Materials Construction
> Materials15102010
> Containers & Packaging Metal & Glass Containers15103010
> Paper Packaging15103020
> 15 Materials Materials Metals & Mining
> Aluminum15104010
> Diversified Metals & Mining15104020
> Gold15104030
> Precious Metals & Minerals15104040
> Steel15104050
> 15 Materials Materials Paper & Forest Products Forest
> Products15105010
> Paper Products15105020
>
> can anyone tell me how 2 query for above

That's just presentational stuff. It is called "banding" in reports and
even the most basic reporting tool will do it for you. There isn't much
cause to do it in SQL and although it is certainly possible it will be
needlessly complex to do and won't perform well.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Small nit --

Whenever posting to a newsgroup try using headers a that are more
descriptive than just 'help'. I assume about 95% of
the people posting here require help. This'll make it easier for people
who are browsing old articles.

thanks,

Crazy|||I got four table structures as follows

CREATE TABLE [dbo].[Sector] (
[SectorID] [int] NOT NULL ,
[SectorName] [varchar] (50)
)

the data is as follows
-------
10Energy

CREATE TABLE [dbo].[GroupMaster] (
[SectorID] [int] NOT NULL ,
[GroupID] [int] NOT NULL ,
[GroupName] [varchar] (50)
)

the data is as follows
--------
10 1010 Energy

CREATE TABLE [dbo].[IndustryMaster] (
[GroupID] [int] NOT NULL ,
[IndustryID] [numeric](6, 0) NOT NULL ,
[IndustryName] [varchar] (50)
)

the data is as follows
--------------
1010101010Energy Equipment & Services
1010101020Oil & Gas

CREATE TABLE [dbo].[SubIndustryMaster] (
[IndustryID] [numeric](6, 0) NOT NULL ,
[SubIndustryID] [numeric](8, 0) NOT NULL ,
[SubIndustryName] [varchar] (30)
)

the data is as follows
----------------
10101010101010Oil & Gas Drilling
10101010101020Oil & Gas Equipment & Svcs
10102010102010Integrated Oil & Gas
10102010102020Oil & Gas Exploration & Prod
10102010102030Oil & Gas Refining & Mktg
10102010102040Oil & Gas Storage & Transpor
10102010102050Coal & Consumable Fuels

Now i want a ADO DataShape command which results the following

Energy
Energy
Energy Equipment & Services
Oil & Gas Drilling
Oil & Gas Equipment & Svcs

Oil & Gas
Integrated Oil & Gas
Oil & Gas Exploration & Prod
Oil & Gas Refining & Mktg
Oil & Gas Storage & Transpor
Coal & Consumable Fuels|||(kalikoi@.gmail.com) writes:
> Now i want a ADO DataShape command which results the following
>
> Energy
> Energy
> Energy Equipment & Services
> Oil & Gas Drilling
> Oil & Gas Equipment & Svcs
> Oil & Gas
> Integrated Oil & Gas
> Oil & Gas Exploration & Prod
> Oil & Gas Refining & Mktg
> Oil & Gas Storage & Transpor
> Coal & Consumable Fuels

Hm, maybe you should try an ADO newsgroup. I've read about MS Data Shape,
but I should probably not suggest solutions for it...

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx