Customised totals

Hi,

I am creating a report using matrix. The reporting services subtotal, sums up the data on all rows. The data in rows contains numeric & percentage values. I need the total for numeric value as sum and for percentage values as weighted average. Does anyone know how to do this or is this limitation of RS. Thanks.

You mean you want to have different calculation done in the subtotal as oppose to the one used in detail cells? If so, you can use the InScope function to do it. http://msdn2.microsoft.com/en-us/library/ms156490.aspxsql

Customer Statements

I am trying to develop a "customer statements" type report.
I have no issue creating "one off single customer at a time" versions.
I have an issue reporting groups of customers at a time.
The scenario is this:
Single Parameter = All Customers in Canada (for example)
3 different data sets of info to show on
each customer, 1 for general address info, 1 for
invoices and 1 for payments. It is necessary
for them to be broken into 3 seperate datasets.
How can I have 3 different table each with the
above datasets and have them group on one page,
and then the next page is the next customer...
The issue is my grouping, where do I set to
start a new group after all 3 tables/datasets based
on a customer grouping?
I am debating trying subreports to accomplish this
but was hoping I could get away with using 3 tables.
Any suggestions?You definitely want to use subreports. Have your general in the main report.
I suggest using a list and placing the data in individual text boxes (versus
using the table control). Then have two subreports using the table control.
This is exactly what subreports are designed for. Subreports are your
friend.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Patten" <ChrisPatten@.discussions.microsoft.com> wrote in message
news:6B1D0B5C-8DE3-4507-AF7D-E4113D10236E@.microsoft.com...
>I am trying to develop a "customer statements" type report.
> I have no issue creating "one off single customer at a time" versions.
> I have an issue reporting groups of customers at a time.
> The scenario is this:
> Single Parameter = All Customers in Canada (for example)
> 3 different data sets of info to show on
> each customer, 1 for general address info, 1 for
> invoices and 1 for payments. It is necessary
> for them to be broken into 3 seperate datasets.
> How can I have 3 different table each with the
> above datasets and have them group on one page,
> and then the next page is the next customer...
> The issue is my grouping, where do I set to
> start a new group after all 3 tables/datasets based
> on a customer grouping?
> I am debating trying subreports to accomplish this
> but was hoping I could get away with using 3 tables.
> Any suggestions?|||Thanks.
I am trying to implentment your suggestion of using a list (which I have
never used before) and dropping the fields on the body. I am not seeing the
"main area" data populate though, the fields show up blank.
"Bruce L-C [MVP]" wrote:
> You definitely want to use subreports. Have your general in the main report.
> I suggest using a list and placing the data in individual text boxes (versus
> using the table control). Then have two subreports using the table control.
> This is exactly what subreports are designed for. Subreports are your
> friend.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris Patten" <ChrisPatten@.discussions.microsoft.com> wrote in message
> news:6B1D0B5C-8DE3-4507-AF7D-E4113D10236E@.microsoft.com...
> >I am trying to develop a "customer statements" type report.
> > I have no issue creating "one off single customer at a time" versions.
> > I have an issue reporting groups of customers at a time.
> >
> > The scenario is this:
> >
> > Single Parameter = All Customers in Canada (for example)
> > 3 different data sets of info to show on
> > each customer, 1 for general address info, 1 for
> > invoices and 1 for payments. It is necessary
> > for them to be broken into 3 seperate datasets.
> >
> > How can I have 3 different table each with the
> > above datasets and have them group on one page,
> > and then the next page is the next customer...
> > The issue is my grouping, where do I set to
> > start a new group after all 3 tables/datasets based
> > on a customer grouping?
> >
> > I am debating trying subreports to accomplish this
> > but was hoping I could get away with using 3 tables.
> >
> > Any suggestions?
>
>

Custom Userform for entering paremeters

How would I intergrate a userform into a report?
I have no problem creating the form in VB.
I want to use the form instead of the default paremeter controls that RS
uses. The form will ask a series of paremeters many of which will be an
either/or and create the SQL statement for which I would then want to pass on
to Reporting Services to get the data for the report.
Just point me in the right direction.David wrote:
> How would I intergrate a userform into a report?
> I want to use the form instead of the default paremeter controls that
> RS uses. The form will ask a series of paremeters many of which will
> be an either/or and create the SQL statement for which I would then
> want to pass on to Reporting Services to get the data for the report.
> Just point me in the right direction.
Use the report viewer control on a asp.net webform
regards
Frank

Custom renderer samples?

Are there any samples of creating a custom renderer, other than the MSDN
Magazone article that seems to be the only thing that everyone points to? The
documentation on this is meager at best.
Thanks.I don't have anything, but read this a while back, it's from Carlos on the
Spanish MS team.
http://blogs.msdn.com/carloshm/archive/2005/10/18/482022.aspx
Steve MunLeeuw
"Dave Burch" <Dave Burch@.discussions.microsoft.com> wrote in message
news:30BF2111-D432-41A6-B99D-3E98767C1EBA@.microsoft.com...
> Are there any samples of creating a custom renderer, other than the MSDN
> Magazone article that seems to be the only thing that everyone points to?
> The
> documentation on this is meager at best.
> Thanks.
>|||Thanks, I'll have a look at it.
"Steve MunLeeuw" wrote:
> I don't have anything, but read this a while back, it's from Carlos on the
> Spanish MS team.
> http://blogs.msdn.com/carloshm/archive/2005/10/18/482022.aspx
> Steve MunLeeuw
> "Dave Burch" <Dave Burch@.discussions.microsoft.com> wrote in message
> news:30BF2111-D432-41A6-B99D-3E98767C1EBA@.microsoft.com...
> > Are there any samples of creating a custom renderer, other than the MSDN
> > Magazone article that seems to be the only thing that everyone points to?
> > The
> > documentation on this is meager at best.
> >
> > Thanks.
> >
>
>

Custom Renderer in SharePoint integrated mode

We have been successful in creating a custom Excel Renderer that works very well on a server configured for SSRS Native mode. However we have another server that is configured to work in SSRS integrated mode that we can not get this custom renderer to work properly. The steps we follow are:

After the report results are displayed we select Actions -> Export -> Excel Custom . So I can see the name of our custom rendering type. After a very short amount of time (no more than a second or 2) I get a frame that says: an unexpected error has occurred. Here is the URL of the web site:

http://sharepointserver/sites/BI/Reports/Reserved.ReportViewerWebPart.axd?ReportSession=2jqe4e45sm0sze553avovv55&ControlID=5c4fbb59def64efdac050393cd3fb338&Culture=1033&UICulture=1033&ReportStack=1&OpType=Export&FileName=edi001&ContentDisposition=OnlyHtmlInline&Format=CUSTOM_RENDERER

Is there anything that has to be done differently to get a custom renderer to work in SharePoint integrated mode?

Note: here is the article we followed to initially create the renderer that will work in SSRS native mode:

http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/

Any help would be appreciated, thanks.

I have had the same problem, and have not found any hints yet on how to get a custom renderer to work. I check the supported/unsupported feature list for Integrated SSRS, and there is no mention there that the feature is not available, so am holding out hope that it is something simple.

-cg

custom flat file for log transactions

Hi,
I am new at reporting services and need help creating a flat file that
will contain transaction logs like userid, amount, date and a comment
line.
I do not want the full report history since that would take a lot of
space on the server.
Is there such a way to create a flat file with plain text
characters(maybe csv or just spaces...) with only the information I
want to provide and to the folder/file I specify?
Thanks.
BTW, this is also my first posting ever.If the data is already in a database table, you should be able to create a
dataset against it, pull the data (i.e., only the columns and rows you want)
into a report table, publish the report, and export it to CSV. Check BOL for
samples and walkthroughs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_overview_v1_631v.asp?frame=true.
There's also a How To section in BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_4bhu.asp?frame=true.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"A Gutie" <fiututor@.yahoo.com> wrote in message
news:eca873f7.0408030527.27d8e376@.posting.google.com...
> Hi,
> I am new at reporting services and need help creating a flat file that
> will contain transaction logs like userid, amount, date and a comment
> line.
> I do not want the full report history since that would take a lot of
> space on the server.
> Is there such a way to create a flat file with plain text
> characters(maybe csv or just spaces...) with only the information I
> want to provide and to the folder/file I specify?
> Thanks.
> BTW, this is also my first posting ever.|||Hi Ravi,
This report does not use any tables but only textboxes that are
populated from different datasets. All is working fine.
EXCEPT: I need to create a text file(could be csv or just plain text
separated by blanks...) that will get appended information to it. It
will contain a few fields from the report. This process MUST be made
automatically without having the user click on the 'export' link. In
other words, like behind the scenes event when clicking on the 'view
report' button.
What I have done is to create a dataset that has an insert but this is
adding the fields to a table I created for testing. If I could just
make the 'insert' send the output to a text file instead of a table
will do all I need.
if you know how, please let me know. I have not had any luck sending
the output to a file from an insert - have not found any documentation
on it but just DTS code that will not suffice.
I apologize for not giving specific details.
Thanks again.
"Ravi Mumulla \(Microsoft\)" <ravimu@.online.microsoft.com> wrote in message news:<OqoCEoXeEHA.1644@.tk2msftngp13.phx.gbl>...
> If the data is already in a database table, you should be able to create a
> dataset against it, pull the data (i.e., only the columns and rows you want)
> into a report table, publish the report, and export it to CSV. Check BOL for
> samples and walkthroughs:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_overview_v1_631v.asp?frame=true.
> There's also a How To section in BOL:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_4bhu.asp?frame=true.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "A Gutie" <fiututor@.yahoo.com> wrote in message
> news:eca873f7.0408030527.27d8e376@.posting.google.com...
> > Hi,
> > I am new at reporting services and need help creating a flat file that
> > will contain transaction logs like userid, amount, date and a comment
> > line.
> > I do not want the full report history since that would take a lot of
> > space on the server.
> > Is there such a way to create a flat file with plain text
> > characters(maybe csv or just spaces...) with only the information I
> > want to provide and to the folder/file I specify?
> > Thanks.
> > BTW, this is also my first posting ever.|||Sounds like execution log will give you what you're looking for. Take a look
at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp?frame=true.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"A Gutie" <fiututor@.yahoo.com> wrote in message
news:eca873f7.0408040544.744a044@.posting.google.com...
> Hi Ravi,
> This report does not use any tables but only textboxes that are
> populated from different datasets. All is working fine.
> EXCEPT: I need to create a text file(could be csv or just plain text
> separated by blanks...) that will get appended information to it. It
> will contain a few fields from the report. This process MUST be made
> automatically without having the user click on the 'export' link. In
> other words, like behind the scenes event when clicking on the 'view
> report' button.
> What I have done is to create a dataset that has an insert but this is
> adding the fields to a table I created for testing. If I could just
> make the 'insert' send the output to a text file instead of a table
> will do all I need.
> if you know how, please let me know. I have not had any luck sending
> the output to a file from an insert - have not found any documentation
> on it but just DTS code that will not suffice.
> I apologize for not giving specific details.
> Thanks again.
> "Ravi Mumulla \(Microsoft\)" <ravimu@.online.microsoft.com> wrote in
message news:<OqoCEoXeEHA.1644@.tk2msftngp13.phx.gbl>...
> > If the data is already in a database table, you should be able to create
a
> > dataset against it, pull the data (i.e., only the columns and rows you
want)
> > into a report table, publish the report, and export it to CSV. Check BOL
for
> > samples and walkthroughs:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_overview_v1_631v.asp?frame=true.
> > There's also a How To section in BOL:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_4bhu.asp?frame=true.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "A Gutie" <fiututor@.yahoo.com> wrote in message
> > news:eca873f7.0408030527.27d8e376@.posting.google.com...
> > > Hi,
> > > I am new at reporting services and need help creating a flat file that
> > > will contain transaction logs like userid, amount, date and a comment
> > > line.
> > > I do not want the full report history since that would take a lot of
> > > space on the server.
> > > Is there such a way to create a flat file with plain text
> > > characters(maybe csv or just spaces...) with only the information I
> > > want to provide and to the folder/file I specify?
> > > Thanks.
> > > BTW, this is also my first posting ever.|||Report Server Execution Log Data would had been great but it does not
contain information from a dataset but only parameter
information(according to the specs).
This link is very good but it does not include values from dataset
if I could just include field values from dataset then it'd do.
any other hints or maybe the execution log may be modified to include
values from datasets?
Thanks again
"Ravi Mumulla \(Microsoft\)" <ravimu@.online.microsoft.com> wrote in message news:<uO7gHJoeEHA.2396@.TK2MSFTNGP11.phx.gbl>...
> Sounds like execution log will give you what you're looking for. Take a look
> at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp?frame=true.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "A Gutie" <fiututor@.yahoo.com> wrote in message
> news:eca873f7.0408040544.744a044@.posting.google.com...
> > Hi Ravi,
> >
> > This report does not use any tables but only textboxes that are
> > populated from different datasets. All is working fine.
> >
> > EXCEPT: I need to create a text file(could be csv or just plain text
> > separated by blanks...) that will get appended information to it. It
> > will contain a few fields from the report. This process MUST be made
> > automatically without having the user click on the 'export' link. In
> > other words, like behind the scenes event when clicking on the 'view
> > report' button.
> >
> > What I have done is to create a dataset that has an insert but this is
> > adding the fields to a table I created for testing. If I could just
> > make the 'insert' send the output to a text file instead of a table
> > will do all I need.
> > if you know how, please let me know. I have not had any luck sending
> > the output to a file from an insert - have not found any documentation
> > on it but just DTS code that will not suffice.
> > I apologize for not giving specific details.
> > Thanks again.
> >
> > "Ravi Mumulla \(Microsoft\)" <ravimu@.online.microsoft.com> wrote in
> message news:<OqoCEoXeEHA.1644@.tk2msftngp13.phx.gbl>...
> > > If the data is already in a database table, you should be able to create
> a
> > > dataset against it, pull the data (i.e., only the columns and rows you
> want)
> > > into a report table, publish the report, and export it to CSV. Check BOL
> for
> > > samples and walkthroughs:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_overview_v1_631v.asp?frame=true.
> > > There's also a How To section in BOL:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_4bhu.asp?frame=true.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "A Gutie" <fiututor@.yahoo.com> wrote in message
> > > news:eca873f7.0408030527.27d8e376@.posting.google.com...
> > > > Hi,
> > > > I am new at reporting services and need help creating a flat file that
> > > > will contain transaction logs like userid, amount, date and a comment
> > > > line.
> > > > I do not want the full report history since that would take a lot of
> > > > space on the server.
> > > > Is there such a way to create a flat file with plain text
> > > > characters(maybe csv or just spaces...) with only the information I
> > > > want to provide and to the folder/file I specify?
> > > > Thanks.
> > > > BTW, this is also my first posting ever.

Custom Fax Delivery Extension

Hello All:
We have setup Reporting Services. I want to integrate it with Fax server for
creating new subsciptions using custom delivery extension.
Apart from this custom extension, I am having one more solution for this
scenario and that is sending email (in the format <fax number>@.<fax server
name>) to the fax server as it is on SMTP.
I have not tested this scenario but from some search on net on this topic
brought out this solution. I am not sure whether sending email to the Fax
server (as it is on SMTP) will be right solution.
And if this is the solution then why do we need to write Custom fax Delivery
Extension? Any help or sample code or steps in this regards will be highly
appreciated
RohitIf you have an eamil address that works like a fax server, then you can make
a subscription to the report and email it... However there is no USER
Rendering agent for fax server, so a user can not run the report, then
export it to a fax server unless you write a custom extension..
--
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
"Rohit Patil" <Rohit Patil@.discussions.microsoft.com> wrote in message
news:86A1792C-506D-4BBE-A06F-7DB888FE7036@.microsoft.com...
> Hello All:
> We have setup Reporting Services. I want to integrate it with Fax server
> for
> creating new subsciptions using custom delivery extension.
> Apart from this custom extension, I am having one more solution for this
> scenario and that is sending email (in the format <fax number>@.<fax server
> name>) to the fax server as it is on SMTP.
> I have not tested this scenario but from some search on net on this topic
> brought out this solution. I am not sure whether sending email to the Fax
> server (as it is on SMTP) will be right solution.
> And if this is the solution then why do we need to write Custom fax
> Delivery
> Extension? Any help or sample code or steps in this regards will be highly
> appreciated
> Rohit|||Hello Wayne,
Thanks for the reply. I have database of external users to whom the report
from reporting server is to be faxed. So depending upon the subscription made
report will be sent to different fax numbers. I am testing for the
functionality of fax server to send fax to different numbers, but I think I
have to write fax extension. If Ic an et some sample code for it then it will
be of real great help.
Rohit
"Wayne Snyder" wrote:
> If you have an eamil address that works like a fax server, then you can make
> a subscription to the report and email it... However there is no USER
> Rendering agent for fax server, so a user can not run the report, then
> export it to a fax server unless you write a custom extension..
> --
> 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
> "Rohit Patil" <Rohit Patil@.discussions.microsoft.com> wrote in message
> news:86A1792C-506D-4BBE-A06F-7DB888FE7036@.microsoft.com...
> > Hello All:
> > We have setup Reporting Services. I want to integrate it with Fax server
> > for
> > creating new subsciptions using custom delivery extension.
> >
> > Apart from this custom extension, I am having one more solution for this
> > scenario and that is sending email (in the format <fax number>@.<fax server
> > name>) to the fax server as it is on SMTP.
> >
> > I have not tested this scenario but from some search on net on this topic
> > brought out this solution. I am not sure whether sending email to the Fax
> > server (as it is on SMTP) will be right solution.
> >
> > And if this is the solution then why do we need to write Custom fax
> > Delivery
> > Extension? Any help or sample code or steps in this regards will be highly
> > appreciated
> >
> > Rohit
>
>

Custom Delivery Extension

Hello Everyone,
I'm in the process of creating a custom delivery extension that will
write to a file share and then email users that the file is available.
I have used the custom printing extension sample as the basis for
creating my FileShareEmail extension.
I think my question is unlike most posted here in that, I have gotten
all the config files to work. So far I have set up a few parameters
(email address to and from). I then send an email with smtp.
I successfully receive the email and I created the notification.Status
= "Status: Email Sent.". This is what i see in the log file:
ReportingServicesService!notification!3ffc!11/02/2005-09:42:06::
Notification 7493a45c-2f0b-431c-bb53-592a99a5977c completed. Success:
False, Status: Email Sent., DeliveryExtension: File Share Email,
Report: 01 - Standard Listing Report, Attempt 1
There are no exceptions and the email was sent. The Report Manager
still has Done: 1 processed of 1 total; 1 errors. in the status column.
I cannot figure out why there was an error generated. Is there a
property that i forgot to set?
Another question I have is: I can see my custom extension in data
driven subscriptions but not in the regular subscriptions. Is this by
design or am I missing a config.
Resources question: I've looked quite a few places for some more
examples (other than the printer example), does anyone know some good
blogs or sites that have some different samples implemented?
The fourth and final question: Since I am trying to replicate some of
the existing functionality of RS, is there a way to send the email
through RS instead of coding my own error checking and such into my
extension?
Thanks for your help!
Regards,
DanI figured out one of the 4 questions. My Deliver() method was
returning the wrong boolean value (i.e. true when failed and false when
succeeded).

Custom Class for Function

I have several fuctions that I would like to share between my different script tasks in my SSIS package. I assume I do this by creating a custom class, but I cant quite figure it out. Can someone please point me in the right direction?

Thank You!!

Check Books Online under Programming Integration Services.|||

I didn't see any instruction for how to do this in the Books Online. If it is there, I can't find it. Please help, I would like to figure out how to do this.

Thank You.

|||

AspUser123 wrote:

I didn't see any instruction for how to do this in the Books Online. If it is there, I can't find it. Please help, I would like to figure out how to do this.

Thank You.

Assuming you know how to create an assembly, this explains how you can reference it from your SSIS scripts.

http://msdn2.microsoft.com/en-US/library/ms136007.aspx

Custom Class for Function

I have several fuctions that I would like to share between my different script tasks in my SSIS package. I assume I do this by creating a custom class, but I cant quite figure it out. Can someone please point me in the right direction?

Thank You!!

Check Books Online under Programming Integration Services.|||

I didn't see any instruction for how to do this in the Books Online. If it is there, I can't find it. Please help, I would like to figure out how to do this.

Thank You.

|||

AspUser123 wrote:

I didn't see any instruction for how to do this in the Books Online. If it is there, I can't find it. Please help, I would like to figure out how to do this.

Thank You.

Assuming you know how to create an assembly, this explains how you can reference it from your SSIS scripts.

http://msdn2.microsoft.com/en-US/library/ms136007.aspx

Custom Assembly Configuration Problems

Hi,
I am attempting to integrate a third party .Net assembly into a custom
report I'm writing. The assembly provides functions for creating 2D barcodes
that are a required format for my solution. I've successfully referenced the
assembly and can run my report from visual studio without error.
However, when I deploy and run the report I get the following exception:
Failed to load expression host assembly. Details:
System.Security.Permissions.SecurityPermission (rsProcessingError)
I've added the Custom Assemblies block to my RSReportDesigner.config and my
RSReportServer.config. I have also added code groups to my
rssrvpolicy.config and rspreviewpolicy.config. I have deployed the
referenced dlls to the appropriate bin directories.
The only thing that I haven't done is code the custom assembly to 'assert
permissions'. I shouldn't have to because the assembly takes a simple string
and returns the encoded string - it doesn't use any 'secure' resources (no
files, db connections, etc.). I have also tried using 'FullTrust'
permissions in my code groups even though that is not recommended. In any
event, I do not have source code for this third party assembly nor license to
modify it if I could.
Is there anything I can do to make this work?
--
PaulThe problem is that the third party assembly has strong name and is not
marked with APTCA
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/aptcatypes.asp)
The report expressions at runtime are located in an untrusted assembly thus
any call to a non_APTCA assembly would fail. What you need to do is to
create a thin wrapper assembly that would accept calls from report
expressions and redirect them into the non-APTCA assembly. You will also
need to give fulltrust to that wrapper assembly
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Keegstra" <PaulKeegstra@.discussions.microsoft.com> wrote in message
news:2F8F0E0C-9C98-4EBD-B9D5-AF6D667975BB@.microsoft.com...
> Hi,
> I am attempting to integrate a third party .Net assembly into a custom
> report I'm writing. The assembly provides functions for creating 2D
> barcodes
> that are a required format for my solution. I've successfully referenced
> the
> assembly and can run my report from visual studio without error.
> However, when I deploy and run the report I get the following exception:
> Failed to load expression host assembly. Details:
> System.Security.Permissions.SecurityPermission (rsProcessingError)
> I've added the Custom Assemblies block to my RSReportDesigner.config and
> my
> RSReportServer.config. I have also added code groups to my
> rssrvpolicy.config and rspreviewpolicy.config. I have deployed the
> referenced dlls to the appropriate bin directories.
> The only thing that I haven't done is code the custom assembly to 'assert
> permissions'. I shouldn't have to because the assembly takes a simple
> string
> and returns the encoded string - it doesn't use any 'secure' resources (no
> files, db connections, etc.). I have also tried using 'FullTrust'
> permissions in my code groups even though that is not recommended. In any
> event, I do not have source code for this third party assembly nor license
> to
> modify it if I could.
> Is there anything I can do to make this work?
> --
> Paul|||That doesn't work. Actually, it makes it worse because whereas before I had
a clearly identified exception, adding the wrapper class only results in my
expression evaluating to #Error - with no clue as to the cause. My guess is
it's just the same error, only now the exception has been wrapped out of view.
--
Paul
"Alexandre Mineev MSFT" wrote:
> The problem is that the third party assembly has strong name and is not
> marked with APTCA
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/aptcatypes.asp)
> The report expressions at runtime are located in an untrusted assembly thus
> any call to a non_APTCA assembly would fail. What you need to do is to
> create a thin wrapper assembly that would accept calls from report
> expressions and redirect them into the non-APTCA assembly. You will also
> need to give fulltrust to that wrapper assembly
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Paul Keegstra" <PaulKeegstra@.discussions.microsoft.com> wrote in message
> news:2F8F0E0C-9C98-4EBD-B9D5-AF6D667975BB@.microsoft.com...
> > Hi,
> >
> > I am attempting to integrate a third party .Net assembly into a custom
> > report I'm writing. The assembly provides functions for creating 2D
> > barcodes
> > that are a required format for my solution. I've successfully referenced
> > the
> > assembly and can run my report from visual studio without error.
> >
> > However, when I deploy and run the report I get the following exception:
> > Failed to load expression host assembly. Details:
> > System.Security.Permissions.SecurityPermission (rsProcessingError)
> >
> > I've added the Custom Assemblies block to my RSReportDesigner.config and
> > my
> > RSReportServer.config. I have also added code groups to my
> > rssrvpolicy.config and rspreviewpolicy.config. I have deployed the
> > referenced dlls to the appropriate bin directories.
> >
> > The only thing that I haven't done is code the custom assembly to 'assert
> > permissions'. I shouldn't have to because the assembly takes a simple
> > string
> > and returns the encoded string - it doesn't use any 'secure' resources (no
> > files, db connections, etc.). I have also tried using 'FullTrust'
> > permissions in my code groups even though that is not recommended. In any
> > event, I do not have source code for this third party assembly nor license
> > to
> > modify it if I could.
> >
> > Is there anything I can do to make this work?
> >
> > --
> > Paul
>
>

Custom Assemblies RS 2000

Hi,

I'm creating a report with 3 parameters. The first parameter will hold the user ID. In order to get this I need to write a function to find the NT login name of the user and then search in a SQL Server Table to find what the User ID is for that user.

This user ID will be required in around 15 or so reports so I suspect a custom assembly will suit the purpose rather than adding custom code to each report.

Can anybody tell me if this sort of thing achievable?

Thanks in advance,

Steve

Sure. You can take a look at the documentation on custom assemblies here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_rdl_6d0i.asp

cursors in named query

hi...

In DSV, i am creating a "named Query", can we use 'cursors' while creating a named query ?

Thanks in advance ..

I don't believe so. Essentially the rule for named queries is that it has to be valid SQL that we can execute arbitrarily and append an ORDER BY clause at the end.