RSExecRole

What is the function of the RSExecRole? Should I be granting this to users
in a development environment who need to create reports?
Thanks,
SteveHi,
"RSExecRole" permission is given to ReportServer database. This can be used
for accessing master, msdb and reportserver tempdb. But when you configure
using report configuration tool, these permissions are granted automatically.
So dont have to give it again.
Regards
Amarnath
"Steven" wrote:
> What is the function of the RSExecRole? Should I be granting this to users
> in a development environment who need to create reports?
> Thanks,
> Steve
>
>

RS2005 Multi-Value Problem, urgent!

Dose RS 2005 Multi-Value parameter function can work?
Trying to use multi-value function of RS2005,
dataset named as "AdventureWorks and syntax as following:
SELECT Name, ProductCategoryID
FROM Production.ProductCategory
WHERE (ProductCategoryID = @.ID)
Properties: multi-value
Available values: From query
Dataset: dataset1
Value field: ProductCategoryID
Label field: Name
Dataset1's syntax:
SELECT Name, ProductCategoryID
FROM Production.ProductCategory
Preview report and choice Bikes, Clothing has error msg:
An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'AdventureWorks'.
Incorrect syntax near ','.
Dose anyone has the same problem?
In Beta the Multi-Value function is ok,
but in released enterprise version I have this problem?
What's happened?
Thanks for any advice!
AngiYou have to write
... WHERE ProductCategoryID IN (@.ID)
"Angi" <enchiw@.msn.com> schrieb im Newsbeitrag
news:uIw261SAGHA.3968@.TK2MSFTNGP10.phx.gbl...
> Dose RS 2005 Multi-Value parameter function can work?
> Trying to use multi-value function of RS2005,
> dataset named as "AdventureWorks and syntax as following:
> SELECT Name, ProductCategoryID
> FROM Production.ProductCategory
> WHERE (ProductCategoryID = @.ID)
> Properties: multi-value
> Available values: From query
> Dataset: dataset1
> Value field: ProductCategoryID
> Label field: Name
> Dataset1's syntax:
> SELECT Name, ProductCategoryID
> FROM Production.ProductCategory
> Preview report and choice Bikes, Clothing has error msg:
> An error occurred during local report processing.
> An error has occurred during report processing.
> Query execution failed for data set 'AdventureWorks'.
> Incorrect syntax near ','.
> Dose anyone has the same problem?
> In Beta the Multi-Value function is ok,
> but in released enterprise version I have this problem?
> What's happened?
> Thanks for any advice!
> Angi
>|||uh... Thanks Ralph...
Don't know what I think... ><
Make the funny mistake..
"Ralph Watermann" <We.Want@.NoSpam.de> ¼¶¼g©ó¶l¥ó·s»D:uizY49VAGHA.3928@.tk2msftngp13.phx.gbl...
> You have to write
> ... WHERE ProductCategoryID IN (@.ID)
>
> "Angi" <enchiw@.msn.com> schrieb im Newsbeitrag
> news:uIw261SAGHA.3968@.TK2MSFTNGP10.phx.gbl...
>> Dose RS 2005 Multi-Value parameter function can work?
>> Trying to use multi-value function of RS2005,
>> dataset named as "AdventureWorks and syntax as following:
>> SELECT Name, ProductCategoryID
>> FROM Production.ProductCategory
>> WHERE (ProductCategoryID = @.ID)
>> Properties: multi-value
>> Available values: From query
>> Dataset: dataset1
>> Value field: ProductCategoryID
>> Label field: Name
>> Dataset1's syntax:
>> SELECT Name, ProductCategoryID
>> FROM Production.ProductCategory
>> Preview report and choice Bikes, Clothing has error msg:
>> An error occurred during local report processing.
>> An error has occurred during report processing.
>> Query execution failed for data set 'AdventureWorks'.
>> Incorrect syntax near ','.
>> Dose anyone has the same problem?
>> In Beta the Multi-Value function is ok,
>> but in released enterprise version I have this problem?
>> What's happened?
>> Thanks for any advice!
>> Angi
>

rs:about the Scope parameter of a aggregate function

A valid scope is the name of a grouping, dataset, or data region. Only groupings or data regions valid scope is the name of a grouping, dataset, or data region. Only groupings or data regions .
the meaning of data region? for example?See my response on the public RS newsgroup:

A data region is a list, matrix, table, or chart.
Please check Reporting Services BOL for more information, e.g.:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_8epf.asp

-- Robert

rs:about the Scope parameter of a aggregate function

A valid scope is the name of a grouping, dataset, or data region. Only
groupings or data regions valid scope is the name of a grouping, dataset, or
data region. Only groupings or data regions .
the meaning of data region? for example?A data region is a list, matrix, table, or chart.
Please check Reporting Services BOL for more information, e.g.:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_8epf.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"aoeabc" <aoeabc@.discussions.microsoft.com> wrote in message
news:72ABECDD-41BB-427E-8CD8-AEC0776BF9F6@.microsoft.com...
>A valid scope is the name of a grouping, dataset, or data region. Only
> groupings or data regions valid scope is the name of a grouping, dataset,
> or
> data region. Only groupings or data regions .
> the meaning of data region? for example?|||Tell me an idea how to do this:
I have three records like this:
Type: 1
Amount: 100
Type 2
Amount: 200
Type 2
Amount: 100
The types of 1 must be negative and the 2 positive, so when I sum must be
-100+300 = 200 positive. I want to make a conditional sum. Now I made it
making the type 1 * -1 and then when I want to print the value amount *
iif(type = 1, -1, 1), so its very tired.
Any idea?
"Robert Bruckner [MSFT]" wrote:
> A data region is a list, matrix, table, or chart.
> Please check Reporting Services BOL for more information, e.g.:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_8epf.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "aoeabc" <aoeabc@.discussions.microsoft.com> wrote in message
> news:72ABECDD-41BB-427E-8CD8-AEC0776BF9F6@.microsoft.com...
> >A valid scope is the name of a grouping, dataset, or data region. Only
> > groupings or data regions valid scope is the name of a grouping, dataset,
> > or
> > data region. Only groupings or data regions .
> > the meaning of data region? for example?
>
>

RS Bug? Multi-Page problem after many attempts...

Ok,
In using the rs.render function (soap) and sending a report to the printer
programatically as an emf file, for months, if the report goes beyond one
page in length, none of the controls (textboxes, images, data missing from
printed textboxes) I set as "repeat on every page" gets printed. First of
all, I've tried settings for the data areas that do get printed (details rows
and footer only) and that selection just doesn't work. I would be happy to
send or upload the report for examination (any help is much appreciated).
Does Microsoft have a fix for this, or is the workaround just not obvious?
Thanks,
Trint
--
Trinity Smith
c#/vb.Net Developer
EcoQuest, Intl.Trint,
We are experiencing the exact same problems. We've thought about rendering
as a Tiff, but image quality decreases. Have you received any feedback on
this issue from Microsoft?
Please pass on any info you have found as it would be greatly appreciated.
Thanks,
-Rick
"TrintCSD" wrote:
> Ok,
> In using the rs.render function (soap) and sending a report to the printer
> programatically as an emf file, for months, if the report goes beyond one
> page in length, none of the controls (textboxes, images, data missing from
> printed textboxes) I set as "repeat on every page" gets printed. First of
> all, I've tried settings for the data areas that do get printed (details rows
> and footer only) and that selection just doesn't work. I would be happy to
> send or upload the report for examination (any help is much appreciated).
> Does Microsoft have a fix for this, or is the workaround just not obvious?
> Thanks,
> Trint
> --
> Trinity Smith
> c#/vb.Net Developer
> EcoQuest, Intl.