Maintenance Plan email report failure

Hello,
I have a simple daily maintenance plan for backups.(check integrity, back up, clean up history and then report) However, sending the email report always fails with the following error:

"Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.Incorrect syntax near 'sys'."

How can the wizard output Incorrect syntax?

I have set up and tested Database mail and set the default public profile.
I have enabled the mail profile in SQL server agent properties and then restarted SQL server agent.
I have set up operator to receive the mail.
The frustrating thing is that if I set up and schedule a really simple test maintenance plan, the email report works! But it always fails on the real one.
How can I get more detail in the error message and actually see the SQL it is trying to execute when it send the mail?

Thanks,
Adam

More detail.

Having done a few tests it seems that this mail report error only occurs after the check integrity job fails. eg.

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error:

"Incorrect PFS free space information for page (1:278) in object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysobjvalues' (object ID 60).

CHECKDB found 0 allocation errors and 1 consistency errors in database 'RHJ'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (RHJ).".

Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

This failure does not affect the backup and maintenance cleanup tasks that run afterwards, only the email report that it tries to send at the end.

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobias
The path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobiasThe path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

sql

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobiasThe path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

Maintanance Plan and xp_delete_file

Hi there,

i have a mp that deletes old bak, trn and txt files. It works well for bak and trn files, but it never deletes any of the report files created by other MPs.

I also can't delete any of the report files by executing the following statement (as sa or with windows login as a local admin)

EXECUTE master.dbo.xp_delete_file 1,N'D:\Backup\log',N'txt'

System ist SQL Server 2005 SP1 German

Any ideas?

Thanks in advance

regards
tobiasThe path needs to end with a '\'|||As that referred XP is an undocumented XP there might be still few features are not enabled properly, this has been logged under MS Connect http://connect.microsoft.com/SQLServer/Feedback and wait for the solution by referring to the link above.|||

Thanks for reporting the issue.

Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Customer reported issues are used to prioritize future work.

Thanks,

Sirish

|||

As an FYI for anyone else who is experiencing problems with this - one issue is now documented at http://support.microsoft.com/kb/938085

The solution seems to involve writing your own deletion script. (Many examples can be found online).

|||

This problem has been addressed in the June Cumulative Update Hotfix, available from Microsoft Customer Support.

I have asked the owner of the article you cite to update it to reflect the availability of a fix.

Thanks,

jkh

Maintaining custom colors when exporting to Excel

I am using RGB HEX #s in my report for some colors. It shows up fine when rendering to a browser, however when exporting to Excel my custom colors don't come over. I've tried creating a report.xlt file with my custom colors in it, but when I export to Excel it uses the standard Excel palette instead of the custom palette in my report.xlt.

Any ideas on how to retain my custom colors when exporting to Excel?

I faced similar issue, it seems custom colors are not supported in excel.

Maintain Report State

I have a matrix report where the user can drill down into a hierarchy to view
data for a particular product. The report also includes a parameter list
allowing the user to change the selected product.
The problem with this approach is that the user may drill to a specific
branch and then decide to switch products. At that point the report refreshes
and collapses back to the root node, because I have defined the report to
hide all groups on first entry.
Given that I am using Report Manager with no custom front end, does anyone
know of a good strategy to maintain state so that I can retain which groups
are expanded and collapsed for a particular user between instances of the
report?Modifying the Report Parameter causes the query to be executed. When this
happens the report is rendered from scratch. Hence you will not be able to
maintain the state of how the groups are displayed.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave Morrow" <DaveMorrow@.discussions.microsoft.com> wrote in message
news:413E2C03-1362-4130-A16B-F7E371D2E0F3@.microsoft.com...
>I have a matrix report where the user can drill down into a hierarchy to
>view
> data for a particular product. The report also includes a parameter list
> allowing the user to change the selected product.
> The problem with this approach is that the user may drill to a specific
> branch and then decide to switch products. At that point the report
> refreshes
> and collapses back to the root node, because I have defined the report to
> hide all groups on first entry.
> Given that I am using Report Manager with no custom front end, does anyone
> know of a good strategy to maintain state so that I can retain which
> groups
> are expanded and collapsed for a particular user between instances of the
> report?

maint. plan fails but doenst report error

Hello

I have this maint. plan where each and every step has been failing the last couple of days. The problem is, it doesn't write anything to the error logs. It only reports to the application log that each step of the plan has failed.

I suspect this might be a user rights problem, but it's difficult for me to say. What kind of rights are necessary for writing to the error logs?

In general, what rights are necessary for the user that runs the SQL Server Agent? And has anybody else experienced something similar?

MNJThis is mostly about scheduling a DTS package as a job. However, the security aspect of it should pertain to your situation as well.

Go Here: http://support.microsoft.com/default.aspx?scid=kb;en-us;269074 (Microsoft Knowledge Base Article 269074)

Main Report Page with multiple visible/nonvisible sub reports

Hi,
I have mainly the problem, that when I use a lot of subreports and
I get error messages by the report server.
Even I think it will not a got solution in matter of performance.
But how can I create a report, which will be configured by a
a field record ?
Up to now, I only use the sub reports with the function "hide " sub report.
The main page of the report will have the parameter selection box, to select
the datasets.
Depending on a record field information, I show only the depending reports,
which are shown different datas from different tables. Even different chart
data.
But I get the impression, that internally all query will be execute, even,
when the
visible flag is set to "hidden".
Need help for a better solution.
Best regards
RichardOn Nov 26, 8:59 am, Ritchie <Ritc...@.discussions.microsoft.com> wrote:
> Hi,
> I have mainly the problem, that when I use a lot of subreports and
> I get error messages by the report server.
> Even I think it will not a got solution in matter of performance.
> But how can I create a report, which will be configured by a
> a field record ?
> Up to now, I only use the sub reports with the function "hide " sub report.
> The main page of the report will have the parameter selection box, to select
> the datasets.
> Depending on a record field information, I show only the depending reports,
> which are shown different datas from different tables. Even different chart
> data.
> But I get the impression, that internally all query will be execute, even,
> when the
> visible flag is set to "hidden".
> Need help for a better solution.
> Best regards
> Richard
In terms of the auto-execution of datasets, I'm not sure; however, you
might want to include all the subreports in the main report as table
controls (where applicable). Then toggle the visibility of the
individual table controls (via: right-clicking the top-left corner of
the table control >> select Properties >> select Visibility >> select
'Visibility can be toggled by another report item' >> then select a
control from the list below 'Report item:'). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Main report drive Subreports

Will SRS support passing parameters from the main report to the subreport
which calls a stored proc that does not contain any parameters ? it will
automatically filter the data without the where clause.
I used to be able to do this in Crystal reports which I don't need to
specify a where clause in my subreport stored proc and I am not sure if SRS
will support this and I hope that I don't need to rewrite all the stored proc
for this.
Need help on this one !
ThanksRS has two different ways of filtering the data. One is to use it as a query
filter. In this case the parameter would either part of the query or passed
to a stored procedure. SQL Server would then only return the necessary data
to the report. The other possibility is to use a filter. The filter has RS
filter the data. Whatever data is defined in the dataset goes to the report
and then the report filters the data. I stay away from this because it is
much more efficient for the database to send only the necessary records to
Reporting Services. However, it sound like you want to use filters.
You would do the following. Create a subreport with a parameter. Use the
parameter in your filter. When you embed the subreport into the report then
do a right mouse click on the subreport and map the report parameter to
whatever is appropriate on the main report.
So in your case the subreport has a dataset based on a stored procedure that
has no parameters. That dataset returns the data. Then using the report
parameter passed into it by the main report, the report takes the data from
the stored procedure and filters it.
Read up in book online on filtering. You can apply the filter in multiple
spots. The value you want to filter on would be an expression which is where
you would then reference the report parameter.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
> Will SRS support passing parameters from the main report to the subreport
> which calls a stored proc that does not contain any parameters ? it will
> automatically filter the data without the where clause.
> I used to be able to do this in Crystal reports which I don't need to
> specify a where clause in my subreport stored proc and I am not sure if
> SRS
> will support this and I hope that I don't need to rewrite all the stored
> proc
> for this.
> Need help on this one !
> Thanks|||Brian,
In my report parameter, it's either a single area or all areas. The filter
works good with one area, but when I select all areas I want to have all
recordset coming back. Is there a way to conditionally turn the filter on or
off ? I only need to filter if the user select a single area.
Thanks,
Eric
"Bruce L-C [MVP]" wrote:
> RS has two different ways of filtering the data. One is to use it as a query
> filter. In this case the parameter would either part of the query or passed
> to a stored procedure. SQL Server would then only return the necessary data
> to the report. The other possibility is to use a filter. The filter has RS
> filter the data. Whatever data is defined in the dataset goes to the report
> and then the report filters the data. I stay away from this because it is
> much more efficient for the database to send only the necessary records to
> Reporting Services. However, it sound like you want to use filters.
> You would do the following. Create a subreport with a parameter. Use the
> parameter in your filter. When you embed the subreport into the report then
> do a right mouse click on the subreport and map the report parameter to
> whatever is appropriate on the main report.
> So in your case the subreport has a dataset based on a stored procedure that
> has no parameters. That dataset returns the data. Then using the report
> parameter passed into it by the main report, the report takes the data from
> the stored procedure and filters it.
> Read up in book online on filtering. You can apply the filter in multiple
> spots. The value you want to filter on would be an expression which is where
> you would then reference the report parameter.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
> news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
> > Will SRS support passing parameters from the main report to the subreport
> > which calls a stored proc that does not contain any parameters ? it will
> > automatically filter the data without the where clause.
> >
> > I used to be able to do this in Crystal reports which I don't need to
> > specify a where clause in my subreport stored proc and I am not sure if
> > SRS
> > will support this and I hope that I don't need to rewrite all the stored
> > proc
> > for this.
> >
> > Need help on this one !
> >
> > Thanks
>
>|||The filter is an expression. You should be able to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
news:00C86BEC-B4EC-4A91-8E09-D4C549915CD7@.microsoft.com...
> Brian,
> In my report parameter, it's either a single area or all areas. The filter
> works good with one area, but when I select all areas I want to have all
> recordset coming back. Is there a way to conditionally turn the filter on
> or
> off ? I only need to filter if the user select a single area.
> Thanks,
> Eric
> "Bruce L-C [MVP]" wrote:
>> RS has two different ways of filtering the data. One is to use it as a
>> query
>> filter. In this case the parameter would either part of the query or
>> passed
>> to a stored procedure. SQL Server would then only return the necessary
>> data
>> to the report. The other possibility is to use a filter. The filter has
>> RS
>> filter the data. Whatever data is defined in the dataset goes to the
>> report
>> and then the report filters the data. I stay away from this because it is
>> much more efficient for the database to send only the necessary records
>> to
>> Reporting Services. However, it sound like you want to use filters.
>> You would do the following. Create a subreport with a parameter. Use the
>> parameter in your filter. When you embed the subreport into the report
>> then
>> do a right mouse click on the subreport and map the report parameter to
>> whatever is appropriate on the main report.
>> So in your case the subreport has a dataset based on a stored procedure
>> that
>> has no parameters. That dataset returns the data. Then using the report
>> parameter passed into it by the main report, the report takes the data
>> from
>> the stored procedure and filters it.
>> Read up in book online on filtering. You can apply the filter in multiple
>> spots. The value you want to filter on would be an expression which is
>> where
>> you would then reference the report parameter.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
>> news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
>> > Will SRS support passing parameters from the main report to the
>> > subreport
>> > which calls a stored proc that does not contain any parameters ? it
>> > will
>> > automatically filter the data without the where clause.
>> >
>> > I used to be able to do this in Crystal reports which I don't need to
>> > specify a where clause in my subreport stored proc and I am not sure if
>> > SRS
>> > will support this and I hope that I don't need to rewrite all the
>> > stored
>> > proc
>> > for this.
>> >
>> > Need help on this one !
>> >
>> > Thanks
>>|||Thanks for the quick reply. I am not sure how to do this.
The way the filter works is that:
In Expression, type or select the expression for the field that you want the
filter to evaluate.
In Operator, select the operator that you want the filter to use to compare
the evaluated field and the value.
In Value, type the expression or value against which you want the filter to
evaluate the value in Expression.
Seem like you always need to assign a value to a filter, so in the case of
all values , I don't want to have a filter and how will this work with
expression ?
"Bruce L-C [MVP]" wrote:
> The filter is an expression. You should be able to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
> news:00C86BEC-B4EC-4A91-8E09-D4C549915CD7@.microsoft.com...
> > Brian,
> >
> > In my report parameter, it's either a single area or all areas. The filter
> > works good with one area, but when I select all areas I want to have all
> > recordset coming back. Is there a way to conditionally turn the filter on
> > or
> > off ? I only need to filter if the user select a single area.
> >
> > Thanks,
> > Eric
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS has two different ways of filtering the data. One is to use it as a
> >> query
> >> filter. In this case the parameter would either part of the query or
> >> passed
> >> to a stored procedure. SQL Server would then only return the necessary
> >> data
> >> to the report. The other possibility is to use a filter. The filter has
> >> RS
> >> filter the data. Whatever data is defined in the dataset goes to the
> >> report
> >> and then the report filters the data. I stay away from this because it is
> >> much more efficient for the database to send only the necessary records
> >> to
> >> Reporting Services. However, it sound like you want to use filters.
> >>
> >> You would do the following. Create a subreport with a parameter. Use the
> >> parameter in your filter. When you embed the subreport into the report
> >> then
> >> do a right mouse click on the subreport and map the report parameter to
> >> whatever is appropriate on the main report.
> >>
> >> So in your case the subreport has a dataset based on a stored procedure
> >> that
> >> has no parameters. That dataset returns the data. Then using the report
> >> parameter passed into it by the main report, the report takes the data
> >> from
> >> the stored procedure and filters it.
> >>
> >> Read up in book online on filtering. You can apply the filter in multiple
> >> spots. The value you want to filter on would be an expression which is
> >> where
> >> you would then reference the report parameter.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Eric Hu" <EricHu@.discussions.microsoft.com> wrote in message
> >> news:132A8634-04DA-4688-8C40-F53513085D43@.microsoft.com...
> >> > Will SRS support passing parameters from the main report to the
> >> > subreport
> >> > which calls a stored proc that does not contain any parameters ? it
> >> > will
> >> > automatically filter the data without the where clause.
> >> >
> >> > I used to be able to do this in Crystal reports which I don't need to
> >> > specify a where clause in my subreport stored proc and I am not sure if
> >> > SRS
> >> > will support this and I hope that I don't need to rewrite all the
> >> > stored
> >> > proc
> >> > for this.
> >> >
> >> > Need help on this one !
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>

Main report Calls subreport Sps when subreport is set to invisible.

Hello,
I have about 15 subreports in main report, and i am making then visible/invisible based on the selection criteria. Currently even i make a subreport invisible, then also i found using profiler that it is calling SP. so the performance doesnot gets improved !

I want to stop these calls when the subreport is invisible! that helps me a gr8!
OR -
Is there any setting in the config file to avoid this ?

please reply ASAP.

Thanks in advance,
Abhay Lakkad

Currently, subreports will still get executed if the end up being invisible in the main report. We will improve this in future releases.

-- Robert

|||

Just wondered if there is any kind of work-around for this, or if it will be addressed in an upcoming RS 2005 service pack.

Thanks
Marie

Main report Calls subreport Sps when subreport is set to invisible.

Hello,
I have about 15 subreports in main report, and i am making then visible/invisible based on the selection criteria. Currently even i make a subreport invisible, then also i found using profiler that it is calling SP. so the performance doesnot gets improved !

I want to stop these calls when the subreport is invisible! that helps me a gr8!
OR -
Is there any setting in the config file to avoid this ?

please reply ASAP.

Thanks in advance,
Abhay Lakkad

Currently, subreports will still get executed if the end up being invisible in the main report. We will improve this in future releases.

-- Robert

|||

Just wondered if there is any kind of work-around for this, or if it will be addressed in an upcoming RS 2005 service pack.

Thanks
Marie

Main differences between new Express Report Server and Standard one?

So far, I haven't been able to find a good list of what the major differences are between the express Reporting Server and the standard one. We are developing an application that will be doing the reporting through SQL server reporting services. Some of our smaller clients will be using SQL Server express instead of enterprise or standard. Anything majorly different in the Express version?

Check out this link - http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

Thanks,

Sharmila

|||Thanks for the reply.

I did see that comparison matrix earlier before the Express Reporting was actually relased. It seemed that they did make some changes from what they were going to do originally. I was hoping there was an up to date feature matrix as that one you linked to mentions that the reporting services still aren't available. I figure there may have been a few changes between then and now
|||

Reporting services is now available in Express with Advanced Services and the following article details that. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms365166(SQL.90).aspx

Sharmila

mailto: hyperlink

How do we put a mailto hyperlink in the report. I used an expression in 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that it is an invalid URI: host name could not be parsed. Any suggestions.
VRThat should work, check the acutal host name of the email address to make
sure it's ok.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"vrodkar" <vrodkar@.discussions.microsoft.com> wrote in message
news:2075FB1D-B624-4C6E-8CB7-F0A468594602@.microsoft.com...
> How do we put a mailto hyperlink in the report. I used an expression in
> 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that
> it is an invalid URI: host name could not be parsed. Any suggestions.
> VR|||I ran across the same problem and found it to be a data issue. The following expression in the Jump to URL validated each email address for an @. sign:
=iif(InStr( Fields!email.Value, "@.")=0,Nothing,"mailto:" + Fields!email.Value )
Hope that helps!
"vrodkar" wrote:
> How do we put a mailto hyperlink in the report. I used an expression in 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that it is an invalid URI: host name could not be parsed. Any suggestions.
> VR

mailto and picking a field for the subject line

I've put a hyperlink on a report to send a message to the support center
concerning service calls that are overdue for closure. How can I assign one
of the report fields as the subject of the mail message? For instance, if
the user clicks the 'Send Mail' link, the subject of the mail is "Call Number
"& "Field.svc00200.
Mail system is Exchange.
Many thanks
(BTW--I know 0 .net code, so keep that in mind, lol)Build the url string programmatically. I know you say you don't know
.Net but in RS a little knowledge goes a long way!
Where you would type the url, try
="mailto:" + Fields!email.Value + "&Subject=Call number" +
Fields!svc00200.Value
Chris
Jeff Metcalf wrote:
> I've put a hyperlink on a report to send a message to the support
> center concerning service calls that are overdue for closure. How
> can I assign one of the report fields as the subject of the mail
> message? For instance, if the user clicks the 'Send Mail' link, the
> subject of the mail is "Call Number "& "Field.svc00200.
> Mail system is Exchange.
> Many thanks
> (BTW--I know 0 .net code, so keep that in mind, lol)|||Nope, doesn't work. Gets Invalid URI: The hostname could not be parsed.
="Mailto:dispatch@.blah.com"+"&Subject=Call Number
"+Fields!svc00200.callnbr.Value
"Chris McGuigan" wrote:
> Build the url string programmatically. I know you say you don't know
> ..Net but in RS a little knowledge goes a long way!
> Where you would type the url, try
> ="mailto:" + Fields!email.Value + "&Subject=Call number" +
> Fields!svc00200.Value
> Chris
>
> Jeff Metcalf wrote:
> > I've put a hyperlink on a report to send a message to the support
> > center concerning service calls that are overdue for closure. How
> > can I assign one of the report fields as the subject of the mail
> > message? For instance, if the user clicks the 'Send Mail' link, the
> > subject of the mail is "Call Number "& "Field.svc00200.
> >
> > Mail system is Exchange.
> >
> > Many thanks
> > (BTW--I know 0 .net code, so keep that in mind, lol)
>|||I'm guessing it's a typo, but you have Fields!svc00200.callnbr.Value,
that doesn't look valid to me!
I have had this working, so it is possible. You probably haven't quite
got the expression right. Are there any characters in the returned
field that would effect the parsing, eg &
Chris
Jeff Metcalf wrote:
> Nope, doesn't work. Gets Invalid URI: The hostname could not be
> parsed.
> ="Mailto:dispatch@.blah.com"+"&Subject=Call Number
> "+Fields!svc00200.callnbr.Value
> "Chris McGuigan" wrote:
> > Build the url string programmatically. I know you say you don't know
> > ..Net but in RS a little knowledge goes a long way!
> > Where you would type the url, try
> > ="mailto:" + Fields!email.Value + "&Subject=Call number" +
> > Fields!svc00200.Value
> >
> > Chris
> >
> >
> > Jeff Metcalf wrote:
> >
> > > I've put a hyperlink on a report to send a message to the support
> > > center concerning service calls that are overdue for closure. How
> > > can I assign one of the report fields as the subject of the mail
> > > message? For instance, if the user clicks the 'Send Mail' link,
> > > the subject of the mail is "Call Number "& "Field.svc00200.
> > >
> > > Mail system is Exchange.
> > >
> > > Many thanks
> > > (BTW--I know 0 .net code, so keep that in mind, lol)
> >
> >

Mailing Reports

Hi,
I am rendering a report in PDF Format when a user needs in my Web Form(on
click of a button)
When this report is rendered in PDF format, Is there a way to send him the
report by Email.
An Email has to be sent when a report is rendered by a particular user.
Is there an option for this...
Thanks
KiranKiran:
I was coming in to ask a similar question. I know what you want to do can be
done through subscriptions, and I have looked at the database table where
subscriptions are stored and I believe it would just be a matter of inserting
a onetime subscription line into the subscription table. But what I want to
know is there any resource out there taht tells you how to add lines to the
subscription table. I have been thinking of purchasing hitchhikers guide but
I am unsure if it is going to help me with anything I do not already know.
"Kiran" wrote:
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>
>|||Since you have your own webform here is another option for you (although
doing a one time subscription will work as well) but you might find this
easier. Save the PDF as a file and then send it using the following SMTP
client. This SMTP client requires no install of any mail client. You need to
have a SMTP server somewhere for this to work. It is very easy to use and is
widely used in the SQL Server community.
http://sqldev.net/xp/xpsmtp.htm
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kiran" <Kiran@.nospam.net> wrote in message
news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>|||Hi Bruce,
How will I save the PDF on the server so as to mail it.
Thanks
Kiran
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eBl8qd3DFHA.576@.TK2MSFTNGP15.phx.gbl...
> Since you have your own webform here is another option for you (although
> doing a one time subscription will work as well) but you might find this
> easier. Save the PDF as a file and then send it using the following SMTP
> client. This SMTP client requires no install of any mail client. You need
> to
> have a SMTP server somewhere for this to work. It is very easy to use and
> is
> widely used in the SQL Server community.
> http://sqldev.net/xp/xpsmtp.htm
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Kiran" <Kiran@.nospam.net> wrote in message
> news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> I am rendering a report in PDF Format when a user needs in my Web Form(on
>> click of a button)
>> When this report is rendered in PDF format, Is there a way to send him
>> the
>> report by Email.
>> An Email has to be sent when a report is rendered by a particular user.
>> Is there an option for this...
>> Thanks
>> Kiran
>>
>|||Bruce; That was very helpful.. but is there a reference to where I can add
the subscription to the database through my application?
thanks
"Bruce L-C [MVP]" wrote:
> Since you have your own webform here is another option for you (although
> doing a one time subscription will work as well) but you might find this
> easier. Save the PDF as a file and then send it using the following SMTP
> client. This SMTP client requires no install of any mail client. You need to
> have a SMTP server somewhere for this to work. It is very easy to use and is
> widely used in the SQL Server community.
> http://sqldev.net/xp/xpsmtp.htm
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Kiran" <Kiran@.nospam.net> wrote in message
> news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I am rendering a report in PDF Format when a user needs in my Web Form(on
> > click of a button)
> >
> > When this report is rendered in PDF format, Is there a way to send him the
> > report by Email.
> >
> > An Email has to be sent when a report is rendered by a particular user.
> >
> > Is there an option for this...
> >
> > Thanks
> > Kiran
> >
> >
>
>|||To add a subscription from you web app you have to use soap (web services)
if you have been using URL integration then you need to learn how to use the
web services to accomplish this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Patrick K" <PatrickK@.discussions.microsoft.com> wrote in message
news:162C8BD3-843B-44FE-A968-3A08770105E4@.microsoft.com...
> Bruce; That was very helpful.. but is there a reference to where I can add
> the subscription to the database through my application?
> thanks
> "Bruce L-C [MVP]" wrote:
> > Since you have your own webform here is another option for you (although
> > doing a one time subscription will work as well) but you might find this
> > easier. Save the PDF as a file and then send it using the following SMTP
> > client. This SMTP client requires no install of any mail client. You
need to
> > have a SMTP server somewhere for this to work. It is very easy to use
and is
> > widely used in the SQL Server community.
> >
> > http://sqldev.net/xp/xpsmtp.htm
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Kiran" <Kiran@.nospam.net> wrote in message
> > news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I am rendering a report in PDF Format when a user needs in my Web
Form(on
> > > click of a button)
> > >
> > > When this report is rendered in PDF format, Is there a way to send him
the
> > > report by Email.
> > >
> > > An Email has to be sent when a report is rendered by a particular
user.
> > >
> > > Is there an option for this...
> > >
> > > Thanks
> > > Kiran
> > >
> > >
> >
> >
> >|||I know it is possible but I haven't been programming asp.net for awhile now
so I can't help you with that.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kiran" <Kiran@.nospam.net> wrote in message
news:%230kCjB4DFHA.1496@.TK2MSFTNGP14.phx.gbl...
> Hi Bruce,
> How will I save the PDF on the server so as to mail it.
> Thanks
> Kiran
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eBl8qd3DFHA.576@.TK2MSFTNGP15.phx.gbl...
> > Since you have your own webform here is another option for you (although
> > doing a one time subscription will work as well) but you might find this
> > easier. Save the PDF as a file and then send it using the following SMTP
> > client. This SMTP client requires no install of any mail client. You
need
> > to
> > have a SMTP server somewhere for this to work. It is very easy to use
and
> > is
> > widely used in the SQL Server community.
> >
> > http://sqldev.net/xp/xpsmtp.htm
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Kiran" <Kiran@.nospam.net> wrote in message
> > news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> >> Hi,
> >>
> >> I am rendering a report in PDF Format when a user needs in my Web
Form(on
> >> click of a button)
> >>
> >> When this report is rendered in PDF format, Is there a way to send him
> >> the
> >> report by Email.
> >>
> >> An Email has to be sent when a report is rendered by a particular user.
> >>
> >> Is there an option for this...
> >>
> >> Thanks
> >> Kiran
> >>
> >>
> >
> >
>|||I have a similar question.
I am using the email provider available out of the box with reporting
services. I am on a flat network using 2 separated domains (resource and
user)and Routed IP schemes. The companies email is handled offsite using an
SMTP server that requires the user to login. There does not appear to be an
option to do this using the out of the box delivery method. And
unfortunately I do not know enough about setting up my own SMTP server
locally. I am trying to mail the reports from the resource domain to the
user domain.
--Eric Cathell, MCSA
"Kiran" <Kiran@.nospam.net> wrote in message
news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>

mailing labels in SQL Server Reporting Services

I am creating a report to be used to print mailing labels. Size 1" x 2 5/8" (3 columns of 10 labels). I seem to have everything but the vertical spacing working properly. I have used a rectangle set to the size of the labels which contains a list box containing text boxes containing expressions to pull in the fields. Some of the street addresses are two lines with the majority being only one line.

I have joined the two fields containing the street addresses and inserted a new line command so each field will print on its own line but yet be contained within the same text box. Everything except the text box containing the street addresses are set to not increase or decrease. My problem is that on the pages of the report where labels vary between the one and two line street addresses the labels tend to creep down which in some cases causes data to be printed over two labels. Any ideas on what I can do to format these to print properly?

Thanks

How did you create 3 columns mailing labels? Is there a way in reporting services to display the data in 3 columns?

Thanks

|||

Report Properties menu on the Layout Tab the first section lets you specify the number of columns and spacing for your report. I then set up a rectangle the size of the label, added a list box and the fields for the data to be shown.

|||

I changed the layout, and added 2 columns to my report, my fields are in a list control, when i preview the report it just shows in one column, the other column is not even displayed, do you know what I could be doing wrong, I am sure it is something silly?

Thanks again

Espy

|||In preview I also only see one column but if you use the print preview you should see all columns. (Took me a few tries to get all this figured out too!). Hope that helps.|||

I did the print layout and get a black screen with nothing in it

When I printed the report it just printed one column

I am not sure what I am doing wrong

Any other suggestions?

thanks for your help

|||

Sorry, I may not be much help in explaining your results; but, below are the Layout settings I have used and I have walked back through the steps: I started a blank report; went to Report - Report Properties - Layout and set the following

Columns: 3; Spacing 0.125 in

Page Width: 8.5in; Page Height: 11 in

Left margin: 0.25in; right margin: 0.125in

Top margin: 0.4in; Bottom margin: 0.5in

Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck.

|||

I was able to make it work

Thanks for your help

|||

Hi

am new to reporting service. I need to do label printing in two columns. that is coming in one column. I changed the layout-columns -2.Is it needed to change anything else ? Its showing in one column. .Please suggest anything. Your earlier conversation helped alot. Thank You very much........

|||

The following may be what you need next, repeating part of my reply posted earlier:

"Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck."

|||

I tried that. now its comin in 2 column, but value that came in the first column is repeating in second column. But in print preview only the second column is showing. adjusted the rectangle. Some silly mistakes will be there. Then, I need 8 labels in 1 column, but only 6 is coming. I increased the report size. but no use. Please help

|||Sorry for the delay in responding to you. Did you get your question resolved? If not, I reviewed the previous posts and then recreated a label. Make sure that in your report properties (menu choice Report - Report Properties - Layout) you have specified the number of columns (8 in your case), your page width and height to match the sheet of labels, and the margins to match the sheet of labels. I then refined the Body of the report; inserted a list box linked to the data source - and sized to match the size of the label; inserted a rectangle sized to match the size of the label and then inserted text boxes with the fields I want to show. From there its just fine-tuning the margins, padding, etc. Please note that I never did get a response addressing my original question though. Hope this helps to answer your question.|||

I am very thankful to you. I got it in a nice maaner by increasing the page width. But I integrated to the program it is not showing that alignment. I am thinking font mismatch will b there . But its not working for me. If u hav any idea pls suggest that. That will help me very much. I am Sure. Thanks alot for ur proper guidings........

|||

Hi

My reports are coming correctly. But the pbms am facing is that,

If am giving page range in print preview(1-2) then 1st page 'll be showing and 2nd page's 1st column [ If 1-3 then 1st,2nd and 3rd page's 1st col; 1-1 means 1st page's ist column]

if it is coming row wise it 'll be helpful.

|||We encountered the same problem - our "fix" was to render in PDF when wanting to print only certain pages. Once entire report is in pdf then you can print specified pages.

mailing labels in SQL Server Reporting Services

I am creating a report to be used to print mailing labels. Size 1" x 2 5/8" (3 columns of 10 labels). I seem to have everything but the vertical spacing working properly. I have used a rectangle set to the size of the labels which contains a list box containing text boxes containing expressions to pull in the fields. Some of the street addresses are two lines with the majority being only one line.

I have joined the two fields containing the street addresses and inserted a new line command so each field will print on its own line but yet be contained within the same text box. Everything except the text box containing the street addresses are set to not increase or decrease. My problem is that on the pages of the report where labels vary between the one and two line street addresses the labels tend to creep down which in some cases causes data to be printed over two labels. Any ideas on what I can do to format these to print properly?

Thanks

How did you create 3 columns mailing labels? Is there a way in reporting services to display the data in 3 columns?

Thanks

|||

Report Properties menu on the Layout Tab the first section lets you specify the number of columns and spacing for your report. I then set up a rectangle the size of the label, added a list box and the fields for the data to be shown.

|||

I changed the layout, and added 2 columns to my report, my fields are in a list control, when i preview the report it just shows in one column, the other column is not even displayed, do you know what I could be doing wrong, I am sure it is something silly?

Thanks again

Espy

|||In preview I also only see one column but if you use the print preview you should see all columns. (Took me a few tries to get all this figured out too!). Hope that helps.|||

I did the print layout and get a black screen with nothing in it

When I printed the report it just printed one column

I am not sure what I am doing wrong

Any other suggestions?

thanks for your help

|||

Sorry, I may not be much help in explaining your results; but, below are the Layout settings I have used and I have walked back through the steps: I started a blank report; went to Report - Report Properties - Layout and set the following

Columns: 3; Spacing 0.125 in

Page Width: 8.5in; Page Height: 11 in

Left margin: 0.25in; right margin: 0.125in

Top margin: 0.4in; Bottom margin: 0.5in

Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck.

|||

I was able to make it work

Thanks for your help

|||

Hi

am new to reporting service. I need to do label printing in two columns. that is coming in one column. I changed the layout-columns -2.Is it needed to change anything else ? Its showing in one column. .Please suggest anything. Your earlier conversation helped alot. Thank You very much........

|||

The following may be what you need next, repeating part of my reply posted earlier:

"Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck."

|||

I tried that. now its comin in 2 column, but value that came in the first column is repeating in second column. But in print preview only the second column is showing. adjusted the rectangle. Some silly mistakes will be there. Then, I need 8 labels in 1 column, but only 6 is coming. I increased the report size. but no use. Please help

|||Sorry for the delay in responding to you. Did you get your question resolved? If not, I reviewed the previous posts and then recreated a label. Make sure that in your report properties (menu choice Report - Report Properties - Layout) you have specified the number of columns (8 in your case), your page width and height to match the sheet of labels, and the margins to match the sheet of labels. I then refined the Body of the report; inserted a list box linked to the data source - and sized to match the size of the label; inserted a rectangle sized to match the size of the label and then inserted text boxes with the fields I want to show. From there its just fine-tuning the margins, padding, etc. Please note that I never did get a response addressing my original question though. Hope this helps to answer your question.|||

I am very thankful to you. I got it in a nice maaner by increasing the page width. But I integrated to the program it is not showing that alignment. I am thinking font mismatch will b there . But its not working for me. If u hav any idea pls suggest that. That will help me very much. I am Sure. Thanks alot for ur proper guidings........

|||

Hi

My reports are coming correctly. But the pbms am facing is that,

If am giving page range in print preview(1-2) then 1st page 'll be showing and 2nd page's 1st column [ If 1-3 then 1st,2nd and 3rd page's 1st col; 1-1 means 1st page's ist column]

if it is coming row wise it 'll be helpful.

|||We encountered the same problem - our "fix" was to render in PDF when wanting to print only certain pages. Once entire report is in pdf then you can print specified pages.

mailing labels in SQL Server Reporting Services

I am creating a report to be used to print mailing labels. Size 1" x 2 5/8" (3 columns of 10 labels). I seem to have everything but the vertical spacing working properly. I have used a rectangle set to the size of the labels which contains a list box containing text boxes containing expressions to pull in the fields. Some of the street addresses are two lines with the majority being only one line.

I have joined the two fields containing the street addresses and inserted a new line command so each field will print on its own line but yet be contained within the same text box. Everything except the text box containing the street addresses are set to not increase or decrease. My problem is that on the pages of the report where labels vary between the one and two line street addresses the labels tend to creep down which in some cases causes data to be printed over two labels. Any ideas on what I can do to format these to print properly?

Thanks

How did you create 3 columns mailing labels? Is there a way in reporting services to display the data in 3 columns?

Thanks

|||

Report Properties menu on the Layout Tab the first section lets you specify the number of columns and spacing for your report. I then set up a rectangle the size of the label, added a list box and the fields for the data to be shown.

|||

I changed the layout, and added 2 columns to my report, my fields are in a list control, when i preview the report it just shows in one column, the other column is not even displayed, do you know what I could be doing wrong, I am sure it is something silly?

Thanks again

Espy

|||In preview I also only see one column but if you use the print preview you should see all columns. (Took me a few tries to get all this figured out too!). Hope that helps.|||

I did the print layout and get a black screen with nothing in it

When I printed the report it just printed one column

I am not sure what I am doing wrong

Any other suggestions?

thanks for your help

|||

Sorry, I may not be much help in explaining your results; but, below are the Layout settings I have used and I have walked back through the steps: I started a blank report; went to Report - Report Properties - Layout and set the following

Columns: 3; Spacing 0.125 in

Page Width: 8.5in; Page Height: 11 in

Left margin: 0.25in; right margin: 0.125in

Top margin: 0.4in; Bottom margin: 0.5in

Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck.

|||

I was able to make it work

Thanks for your help

|||

Hi

am new to reporting service. I need to do label printing in two columns. that is coming in one column. I changed the layout-columns -2.Is it needed to change anything else ? Its showing in one column. .Please suggest anything. Your earlier conversation helped alot. Thank You very much........

|||

The following may be what you need next, repeating part of my reply posted earlier:

"Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck."

|||

I tried that. now its comin in 2 column, but value that came in the first column is repeating in second column. But in print preview only the second column is showing. adjusted the rectangle. Some silly mistakes will be there. Then, I need 8 labels in 1 column, but only 6 is coming. I increased the report size. but no use. Please help

|||Sorry for the delay in responding to you. Did you get your question resolved? If not, I reviewed the previous posts and then recreated a label. Make sure that in your report properties (menu choice Report - Report Properties - Layout) you have specified the number of columns (8 in your case), your page width and height to match the sheet of labels, and the margins to match the sheet of labels. I then refined the Body of the report; inserted a list box linked to the data source - and sized to match the size of the label; inserted a rectangle sized to match the size of the label and then inserted text boxes with the fields I want to show. From there its just fine-tuning the margins, padding, etc. Please note that I never did get a response addressing my original question though. Hope this helps to answer your question.|||

I am very thankful to you. I got it in a nice maaner by increasing the page width. But I integrated to the program it is not showing that alignment. I am thinking font mismatch will b there . But its not working for me. If u hav any idea pls suggest that. That will help me very much. I am Sure. Thanks alot for ur proper guidings........

|||

Hi

My reports are coming correctly. But the pbms am facing is that,

If am giving page range in print preview(1-2) then 1st page 'll be showing and 2nd page's 1st column [ If 1-3 then 1st,2nd and 3rd page's 1st col; 1-1 means 1st page's ist column]

if it is coming row wise it 'll be helpful.

|||We encountered the same problem - our "fix" was to render in PDF when wanting to print only certain pages. Once entire report is in pdf then you can print specified pages.

Mailing Labels from a subreport?

I have a main report which is essentially a letter. When the letter is
completed, I have a SubReport which are mailing labels. In the sub report I
have 2 columns and in the main report I have 1 column. When I run the main
report, I only get 1 column of Labels. When I run the subreport I get the 2
columns that I'm looking for.
Any suggestions on how I can get the main report to show 2 columns of Labels?
Regarding the dimension of the Main Report:
Report
Margin .5 Left, .5 Right, .5 Top, .5 Bottom
Page Size 7.5in Width, 11in Height
Body
Columns 1
Size 7.5in, 21.7448in
On the Sub Report :
Columns 2
Column Spacing .25
Size 3.5in, 0.73958in
Is this possible?
Thanks!I've done some research and such a thing is not possible. The columns is
driven from the top level report.
I am thinking of a work-around:
I'll essentially have 2 datasets one on the left and one on the right. They
will both call the same stored procedure to get the label. However, the left
side will call with a parameter of "Even" and the right with "Odd". The only
rows that will be returned on the left will be the ones that are moded by
Even Numbers. The only rows that will be returned on the right will be the
ones moded by Odd Numbers. To get this Even/Odd in the stored procedure, I
will have an identity column.
"CraigZello" wrote:
> I have a main report which is essentially a letter. When the letter is
> completed, I have a SubReport which are mailing labels. In the sub report I
> have 2 columns and in the main report I have 1 column. When I run the main
> report, I only get 1 column of Labels. When I run the subreport I get the 2
> columns that I'm looking for.
> Any suggestions on how I can get the main report to show 2 columns of Labels?
> Regarding the dimension of the Main Report:
> Report
> Margin .5 Left, .5 Right, .5 Top, .5 Bottom
> Page Size 7.5in Width, 11in Height
> Body
> Columns 1
> Size 7.5in, 21.7448in
>
> On the Sub Report :
> Columns 2
> Column Spacing .25
> Size 3.5in, 0.73958in
> Is this possible?
> Thanks!
>
>