Embedding a Report Within Page

Ok, I am getting extremely frustrated here, so I hope someone can help me.

I am trying to pass a parameter to a reportviewer control that is supposed to run a server report. This is how I am doing this:

Dim serverParams(0) As ReportParameter
serverParams(0) = New ReportParameter("RMAID", "3")
Me.RMAReport.ServerReport.ReportServerUrl = New Uri("http://MEDUSA/reportserver")
Me.RMAReport.ServerReport.ReportPath = "/CustomerServiceReports/RMAListingsById"
Me.RMAReport.ServerReport.SetParameters(serverParams)
Me.RMAReport.ServerReport.Refresh()

Now as far as I can tell this should work, but no matter what I do I get

Execution '' Cannot Be Found

Then I can not run any of the server reports at all, not just this one. Going to the reportserver I can run this report just fine. I just can't seem to get it so that this will render. Could someone please help me, I am about to go nuts!!!!

Thank you,

Josh

Ok, so I solved this problem by going from remote processing to local processing...I now have ran into another issue...I'll copy from my post over at the sql server 2005 forums where i have yet to receive a response....

Ok, I have been struggling with getting a report to run that I can pass parameters to for two days now, I have finally made progress on that front from going to local processing vs remote processing.

Now though I am about to pitch my computer underneath a truck if I don't get this solved shortly. I have two subreports as a part of this report. They aresupposedto be passed the id value as a parameter from the parent report. I found out that I still have to set data sources for these sub reports, so I attached the subreportprocessing event to the report viewer and attached the datasources that I created. My problem, I assume, is I don't understand how the dataset is supposed to be defined. I have tried three different ways. I built one dataset that has the relations to the two different tables that the sub reports use and built 3 distinct object data sources that reference the appropriate table adapters in the single dataset and I run the report.

Result I get every record in both tables for each record in the parent report

So next I tried creating three distinct datasets referencing the individual tables that the three reports would use (1 parent 2 child) and assign the datasources to the table adapters for the relevant reports and assigned them in the event.

Result I get every record in both tables for each record in the parent report

Finally I change the dataset to use a parameter to filter out the rows to only be the one for the relevant record in the report. I use the exact same name as the parameter that issupposedto be being passed from the parent report and assign accordingly in the subreportprocessing event

Result I get no error but I get no data either. I am assuming because it is not getting a parameter value.

I can find almost no information on this at all...I'm bashing my head on my desk yelling "WHY?"....this should not be this hard...please someone advise me in the proper direction. If you need any source samples please let me know....

|||

Does anyone have any ideas? I am running out of time to figure this out?

Thank you,

Josh

|||

Hello there:

In case you didn't play this drillthrough sample on:

http://www.gotreportviewer.com/

I am fighting for different issues with this reportviewer. It takes to long to figure out things that is supposed to be documented.

Good luck.

|||

I have spent a lot of time on that site, but it doesn't seem to have what I need.

Unfortunately I am not using drillthrough reports but just two sub reports...I implemented their sub reports exactly as they did except with sql instead of xml, but like I noted I return all results rather than the filtered results.

This truly should not be this hard....I have never wanted to go back to crystal reports until now....this is truly hurting my deadline...

Josh

|||

The reportviewer control is really meant to be used with local reports. Probably if you switched over to fully using the the report server or the reportviewer with local reports, you'll eliminate many of your difficulties.

|||

Hello again:

I look at the sample for the subreport and I found the way you assigned the parameter was different from the sample.

"Finally I change the dataset to use a parameter to filter out the rowsto only be the one for the relevant record in the report. I use theexact same name as the parameter that issupposedto be being passed from the parent report and assign accordingly in the subreportprocessing event"

Actually, you can assign the parameter through the property of the subreport: right click on your subreport> subreport Properties>Parameters: under this tab, you assign your parameter name and value. For example, mainID-- Field!mainID.Value.

I have read tons to find more about this control. I don't know whether this can fix your problem.

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="100%" Width="100%" AsyncRendering="False" SizeToReportContent="True">
<LocalReport ReportPath="YourMainReport.rdlc" OnSubreportProcessing="ReportViewer1_SubreportProcessing">
</LocalReport>
</rsweb:ReportViewer>

I think in OnSubreportProcessing you simply assign your subreport dataset to datasource. Another thing is to make sure the name of these datasets: yourDataset_yourDatatable. They have to be consistent with the definition in the source of your .rdlc files. You can check them to make sure.

I am close to get what I want to implement. I hope I can share with you with my findings.

|||

Limno,

You are right, I was doing it incorrectly. I solved my problem yesterday by a stroke of luck. You are right in the assumption that I was looking at the parameters incorrectly...I actually needed to pass all possible values to the sub report through the data source. I then needed to go in and make sure filtering was set up on the table that I was using to properly utilize the parameters passed to it. I wish this had been more clear in the documentation, or mentioned at all really, but it wasn't. Anyways, thank you for all of your help and if there is anything I can help with in your problem, please let me know!

Thanks,

Josh

Embed ASP page INSIDE my report

I would like to embed an .ASP page INSIDE my report...
I know I can add images inside through URL. But can add an asp page?
Can I do that with custom assembly?
If not, what version of reporting services would allow us to do so.
ThanksNo way I know of doing this. People have asked to be able to embed other
controls in a report which we'll look at doing but nothing concrete right
now.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407151625.4b36183f@.posting.google.com...
> I would like to embed an .ASP page INSIDE my report...
> I know I can add images inside through URL. But can add an asp page?
> Can I do that with custom assembly?
> If not, what version of reporting services would allow us to do so.
> Thanks

Emailing report details

Hi,
I have a simple report that displays a page of text. I want to add a
button to it and
when the button is clicked a new outlook email is created with the
report as body, ready for the user to enter an email address.
Yes I know reports have subscriptions, they want a more adhoc
solution.
And users don't want the extra clicks of saving the report to file and
attaching it themselves.
Can it be done, is there an example?
thanks in advance.On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> Hi,
> I have a simple report that displays a page of text. I want to add a
> button to it and
> when the button is clicked a new outlook email is created with the
> report as body, ready for the user to enter an email address.
> Yes I know reports have subscriptions, they want a more adhoc
> solution.
> And users don't want the extra clicks of saving the report to file and
> attaching it themselves.
> Can it be done, is there an example?
> thanks in advance.
There are not really any options available for this type of
functionality (aside from what you mentioned). If exporting the report
to PDF and attaching it to an email is an option, I would suggest
going the custom/ASP.NET application route. There is an open source
library available that can assist you in doing this: iTextSharp
(http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
). Otherwise, you will need to design a custom application that
includes a report viewer control that incorporates an SSRS report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > Hi,
> > I have a simple report that displays a page of text. I want to add a
> > button to it and
> > when the button is clicked a new outlook email is created with the
> > report as body, ready for the user to enter an email address.
> > Yes I know reports have subscriptions, they want a more adhoc
> > solution.
> > And users don't want the extra clicks of saving the report to file and
> > attaching it themselves.
> > Can it be done, is there an example?
> > thanks in advance.
> There are not really any options available for this type of
> functionality (aside from what you mentioned). If exporting the report
> to PDF and attaching it to an email is an option, I would suggest
> going the custom/ASP.NET application route. There is an open source
> library available that can assist you in doing this: iTextSharp
> (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourceforge.net/tutorial/
> ). Otherwise, you will need to design a custom application that
> includes a report viewer control that incorporates an SSRS report.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
****************************
thanks Enrique|||On Aug 2, 9:05 pm, paulhux...@.hotmail.com wrote:
> On Aug 3, 11:31 am, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Aug 1, 11:07 pm, paulhux...@.hotmail.com wrote:
> > > Hi,
> > > I have a simple report that displays a page of text. I want to add a
> > > button to it and
> > > when the button is clicked a new outlook email is created with the
> > > report as body, ready for the user to enter an email address.
> > > Yes I know reports have subscriptions, they want a more adhoc
> > > solution.
> > > And users don't want the extra clicks of saving the report to file and
> > > attaching it themselves.
> > > Can it be done, is there an example?
> > > thanks in advance.
> > There are not really any options available for this type of
> > functionality (aside from what you mentioned). If exporting the report
> > to PDF and attaching it to an email is an option, I would suggest
> > going the custom/ASP.NET application route. There is an open source
> > library available that can assist you in doing this: iTextSharp
> > (http://sourceforge.net/projects/itextsharp/http://itextsharp.sourcefo...
> > ). Otherwise, you will need to design a custom application that
> > includes a report viewer control that incorporates an SSRS report.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> ****************************
> thanks Enrique
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Emailing

Not sure if this can be done but I have a report that gets run that has a
different page for each client it is run for. It doesnt necessarily have a
parameter. What my question is, is there a way to email each different page
to the specific client it is run for. Say I ran the report and it had 10
pages and on each page was a separate client. After the report is ran, how
can I get it to automatically send each specific page to its respectful
owner?I dont think it is a proper approach to do if the client doesn;t mind
or you Either seeing others information.
The proper approach should be have a parameter, Create subscriptions
for the 10 users.
Thats good
Thanks
Raj deep.A|||Clients dont want to see each others info and dont want others seeing their
info!
"RajDeep" <rajalapati@.gmail.com> wrote in message
news:c63098f5-ed9b-405d-851a-7f6e29f12769@.q27g2000prf.googlegroups.com...
>I dont think it is a proper approach to do if the client doesn;t mind
> or you Either seeing others information.
> The proper approach should be have a parameter, Create subscriptions
> for the 10 users.
> Thats good
> Thanks
> Raj deep.A|||On Apr 30, 5:58=A0pm, "Ben Watts" <lunuticsho...@.hotmail.com> wrote:
> Clients dont want to see each others info and dont want others seeing thei=r
> info!
> "RajDeep" <rajalap...@.gmail.com> wrote in message
> news:c63098f5-ed9b-405d-851a-7f6e29f12769@.q27g2000prf.googlegroups.com...
>
> >I dont think it is a proper approach to do if the client doesn;t mind
> > or you =A0Either seeing others information.
> > The proper approach should be have a parameter, Create subscriptions
> > for the 10 users.
> > Thats good
> > Thanks
> > Raj deep.A- Hide quoted text -
> - Show quoted text -
Are you running the Enterprise Editon? If so you MAY (running
Developer Edition here so don't know for sure whether you can or not)
be able to accomplish what you want with a data driven subscription.
Even if you can, I'm thinking you'll still need to parameterize your
query.
Without Enterprise, I agree with Rajdeep. You're going to have to use
a parameter for client ID and then probably create separate
subscriptions for each client.sql

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email on demand

Looking for an example of sending a 2005 RS report via a web page on demand.
I would need to fire it when a user clicked a button on the web form.
In the old days, in plain old ASP, we used to build an HTML formatted email
body and then fire it off using CDO. We could still do that with ASPX but
I'd much prefer to build a report in RS (more formatting and doc type options)
and then fire it off.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1On Oct 3, 1:07 pm, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Looking for an example of sending a 2005 RS report via a web page on demand.
> I would need to fire it when a user clicked a button on the web form.
> In the old days, in plain old ASP, we used to build an HTML formatted email
> body and then fire it off using CDO. We could still do that with ASPX but
> I'd much prefer to build a report in RS (more formatting and doc type options)
> and then fire it off.
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
This link should help.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
You will want to create a Proxy (Web Reference) to
ReportingService2005.asmx. Then attach the newly created file to an
email created via ASP.NET. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
Thanks for the info.
EMartinez wrote:
>> Looking for an example of sending a 2005 RS report via a web page on demand.
>> I would need to fire it when a user clicked a button on the web form.
>[quoted text clipped - 6 lines]
>> --
>> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
>This link should help.
>http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
>You will want to create a Proxy (Web Reference) to
>ReportingService2005.asmx. Then attach the newly created file to an
>email created via ASP.NET. Hope this helps.
>Regards,
>Enrique Martinez
>Sr. Software Consultant
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1|||On Oct 4, 11:04 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Enrique,
> Thanks for the info.
>
> EMartinez wrote:
> >> Looking for an example of sending a 2005 RS report via a web page on demand.
> >> I would need to fire it when a user clicked a button on the web form.
> >[quoted text clipped - 6 lines]
> >> --
> >> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
> >This link should help.
> >http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingser...
> >You will want to create a Proxy (Web Reference) to
> >ReportingService2005.asmx. Then attach the newly created file to an
> >email created via ASP.NET. Hope this helps.
> >Regards,
> >Enrique Martinez
> >Sr. Software Consultant
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Eliminating blank pages when printing

I have a report which prints an employee information sheet for multiple
employees - with each employee' sinformation on a separate page. When I view
and navigate through this online, I see one page per employee (which is
correct). However, when I print this report, I get a blank page (with the
page header but no employee data) inbetween each correct/full page. Is there
a way to suppress these blank pages?
FYI - the report data and section defined sizes are not big enough to cause
another page to spit out for each employee record.
Thank you in advance.On Nov 1, 1:42 pm, "Michael K. Walter" <mkwal...@.sqlcraft.com> wrote:
> I have a report which prints an employee information sheet for multiple
> employees - with each employee' sinformation on a separate page. When I view
> and navigate through this online, I see one page per employee (which is
> correct). However, when I print this report, I get a blank page (with the
> page header but no employee data) inbetween each correct/full page. Is there
> a way to suppress these blank pages?
> FYI - the report data and section defined sizes are not big enough to cause
> another page to spit out for each employee record.
> Thank you in advance.
If you are exporting to PDF format, this is pretty common. If so,
encapsulating a majority of your table/matrix controls (where
applicable) in a single rectangle control could be helpful. Also, you
might want to check your margins (via: Layout view >> Report drop-down
tab >> Report Properties... >> Layout) and possibly reduce them.
Another thing to check is how wide your report is in Layout view.
Normally, you will want to keep it at or below 6.5". Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 1, 11:42 pm, "Michael K. Walter" <mkwal...@.sqlcraft.com> wrote:
> I have a report which prints an employee information sheet for multiple
> employees - with each employee' sinformation on a separate page. When I view
> and navigate through this online, I see one page per employee (which is
> correct). However, when I print this report, I get a blank page (with the
> page header but no employee data) inbetween each correct/full page. Is there
> a way to suppress these blank pages?
> FYI - the report data and section defined sizes are not big enough to cause
> another page to spit out for each employee record.
> Thank you in advance.
Hi Micheal
Check with your page width & height. B'coz of the width & height is
not fixing the one page that the reason Ur getting blank page while
taking printout..
Thanks
Sundaraguru S

Efficient table record size

I understand that I can put a massive 8K varchar in one data page, but I want to know if that is the best design.

I have a data stream that can be from 10 to 7000 characters. 90% of the time the field data length is less than 700 characters. Is it better to create one massive varchar field or to create multiple smaller varchar fields? (Perhaps varchar(700) fields ten times.) Or does it matter?

(Also, the record is primarily inserted once then just read from then on.)

The query with the smaller fields would look like this:

SELECT RTRIM(
LEFT( ReportStream1 + SPACE(700), 700) +
LEFT(ISNULL(ReportStream2 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream3 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream4 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream5 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream6 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream7 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream8 , '') + SPACE(700), 700) +
LEFT(ISNULL(ReportStream9 , '') + SPACE(700), 700)
)
FROM ReportStream
WHERE StreamID = 123

It depends on what you want to do with the data. If the data is always selected as one chunk, performance wise, it is better to store it as a single column.

For each varchar column, you get a little bit storage overhead (about 2 bytes per column) that will be stored as well, so having one column is better from storage point of view.

However, if you frequently want to query subsets of your string (i.e. you only are interested in the first few characters, and want to do queries based on that), it makes more sense to have multiple columns, so that you can more easily query and index these substrings.

Thanks,

Marcel van der Holst
[MSFT]

Editing Varchar field in Enterprise Manager

I am using SQL 2000. In a table (tblTestTable) I have a field VARHCAR(4000).
the field stores text taken from a text area in a web page so contains new line characters also length is around 2000 characters.

The problem is that I am unable to edit the text in this field through Enterprise Manager. The text remains as if it is readonly. All I can do is select entire text and cut or delete. :confused:
Is there reason for this occurance? How can it beovercome?Don't use EM?

It really wasn't made for that purpose, but I'll have a look.