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 Tutorials Problem

Hi, I'm having a problem with the 6th tutorial of the Reporting Services: Using XML Data in a Report. Im using SQL Server Standard Edition on Windows server 2003.

In 'Lesson 1: Defining a Data Source and Dataset for XML Data' (http://msdn2.microsoft.com/en-us/library/ms345338.aspx), I can't seem to get steps 10 to 15 right.

In Step 10, it says you must type :

"<Query> <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren</SoapAction> </Query>"

But in the diagram it has .../reporting/reportingservices/ListChildren...

Well I tried both(The namespace info from "http://localhost/reportserver/reportservice2005.asmx?wsdl" uses the latter.) but I get the error:

An error occurred while executing the query.

Failed to execute web request for the specified URL.

What am I doing wrong?

The schema information is wrong in the tutorial. We've fixed it for the next release. The following schema namespace should work for you:

Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>

|||

After typing the query as stated in the last post being:

<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>

I still get the same error. What is the correct syntax in order to get this to work?

Thanks

Reporting Services Tutorials Problem

Hi, I'm having a problem with the 6th tutorial of the Reporting Services: Using XML Data in a Report. Im using SQL Server Standard Edition on Windows server 2003.

In 'Lesson 1: Defining a Data Source and Dataset for XML Data' (http://msdn2.microsoft.com/en-us/library/ms345338.aspx), I can't seem to get steps 10 to 15 right.

In Step 10, it says you must type :

"<Query> <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren</SoapAction> </Query>"

But in the diagram it has .../reporting/reportingservices/ListChildren...

Well I tried both(The namespace info from "http://localhost/reportserver/reportservice2005.asmx?wsdl" uses the latter.) but I get the error:

An error occurred while executing the query.

Failed to execute web request for the specified URL.

What am I doing wrong?

The schema information is wrong in the tutorial. We've fixed it for the next release. The following schema namespace should work for you:

Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>

|||

After typing the query as stated in the last post being:

<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>

I still get the same error. What is the correct syntax in order to get this to work?

Thanks

Reporting Services Toolbar & version

Hi All,

1. Whether I'm working on in Layout, Data or Preview (Reporting Services 2005) for any report

the toolbars I select disappear when I click on close. In Tools, Customize, I have check marks by: Formatting, Query designer, Layou,Build and Standard among a few others. I tried the reset button but no help as well.

What am I missing? Should they be visible and not grayed out?

2. Also, Is there an easy way to tell what verion/service pack level SQl server 2005 and of MSSRS 2005 I am running?

Thanks in Advance !

>Scott

http://i55.photobucket.com/albums/g121/Farsight38/toolbars.jpg

These should be all of your toolbars.

To get the versin of SQL server 2005, execute the following query:

select @.@.version

reporting services TOC

We need a way add a WORD style TOC to a report, an ideas out there...?Try a document map.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mike" <michael.w.i@.gmail.com> wrote in message
news:dbd5909c.0411121733.623da7b3@.posting.google.com...
> We need a way add a WORD style TOC to a report, an ideas out there...?sql

Reporting Services to MS Word Questions

Hello

I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.

The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.

Is there a way to fix this formatting issues in Word?

Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||

We have the same dillemma...

We are currently evaluating another reporting tool due to couple of reasons:

1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.

2) No support for export of nested data regions to Excel?

Any idea when these features will be available?

Thanks a lot,

Panna Balaji

|||

We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.

Reporting Services to MS Word Questions

Hello

I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.

The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.

Is there a way to fix this formatting issues in Word?

Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||

We have the same dillemma...

We are currently evaluating another reporting tool due to couple of reasons:

1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.

2) No support for export of nested data regions to Excel?

Any idea when these features will be available?

Thanks a lot,

Panna Balaji

|||

We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.

Reporting Services to MS Word Questions

Hello

I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.

The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.

Is there a way to fix this formatting issues in Word?

Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||

We have the same dillemma...

We are currently evaluating another reporting tool due to couple of reasons:

1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.

2) No support for export of nested data regions to Excel?

Any idea when these features will be available?

Thanks a lot,

Panna Balaji

|||

We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.

Reporting Services Third Party Utilities

I was wondering if anyone knows of a report utility that works with Reporting Services to enable end users to create their own reports? A utility that is user-friendly enough for end users to modify reports without the aid of a developer.SQL Server 2005 ships with an application called Report Builder that does this. It is bundled with every edition (except Express, Mobile, or Anywhere). It is easy to install on end-user machines, it even deploys with clickonce!|||I have tried Report Builder, and it seems to do everything that I've needed. Thanks for your post and help.sql

Reporting Services Template

How can I setup Reporting Service so the report wizard uses a default
template we have created?Hi,
Basically you can save at this folder to access the template.
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
But for the wizard, you need to change the .vsz file with some scripts, it
is basically a text file. I would suggest you go through MSDN for changing
the scripts and search for "Creating a .vsz File" in MSDN.
Amarnath
"Chris Townsend" wrote:
> How can I setup Reporting Service so the report wizard uses a default
> template we have created?
>
>

Reporting Services Subscriptions - Help!

Hi, I have two questions regarding subscriptions in Report Services 2000.

1) Is there a way to view all the subscriptions in one centralised place. I know that you can view all your own subscriptions, but I did not create all of them. What I need is to be able to see all the subscriptions for all the reports without having to go into each report and see if it has subscriptions associated with it (we have about three hundred reports)

2) How can you disable a subscription, for example, my warehouse may be down one day and I dont want my daily reports to get sent to my clients so I just want to disable the subscription, not delete it. Anyway to get around this?

Thanks in advance

Look in Subscriptions in the ReportServer Db. I've created reports pulling data from the ReportServer database.

To disable a Subscription I'd set the end date before today.

|||Thanks very much for the help. Have decided to go that route now

Reporting Services Subscriptions - Help!

Hi, I have two questions regarding subscriptions in Report Services 2000.

1) Is there a way to view all the subscriptions in one centralised place. I know that you can view all your own subscriptions, but I did not create all of them. What I need is to be able to see all the subscriptions for all the reports without having to go into each report and see if it has subscriptions associated with it (we have about three hundred reports)

2) How can you disable a subscription, for example, my warehouse may be down one day and I dont want my daily reports to get sent to my clients so I just want to disable the subscription, not delete it. Anyway to get around this?

Thanks in advance

Look in Subscriptions in the ReportServer Db. I've created reports pulling data from the ReportServer database.

To disable a Subscription I'd set the end date before today.

|||Thanks very much for the help. Have decided to go that route now

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 Subscriptions

Hi All,
I'm testing RS with the Samples Reports, and especially the Product
Catalog report, which has no parameters, and is not a linked report.
I'm trying to make a subscription on this report, and I always get the
classical message shown bellow :
"Subscriptions cannot be created because the
credentials used to run the report are not stored,the report is using
user-defined para values,or if a linked report,the link is no longer
work."
So, as the report as no parameters, and is not a linked report, the
problem is with credentials.
I've changed the AdventureWorks datasource to make the credential
stored. The report is generated well.
But when I want to make a subscription? same message again.
I've tried with the "sa" account !!! Same message.
Am I wrong in my settings ?
Thanks for help.
DAThis report uses the user property which makes it unusable for
subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Death Angel" <lionel.valero@.scam.fr> wrote in message
news:d114e6a.0407290555.3734e70e@.posting.google.com...
> Hi All,
>
> I'm testing RS with the Samples Reports, and especially the Product
> Catalog report, which has no parameters, and is not a linked report.
> I'm trying to make a subscription on this report, and I always get the
> classical message shown bellow :
> "Subscriptions cannot be created because the
> credentials used to run the report are not stored,the report is using
> user-defined para values,or if a linked report,the link is no longer
> work."
> So, as the report as no parameters, and is not a linked report, the
> problem is with credentials.
> I've changed the AdventureWorks datasource to make the credential
> stored. The report is generated well.
> But when I want to make a subscription. same message again.
> I've tried with the "sa" account !!! Same message.
> Am I wrong in my settings ?
>
> Thanks for help.
>
> DA|||I am running into the same problem with my own custom
report. What is this 'user property' that is being
referred to and what needs to change?
Thanks for any assistance!!!
>--Original Message--
>This report uses the user property which makes it
unusable for
>subscriptions.
>--
>-Daniel
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Death Angel" <lionel.valero@.scam.fr> wrote in message
>news:d114e6a.0407290555.3734e70e@.posting.google.com...
>> Hi All,
>>
>> I'm testing RS with the Samples Reports, and especially
the Product
>> Catalog report, which has no parameters, and is not a
linked report.
>> I'm trying to make a subscription on this report, and I
always get the
>> classical message shown bellow :
>> "Subscriptions cannot be created because the
>> credentials used to run the report are not stored,the
report is using
>> user-defined para values,or if a linked report,the link
is no longer
>> work."
>> So, as the report as no parameters, and is not a linked
report, the
>> problem is with credentials.
>> I've changed the AdventureWorks datasource to make the
credential
>> stored. The report is generated well.
>> But when I want to make a subscription. same message
again.
>> I've tried with the "sa" account !!! Same message.
>> Am I wrong in my settings ?
>>
>> Thanks for help.
>>
>> DA
>
>.
>|||The user property is a property made available by RS. It contains
information such as the current user name (user running the report), their
language, etc. It is used in expression.
This link should help you:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jb" <Jill.Barrett@.accesspointinc.com> wrote in message
news:044d01c47eec$716543a0$7d02280a@.phx.gbl...
> I am running into the same problem with my own custom
> report. What is this 'user property' that is being
> referred to and what needs to change?
> Thanks for any assistance!!!
> >--Original Message--
> >This report uses the user property which makes it
> unusable for
> >subscriptions.
> >
> >--
> >-Daniel
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> >
> >"Death Angel" <lionel.valero@.scam.fr> wrote in message
> >news:d114e6a.0407290555.3734e70e@.posting.google.com...
> >> Hi All,
> >>
> >>
> >> I'm testing RS with the Samples Reports, and especially
> the Product
> >> Catalog report, which has no parameters, and is not a
> linked report.
> >>
> >> I'm trying to make a subscription on this report, and I
> always get the
> >> classical message shown bellow :
> >>
> >> "Subscriptions cannot be created because the
> >> credentials used to run the report are not stored,the
> report is using
> >> user-defined para values,or if a linked report,the link
> is no longer
> >> work."
> >>
> >> So, as the report as no parameters, and is not a linked
> report, the
> >> problem is with credentials.
> >>
> >> I've changed the AdventureWorks datasource to make the
> credential
> >> stored. The report is generated well.
> >>
> >> But when I want to make a subscription. same message
> again.
> >>
> >> I've tried with the "sa" account !!! Same message.
> >>
> >> Am I wrong in my settings ?
> >>
> >>
> >> Thanks for help.
> >>
> >>
> >> DA
> >
> >
> >.
> >|||Thanks for the reference I was able to figure out what's happening. Now, of
course, I have another question.
Is there any way to allow for subscriptions while using integrated security
on the data source?
jb
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OLfyslvfEHA.3932@.TK2MSFTNGP09.phx.gbl...
> The user property is a property made available by RS. It contains
> information such as the current user name (user running the report), their
> language, etc. It is used in expression.
> This link should help you:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "jb" <Jill.Barrett@.accesspointinc.com> wrote in message
> news:044d01c47eec$716543a0$7d02280a@.phx.gbl...
> > I am running into the same problem with my own custom
> > report. What is this 'user property' that is being
> > referred to and what needs to change?
> >
> > Thanks for any assistance!!!
> >
> > >--Original Message--
> > >This report uses the user property which makes it
> > unusable for
> > >subscriptions.
> > >
> > >--
> > >-Daniel
> > >This posting is provided "AS IS" with no warranties, and
> > confers no rights.
> > >
> > >
> > >"Death Angel" <lionel.valero@.scam.fr> wrote in message
> > >news:d114e6a.0407290555.3734e70e@.posting.google.com...
> > >> Hi All,
> > >>
> > >>
> > >> I'm testing RS with the Samples Reports, and especially
> > the Product
> > >> Catalog report, which has no parameters, and is not a
> > linked report.
> > >>
> > >> I'm trying to make a subscription on this report, and I
> > always get the
> > >> classical message shown bellow :
> > >>
> > >> "Subscriptions cannot be created because the
> > >> credentials used to run the report are not stored,the
> > report is using
> > >> user-defined para values,or if a linked report,the link
> > is no longer
> > >> work."
> > >>
> > >> So, as the report as no parameters, and is not a linked
> > report, the
> > >> problem is with credentials.
> > >>
> > >> I've changed the AdventureWorks datasource to make the
> > credential
> > >> stored. The report is generated well.
> > >>
> > >> But when I want to make a subscription. same message
> > again.
> > >>
> > >> I've tried with the "sa" account !!! Same message.
> > >>
> > >> Am I wrong in my settings ?
> > >>
> > >>
> > >> Thanks for help.
> > >>
> > >>
> > >> DA
> > >
> > >
> > >.
> > >
>

Reporting Services Soap API Internal Parameter

Using the web service how do i tell if a report parameter is internal, or hidden?A hidden parameter has a PromptUser value of true, but the Prompt is empty. An internal parameter has the PromptUser set to false.

Reporting Services Snapshots Access Denied

Hi guys,
I've set up a scheduled execution snapshots on a report; however, the
snapshot could only be viewed once. After the snapshot file being created on
rstempfiles directory, it cannot be acessed anymore. The error was 'Access to
path "C:\Program Files\Microsoft SQL Server\RSTempFiles\RSFile_da9ed300-e4a9-
4f7f-8ee7-48edf9ebedcd" is dnied.'
I've checked the security on the RSTempFiles directory and the snapshot file,
they both have users ASP.NET and SYSTEM with all permissions except the Full
Control permission.
Any help is appreciated.
Paul
--
Message posted via http://www.sqlmonster.comI think the login that the Reporting Services Services uses must also be
granted permissions on that directory..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul L via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54476CB0823F7@.SQLMonster.com...
> Hi guys,
> I've set up a scheduled execution snapshots on a report; however, the
> snapshot could only be viewed once. After the snapshot file being created
> on
> rstempfiles directory, it cannot be acessed anymore. The error was 'Access
> to
> path "C:\Program Files\Microsoft SQL
> Server\RSTempFiles\RSFile_da9ed300-e4a9-
> 4f7f-8ee7-48edf9ebedcd" is dnied.'
> I've checked the security on the RSTempFiles directory and the snapshot
> file,
> they both have users ASP.NET and SYSTEM with all permissions except the
> Full
> Control permission.
> Any help is appreciated.
> Paul
>
> --
> Message posted via http://www.sqlmonster.comsql

Reporting Services Slow to wake up

My users have been complaining that the first time they run reports on Reporting Services during the day it takes 30+ seconds for the first report to run. After this initial delay they respond very quickly.

There is considerable interaction with the database through a client application prior to this so the server is not in a sleep mode. It appears to only be an issue with Reporting Services.

Any ideas on how I can get this initial delay to go away?

Thanks in advance.

If the user is accessing reports through Report Manager, reporting services relies on IIS to host it in an AppDomain. IIS will often take several seconds (duration depending on the current use and speed of the machine) to intialize this AppDomain. You can adjust the timeout period of the Report Server AppDomain through IIS. This would minimize the number of startups that have to occur.

Thanks, Jon

Reporting Services Select All

When Building a report in the Business Intelligence Studio /w a select parameter it gives you a select all option. When you publish the report to your report server you no longer have this option?Most likely, SP1 has been applied to your server and not to your client. See http://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx for the story of "Select All".sql

Reporting Services seems to requery or refresh during drilldown

I have a report in reporting services with a single level of grouping:
Order
> Items
When I return the result the report is fine, but if I try to drill down into
an order, the screen flashes (as in a refresh), and then pushes the item I
opened to the top of the screen. It seems to be re-querying the database on
every click into the drilldown. Even though the result set is not large,
it's drawing it from a production database, and it takes several seconds to
complete the query.
Is it requerying, or is there a display issue? We're in the early stages of
using reporting services and it's currently running on an underpowered
machine for the server. Still, the result set has already been returned, and
shouldn't have to be drawn from the DB every time you drill down into a
single order.
Any ideas?I'm pretty sure it is a display issue. Just look at the HTML source code.
Every time you click into the drilldown, it does a postback to the server
and executing some "hide and show" code for the report.
The only time a query is send to the database is when you see the
"Generating Report" image.
"Ben Graham" <BenGraham@.discussions.microsoft.com> a écrit dans le message
de news:96761387-77EB-48C4-A40D-889ABD3521C9@.microsoft.com...
> I have a report in reporting services with a single level of grouping:
> Order
> > Items
> When I return the result the report is fine, but if I try to drill down
into
> an order, the screen flashes (as in a refresh), and then pushes the item I
> opened to the top of the screen. It seems to be re-querying the database
on
> every click into the drilldown. Even though the result set is not large,
> it's drawing it from a production database, and it takes several seconds
to
> complete the query.
> Is it requerying, or is there a display issue? We're in the early stages
of
> using reporting services and it's currently running on an underpowered
> machine for the server. Still, the result set has already been returned,
and
> shouldn't have to be drawn from the DB every time you drill down into a
> single order.
> Any ideas?
>

Reporting Services seems to go to sleep

I have been having a problem with Reporting Services.
It seems as though on Monday mornings, until an Admin logs on - and
browses/ uses the report manager for anything... the users who have
rights to browse get an error.
As if - reporting services goes to sleep, until someone wakes it up...
Can someone help?
ThanksAny answers on this one?
I saw similar postings but no replies...
The only one I found by Brian (MSFT) was:
"Are you reusing a database from a previous installation? It looks like the
windows service is not activating automatically because it thinks another
report server is using the database. If this is not the case, you can clear
out the old entries by running rskeymgmt -d, then restart the windows and
web service."
Any more suggestions?