Dear all...
need your help... i am now trying to create a report using SQL reporting services... when declare all the @.parameters needed in where clause, i have come across a problem. where one of the parameters that prompting user to key in...i need to put in some condition.
select..............(blah blah).....
.....(SELECT CASE WHEN
((SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID)) = 1 THEN 0 ELSE 1 END) AS PTType .....................(blah blah)......
where (CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate) OR (@.FromDate = ' ') OR (@.ToDate = ' ')
AND (@.PatientType = CASE WHEN
(SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0 ELSE 1 END)
my situition is something like above, i know i have done something wrong in teh WHERE clause for the @.PatientType... can i ask how to restrict the parameters entered by user, let's say if user enter parameter "0", then the visitcount is 1, if enter "1" then the visit count refers to more than 1...
thanks in advanced ...............Your post is kind of confusing regarding requirements, but part of your problem may be due to using brackets where they are not necessary, and not using them where they might be necessary to specify logical operations.
--Your Version:
where (CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate)
OR (@.FromDate = ' ')
OR (@.ToDate = ' ')
AND (@.PatientType = CASE
WHEN (SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0
ELSE 1
END)
--Unnecessary brackets removed:
where CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate
OR @.FromDate = ' '
OR @.ToDate = ' '
AND @.PatientType = CASE
WHEN (SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0
ELSE 1
END
--Useful brackets added:
where (CONVERT(Varchar(10), tbl_OutpatientReg.VisitDatetime, 103) BETWEEN @.FromDate AND @.ToDate
OR @.FromDate = ' '
OR @.ToDate = ' ')
AND @.PatientType = CASE
WHEN (SELECT COUNT(*)
FROM tbl_OutpatientReg OPT
WHERE OPT.PatientID = tbl_Patient.PatientID) = 1 THEN 0
ELSE 1
END|||ya...thanks for reminding me...as there are too many parameters to pass, i also confused... ;) anyway, really appreciate ur help
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Friday, March 30, 2012
Is it possible to publish subscriptions to Reporting Services?
Is there anything in the API that would support this, or would it have to be
done surreptitiously in the database?
Thanks,
Bill MellYes it is possible . . . using the CreateSubscription method.
(just in case anyone cares)
Bill Mell
"Bill Mell" <BillM@.netforcement.com> wrote in message
news:%23sRXzT0DIHA.1316@.TK2MSFTNGP02.phx.gbl...
> Is there anything in the API that would support this, or would it have to
be
> done surreptitiously in the database?
> Thanks,
> Bill Mell
>sql
done surreptitiously in the database?
Thanks,
Bill MellYes it is possible . . . using the CreateSubscription method.
(just in case anyone cares)
Bill Mell
"Bill Mell" <BillM@.netforcement.com> wrote in message
news:%23sRXzT0DIHA.1316@.TK2MSFTNGP02.phx.gbl...
> Is there anything in the API that would support this, or would it have to
be
> done surreptitiously in the database?
> Thanks,
> Bill Mell
>sql
Wednesday, March 28, 2012
Is it possible to localize Report Manager using satellite assembly
Hi,
I'm trying to localize Report Manager (Reporting Services 2005) by
implementing my own Finnish version of the resources in
ReportingServicesWebUserInterface.dll assembly.
I have the satellite assembly in the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting
Services\ReportManager\Bin\fi
I used the Assembly Linker tool (al) to create the assembly and used the
ReportingServicesWebUserInterface.dll in the base directory as the template.
I tried delay signing the assembly using my own key. Then I used the Strong
Name
Utility (sn) to add the assembly to skip verification list.
For some reason my satellite assembly is not loaded when I set my web
browser language to Finnish. If I set it to German it works ok. I have very
little .NET experience by I suspect that is due to the fact that the
sattelite assembly should be signed with the same key as the base assembly?
So is it possible to implement your own language version of the
ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager?
If it is possible is there any document that describes the process and the
related security issues?
If it's not possible then please tell me so that I can make a decision about
developing a new report portal web application. We would like to use the
Report Manager if we only could localize it.
I tried emailing the Gold Certified Partner support address, but got no
answer. Any assitance will be greatly appreciated.
Thank you,
Juho Salo> I tried emailing the Gold Certified Partner support address, but got no
> answer.
Scractch that. They actually called me instead of emailing, but my phone was
not on, stupid I know. I will post the answer here when I get it.
Juho|||I have received a very decisive answer from Microsoft.
Quote:
"You have asked if it is possible to implement your own language version of
the ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager. Unfortunately, this is NOT possible. The Report
Manager resource assemblies MUST be signed with a Microsoft key."
So if anyone else is wondering, if you need to localize Report Manager
easily it's not possible (unless ofcourse you live in one of those
priviledged countries that are provided with localization for it).
I'm off to writing my own report portal application then.|||I actually came up with a solution that is a bit of a hack but will do nicely
and let's me use the Report Manager. Just add the code below to all of the
aspx pages under the Report Manager\Pages folder
<script language=cs runat=server src= "Dictionary.cs"/>
<script language="C#" runat="server">
void Page_LoadComplete(object sender, EventArgs e) {
TranslateControls(Page);
}
private void TranslateControls(Control c)
{
Type t = c.GetType();
System.Reflection.PropertyInfo p = t.GetProperty("Text");
string s;
if (p != null) {
s = (string) p.GetValue(c, null);
if (s!= null ) {
if (s.Length > 0 ) {
if (p.CanWrite)
{
p.SetValue(c, Dictionary.Translate((string) p.GetValue(c, null)), null);
}
}
}
}
foreach (Control child in c.Controls)
{
TranslateControls(child);
}
}
</script>
Then just create some sort of implementation for the Dictionary class in the
Dictionary.cs file. The code above is not the final version but it works.
Comments are welcome.
I'm trying to localize Report Manager (Reporting Services 2005) by
implementing my own Finnish version of the resources in
ReportingServicesWebUserInterface.dll assembly.
I have the satellite assembly in the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting
Services\ReportManager\Bin\fi
I used the Assembly Linker tool (al) to create the assembly and used the
ReportingServicesWebUserInterface.dll in the base directory as the template.
I tried delay signing the assembly using my own key. Then I used the Strong
Name
Utility (sn) to add the assembly to skip verification list.
For some reason my satellite assembly is not loaded when I set my web
browser language to Finnish. If I set it to German it works ok. I have very
little .NET experience by I suspect that is due to the fact that the
sattelite assembly should be signed with the same key as the base assembly?
So is it possible to implement your own language version of the
ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager?
If it is possible is there any document that describes the process and the
related security issues?
If it's not possible then please tell me so that I can make a decision about
developing a new report portal web application. We would like to use the
Report Manager if we only could localize it.
I tried emailing the Gold Certified Partner support address, but got no
answer. Any assitance will be greatly appreciated.
Thank you,
Juho Salo> I tried emailing the Gold Certified Partner support address, but got no
> answer.
Scractch that. They actually called me instead of emailing, but my phone was
not on, stupid I know. I will post the answer here when I get it.
Juho|||I have received a very decisive answer from Microsoft.
Quote:
"You have asked if it is possible to implement your own language version of
the ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager. Unfortunately, this is NOT possible. The Report
Manager resource assemblies MUST be signed with a Microsoft key."
So if anyone else is wondering, if you need to localize Report Manager
easily it's not possible (unless ofcourse you live in one of those
priviledged countries that are provided with localization for it).
I'm off to writing my own report portal application then.|||I actually came up with a solution that is a bit of a hack but will do nicely
and let's me use the Report Manager. Just add the code below to all of the
aspx pages under the Report Manager\Pages folder
<script language=cs runat=server src= "Dictionary.cs"/>
<script language="C#" runat="server">
void Page_LoadComplete(object sender, EventArgs e) {
TranslateControls(Page);
}
private void TranslateControls(Control c)
{
Type t = c.GetType();
System.Reflection.PropertyInfo p = t.GetProperty("Text");
string s;
if (p != null) {
s = (string) p.GetValue(c, null);
if (s!= null ) {
if (s.Length > 0 ) {
if (p.CanWrite)
{
p.SetValue(c, Dictionary.Translate((string) p.GetValue(c, null)), null);
}
}
}
}
foreach (Control child in c.Controls)
{
TranslateControls(child);
}
}
</script>
Then just create some sort of implementation for the Dictionary class in the
Dictionary.cs file. The code above is not the final version but it works.
Comments are welcome.
Is it possible to launch a report rendered in excel or pdf instead of report viewer?
On my reporting services website, I would like to browse to a report,
click on it and have it render to excel or pdf by instead of report
viewer. Is this possible? I know that I can create rs scripts that run
a report and render to excel, but would like to users to experience
this on the web if possible. I couldn't find this option.you can try to send the format you want in the URL:
http://localhost/......&rs:Format=Excel
"steve" <stevensherman@.comcast.net> wrote in message
news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> On my reporting services website, I would like to browse to a report,
> click on it and have it render to excel or pdf by instead of report
> viewer. Is this possible? I know that I can create rs scripts that run
> a report and render to excel, but would like to users to experience
> this on the web if possible. I couldn't find this option.
>|||Putting the format in the url works nicely. Thanks for the reply - that
helps. I was hoping that the report manager would have a configuration
setting for a report that would indicate how to render it.
Jeje wrote:
> you can try to send the format you want in the URL:
> http://localhost/......&rs:Format=Excel
>
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> > On my reporting services website, I would like to browse to a report,
> > click on it and have it render to excel or pdf by instead of report
> > viewer. Is this possible? I know that I can create rs scripts that run
> > a report and render to excel, but would like to users to experience
> > this on the web if possible. I couldn't find this option.
> >|||I'm not sure, maybe you'll found in the config files of your reporting
services installation the default rendering format.
I'm sure there is a list of authorized formats, so I presume there is a
default rendering option.
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>|||Report manager is not configurable that way. You have to create your own
portal if you want to do that. I recommend against doing this. HTML is much
much faster and having all your reports default to PDF is just not a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>sql
click on it and have it render to excel or pdf by instead of report
viewer. Is this possible? I know that I can create rs scripts that run
a report and render to excel, but would like to users to experience
this on the web if possible. I couldn't find this option.you can try to send the format you want in the URL:
http://localhost/......&rs:Format=Excel
"steve" <stevensherman@.comcast.net> wrote in message
news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> On my reporting services website, I would like to browse to a report,
> click on it and have it render to excel or pdf by instead of report
> viewer. Is this possible? I know that I can create rs scripts that run
> a report and render to excel, but would like to users to experience
> this on the web if possible. I couldn't find this option.
>|||Putting the format in the url works nicely. Thanks for the reply - that
helps. I was hoping that the report manager would have a configuration
setting for a report that would indicate how to render it.
Jeje wrote:
> you can try to send the format you want in the URL:
> http://localhost/......&rs:Format=Excel
>
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> > On my reporting services website, I would like to browse to a report,
> > click on it and have it render to excel or pdf by instead of report
> > viewer. Is this possible? I know that I can create rs scripts that run
> > a report and render to excel, but would like to users to experience
> > this on the web if possible. I couldn't find this option.
> >|||I'm not sure, maybe you'll found in the config files of your reporting
services installation the default rendering format.
I'm sure there is a list of authorized formats, so I presume there is a
default rendering option.
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>|||Report manager is not configurable that way. You have to create your own
portal if you want to do that. I recommend against doing this. HTML is much
much faster and having all your reports default to PDF is just not a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>sql
Is it possible to install SQL Sever 2005 Developer on Vista Home Premium?
During the install, I receive this message:
Here's a link that should help: http://support.microsoft.com/kb/920201
I was experiencing the same problem. In my case, I did not have Windows Authentication selected when I installed IIS. When I added it, the warning went away.
|||Thanks. I'll try it with Windows Authentication selected.Monday, March 26, 2012
Is it possible to hide the report parameters after click on the view report button?
i am working in SQL Reporting services 2005. i had a requirement that
after selecting all the report paramters and click on the view report
button, i need to turn off or hide the report parameters.
please let me know is it possible to implement to do this.
any suggesstion
Thanks
VinodThere is a button the right side of the page of the reports browser
that look like to arrows on top of each other, click that and it will
hide the parameters. There are actually two sets, one for the
parameters and one for the web page header. Hope that helps.
Vinod wrote:
> i am working in SQL Reporting services 2005. i had a requirement that
> after selecting all the report paramters and click on the view report
> button, i need to turn off or hide the report parameters.
> please let me know is it possible to implement to do this.
> any suggesstion
> Thanks
> Vinod|||Thanks for the reply Kerrie.
i have seen the hide button icon in the report layout.but my
requirement is that i need to hide the parameters when i click on the
view report button in the report layout after selecting the all the
report parameters.
if user wants to modify the criteria again, he needs to click on the
hide icon in the report layout. then select the criteria and view the
report.
please let me know if you are not clear
Thanks
vinod
Kerrie wrote:
> There is a button the right side of the page of the reports browser
> that look like to arrows on top of each other, click that and it will
> hide the parameters. There are actually two sets, one for the
> parameters and one for the web page header. Hope that helps.
>
> Vinod wrote:
> > i am working in SQL Reporting services 2005. i had a requirement that
> > after selecting all the report paramters and click on the view report
> > button, i need to turn off or hide the report parameters.
> >
> > please let me know is it possible to implement to do this.
> >
> > any suggesstion
> >
> > Thanks
> > Vinod|||I'm pretty sure there's no function like that in RS out of the box. But I'm
thinking that if you can modify the View Report button's code, you could add
a java script that redirects to a url with parameters toolbar=false and the
chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
how easy that is.
Alternatively, create a aspx. page that creates the parameters to be chosen,
and send the users to a report using the same paramtererized url as
suggested above.
Kaisa M. Lindahl Lervik
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> Thanks for the reply Kerrie.
> i have seen the hide button icon in the report layout.but my
> requirement is that i need to hide the parameters when i click on the
> view report button in the report layout after selecting the all the
> report parameters.
> if user wants to modify the criteria again, he needs to click on the
> hide icon in the report layout. then select the criteria and view the
> report.
> please let me know if you are not clear
> Thanks
> vinod
>
> Kerrie wrote:
>> There is a button the right side of the page of the reports browser
>> that look like to arrows on top of each other, click that and it will
>> hide the parameters. There are actually two sets, one for the
>> parameters and one for the web page header. Hope that helps.
>>
>> Vinod wrote:
>> > i am working in SQL Reporting services 2005. i had a requirement that
>> > after selecting all the report paramters and click on the view report
>> > button, i need to turn off or hide the report parameters.
>> >
>> > please let me know is it possible to implement to do this.
>> >
>> > any suggesstion
>> >
>> > Thanks
>> > Vinod
>|||Thanks for the reply Kaisa.
i am not creating a aspx page for criteria. i have added 15 report
parameters in the report layout iteself. everything is fine upto this
point.
but my client requriment is that we dont want to show the report
parameters in the report layout after clicking on the view report
button. it should be hided.
let me know is it possible.
Thanks
Vinod
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure there's no function like that in RS out of the box. But I'm
> thinking that if you can modify the View Report button's code, you could add
> a java script that redirects to a url with parameters toolbar=false and the
> chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
> how easy that is.
> Alternatively, create a aspx. page that creates the parameters to be chosen,
> and send the users to a report using the same paramtererized url as
> suggested above.
> Kaisa M. Lindahl Lervik
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> > Thanks for the reply Kerrie.
> >
> > i have seen the hide button icon in the report layout.but my
> > requirement is that i need to hide the parameters when i click on the
> > view report button in the report layout after selecting the all the
> > report parameters.
> >
> > if user wants to modify the criteria again, he needs to click on the
> > hide icon in the report layout. then select the criteria and view the
> > report.
> >
> > please let me know if you are not clear
> >
> > Thanks
> > vinod
> >
> >
> > Kerrie wrote:
> >> There is a button the right side of the page of the reports browser
> >> that look like to arrows on top of each other, click that and it will
> >> hide the parameters. There are actually two sets, one for the
> >> parameters and one for the web page header. Hope that helps.
> >>
> >>
> >> Vinod wrote:
> >> > i am working in SQL Reporting services 2005. i had a requirement that
> >> > after selecting all the report paramters and click on the view report
> >> > button, i need to turn off or hide the report parameters.
> >> >
> >> > please let me know is it possible to implement to do this.
> >> >
> >> > any suggesstion
> >> >
> >> > Thanks
> >> > Vinod
> >
after selecting all the report paramters and click on the view report
button, i need to turn off or hide the report parameters.
please let me know is it possible to implement to do this.
any suggesstion
Thanks
VinodThere is a button the right side of the page of the reports browser
that look like to arrows on top of each other, click that and it will
hide the parameters. There are actually two sets, one for the
parameters and one for the web page header. Hope that helps.
Vinod wrote:
> i am working in SQL Reporting services 2005. i had a requirement that
> after selecting all the report paramters and click on the view report
> button, i need to turn off or hide the report parameters.
> please let me know is it possible to implement to do this.
> any suggesstion
> Thanks
> Vinod|||Thanks for the reply Kerrie.
i have seen the hide button icon in the report layout.but my
requirement is that i need to hide the parameters when i click on the
view report button in the report layout after selecting the all the
report parameters.
if user wants to modify the criteria again, he needs to click on the
hide icon in the report layout. then select the criteria and view the
report.
please let me know if you are not clear
Thanks
vinod
Kerrie wrote:
> There is a button the right side of the page of the reports browser
> that look like to arrows on top of each other, click that and it will
> hide the parameters. There are actually two sets, one for the
> parameters and one for the web page header. Hope that helps.
>
> Vinod wrote:
> > i am working in SQL Reporting services 2005. i had a requirement that
> > after selecting all the report paramters and click on the view report
> > button, i need to turn off or hide the report parameters.
> >
> > please let me know is it possible to implement to do this.
> >
> > any suggesstion
> >
> > Thanks
> > Vinod|||I'm pretty sure there's no function like that in RS out of the box. But I'm
thinking that if you can modify the View Report button's code, you could add
a java script that redirects to a url with parameters toolbar=false and the
chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
how easy that is.
Alternatively, create a aspx. page that creates the parameters to be chosen,
and send the users to a report using the same paramtererized url as
suggested above.
Kaisa M. Lindahl Lervik
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> Thanks for the reply Kerrie.
> i have seen the hide button icon in the report layout.but my
> requirement is that i need to hide the parameters when i click on the
> view report button in the report layout after selecting the all the
> report parameters.
> if user wants to modify the criteria again, he needs to click on the
> hide icon in the report layout. then select the criteria and view the
> report.
> please let me know if you are not clear
> Thanks
> vinod
>
> Kerrie wrote:
>> There is a button the right side of the page of the reports browser
>> that look like to arrows on top of each other, click that and it will
>> hide the parameters. There are actually two sets, one for the
>> parameters and one for the web page header. Hope that helps.
>>
>> Vinod wrote:
>> > i am working in SQL Reporting services 2005. i had a requirement that
>> > after selecting all the report paramters and click on the view report
>> > button, i need to turn off or hide the report parameters.
>> >
>> > please let me know is it possible to implement to do this.
>> >
>> > any suggesstion
>> >
>> > Thanks
>> > Vinod
>|||Thanks for the reply Kaisa.
i am not creating a aspx page for criteria. i have added 15 report
parameters in the report layout iteself. everything is fine upto this
point.
but my client requriment is that we dont want to show the report
parameters in the report layout after clicking on the view report
button. it should be hided.
let me know is it possible.
Thanks
Vinod
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure there's no function like that in RS out of the box. But I'm
> thinking that if you can modify the View Report button's code, you could add
> a java script that redirects to a url with parameters toolbar=false and the
> chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
> how easy that is.
> Alternatively, create a aspx. page that creates the parameters to be chosen,
> and send the users to a report using the same paramtererized url as
> suggested above.
> Kaisa M. Lindahl Lervik
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> > Thanks for the reply Kerrie.
> >
> > i have seen the hide button icon in the report layout.but my
> > requirement is that i need to hide the parameters when i click on the
> > view report button in the report layout after selecting the all the
> > report parameters.
> >
> > if user wants to modify the criteria again, he needs to click on the
> > hide icon in the report layout. then select the criteria and view the
> > report.
> >
> > please let me know if you are not clear
> >
> > Thanks
> > vinod
> >
> >
> > Kerrie wrote:
> >> There is a button the right side of the page of the reports browser
> >> that look like to arrows on top of each other, click that and it will
> >> hide the parameters. There are actually two sets, one for the
> >> parameters and one for the web page header. Hope that helps.
> >>
> >>
> >> Vinod wrote:
> >> > i am working in SQL Reporting services 2005. i had a requirement that
> >> > after selecting all the report paramters and click on the view report
> >> > button, i need to turn off or hide the report parameters.
> >> >
> >> > please let me know is it possible to implement to do this.
> >> >
> >> > any suggesstion
> >> >
> >> > Thanks
> >> > Vinod
> >
Is it possible to have reporting services without IIS?
Is it possible to have SQL Express and Reporting Services on XP Home and use
reports locally (like Access)?
ThxOn Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
As far as I know, there is not. That said, I'm not sure how SSRS would
react if you somehow tried to tie it to Apache or some other web
server. Sorry that I could not offer further insight.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, Enrique
I guess same applies to Advanced Services
MS, please make this available on XP Home too.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||For development purposes you can install sql2005 dev edition (costs $50 or
comes free with VS2005) and you get all the features.
"AlexS" wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
>
>|||I asked about WinXP Home and SQL Express Advanced / Reporting, which is
available now from MS site for download.
Thanks for a tip - I will check dev edition.
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:9F612C59-BEC7-4854-BF02-C51F8DBFCFD4@.microsoft.com...
> For development purposes you can install sql2005 dev edition (costs $50 or
> comes free with VS2005) and you get all the features.
>
>
> "AlexS" wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>>
>|||On Jun 7, 12:54 pm, "AlexS" <salexru200...@.SPAMrogers.comPLEASE>
wrote:
> Thanks, Enrique
> I guess same applies to Advanced Services
> MS, please make this available on XP Home too.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> > On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> >> Is it possible to have SQL Express and Reporting Services on XP Home and
> >> use
> >> reports locally (like Access)?
> >> Thx
> > As far as I know, there is not. That said, I'm not sure how SSRS would
> > react if you somehow tried to tie it to Apache or some other web
> > server. Sorry that I could not offer further insight.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. SSAS I'm not sure about. Let me know if I can be of
further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It would not work. RS is a asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
reports locally (like Access)?
ThxOn Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
As far as I know, there is not. That said, I'm not sure how SSRS would
react if you somehow tried to tie it to Apache or some other web
server. Sorry that I could not offer further insight.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, Enrique
I guess same applies to Advanced Services
MS, please make this available on XP Home too.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||For development purposes you can install sql2005 dev edition (costs $50 or
comes free with VS2005) and you get all the features.
"AlexS" wrote:
> Is it possible to have SQL Express and Reporting Services on XP Home and use
> reports locally (like Access)?
> Thx
>
>|||I asked about WinXP Home and SQL Express Advanced / Reporting, which is
available now from MS site for download.
Thanks for a tip - I will check dev edition.
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:9F612C59-BEC7-4854-BF02-C51F8DBFCFD4@.microsoft.com...
> For development purposes you can install sql2005 dev edition (costs $50 or
> comes free with VS2005) and you get all the features.
>
>
> "AlexS" wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>>
>|||On Jun 7, 12:54 pm, "AlexS" <salexru200...@.SPAMrogers.comPLEASE>
wrote:
> Thanks, Enrique
> I guess same applies to Advanced Services
> MS, please make this available on XP Home too.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> > On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
> >> Is it possible to have SQL Express and Reporting Services on XP Home and
> >> use
> >> reports locally (like Access)?
> >> Thx
> > As far as I know, there is not. That said, I'm not sure how SSRS would
> > react if you somehow tried to tie it to Apache or some other web
> > server. Sorry that I could not offer further insight.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. SSAS I'm not sure about. Let me know if I can be of
further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It would not work. RS is a asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181237578.827513.103640@.q75g2000hsh.googlegroups.com...
> On Jun 7, 8:54 am, "AlexS" <salexru200...@.SPAMrogers.comPLEASE> wrote:
>> Is it possible to have SQL Express and Reporting Services on XP Home and
>> use
>> reports locally (like Access)?
>> Thx
>
> As far as I know, there is not. That said, I'm not sure how SSRS would
> react if you somehow tried to tie it to Apache or some other web
> server. Sorry that I could not offer further insight.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Is it possible to get Multiple DataTables in a DataSet like VB.NET?
Hello
My stored procedure returns 4 recordsets. I require these recordsets as 4 different datatables in a dataset in Sql Server Reporting Services 2005, to use them on my rdl report.
I don't want to make the 4 diffrent datasets. Is it possible in SqlServer Reporting Services 2005? Please help me. Its urgent.
SSRS uses the first resultset returned from a stored procedure only.|||Thanx for the reply. But is there some way I can get all these recordsets. I have heard about Custom Data Extensions. Do these extensions help me in my problem. Or any other solution, other than data extension, if possible.|||Well, I think nobody here is interested to answer this one. Do anyone suggest me any good forum for Reporting services queries.
Looking.
|||I won't suggest you write a custom data extension just for this. Instead, if possible, I will consider wrapping up the stored procedure inside another stored procedure which will return the requested dataset.sqlIs it possible to get Multiple DataTables in a DataSet like VB.NET?
Hello
My stored procedure returns 4 recordsets. I require these recordsets as 4 different datatables in a dataset in Sql Server Reporting Services 2005, to use them on my rdl report.
I don't want to make the 4 diffrent datasets. Is it possible in SqlServer Reporting Services 2005? Please help me. Its urgent.
SSRS uses the first resultset returned from a stored procedure only.|||Thanx for the reply. But is there some way I can get all these recordsets. I have heard about Custom Data Extensions. Do these extensions help me in my problem. Or any other solution, other than data extension, if possible.|||Well, I think nobody here is interested to answer this one. Do anyone suggest me any good forum for Reporting services queries.
Looking.
|||I won't suggest you write a custom data extension just for this. Instead, if possible, I will consider wrapping up the stored procedure inside another stored procedure which will return the requested dataset.Friday, March 23, 2012
Is it possible to extract RS installation credentials
Have spent quite some time setting up an eval version of RS featuring
access to both an SQL Server and Analysis Services. Eventually i got it
running smooth. The issues where setting the accounts during
installation of RS in a combination that worked for my situation.
Now the problem: RS eval expired so i am not able to inspect any
settings and the RSReportServer.config file has encrypted values and
the rsconfig utility can only set values in the config file. Moment 22.
Is there anyway i can extract installation settings from the config
file so i can repeat the installation with a licensed version of RS?
No.
Only what you can see in the config files. The encrypted content is not accessible.
If you want to know the service accounts, check the Windows and Web services through the service control panel applet or through the IIS Manager plugin.
sqlIs it possible to edit the list of export options in RS 2000?
Hi,
I'm trying to edit the list of export options in Reporting Services 2000. I only want to display Excel and PDF in the export options list. I tried looking in the CSS file in the Styles folder, but didn't see anything that could be changed to accomplish this. Is it possible to do this?
Thanks,
Mike
Look in the RSReportSErver.config file. Add visible="false" to any rendering extensions you do not want to show up. You can also just remove them if you don't ever want people to use them (Although getting rid of html4.0 would break Report Manager.)|||Excellent! Thanks.Wednesday, March 21, 2012
Is it possible to custom format the parameter dropdownlist?
I have a reporting services 2000 report that has only one string report
parameter with a prompt 'Select a Project'. The project list contains
project names that are so long that they take up about 95% of the page
width and the View report button becomes a partially visible button
with a horizontal scroll bar to scroll further to the right to view the
entire page.
My users hate to have to scroll to the right. They are requesting a
fixed width dropdownlist with fully visible 'View report' button.
We want to make our DDL pretty narrow so that it only shows the first n
characters of the project name string when the DDL is not dropped down.
When the user
drops the list down we want to resize it wide enough to show the entire
string.
We could also assign a tool tip to the DDL if we could supply a unique
tip
to each row in the DDL?
Any ideas? Does SSRS 2005 let the designer specify the parameter
control width?
Many thanks in advance.I've found that the parameter panel is not at all configurable and have
been creating a front-end web page for each report giving me total
control over presentation. Then I hide the parameter panel via a
parameter on the URL. It's my understanding RS 2005 has more control
over the parameter panel.|||Many thanks, Kent.
parameter with a prompt 'Select a Project'. The project list contains
project names that are so long that they take up about 95% of the page
width and the View report button becomes a partially visible button
with a horizontal scroll bar to scroll further to the right to view the
entire page.
My users hate to have to scroll to the right. They are requesting a
fixed width dropdownlist with fully visible 'View report' button.
We want to make our DDL pretty narrow so that it only shows the first n
characters of the project name string when the DDL is not dropped down.
When the user
drops the list down we want to resize it wide enough to show the entire
string.
We could also assign a tool tip to the DDL if we could supply a unique
tip
to each row in the DDL?
Any ideas? Does SSRS 2005 let the designer specify the parameter
control width?
Many thanks in advance.I've found that the parameter panel is not at all configurable and have
been creating a front-end web page for each report giving me total
control over presentation. Then I hide the parameter panel via a
parameter on the URL. It's my understanding RS 2005 has more control
over the parameter panel.|||Many thanks, Kent.
Is it possible to create some kind of "libraries"?
Hi,
I want to reuse parts of my last report in a new one -
is it possible to create some kind of "libraries" (or templates) in
Reporting Services?
Thanks.Now you can create your custom Report Templates, and keep it in managed code
and reuse it!, in this example will show you, how to sub-class
the Report Class and create your report templates for further reuse.
http://www.rdlcomponents.com/examples/inherited/inherited.aspx
Thanks
Jerry
"Hawkeye" wrote:
> Hi,
> I want to reuse parts of my last report in a new one -
> is it possible to create some kind of "libraries" (or templates) in
> Reporting Services?
> Thanks.
>
I want to reuse parts of my last report in a new one -
is it possible to create some kind of "libraries" (or templates) in
Reporting Services?
Thanks.Now you can create your custom Report Templates, and keep it in managed code
and reuse it!, in this example will show you, how to sub-class
the Report Class and create your report templates for further reuse.
http://www.rdlcomponents.com/examples/inherited/inherited.aspx
Thanks
Jerry
"Hawkeye" wrote:
> Hi,
> I want to reuse parts of my last report in a new one -
> is it possible to create some kind of "libraries" (or templates) in
> Reporting Services?
> Thanks.
>
Is it possible to create dynamic reports using reporting services
I have a requirement to create dynamic reports for my client.
once i create these reports then the user will choose columns of there choice.
so the columns may belong to multiple tables.
Now the report should get generated with the layout etc. is it possible.
since our project is totally on the webserver(webbased.)
please if you can provide me with any links with dynamic report creation wizards.
and also we only use Stored procedures via database.
which is best is writing the entire queries right behind the layouit or calling the entire logic via Stored procedure. i am a bit confused. this is my first project working on reports itself.
Thank you all for the helpful information.
Sounds like you need to generate the report definitions programatically. The RDL Object Model code sample in this download should help.sqlIs it possible to create cube file without Microsoft Analysis Services
Can I create a cube file, .cub ,without the Microsoft Analysis Services
Pls Guide me as I am new in this field.
Thanks
LoydI think that other products (Cognos, MicroStrategy, possibly others) may let you do this, but I am not certain.
I do know that MS Excel will let you OPEN a .CUB file, but you can't create a .CUB file.
Regards,
hmscott
Can I create a cube file, .cub ,without the Microsoft Analysis Services
Pls Guide me as I am new in this field.
Thanks
Loyd|||Hi Loyd you can create a .cub file using MSQuery in presnt in MS office.
What do you intend to use it for??
Try and let me know.
Regards,
Hemanrh|||You can create .cub file with MS excel bat you need anyway Analysis Services to do it.
I don't know any other programs
Pls Guide me as I am new in this field.
Thanks
LoydI think that other products (Cognos, MicroStrategy, possibly others) may let you do this, but I am not certain.
I do know that MS Excel will let you OPEN a .CUB file, but you can't create a .CUB file.
Regards,
hmscott
Can I create a cube file, .cub ,without the Microsoft Analysis Services
Pls Guide me as I am new in this field.
Thanks
Loyd|||Hi Loyd you can create a .cub file using MSQuery in presnt in MS office.
What do you intend to use it for??
Try and let me know.
Regards,
Hemanrh|||You can create .cub file with MS excel bat you need anyway Analysis Services to do it.
I don't know any other programs
Monday, March 12, 2012
Is it possible that I change the data's type when I create the DSV in the Visual Studio 2005?
Hello everyone:
Recently, I was responsible for creating a analysis services project with the SQL Server Business Intelligence Development Studio in Visual studio 2005. I encountered a error that the data type is not supported when I tried to add the table from a remote Oracle server. I can not modify the data type in the oracle server. Is it possible that I change the data's type when I create the DSV in the Visual Studio 2005? (if I have known the table's name)
Help me Please! tell me the steps or some references if it is possible
Thanks
While I don't think you can change the data type of the column within the DSV, what you can do is add a named calculation to the table within the DSV and use a snippet of Oracle to cast the underlying column to whatever data type you want. The new named calculation would then inherit that data type.
For example (using SQL Server here, not Oracle), if I had a table with a column named ZIPCODE of type INT but I wanted to treat the column as VARCHAR within my SSAS solution, I could add a new named calculation to the table within the DSV (right-click on the table in the DSV and select New Named Calculation), call it something like ZIPCODE_STR and then use the T-SQL snippet CONVERT(VARCHAR(10), ZIPCODE). This new column then behaves like any other within the DSV and within the rest of my solution -- and has a datatype of System.String with a length of 10.
HTH,
Dave Fackler
||| Thank you very much
Now I did not install SQL Server 2005 and VS on current computer, I will try it later. I think you suggest is very well. But I have a question: you said I could add a new name calculation to the table within the DSV. Does it equal that the table (at least one column's datatype doesn't not match the SSAS's rule) have been added into the DSV?
The problem I encounter is that I can not add that table to the DSV because of the unsuited the datatype for the column. Is there any other suggestion to me?
Thanks^_^
|||Sorry, I missed the point that you can't add the table to the DSV because of the data type...
In that case, instead of adding a named calculation to the table (as you are correct in thinking that the table must be present within the DSV to do this), add a named query instead. Just right-click on the design surface of the DSV and select New Named Query.
This will bring up a dialog box that you can use to enter any PL/SQL select statement (given you are using Oracle) returning whatever columns (converted to whatever datatypes you need) from one or more tables. Very similar to creating a view in the Oracle database. Just give the named query a name and it will then appear as a table within the DSV. So, in your case, you'd likely want to select all the relevant columns that you need, converting the one with the unsupported datatype to another datatype (just be sure to alias the column once you convert it as a named query must return named columns so that the DSV can understand the metadata returned by the query).
HTH,
Dave Fackler
||| I think this response is I need. Thank~ you very much.
I will try it later.
Thanks^_^
Winnie
Is it possible that I change the data's type when I create the DSV in the Visual Studio 200
Hello everyone:
Recently, I was responsible for creating a analysis services project with the SQL Server Business Intelligence Development Studio in Visual studio 2005. I encountered a error that the data type is not supported when I tried to add the table from a remote Oracle server. I can not modify the data type in the oracle server. Is it possible that I change the data's type when I create the DSV in the Visual Studio 2005? (if I have known the table's name)
Help me Please! tell me the steps or some references if it is possible
Thanks
While I don't think you can change the data type of the column within the DSV, what you can do is add a named calculation to the table within the DSV and use a snippet of Oracle to cast the underlying column to whatever data type you want. The new named calculation would then inherit that data type.
For example (using SQL Server here, not Oracle), if I had a table with a column named ZIPCODE of type INT but I wanted to treat the column as VARCHAR within my SSAS solution, I could add a new named calculation to the table within the DSV (right-click on the table in the DSV and select New Named Calculation), call it something like ZIPCODE_STR and then use the T-SQL snippet CONVERT(VARCHAR(10), ZIPCODE). This new column then behaves like any other within the DSV and within the rest of my solution -- and has a datatype of System.String with a length of 10.
HTH,
Dave Fackler
||| Thank you very much
Now I did not install SQL Server 2005 and VS on current computer, I will try it later. I think you suggest is very well. But I have a question: you said I could add a new name calculation to the table within the DSV. Does it equal that the table (at least one column's datatype doesn't not match the SSAS's rule) have been added into the DSV?
The problem I encounter is that I can not add that table to the DSV because of the unsuited the datatype for the column. Is there any other suggestion to me?
Thanks^_^
|||Sorry, I missed the point that you can't add the table to the DSV because of the data type...
In that case, instead of adding a named calculation to the table (as you are correct in thinking that the table must be present within the DSV to do this), add a named query instead. Just right-click on the design surface of the DSV and select New Named Query.
This will bring up a dialog box that you can use to enter any PL/SQL select statement (given you are using Oracle) returning whatever columns (converted to whatever datatypes you need) from one or more tables. Very similar to creating a view in the Oracle database. Just give the named query a name and it will then appear as a table within the DSV. So, in your case, you'd likely want to select all the relevant columns that you need, converting the one with the unsupported datatype to another datatype (just be sure to alias the column once you convert it as a named query must return named columns so that the DSV can understand the metadata returned by the query).
HTH,
Dave Fackler
||| I think this response is I need. Thank~ you very much.
I will try it later.
Thanks^_^
Winnie
Friday, February 24, 2012
Is Excel really Excel
I have a client who uses Reporting Services for their reports. They
prefer Excel format, but what comes back doesn't seem to be a real Excel
file. It will only load in Office 2003 for the PC, everything else,
including Macs, thinks they are some XML file. For large reports,
several thousands rows that produce 52 MB files, do not load at all and
will cause desktops to crap out. What kind of Excel comes back from RS?Hi,
I think you need to install Service Pack 1 for Reporting services as it
introduces excel export for excel pre Office 2003.
Although Service Pack 2 is out now so you can just install that (it already
contains Service Pack 1).
"No One" wrote:
> I have a client who uses Reporting Services for their reports. They
> prefer Excel format, but what comes back doesn't seem to be a real Excel
> file. It will only load in Office 2003 for the PC, everything else,
> including Macs, thinks they are some XML file. For large reports,
> several thousands rows that produce 52 MB files, do not load at all and
> will cause desktops to crap out. What kind of Excel comes back from RS?
>|||Is this chosen with the same format specifier or a different one?
NH wrote:
> Hi,
> I think you need to install Service Pack 1 for Reporting services as it
> introduces excel export for excel pre Office 2003.
> Although Service Pack 2 is out now so you can just install that (it already
> contains Service Pack 1).
> "No One" wrote:
>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||I dont understand your question.
"No One" wrote:
> Is this chosen with the same format specifier or a different one?
> NH wrote:
> > Hi,
> >
> > I think you need to install Service Pack 1 for Reporting services as it
> > introduces excel export for excel pre Office 2003.
> >
> > Although Service Pack 2 is out now so you can just install that (it already
> > contains Service Pack 1).
> >
> > "No One" wrote:
> >
> >
> >>I have a client who uses Reporting Services for their reports. They
> >>prefer Excel format, but what comes back doesn't seem to be a real Excel
> >>file. It will only load in Office 2003 for the PC, everything else,
> >>including Macs, thinks they are some XML file. For large reports,
> >>several thousands rows that produce 52 MB files, do not load at all and
> >>will cause desktops to crap out. What kind of Excel comes back from RS?
> >>
>|||When you choose Excel prior to the service packs it came out in an XML
format known and supported by Excel. But, it had to be Excel 2003. With the
service pack they went to binary format of Excel which is supported by Excel
2000 and greater. When you select Excel after the service pack is applied
you will get the binary format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"No One" <aintnoway@.blahblahblah.com> wrote in message
news:adbml2-jp9.ln1@.gandalf.grey-net.com...
> Is this chosen with the same format specifier or a different one?
> NH wrote:
>> Hi,
>> I think you need to install Service Pack 1 for Reporting services as it
>> introduces excel export for excel pre Office 2003. Although Service Pack
>> 2 is out now so you can just install that (it already contains Service
>> Pack 1).
>> "No One" wrote:
>>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||Thanks.
Is there anyway to tell if the stream returned in empty?
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>|||It also works in OpenOffice. Very good.
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>
prefer Excel format, but what comes back doesn't seem to be a real Excel
file. It will only load in Office 2003 for the PC, everything else,
including Macs, thinks they are some XML file. For large reports,
several thousands rows that produce 52 MB files, do not load at all and
will cause desktops to crap out. What kind of Excel comes back from RS?Hi,
I think you need to install Service Pack 1 for Reporting services as it
introduces excel export for excel pre Office 2003.
Although Service Pack 2 is out now so you can just install that (it already
contains Service Pack 1).
"No One" wrote:
> I have a client who uses Reporting Services for their reports. They
> prefer Excel format, but what comes back doesn't seem to be a real Excel
> file. It will only load in Office 2003 for the PC, everything else,
> including Macs, thinks they are some XML file. For large reports,
> several thousands rows that produce 52 MB files, do not load at all and
> will cause desktops to crap out. What kind of Excel comes back from RS?
>|||Is this chosen with the same format specifier or a different one?
NH wrote:
> Hi,
> I think you need to install Service Pack 1 for Reporting services as it
> introduces excel export for excel pre Office 2003.
> Although Service Pack 2 is out now so you can just install that (it already
> contains Service Pack 1).
> "No One" wrote:
>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||I dont understand your question.
"No One" wrote:
> Is this chosen with the same format specifier or a different one?
> NH wrote:
> > Hi,
> >
> > I think you need to install Service Pack 1 for Reporting services as it
> > introduces excel export for excel pre Office 2003.
> >
> > Although Service Pack 2 is out now so you can just install that (it already
> > contains Service Pack 1).
> >
> > "No One" wrote:
> >
> >
> >>I have a client who uses Reporting Services for their reports. They
> >>prefer Excel format, but what comes back doesn't seem to be a real Excel
> >>file. It will only load in Office 2003 for the PC, everything else,
> >>including Macs, thinks they are some XML file. For large reports,
> >>several thousands rows that produce 52 MB files, do not load at all and
> >>will cause desktops to crap out. What kind of Excel comes back from RS?
> >>
>|||When you choose Excel prior to the service packs it came out in an XML
format known and supported by Excel. But, it had to be Excel 2003. With the
service pack they went to binary format of Excel which is supported by Excel
2000 and greater. When you select Excel after the service pack is applied
you will get the binary format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"No One" <aintnoway@.blahblahblah.com> wrote in message
news:adbml2-jp9.ln1@.gandalf.grey-net.com...
> Is this chosen with the same format specifier or a different one?
> NH wrote:
>> Hi,
>> I think you need to install Service Pack 1 for Reporting services as it
>> introduces excel export for excel pre Office 2003. Although Service Pack
>> 2 is out now so you can just install that (it already contains Service
>> Pack 1).
>> "No One" wrote:
>>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||Thanks.
Is there anyway to tell if the stream returned in empty?
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>|||It also works in OpenOffice. Very good.
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>
Monday, February 20, 2012
Is Cross-Validation (or Rotation Estimation) available in SQL Server?
Dear forum users,
I am a newbie in using MS SQL server with analysis services.
There seems to be no 'cross-validation' tool in MS SQL
which is frequently used in data mining and even statistics.
Is there anyone having similar difficulties?
Is there any solution like a small scripts to divide
the given dataset with multiple folds?
Your valuable comments and feedbacks would be appreciated.
Minnetongka
We have implemented cross-validation as part of a larger "model evaluation" module on top of the data mining algorithm implementations in SQL-Server 2005 Analysis Services. This is done by implementing sampling on top of the source case/nested tables and then utilizing the Analysis Services APIs (in C#) to train predictive models over training sets and then execute the appropriate prediction join over the testing sets to collect model performance metrics.
We commonly use this "model evaluation" model to automate the process of finding the most accurate predictive models for a given application.
Although we can't make our module publicly available at this time, let me know if you're interested in more information.
Thanks,
- Paul Bradley
Subscribe to:
Posts (Atom)