reporting services valid values query based

I have a parameter that is query based. I have created my own UI to list out
the text boxes per parameter required by the report. Now comes the problem of
a query based parameter. How to I get the queary based valid values to
populate my drop down list boxEddie,
If I understand your correctly I may have some ideas that will help you with
query based Parameters, but first please clarify the reason you built a UI
for users to pass parameters into the report?
thx.
"Eddie" wrote:
> I have a parameter that is query based. I have created my own UI to list out
> the text boxes per parameter required by the report. Now comes the problem of
> a query based parameter. How to I get the queary based valid values to
> populate my drop down list box|||I have several clients that use browsers which the report viewer doesn't
behave well.
I did figure it out. The valid values come back as array when you call the
GetReportParameter method and set the "ForRendering" to TRUE.
So all I did was add the values to ListItems and populated a drop down.
Also, a nifty thing was to find all the Date type parameters and lock the
text box and provide a calendar. This allowed me to use our application's
Localization methods to handle all the different Date formats.
"RS_CZAR" wrote:
> Eddie,
> If I understand your correctly I may have some ideas that will help you with
> query based Parameters, but first please clarify the reason you built a UI
> for users to pass parameters into the report?
> thx.
> "Eddie" wrote:
> > I have a parameter that is query based. I have created my own UI to list out
> > the text boxes per parameter required by the report. Now comes the problem of
> > a query based parameter. How to I get the queary based valid values to
> > populate my drop down list box

Reporting Services Templates

I have been successful in using a Template for my Reports, however if I
decide to change my template after a few reports have been created the old
reports do not 'automatically' pick up the changes to the Template. Is there
a way to 'Refer' to a template as opposed to 'Using' a template? Will this
be available in the next release?I don't know about the next release but with the current release there is no
way to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KDogg" <KDogg@.discussions.microsoft.com> wrote in message
news:983A3BD2-BF11-4FF4-A314-7091DC632F4A@.microsoft.com...
>I have been successful in using a Template for my Reports, however if I
> decide to change my template after a few reports have been created the old
> reports do not 'automatically' pick up the changes to the Template. Is
> there
> a way to 'Refer' to a template as opposed to 'Using' a template? Will
> this
> be available in the next release?|||Thanks Bruce,
Do you know of any way to obtain any information regarding Reporting
Services templates in SQL Server 2005 Beta? We have just started
implementing Reporting Services and if the benefits of SQL2005's
functionality outweigh our options in SQL2000 we can switch as we are just
working on a pilot project for proof of concept.
"Bruce L-C [MVP]" wrote:
> I don't know about the next release but with the current release there is no
> way to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "KDogg" <KDogg@.discussions.microsoft.com> wrote in message
> news:983A3BD2-BF11-4FF4-A314-7091DC632F4A@.microsoft.com...
> >I have been successful in using a Template for my Reports, however if I
> > decide to change my template after a few reports have been created the old
> > reports do not 'automatically' pick up the changes to the Template. Is
> > there
> > a way to 'Refer' to a template as opposed to 'Using' a template? Will
> > this
> > be available in the next release?
>
>

Reporting Services subscriptions

I've created a report and I did subscribe to it using the subscriptions on this report. I get a mail with the data from that report.

So everything works fine but some times the reports results in an empty report because there is nothing. This is correct but then the mail is send anyway.

So I want to prevent that the mail of the subscription is send when the result of the report is empty (recordset of the report returns 0 rows).

Is this posibel and if so how do I do this.

Hi,

Based on my knowledge, I'm afraid you can't achieve that via some built-in options in reporting service.

The email delivering extension service is specially for each requesting to the report database, and send the produced reports to users and groups, the schedule always runs no matter what result it is.

Thanks.

sql

Reporting Services runningValue

I am trying to use the sql reporting services and I cannot figure out how to use scope parameters
I created a report with various information about stores
If a grouping is specified, the running value is reset when the group expression changes.
I have a Group on =Fields!FECHA.Value in the dataset, and I want reset the field!Cost when Field!Fecha change
How change this expressions RunningValue(Fields!Cost.Value, Sum, Nothing) ?
Thank’s
Yovanny Vasquez
User group name, example "GroupDate"
Yovanny Vasquez
"yovys" wrote:

> I am trying to use the sql reporting services and I cannot figure out how to use scope parameters
> I created a report with various information about stores
> If a grouping is specified, the running value is reset when the group expression changes.
> I have a Group on =Fields!FECHA.Value in the dataset, and I want reset the field!Cost when Field!Fecha change
> How change this expressions RunningValue(Fields!Cost.Value, Sum, Nothing) ?
>
> Thank’s
> --
> Yovanny Vasquez

Reporting services question

Hi,
I created aspx page with reprotviewer. Report runs fine and I exported it to excel. (Windows 2000 Professional and MS Office 2002). When I try to open report with excel it gives me "Problem during load" message box with message: "Missing file: c:\styleshe
et.css". When I opened excel file with notepad, I found following line "<link rel=3DStylesheet href=3D"file:///c:\stylesheet.css">". I removed line and when I opened excel file again, file opened without message box.
What should I do to make sure that line mentioned above doesn't appear in file in the first place?
Thanks,
Vcitor
I have to assume that the stylesheet link is being placed in there from =
your aspx page or the report viewer. Can you see any way to not use =
this stylesheet (or any other style sheet for that matter)?
On a side note, I would be interested in seeing the code. I am =
beginning to use Reporting Services and it would be interesting to see =
how you were able to render reports within the web pages using the =
report viewer. Are you willing to post your code here or to a location =
like http://www.gotdotnet.com/ ?
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:84995B62-2670-47E8-B563-9904A0C466DE@.microsoft.com...
> Hi,
>=20
> I created aspx page with reprotviewer. Report runs fine and I exported =
it to excel. (Windows 2000 Professional and MS Office 2002). When I try =
to open report with excel it gives me "Problem during load" message box =
with message: "Missing file: c:\stylesheet.css". When I opened excel =
file with notepad, I found following line "<link rel=3D3DStylesheet =
href=3D3D"file:///c:\stylesheet.css">". I removed line and when I opened =
excel file again, file opened without message box.
> What should I do to make sure that line mentioned above doesn't appear =
in file in the first place?
>=20
> Thanks,
> Vcitor
|||I exported again to excel format and its working fine now. Reporting services have some issues which hopefully will be resolved in Service Pack 1.
Following is C# code which executed in code behind on button click:
protected Microsoft.Samples.ReportingServices.ReportViewer reprotViewer;
private void btnView_Click(object sender, System.EventArgs e){
string _dateFormat = "yyyy-MM-dd";
string _zeroTime = "+00%3a00%3a00";
string _fromDate = Convert.ToDateTime(lblFromDatetxt.Text).ToString(_ dateFormat) + _zeroTime;
string _toDate = Convert.ToDateTime(lblToDatetxt.Text).AddDays(1).T oString(_dateFormat) + _zeroTime;
string _reportName = "";
string _merchant = "";
reprotViewer.Visible = true;
if(ddlCIMSreports.SelectedItem.Text == "Summary"){
_reportName = "SalesSummary";
}
else{
_reportName = "SalesByMerchantDetail";
//Following assigns Vendor from dropdown list box
_merchant = "&vendor=" + ddlVendor.SelectedItem.Text.Replace(" ", "+");
}
reprotViewer.ServerUrl = "http://localhost/ReportServer";
//Following assigns report name and 3 parameters expected by report
reprotViewer.ReportPath = "%2MerchantSales%2f" + _reportName + _merchant + "&dateFrom=" + _fromDate + "&dateTo=" +_toDate;
}
I hope its helpfull.
Victor
|||Nice article:
http://odetocode.com/Articles/128.aspx
|||good info. thanks
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:9FF0148B-33D9-4FAB-933D-1FC357A0E774@.microsoft.com...
> Nice article:
>=20
> http://odetocode.com/Articles/128.aspx

Reporting Services question

I've created a dataset and report that has been running fine. Recently I modified the dataset, tested it OK, but was surprised the report shows nothing. Any clue why? thanks.I have read that after changeing a dataset - you have to refresh the schema
fromgotreportviewer.com...

There are two other common reasons to open the Report Data Sources dialog:

If a new field has been added to a datasource since it was added to the report, you have to press the Refresh All button before the report can "see" the new field.

You will also open this dialog to find out the names of report data sources.

.

Reporting services question

Hi,
I created aspx page with reprotviewer. Report runs fine and I exported it to
excel. (Windows 2000 Professional and MS Office 2002). When I try to open r
eport with excel it gives me "Problem during load" message box with message:
"Missing file: c:\styleshe
et.css". When I opened excel file with notepad, I found following line "<lin
k rel=3DStylesheet href=3D"file:///c:\stylesheet.css">". I removed line and
when I opened excel file again, file opened without message box.
What should I do to make sure that line mentioned above doesn't appear in fi
le in the first place?
Thanks,
VcitorI have to assume that the stylesheet link is being placed in there from =
your aspx page or the report viewer. Can you see any way to not use =
this stylesheet (or any other style sheet for that matter)?
On a side note, I would be interested in seeing the code. I am =
beginning to use Reporting Services and it would be interesting to see =
how you were able to render reports within the web pages using the =
report viewer. Are you willing to post your code here or to a location =
like http://www.gotdotnet.com/ ?
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:84995B62-2670-47E8-B563-9904A0C466DE@.microsoft.com...
> Hi,
>=20
> I created aspx page with reprotviewer. Report runs fine and I exported =
it to excel. (Windows 2000 Professional and MS Office 2002). When I try =
to open report with excel it gives me "Problem during load" message box =
with message: "Missing file: c:\stylesheet.css". When I opened excel =
file with notepad, I found following line "<link rel=3D3DStylesheet =
href=3D3D"file:///c:\stylesheet.css">". I removed line and when I opened =
excel file again, file opened without message box.
> What should I do to make sure that line mentioned above doesn't appear =
in file in the first place?
>=20
> Thanks,
> Vcitor|||I exported again to excel format and its working fine now. Reporting service
s have some issues which hopefully will be resolved in Service Pack 1.
Following is C# code which executed in code behind on button click:
protected Microsoft.Samples.ReportingServices.ReportViewer reprotViewer;
private void btnView_Click(object sender, System.EventArgs e){
string _dateFormat = "yyyy-MM-dd";
string _zeroTime = "+00%3a00%3a00";
string _fromDate = Convert.ToDateTime(lblFromDatetxt.Text).ToString(_dateFor
mat) + _zeroTime;
string _toDate = Convert.ToDateTime(lblToDatetxt.Text).AddDays(1).ToString(_
dateFormat) + _zeroTime;
string _reportName = "";
string _merchant = "";
reprotViewer.Visible = true;
if(ddlCIMSreports.SelectedItem.Text == "Summary"){
_reportName = "SalesSummary";
}
else{
_reportName = "SalesByMerchantDetail";
//Following assigns Vendor from dropdown list box
_merchant = "&vendor=" + ddlVendor.SelectedItem.Text.Replace(" ", "+");
}
reprotViewer.ServerUrl = "http://localhost/ReportServer";
//Following assigns report name and 3 parameters expected by report
reprotViewer.ReportPath = "%2MerchantSales%2f" + _reportName + _merchant + "
&dateFrom=" + _fromDate + "&dateTo=" +_toDate;
}
I hope its helpfull.
Victor|||Nice article:
http://odetocode.com/Articles/128.aspx|||good info. thanks
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:9FF0148B-33D9-4FAB-933D-1FC357A0E774@.microsoft.com...
> Nice article:
>=20
> http://odetocode.com/Articles/128.aspx

Reporting services permissions erorr reports not showing

Hi I successfully created a 2005 report server but not when I assess
from internet explorer i cant see the reports we created, only SQL
Reporting Serices Heading and HOME
also my developers cant deploy to http:\\server\reportserver
does any one know whats wrong, or whta the default permission setup is
required to make it go.
cheersMake sure you turn off Friendly Http-messages in your browser as well. For
IE, it's under Tools - Internet Options - Advanced - uncheck "Show Friendly
HTTP error Messages".
What happens if you go directly to http://server/reportserver in your
browser?
Also, make sure you deploy to http://server/reportserver, not
http:\\server\reportserver... (use / instead of \)
Kaisa M. Lindahl Lervik
"johnboy1973" <johnboy1973@.hotmail.com> wrote in message
news:1166635621.781155.220610@.t46g2000cwa.googlegroups.com...
> Hi I successfully created a 2005 report server but not when I assess
> from internet explorer i cant see the reports we created, only SQL
> Reporting Serices Heading and HOME
> also my developers cant deploy to http:\\server\reportserver
> does any one know whats wrong, or whta the default permission setup is
> required to make it go.
> cheers
>

Reporting services passing parameters

I have a report that is link from another report, I've created this link in the report designer by using the rightclick textbox>select properties>Navigation tab > jump to report.

Now I have passed 4 parameters over to the new report, these are hidden and shouldn't be seen by the user. There is however a fifth parameter that should be set by the user at run time, as this controls what the report shows. This works perfectly when I'm in the designer using the preview tab. However once I upload the report to the server, I get an error message saying that the fifth parameter is missing a value! Even though in report manager the fifth parameter is set to prompt User, it will not display a prompt and allow a user to input the data, it just says that the parameter is missing a value and that's as far as it gets.

I think this must have something to do with how report manager renders the parameters of a report but I can't seem to find any information on it anywhere. Can anyone help at all?

Hi James,
Two days ago I encountered the same issue with one of my reports. On the local designer studio everything worked fine and as soon as I uploaded it to Report Manager the parameter was not prompting for value but kept on complaining.
All I had to do was, save the report locally, reboot the machine and upload it again. I know its a crazy answer but it worked for me. On a hindsight, I guess it was caused by RDL file not getting updated or getting corrupt for some reason.
HTH
Uday
|||

Cheers hedgeu

I tried that though and it's still not working, i'm not sure if it's the way that i'm passing the parameters or weather it's a rendering problem all i know is i can't seem to get it to work.

James

|||

I'm not sure if this will fix your problem, but I have an idea you can try if you are still stuck.

Go to: http://localhost/Reports (keep in mind this is a different location from ReportServer)

Find the report which is accepting the parameters (ie, the one in which the user should enter a value for the parameter) and open the report.

Now, at the top of the page, click "Properties". Then select "Parameters"

Verify that your fifth parameter has a check for the prompt user option and that the hidden checkbox is not selected.

Once that is fixed, you should be good to go. Try to link to that report now.

reporting services Parameters Postbacks

Hi,
I had an experiment with the reporting services.
I created a report with 2 parameters param1 and param2, while param2 depend
on param1 (i.e., while selecting param1 param2 refreshed). In the SQL Server
profiler i can see that while selecting param1, the param1 stored procedure
run again (sometimes more than once).
Does someone know if there is a SSRS bug?On Jan 19, 1:08 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> Hi,
> I had an experiment with the reporting services.
> I created a report with 2 parameters param1 and param2, while param2 depend
> on param1 (i.e., while selecting param1 param2 refreshed). In the SQL Server
> profiler i can see that while selecting param1, the param1 stored procedure
> run again (sometimes more than once).
> Does someone know if there is a SSRS bug?
I do believe that this might be due to the postback in the Report
Manager (as you eluded to). A long shot might be to try checking web
config settings in the SSRS path (normally located at: C:\Program Files
\Microsoft SQL Server\MSSQL.2 -or- MSSQL.3\Reporting Services
\ReportManager). There might be a way to change the postback nature,
though not very likely. Sorry that I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Reporting Services On Web Server not on SQL Server

I have my web server and sql server seperated. Is it possible to have the virtual directories that get created point to the web server and not on the sql server? Also, if I have domain abc.com, def.com, ghi.com can they all go to the reporting services with their domains?

Thanks in advance!

anybody?

|||

Yes you can run reporting services on the webserver separated from the database server. Think of the Reporting Services as an ASP.NET application.

Reporting Services Login

Hi all,
I am trying to deploy a report that I have created. When I right-click
on the Report and click on Deploy, I get a Reporting Services login
dialog box. I tried all login/passwords possible and it keeps on
prompting me for it.
Everything is local to my computer. I am running SQL Server 2005
Standard Edition SP2.
Please help!
*** Sent via Developersdex http://www.codecomments.com ***Life is much easier if you set up the system so that you don't get any
Reporting Services logon dialogue. You need to fix up your IIS configuration
to sort out correct usage of integrated security.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:%23X0d8BcjHHA.492@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I am trying to deploy a report that I have created. When I right-click
> on the Report and click on Deploy, I get a Reporting Services login
> dialog box. I tried all login/passwords possible and it keeps on
> prompting me for it.
> Everything is local to my computer. I am running SQL Server 2005
> Standard Edition SP2.
> Please help!
>
> *** Sent via Developersdex http://www.codecomments.com ***

Reporting Services Login

Hi all,
I am trying to deploy a report that I have created. When I right-click
on the Report and click on Deploy, I get a Reporting Services login
dialog box. I tried all login/passwords possible and it keeps on
prompting me for it.
Everything is local to my computer. I am running SQL Server 2005
Standard Edition SP2.
Please help!
*** Sent via Developersdex http://www.developersdex.com ***Life is much easier if you set up the system so that you don't get any
Reporting Services logon dialogue. You need to fix up your IIS configuration
to sort out correct usage of integrated security.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:%23X0d8BcjHHA.492@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I am trying to deploy a report that I have created. When I right-click
> on the Report and click on Deploy, I get a Reporting Services login
> dialog box. I tried all login/passwords possible and it keeps on
> prompting me for it.
> Everything is local to my computer. I am running SQL Server 2005
> Standard Edition SP2.
> Please help!
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reporting Services Login

Hi all,
I am trying to deploy a report that I have created. When I right-click
on the Report and click on Deploy, I get a Reporting Services login
dialog box. I tried all login/passwords possible and it keeps on
prompting me for it.
Everything is local to my computer. I am running SQL Server 2005
Standard Edition SP2.
Please help!
*** Sent via Developersdex http://www.codecomments.com ***
Life is much easier if you set up the system so that you don't get any
Reporting Services logon dialogue. You need to fix up your IIS configuration
to sort out correct usage of integrated security.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:%23X0d8BcjHHA.492@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I am trying to deploy a report that I have created. When I right-click
> on the Report and click on Deploy, I get a Reporting Services login
> dialog box. I tried all login/passwords possible and it keeps on
> prompting me for it.
> Everything is local to my computer. I am running SQL Server 2005
> Standard Edition SP2.
> Please help!
>
> *** Sent via Developersdex http://www.codecomments.com ***

Reporting Services Key Management

I have a situation where I need to delete the keys from my SRS install and have new ones created. I see from here: http://msdn2.microsoft.com/en-us/library/ms162822.aspx

that I can use a -s switch but I don't have that. I have this installed on SQL 2000.

Here are the options I have:

Microsoft (R) Reporting Services Key Manager
Version 8.00.1038.00 x86

Extracts from the report server and applies to the report server the key used during encryption.

RSKeyMgmt [-e] [-a] [-d] [-r installationID] [-f file] [-p password] [-t]

-e extract Extracts a key from a report server instance
-a apply Applies a key to a report server instance
-d deletecontent Deletes all encrypted content from a report server
database
-r installationID Remove the key for the specified installation ID
-f file Full path and file name to read/write key.
-p password Password used to encrypt or decrypt key.
-t trace Include trace information in error message

I don't see a way to get the new ones created, if I use rskeymgmt.exe I see ways to extract the existing and apply an extracted key but nothing about creating new keys.

Anyone know how to create new keys and apply them to an exising install?

Joe

I am not too familar with RS2000, so try this at your own risk :). You can use -d, and then -r to remove the installation from RS catalog, then restart the RS service. This should create a new key for you. However, you'll loose the encrypted content.

Reporting Services in SQL 2005

I'm having trouble accessing reports via the reporting services in SQL 2005.
I have a role created for the test account I'm using with Browser access. The
only way I can see the report is if I give the test user local admin rights
on the SQL 2005 Report Server. Since I don't want to give all the users who
will use reports local admin rights on our SQL server is there any other way
around this?
No, do not give the users local admin rights.
Report Server rights are really implemented as directory rights, not what
you are used to from SQL Server database rights. In the Books Online, look
up the topics in this hierarchy:
SQL Server Reporting Services
Managing and Working With Published Reports
Using Role-Based Security
That should tell you what you need to know.
RLF
"m968vuk" <m968vuk@.discussions.microsoft.com> wrote in message
news:48360D4F-3320-4064-A48D-03DE73D03396@.microsoft.com...
> I'm having trouble accessing reports via the reporting services in SQL
> 2005.
> I have a role created for the test account I'm using with Browser access.
> The
> only way I can see the report is if I give the test user local admin
> rights
> on the SQL 2005 Report Server. Since I don't want to give all the users
> who
> will use reports local admin rights on our SQL server is there any other
> way
> around this?

Reporting Services in SQL 2005

I'm having trouble accessing reports via the reporting services in SQL 2005.
I have a role created for the test account I'm using with Browser access. The
only way I can see the report is if I give the test user local admin rights
on the SQL 2005 Report Server. Since I don't want to give all the users who
will use reports local admin rights on our SQL server is there any other way
around this?No, do not give the users local admin rights.
Report Server rights are really implemented as directory rights, not what
you are used to from SQL Server database rights. In the Books Online, look
up the topics in this hierarchy:
SQL Server Reporting Services
Managing and Working With Published Reports
Using Role-Based Security
That should tell you what you need to know.
RLF
"m968vuk" <m968vuk@.discussions.microsoft.com> wrote in message
news:48360D4F-3320-4064-A48D-03DE73D03396@.microsoft.com...
> I'm having trouble accessing reports via the reporting services in SQL
> 2005.
> I have a role created for the test account I'm using with Browser access.
> The
> only way I can see the report is if I give the test user local admin
> rights
> on the SQL 2005 Report Server. Since I don't want to give all the users
> who
> will use reports local admin rights on our SQL server is there any other
> way
> around this?

Reporting Services in SQL 2005

I'm having trouble accessing reports via the reporting services in SQL 2005.
I have a role created for the test account I'm using with Browser access. Th
e
only way I can see the report is if I give the test user local admin rights
on the SQL 2005 Report Server. Since I don't want to give all the users who
will use reports local admin rights on our SQL server is there any other way
around this?No, do not give the users local admin rights.
Report Server rights are really implemented as directory rights, not what
you are used to from SQL Server database rights. In the Books Online, look
up the topics in this hierarchy:
SQL Server Reporting Services
Managing and Working With Published Reports
Using Role-Based Security
That should tell you what you need to know.
RLF
"m968vuk" <m968vuk@.discussions.microsoft.com> wrote in message
news:48360D4F-3320-4064-A48D-03DE73D03396@.microsoft.com...
> I'm having trouble accessing reports via the reporting services in SQL
> 2005.
> I have a role created for the test account I'm using with Browser access.
> The
> only way I can see the report is if I give the test user local admin
> rights
> on the SQL 2005 Report Server. Since I don't want to give all the users
> who
> will use reports local admin rights on our SQL server is there any other
> way
> around this?

Reporting Services in Express SP2

Can reports I created in SQL Server 2005 using Reporting Services run on SQL
Express 2005 with SP2? I am a developer and some of our clients use SQL
Express. Thank you.
DavidOn Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
> Can reports I created in SQL Server 2005 using Reporting Services run on SQL
> Express 2005 with SP2? I am a developer and some of our clients use SQL
> Express. Thank you.
> David
Prior to SP2, this was no problem. I would assume the same afterwards;
however, someone else may know for certain.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||I thought it still requires and SQL Server license, correct? So if a small
company only uses SQL Express then I think they cannot install Reporting
Services. Can anyone verify that for me or point me to documentation?
Thanks.
David
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> Can reports I created in SQL Server 2005 using Reporting Services run on
>> SQL
>> Express 2005 with SP2? I am a developer and some of our clients use SQL
>> Express. Thank you.
>> David
> Prior to SP2, this was no problem. I would assume the same afterwards;
> however, someone else may know for certain.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||If the data is local to SQL Server Express there is a version of SQL Server
Express that comes with RS.
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn.microsoft.com/vstudio/express/sql/
It is free with the one caveat. The data being reported off of is local
(i.e. on express as well). You cannot use this to report off of other SQL
Servers, or Oracle or etc etc.
"David" <dlchase@.lifetimeinc.com> wrote in message
news:eWXCZj0WHHA.4240@.TK2MSFTNGP06.phx.gbl...
>I thought it still requires and SQL Server license, correct? So if a small
>company only uses SQL Express then I think they cannot install Reporting
>Services. Can anyone verify that for me or point me to documentation?
>Thanks.
> David
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
>> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> Can reports I created in SQL Server 2005 using Reporting Services run on
>> SQL
>> Express 2005 with SP2? I am a developer and some of our clients use SQL
>> Express. Thank you.
>> David
>> Prior to SP2, this was no problem. I would assume the same afterwards;
>> however, someone else may know for certain.
>> Regards,
>> Enrique Martinez
>> Sr. SQL Server Developer
>|||That is ok as this will be the only database reported on. Are all output
formats available (PDF, Excel, etc.)? Thanks.
David
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uJ09dY1WHHA.1200@.TK2MSFTNGP04.phx.gbl...
> If the data is local to SQL Server Express there is a version of SQL
> Server Express that comes with RS.
> http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
> http://msdn.microsoft.com/vstudio/express/sql/
> It is free with the one caveat. The data being reported off of is local
> (i.e. on express as well). You cannot use this to report off of other SQL
> Servers, or Oracle or etc etc.
>
> "David" <dlchase@.lifetimeinc.com> wrote in message
> news:eWXCZj0WHHA.4240@.TK2MSFTNGP06.phx.gbl...
>>I thought it still requires and SQL Server license, correct? So if a
>>small company only uses SQL Express then I think they cannot install
>>Reporting Services. Can anyone verify that for me or point me to
>>documentation? Thanks.
>> David
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
>> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> Can reports I created in SQL Server 2005 using Reporting Services run
>> on SQL
>> Express 2005 with SP2? I am a developer and some of our clients use
>> SQL
>> Express. Thank you.
>> David
>> Prior to SP2, this was no problem. I would assume the same afterwards;
>> however, someone else may know for certain.
>> Regards,
>> Enrique Martinez
>> Sr. SQL Server Developer
>>
>|||http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dlchase@.lifetimeinc.com> wrote in message
news:%2349vdu1WHHA.4624@.TK2MSFTNGP03.phx.gbl...
> That is ok as this will be the only database reported on. Are all output
> formats available (PDF, Excel, etc.)? Thanks.
> David
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uJ09dY1WHHA.1200@.TK2MSFTNGP04.phx.gbl...
>> If the data is local to SQL Server Express there is a version of SQL
>> Server Express that comes with RS.
>> http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
>> http://msdn.microsoft.com/vstudio/express/sql/
>> It is free with the one caveat. The data being reported off of is local
>> (i.e. on express as well). You cannot use this to report off of other SQL
>> Servers, or Oracle or etc etc.
>>
>> "David" <dlchase@.lifetimeinc.com> wrote in message
>> news:eWXCZj0WHHA.4240@.TK2MSFTNGP06.phx.gbl...
>>I thought it still requires and SQL Server license, correct? So if a
>>small company only uses SQL Express then I think they cannot install
>>Reporting Services. Can anyone verify that for me or point me to
>>documentation? Thanks.
>> David
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1172635810.340693.99970@.8g2000cwh.googlegroups.com...
>> On Feb 27, 4:38 pm, "David" <dlch...@.lifetimeinc.com> wrote:
>> Can reports I created in SQL Server 2005 using Reporting Services run
>> on SQL
>> Express 2005 with SP2? I am a developer and some of our clients use
>> SQL
>> Express. Thank you.
>> David
>> Prior to SP2, this was no problem. I would assume the same afterwards;
>> however, someone else may know for certain.
>> Regards,
>> Enrique Martinez
>> Sr. SQL Server Developer
>>
>>
>

Reporting Services Filter

I `m using Reporting Services from web. I mean that I have created some reports in report builder and put them in web. Other users can access and view this reports and everything works good. My question: Can other user apply some filter on the report if user has no any Reporting Services ?

For example:

If I created a report, wich contains 2 fields (ClientName and BirthDayDate), and I select all clients with birthdays from 1900 to 2007. But what if user wants to filter this clients and choose those, who hase birthdays from 1998 to 2001 for instance.... Is there a posibility like this in Reporting Services ?

You can configure the Report Builder parameter as prompted by right-clicking on it (on the Filter dialog) and choose Prompt.