Infopath for Reporting Services Parameters

Has anyone looked at that? I think it could be a good option...
Parameters layout is something I would like to change.
Any suggestions?This is the approach I could think of so far:
Download
http://www.microsoft.com/downloads/details.aspx?FamilyId=7E9EBC57-E115-4CAC-9986-A712E22879BB&displaylang=en
- and then customize Infopath the way data is retrived...
- reference the dll's for reporting service
... any thoughts...?
(Maybe I am off on another direction...but just thought it's worth a
try)|||You can use Reportng Services as a source for InfoPath data (use the XML
rendering extension and XSL).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407230611.2431bfb@.posting.google.com...
> This is the approach I could think of so far:
> Download
> http://www.microsoft.com/downloads/details.aspx?FamilyId=7E9EBC57-E115-4CAC-9986-A712E22879BB&displaylang=en
> - and then customize Infopath the way data is retrived...
> - reference the dll's for reporting service
> ... any thoughts...?
> (Maybe I am off on another direction...but just thought it's worth a
> try)sql

info on setting up XML webservices and SSL ?

Hi,
Im under the impression the SQL has something called XML web services and
that I can use this service to provided an SSL layer for my IIS6 machine and
aspx code to query the SQL db remotly.
At the moment my aspx app simply connects to the remote SQL server on 1433
using SQL authentication. It then pulls back an XML page. It was suggested
this XML web service could do this far more securely + uses SSL.
I just wondering if anyone has a few pointers about how to start setting
this up ?
I assume in need to install services on SQL server (web server and IIS
maybe) and setup certificate server etc...
Any information is helpful.
Thanks for your time
Scott
Do you have the SQLXML 3.0 component downloaded from MSDN (aka as
WebServices toolkit)?
Best regards
Michael
"scott" <nospamscott@.yahoo.com> wrote in message
news:%23zmMNVMnEHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Im under the impression the SQL has something called XML web services and
> that I can use this service to provided an SSL layer for my IIS6 machine
> and aspx code to query the SQL db remotly.
> At the moment my aspx app simply connects to the remote SQL server on 1433
> using SQL authentication. It then pulls back an XML page. It was suggested
> this XML web service could do this far more securely + uses SSL.
> I just wondering if anyone has a few pointers about how to start setting
> this up ?
> I assume in need to install services on SQL server (web server and IIS
> maybe) and setup certificate server etc...
> Any information is helpful.
> Thanks for your time
> Scott
>
|||thanks for reply, i will take a look at the download.
Scott

Info on Reporting Services

Anyone have a source for detailed specs on this? Specifically inclusion of
the ad-hoc interface like CR has? (ActiveView?)
We are looking at a potential dump of CRE and using SRS if the
funcitionality we need/want is there.
thanks
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.comCurt,
Detailed specs on what? Currently, RS doesn't come with ad-hoc capabilities.
There are third-party tools you can use, e.g. Cizer Query. No details at
this time about ActiveView-to-RS integration.
--
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://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%23RTzAiJkEHA.2668@.TK2MSFTNGP10.phx.gbl...
> Anyone have a source for detailed specs on this? Specifically inclusion of
> the ad-hoc interface like CR has? (ActiveView?)
> We are looking at a potential dump of CRE and using SRS if the
> funcitionality we need/want is there.
> thanks
> --
> Curt Christianson
> Owner/Lead Developer, DF-Software
> Site: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
>|||That's what I was wondering. I know that MS acquired ActiveView but wasn't
sure if it was rolled into the system yet.
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Teo Lachev" <teo.lachev@.nospam.prologika.com> wrote in message
news:OmfknMPkEHA.3372@.TK2MSFTNGP09.phx.gbl...
> Curt,
> Detailed specs on what? Currently, RS doesn't come with ad-hoc
> capabilities.
> There are third-party tools you can use, e.g. Cizer Query. No details at
> this time about ActiveView-to-RS integration.
> --
> 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://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> news:%23RTzAiJkEHA.2668@.TK2MSFTNGP10.phx.gbl...
>> Anyone have a source for detailed specs on this? Specifically inclusion
>> of
>> the ad-hoc interface like CR has? (ActiveView?)
>> We are looking at a potential dump of CRE and using SRS if the
>> funcitionality we need/want is there.
>> thanks
>> --
>> Curt Christianson
>> Owner/Lead Developer, DF-Software
>> Site: http://www.Darkfalz.com
>> Blog: http://blog.Darkfalz.com
>>
>|||I can't help you out with detailed specs, but if you're evaluating RS
like we are, you may be interested in the thread that's been running
in response to a post I made earlier in this ng with the subject
"Evaluating: opinions please!" You can also find this thread at
http://msdn.microsoft.com/newsgroups/Default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=0d0fe562-f171-47ec-a61b-b38b0a9f02fe&sloc=en-us
or
http://www.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=gdfci05vsd2o1a67r1getvdmmep61o8tr3%404ax.com&rnum=1&prev=/groups%3Fas_epq%3DEvaluating%253A%2520%2520opinions%2520please!%26safe%3Dimages%26ie%3DUTF-8%26as_ugroup%3Dmicrosoft.*%26lr%3D%26num%3D100%26hl%3Den
Hope that helps!
Brad.
On Wed, 1 Sep 2004 21:57:21 -0500, "Curt_C [MVP]"
<software_AT_darkfalz.com> wrote:
>Anyone have a source for detailed specs on this? Specifically inclusion of
>the ad-hoc interface like CR has? (ActiveView?)
>We are looking at a potential dump of CRE and using SRS if the
>funcitionality we need/want is there.
>thanks

info

Good Morning,
I have a question.
For Use sql reporting services I need on the same server Sql reporting
services and VB .Net?
Can I use Visual basic 6 or Crystal Report to create a report and only than
use Sql Reporting Services to sharing the report?With the current version of SQL RS, the report designer is integrated
with VS. I suppose you could, in theory, build your own RDL file to
create reports, but that would be incredibly tedious. I don't think
there's any way to build the reports with VB6, and, though there are
paid services to do it, there is no easy way to convert CR reports to
RS.
However, if the public beta is indicative, with SQL 2k5, MS has taken
the report designer out and made it a stand-alone app. My impression
is that in that scenario you won't need VS.
Hope that helps!
Brad.
On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
wrote:
>Good Morning,
>I have a question.
>For Use sql reporting services I need on the same server Sql reporting
>services and VB .Net?
>Can I use Visual basic 6 or Crystal Report to create a report and only than
>use Sql Reporting Services to sharing the report?
>|||About your second statement. I don't think that is the case (not needing
VS). The only announcement has been some stand-alone controls that can be
used for rendering (winform control and asp.net control). This has nothing
to do with the report designer. I have seen nothing that would indicate that
VS would not be needed to design the report. Think about designing Winforms,
ASP.Net. Writing VB.Net code. All these things can be done without VS
(nothing prevents using notepad) but I sure wouldn't want to try.
Bruce L-C
"Bradley Plett" <plettb@.hotmail.com> wrote in message
news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
> With the current version of SQL RS, the report designer is integrated
> with VS. I suppose you could, in theory, build your own RDL file to
> create reports, but that would be incredibly tedious. I don't think
> there's any way to build the reports with VB6, and, though there are
> paid services to do it, there is no easy way to convert CR reports to
> RS.
> However, if the public beta is indicative, with SQL 2k5, MS has taken
> the report designer out and made it a stand-alone app. My impression
> is that in that scenario you won't need VS.
> Hope that helps!
> Brad.
> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
> wrote:
> >Good Morning,
> >I have a question.
> >For Use sql reporting services I need on the same server Sql reporting
> >services and VB .Net?
> >
> >Can I use Visual basic 6 or Crystal Report to create a report and only
than
> >use Sql Reporting Services to sharing the report?
> >
>|||Having tried out the public beta of SQL 2k5, I can tell you that there
is a stand-alone report designer. Furthermore, when I tried to get
report designer integration into VS, I found (thanks to newsgroup
postings) that the VS integration was no longer even an option.
Certainly VS will be useful when creating applications that use the
new report viewer components, but I haven't been able to get my hands
on those yet to give them a try. :-)
Brad.
On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>About your second statement. I don't think that is the case (not needing
>VS). The only announcement has been some stand-alone controls that can be
>used for rendering (winform control and asp.net control). This has nothing
>to do with the report designer. I have seen nothing that would indicate that
>VS would not be needed to design the report. Think about designing Winforms,
>ASP.Net. Writing VB.Net code. All these things can be done without VS
>(nothing prevents using notepad) but I sure wouldn't want to try.
>Bruce L-C
>"Bradley Plett" <plettb@.hotmail.com> wrote in message
>news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
>> With the current version of SQL RS, the report designer is integrated
>> with VS. I suppose you could, in theory, build your own RDL file to
>> create reports, but that would be incredibly tedious. I don't think
>> there's any way to build the reports with VB6, and, though there are
>> paid services to do it, there is no easy way to convert CR reports to
>> RS.
>> However, if the public beta is indicative, with SQL 2k5, MS has taken
>> the report designer out and made it a stand-alone app. My impression
>> is that in that scenario you won't need VS.
>> Hope that helps!
>> Brad.
>> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
>> wrote:
>> >Good Morning,
>> >I have a question.
>> >For Use sql reporting services I need on the same server Sql reporting
>> >services and VB .Net?
>> >
>> >Can I use Visual basic 6 or Crystal Report to create a report and only
>than
>> >use Sql Reporting Services to sharing the report?
>> >
>|||I don't have this installed but based on your response here I went to read
the newsgroup for the beta plus read up on SQL 2005. Several points. SQL
Server 2005 says it ships with VS 2005 (since you can now create stored
procedurs using dotnet that makes sense). From someone elses posting on the
beta newsgroup it seems there is something called Business Intelligence
Development Studio. Given the two statements it seems to me that VS 2005 was
installed and then selecting the menu opens it up with that type of project.
Given that the user hasn't purchased the full package then it will only have
a subset of the functionality. If so then it means that for people that
don't have VS 2005 they won't have to spend the $100 getting. But under the
covers it is still VS. I do know that the controls will ship with VS 2005.
I very well could be wrong but I know how MS reuses functionality (like the
query designer) and I feel it is much more likely to be that the VS that
ships with SQL 2005 allows only creating reports, stored procedures and
other database stuff than for it to be something brand new. I bet that in VS
2005 that you will be able to do all of the same things (create reports,
stored procedures etc).
When you said VS integration was that with Widbey? I wouldn't expect it to
work with anything other than Widbey and even there, there could be a
version mismatch due to the beta process. As I said, I find it highly
doubtful that by release it won't be integrateable (is that a word?) with VS
2005.
Thanks for the correction. I haven't been exploring SQL 2005 much yet. The
newsgroup says the new functionality for RS that I do care about (printing
for instance) will be with beta 3.
Bruce L-C
"Bradley Plett" <plettb@.hotmail.com> wrote in message
news:e7mej0ph9f5rho4a1b1ii8ej1vppbqqh9a@.4ax.com...
> Having tried out the public beta of SQL 2k5, I can tell you that there
> is a stand-alone report designer. Furthermore, when I tried to get
> report designer integration into VS, I found (thanks to newsgroup
> postings) that the VS integration was no longer even an option.
> Certainly VS will be useful when creating applications that use the
> new report viewer components, but I haven't been able to get my hands
> on those yet to give them a try. :-)
> Brad.
> On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >About your second statement. I don't think that is the case (not needing
> >VS). The only announcement has been some stand-alone controls that can be
> >used for rendering (winform control and asp.net control). This has
nothing
> >to do with the report designer. I have seen nothing that would indicate
that
> >VS would not be needed to design the report. Think about designing
Winforms,
> >ASP.Net. Writing VB.Net code. All these things can be done without VS
> >(nothing prevents using notepad) but I sure wouldn't want to try.
> >
> >Bruce L-C
> >
> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
> >news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
> >> With the current version of SQL RS, the report designer is integrated
> >> with VS. I suppose you could, in theory, build your own RDL file to
> >> create reports, but that would be incredibly tedious. I don't think
> >> there's any way to build the reports with VB6, and, though there are
> >> paid services to do it, there is no easy way to convert CR reports to
> >> RS.
> >>
> >> However, if the public beta is indicative, with SQL 2k5, MS has taken
> >> the report designer out and made it a stand-alone app. My impression
> >> is that in that scenario you won't need VS.
> >>
> >> Hope that helps!
> >> Brad.
> >>
> >> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
> >> wrote:
> >>
> >> >Good Morning,
> >> >I have a question.
> >> >For Use sql reporting services I need on the same server Sql reporting
> >> >services and VB .Net?
> >> >
> >> >Can I use Visual basic 6 or Crystal Report to create a report and only
> >than
> >> >use Sql Reporting Services to sharing the report?
> >> >
> >>
> >
>|||Yes, "Business Intelligence Development Studio" is the new report
designer. It looks a lot like VS, so I'm sure there's a lot of code
reuse, but it's not VS.
Yes, I was using Whidbey, and there is no integration with RS. Here
are a couple of direct quotes from "someone in the know" (i.e. not me!
:-)
----
RS 2005 does no longer require VS for authoring reports and it will
not install into VS2005. When you install SQL 2005 B2, there is an
option to install the Business Intelligence Development Studio with
Report Designer. Then, under the SQL 2005 menu you should find a
shortcut to start the BI Development Studio.
----
There will be RS WinForm and WebForm client side controls for VS 2005
Beta 2. Sorry, they are not yet available in VS 2005 Beta 1. You can
read about it in the bottom half of this announcement:
http://www.microsoft.com/presspass/press/2004/mar04/03-26MicrosoftOLAPReportPR.asp
----
I agree about Beta 3 - I'm really looking forward to it too, since I'm
hoping a number of the features I desperately need will be there.
Brad.
On Thu, 2 Sep 2004 13:05:58 -0500, "Bruce Loehle-Conger"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>I don't have this installed but based on your response here I went to read
>the newsgroup for the beta plus read up on SQL 2005. Several points. SQL
>Server 2005 says it ships with VS 2005 (since you can now create stored
>procedurs using dotnet that makes sense). From someone elses posting on the
>beta newsgroup it seems there is something called Business Intelligence
>Development Studio. Given the two statements it seems to me that VS 2005 was
>installed and then selecting the menu opens it up with that type of project.
>Given that the user hasn't purchased the full package then it will only have
>a subset of the functionality. If so then it means that for people that
>don't have VS 2005 they won't have to spend the $100 getting. But under the
>covers it is still VS. I do know that the controls will ship with VS 2005.
>I very well could be wrong but I know how MS reuses functionality (like the
>query designer) and I feel it is much more likely to be that the VS that
>ships with SQL 2005 allows only creating reports, stored procedures and
>other database stuff than for it to be something brand new. I bet that in VS
>2005 that you will be able to do all of the same things (create reports,
>stored procedures etc).
>When you said VS integration was that with Widbey? I wouldn't expect it to
>work with anything other than Widbey and even there, there could be a
>version mismatch due to the beta process. As I said, I find it highly
>doubtful that by release it won't be integrateable (is that a word?) with VS
>2005.
>Thanks for the correction. I haven't been exploring SQL 2005 much yet. The
>newsgroup says the new functionality for RS that I do care about (printing
>for instance) will be with beta 3.
>Bruce L-C
>
>"Bradley Plett" <plettb@.hotmail.com> wrote in message
>news:e7mej0ph9f5rho4a1b1ii8ej1vppbqqh9a@.4ax.com...
>> Having tried out the public beta of SQL 2k5, I can tell you that there
>> is a stand-alone report designer. Furthermore, when I tried to get
>> report designer integration into VS, I found (thanks to newsgroup
>> postings) that the VS integration was no longer even an option.
>> Certainly VS will be useful when creating applications that use the
>> new report viewer components, but I haven't been able to get my hands
>> on those yet to give them a try. :-)
>> Brad.
>> On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
>> <bruce_lcNOSPAM@.hotmail.com> wrote:
>> >About your second statement. I don't think that is the case (not needing
>> >VS). The only announcement has been some stand-alone controls that can be
>> >used for rendering (winform control and asp.net control). This has
>nothing
>> >to do with the report designer. I have seen nothing that would indicate
>that
>> >VS would not be needed to design the report. Think about designing
>Winforms,
>> >ASP.Net. Writing VB.Net code. All these things can be done without VS
>> >(nothing prevents using notepad) but I sure wouldn't want to try.
>> >
>> >Bruce L-C
>> >
>> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
>> >news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
>> >> With the current version of SQL RS, the report designer is integrated
>> >> with VS. I suppose you could, in theory, build your own RDL file to
>> >> create reports, but that would be incredibly tedious. I don't think
>> >> there's any way to build the reports with VB6, and, though there are
>> >> paid services to do it, there is no easy way to convert CR reports to
>> >> RS.
>> >>
>> >> However, if the public beta is indicative, with SQL 2k5, MS has taken
>> >> the report designer out and made it a stand-alone app. My impression
>> >> is that in that scenario you won't need VS.
>> >>
>> >> Hope that helps!
>> >> Brad.
>> >>
>> >> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
>> >> wrote:
>> >>
>> >> >Good Morning,
>> >> >I have a question.
>> >> >For Use sql reporting services I need on the same server Sql reporting
>> >> >services and VB .Net?
>> >> >
>> >> >Can I use Visual basic 6 or Crystal Report to create a report and only
>> >than
>> >> >use Sql Reporting Services to sharing the report?
>> >> >
>> >>
>> >
>|||Thank you very much. Very interesting. Looks like I assumed too much.
Well, it better install side by side then with VS2005.
Bruce L-C
"Bradley Plett" <plettb@.hotmail.com> wrote in message
news:6moej0lfsiak5ne60d404afmd5rsj9qr4r@.4ax.com...
> Yes, "Business Intelligence Development Studio" is the new report
> designer. It looks a lot like VS, so I'm sure there's a lot of code
> reuse, but it's not VS.
> Yes, I was using Whidbey, and there is no integration with RS. Here
> are a couple of direct quotes from "someone in the know" (i.e. not me!
> :-)
> ----
> RS 2005 does no longer require VS for authoring reports and it will
> not install into VS2005. When you install SQL 2005 B2, there is an
> option to install the Business Intelligence Development Studio with
> Report Designer. Then, under the SQL 2005 menu you should find a
> shortcut to start the BI Development Studio.
> ----
> There will be RS WinForm and WebForm client side controls for VS 2005
> Beta 2. Sorry, they are not yet available in VS 2005 Beta 1. You can
> read about it in the bottom half of this announcement:
>
http://www.microsoft.com/presspass/press/2004/mar04/03-26MicrosoftOLAPReportPR.asp
> ----
> I agree about Beta 3 - I'm really looking forward to it too, since I'm
> hoping a number of the features I desperately need will be there.
> Brad.
>
> On Thu, 2 Sep 2004 13:05:58 -0500, "Bruce Loehle-Conger"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >I don't have this installed but based on your response here I went to
read
> >the newsgroup for the beta plus read up on SQL 2005. Several points. SQL
> >Server 2005 says it ships with VS 2005 (since you can now create stored
> >procedurs using dotnet that makes sense). From someone elses posting on
the
> >beta newsgroup it seems there is something called Business Intelligence
> >Development Studio. Given the two statements it seems to me that VS 2005
was
> >installed and then selecting the menu opens it up with that type of
project.
> >Given that the user hasn't purchased the full package then it will only
have
> >a subset of the functionality. If so then it means that for people that
> >don't have VS 2005 they won't have to spend the $100 getting. But under
the
> >covers it is still VS. I do know that the controls will ship with VS
2005.
> >
> >I very well could be wrong but I know how MS reuses functionality (like
the
> >query designer) and I feel it is much more likely to be that the VS that
> >ships with SQL 2005 allows only creating reports, stored procedures and
> >other database stuff than for it to be something brand new. I bet that in
VS
> >2005 that you will be able to do all of the same things (create reports,
> >stored procedures etc).
> >
> >When you said VS integration was that with Widbey? I wouldn't expect it
to
> >work with anything other than Widbey and even there, there could be a
> >version mismatch due to the beta process. As I said, I find it highly
> >doubtful that by release it won't be integrateable (is that a word?) with
VS
> >2005.
> >
> >Thanks for the correction. I haven't been exploring SQL 2005 much yet.
The
> >newsgroup says the new functionality for RS that I do care about
(printing
> >for instance) will be with beta 3.
> >
> >Bruce L-C
> >
> >
> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
> >news:e7mej0ph9f5rho4a1b1ii8ej1vppbqqh9a@.4ax.com...
> >> Having tried out the public beta of SQL 2k5, I can tell you that there
> >> is a stand-alone report designer. Furthermore, when I tried to get
> >> report designer integration into VS, I found (thanks to newsgroup
> >> postings) that the VS integration was no longer even an option.
> >>
> >> Certainly VS will be useful when creating applications that use the
> >> new report viewer components, but I haven't been able to get my hands
> >> on those yet to give them a try. :-)
> >>
> >> Brad.
> >>
> >> On Thu, 2 Sep 2004 10:22:21 -0500, "Bruce Loehle-Conger"
> >> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >>
> >> >About your second statement. I don't think that is the case (not
needing
> >> >VS). The only announcement has been some stand-alone controls that can
be
> >> >used for rendering (winform control and asp.net control). This has
> >nothing
> >> >to do with the report designer. I have seen nothing that would
indicate
> >that
> >> >VS would not be needed to design the report. Think about designing
> >Winforms,
> >> >ASP.Net. Writing VB.Net code. All these things can be done without VS
> >> >(nothing prevents using notepad) but I sure wouldn't want to try.
> >> >
> >> >Bruce L-C
> >> >
> >> >"Bradley Plett" <plettb@.hotmail.com> wrote in message
> >> >news:ivdej01sjfarrdg2u2rcpjcq3d7h0r0vb4@.4ax.com...
> >> >> With the current version of SQL RS, the report designer is
integrated
> >> >> with VS. I suppose you could, in theory, build your own RDL file to
> >> >> create reports, but that would be incredibly tedious. I don't think
> >> >> there's any way to build the reports with VB6, and, though there are
> >> >> paid services to do it, there is no easy way to convert CR reports
to
> >> >> RS.
> >> >>
> >> >> However, if the public beta is indicative, with SQL 2k5, MS has
taken
> >> >> the report designer out and made it a stand-alone app. My
impression
> >> >> is that in that scenario you won't need VS.
> >> >>
> >> >> Hope that helps!
> >> >> Brad.
> >> >>
> >> >> On Thu, 02 Sep 2004 10:51:40 GMT, "Killer" <roninkaiser@.tiscali.it>
> >> >> wrote:
> >> >>
> >> >> >Good Morning,
> >> >> >I have a question.
> >> >> >For Use sql reporting services I need on the same server Sql
reporting
> >> >> >services and VB .Net?
> >> >> >
> >> >> >Can I use Visual basic 6 or Crystal Report to create a report and
only
> >> >than
> >> >> >use Sql Reporting Services to sharing the report?
> >> >> >
> >> >>
> >> >
> >>
> >
>

Indicator non aggregate

Hi everybody,

I'm working on SQL Server 2005 & Reporting services to create a Projet model to deploy it on the server.

To explain me, i 'll recreate simply my problem on the the database "AdventureWorksDW".

I woudl like to see information on my product dimension.

In a matrix tab, i put "Product name" in row value and "customer name" on column.

I would naturally know the "Sales Amount" for my product by customers.

But, as i had not create aggregate, i can't put my numerique value on the cells indicators. It just allowed me to put the SUM(SALES_AMOUNT) by exemple, but it's not what i want.

How can i put my numerique value in this case ?

Regards,

Erwan

Toulouse, France

Have a column called count on the fact table.

Have the value 1 in the column

Sum the column

|||

The probleme is that i dont want the sum of my value, in just want the pure value.

It is possible ?

Erwan

|||

The whole point of a matrix is that it aggregates the data.

Otherwise it would be a table.

In analysis services, you can drillthrough to the underlying data in the fact table. You would need to post on that forum to find out how.

|||

it's ok, i had just execute my request to blind total.

Thanks adolf

sql

Indexing

Hi!!
I dont know if this is the correct forum for this or not, but still...
Actually i wanted to know some details about SQl's Indexing services.

I found this link on my hosters help pages :

You need to use SQL Query Analyzer tool for this.

This will enable full-text indexing for the current database:
exec sp_fulltext_database 'enable'

This creates a catalog:
exec sp_fulltext_catalog 'catalogname', 'create'

This enables indexing of a table:
exec sp_fulltext_table 'tablename', 'create',
'catalogname', 'indexname'

This adds a column to an index:
exec sp_fulltext_column 'tablename', 'columnname', 'add'

This activates fulltext on a table:
exec sp_fulltext_table 'tablename', 'activate'

These two enable automatic filling of the full-text index when changes occur to a table:
exec sp_fulltext_table 'tablename',
'start_change_tracking'
exec sp_fulltext_table 'tablename',
'start_background_updateindex'

From the above i get that i need to set up my database for indexing then make a catalog and then add an index of a table to this catalog. Can anyone point any good tutorials for using this is the proper way so that performance is not affected and tells me details on updating indexes etc(esp using some criterias). Moreover does indexing columns lower the performance? Is there a workaround? I am completely new to this.

Try these:
http://www.sqlteam.com/item.asp?ItemID=114
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_fullad_3bs2.asp
http://developer.com/db/article.php/3446891