I am tring to format a mailto command for an email field.
Properites - Navigation - Jump to URL option
mailto:// Fields!email_address.ValueFields!
This opens mail and inserts
TO: // Fields!email_address.ValueFields!
not the field data joe@.joeco.com
Thanks in advance.Have you tried this?
= "mailto://" & Fields!email_address.Value
"Bob" wrote:
> I am tring to format a mailto command for an email field.
> Properites - Navigation - Jump to URL option
> mailto:// Fields!email_address.ValueFields!
> This opens mail and inserts
> TO: // Fields!email_address.ValueFields!
> not the field data joe@.joeco.com
> Thanks in advance.
>|||I got it to work with = "mailto:" & Fields!email_address.Value
"isaak" wrote:
> Have you tried this?
> = "mailto://" & Fields!email_address.Value
> "Bob" wrote:
> > I am tring to format a mailto command for an email field.
> > Properites - Navigation - Jump to URL option
> > mailto:// Fields!email_address.ValueFields!
> >
> > This opens mail and inserts
> > TO: // Fields!email_address.ValueFields!
> > not the field data joe@.joeco.com
> >
> > Thanks in advance.
> >
> >
Showing posts with label email. Show all posts
Showing posts with label email. Show all posts
Wednesday, March 21, 2012
Formatting exported Reports in Excel
Hi All,
I'm using SQL Services 2000, and have a report with 3 tables. I export
this to Excel and use Subscriptions to email this report daily. I have
inserted page breaks after each table and so each table gets printed
on separate sheets in the Excel spreadsheet. All this is fine.
Now my problem are:
1) How could I format the sheets in such a way that they print neatly
on 1 page? Right now, they spill on to the next page when it is
printed.
2) Also, how could I name these sheets so that they represent the
report the user is viewing?
I tried many options in the table properties..but couldn't figure it
out!
Any help in these issues will be greatly appreciated!
Thanks in advance.
SSIf you have grouping in your report, when you export it goes into diferent
sheets depending on the pages, Dont give grouping if possible and no page
breaks then it prints in one page. you can check in the preview itself, that
it should show 1 of 1 page and asnwering your 2nd part, It is not possible to
do Sheet naming.
Amarnath, MCTS
"SMS" wrote:
> Hi All,
> I'm using SQL Services 2000, and have a report with 3 tables. I export
> this to Excel and use Subscriptions to email this report daily. I have
> inserted page breaks after each table and so each table gets printed
> on separate sheets in the Excel spreadsheet. All this is fine.
> Now my problem are:
> 1) How could I format the sheets in such a way that they print neatly
> on 1 page? Right now, they spill on to the next page when it is
> printed.
> 2) Also, how could I name these sheets so that they represent the
> report the user is viewing?
> I tried many options in the table properties..but couldn't figure it
> out!
> Any help in these issues will be greatly appreciated!
> Thanks in advance.
> SS
>|||On Mar 13, 12:18 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> If you have grouping in your report, when you export it goes into diferent
> sheets depending on the pages, Dont give grouping if possible and no page
> breaks then it prints in one page. you can check in the preview itself, that
> it should show 1 of 1 page and asnwering your 2nd part, It is not possible to
> do Sheet naming.
> Amarnath, MCTS
Amarnath,
I guess I'll need to remove the page breaks.
I'll try this. Thanks!
I'm using SQL Services 2000, and have a report with 3 tables. I export
this to Excel and use Subscriptions to email this report daily. I have
inserted page breaks after each table and so each table gets printed
on separate sheets in the Excel spreadsheet. All this is fine.
Now my problem are:
1) How could I format the sheets in such a way that they print neatly
on 1 page? Right now, they spill on to the next page when it is
printed.
2) Also, how could I name these sheets so that they represent the
report the user is viewing?
I tried many options in the table properties..but couldn't figure it
out!
Any help in these issues will be greatly appreciated!
Thanks in advance.
SSIf you have grouping in your report, when you export it goes into diferent
sheets depending on the pages, Dont give grouping if possible and no page
breaks then it prints in one page. you can check in the preview itself, that
it should show 1 of 1 page and asnwering your 2nd part, It is not possible to
do Sheet naming.
Amarnath, MCTS
"SMS" wrote:
> Hi All,
> I'm using SQL Services 2000, and have a report with 3 tables. I export
> this to Excel and use Subscriptions to email this report daily. I have
> inserted page breaks after each table and so each table gets printed
> on separate sheets in the Excel spreadsheet. All this is fine.
> Now my problem are:
> 1) How could I format the sheets in such a way that they print neatly
> on 1 page? Right now, they spill on to the next page when it is
> printed.
> 2) Also, how could I name these sheets so that they represent the
> report the user is viewing?
> I tried many options in the table properties..but couldn't figure it
> out!
> Any help in these issues will be greatly appreciated!
> Thanks in advance.
> SS
>|||On Mar 13, 12:18 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> If you have grouping in your report, when you export it goes into diferent
> sheets depending on the pages, Dont give grouping if possible and no page
> breaks then it prints in one page. you can check in the preview itself, that
> it should show 1 of 1 page and asnwering your 2nd part, It is not possible to
> do Sheet naming.
> Amarnath, MCTS
Amarnath,
I guess I'll need to remove the page breaks.
I'll try this. Thanks!
Monday, March 12, 2012
Formatting @executiontime
Hi, is it possible to format the @.executiontime variable in the subject line
of an
email. I'm setting up a subscription and would like the subject line of the
email to format the date in MMM yyyy format.
ThanksGenerally the full format including the time, is required to be displayed in
a report generation, I dont formating can be done, since these 2 variables
are created by RS (reportname,executiontime) on the subject line. Other
method is to use your custom subscription methods, but just for formating,
sure you wont go for that unless it is very very critical.
Amarnath, MCTS
"Kerry" wrote:
> Hi, is it possible to format the @.executiontime variable in the subject line
> of an
> email. I'm setting up a subscription and would like the subject line of the
> email to format the date in MMM yyyy format.
> Thanks
of an
email. I'm setting up a subscription and would like the subject line of the
email to format the date in MMM yyyy format.
ThanksGenerally the full format including the time, is required to be displayed in
a report generation, I dont formating can be done, since these 2 variables
are created by RS (reportname,executiontime) on the subject line. Other
method is to use your custom subscription methods, but just for formating,
sure you wont go for that unless it is very very critical.
Amarnath, MCTS
"Kerry" wrote:
> Hi, is it possible to format the @.executiontime variable in the subject line
> of an
> email. I'm setting up a subscription and would like the subject line of the
> email to format the date in MMM yyyy format.
> Thanks
Wednesday, March 7, 2012
format print range when converted to Excel?
I have a report that the user can print right from the RS site on three pages (each page one page wide). However, when I have the server email the report as an attachment in Excel; Excel tries to print it on four pages with one of the pages spilling over into the fourth page.
How can I get Excel to format the print version just as I have on the RS site?
I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.|||Anyone else?
Is there a way to format the report to print at 80% in Excel without the user having to make the change in Excel?
|||
KimberlyL wrote:
I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.
I also have this problem. I have tried to minimize tables, move around objects, etc. but nothing works. The report looks good in direct print and export to other formats but when it comes to print from the exported excel report it is always to wide.
Has anyone got a solution or work around for this problem?
Thanks
/Mats
|||I hope that Microsoft can fix this in a future release. I get many complaints about this. My users want to print from Excel without intervention and I cannot find a work around for this.
format print range when converted to Excel?
I have a report that the user can print right from the RS site on three pages (each page one page wide). However, when I have the server email the report as an attachment in Excel; Excel tries to print it on four pages with one of the pages spilling over into the fourth page.
How can I get Excel to format the print version just as I have on the RS site?
I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.|||Anyone else?
Is there a way to format the report to print at 80% in Excel without the user having to make the change in Excel?
|||
I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.
I also have this problem. I have tried to minimize tables, move around objects, etc. but nothing works. The report looks good in direct print and export to other formats but when it comes to print from the exported excel report it is always to wide.
Has anyone got a solution or work around for this problem?
Thanks
/Mats
|||I hope that Microsoft can fix this in a future release. I get many complaints about this. My users want to print from Excel without intervention and I cannot find a work around for this.
format print range when converted to Excel?
I have a report that the user can print right from the RS site on three pages (each page one page wide). However, when I have the server email the report as an attachment in Excel; Excel tries to print it on four pages with one of the pages spilling over into the fourth page.
How can I get Excel to format the print version just as I have on the RS site?
I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.|||Anyone else?
Is there a way to format the report to print at 80% in Excel without the user having to make the change in Excel?
|||
I have had the same problem. It almost seems that anything that I export to excel looks like it grows when it is printed in excel. I posted a question referring to that and never got an answer.
I also have this problem. I have tried to minimize tables, move around objects, etc. but nothing works. The report looks good in direct print and export to other formats but when it comes to print from the exported excel report it is always to wide.
Has anyone got a solution or work around for this problem?
Thanks
/Mats
|||I hope that Microsoft can fix this in a future release. I get many complaints about this. My users want to print from Excel without intervention and I cannot find a work around for this.
|||You can report the same in connect site by referring to Http://connect.microsoft.com.FYI
Sunday, February 19, 2012
Format Address as EMail Link
How can I format a column so that the email address is clickable and will
start up a new mail message?On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> How can I format a column so that the email address is clickable and will
> start up a new mail message?
Normally, you can use "mailto:someperson@.someURL.com." I'm not sure if
you can use it as part of an 'a' tag w/html or not. In that case it
would be:
<a href="http://links.10026.com/?link=mailto:someperson@.someURL.com">SomeDescription</a>
Of course, you can append different text/fields as a report
expression, etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||>>I'm not sure if you can use it as part of an 'a' tag w/html or not.
The answer is yes, you can.
>L<
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181327056.703585.10240@.h2g2000hsg.googlegroups.com...
> On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
>> How can I format a column so that the email address is clickable and will
>> start up a new mail message?
>
> Normally, you can use "mailto:someperson@.someURL.com." I'm not sure if
> you can use it as part of an 'a' tag w/html or not. In that case it
> would be:
> <a href="http://links.10026.com/?link=mailto:someperson@.someURL.com">SomeDescription</a>
> Of course, you can append different text/fields as a report
> expression, etc. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Thanks, both of you got me pointed in the right direction.
I accomplished this by:
Right click on the text box containing an email address
Click Navigation
Enter ="mailto:"+Fields!Email.Value in the Jump to URL
Formatted text box with an Underline
"Lisa Slater Nicholls" <lisa@.spacefold.com> wrote in message
news:uzWENRgqHHA.1168@.TK2MSFTNGP03.phx.gbl...
>>I'm not sure if you can use it as part of an 'a' tag w/html or not.
> The answer is yes, you can.
>>L<
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1181327056.703585.10240@.h2g2000hsg.googlegroups.com...
>> On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
>> How can I format a column so that the email address is clickable and
>> will
>> start up a new mail message?
>>
>> Normally, you can use "mailto:someperson@.someURL.com." I'm not sure if
>> you can use it as part of an 'a' tag w/html or not. In that case it
>> would be:
>> <a href="http://links.10026.com/?link=mailto:someperson@.someURL.com">SomeDescription</a>
>> Of course, you can append different text/fields as a report
>> expression, etc. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>|||On Jun 8, 2:54 pm, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> Thanks, both of you got me pointed in the right direction.
> I accomplished this by:
> Right click on the text box containing an email address
> Click Navigation
> Enter ="mailto:"+Fields!Email.Value in the Jump to URL
> Formatted text box with an Underline
> "Lisa Slater Nicholls" <l...@.spacefold.com> wrote in messagenews:uzWENRgqHHA.1168@.TK2MSFTNGP03.phx.gbl...
> >>I'm not sure if you can use it as part of an 'a' tag w/html or not.
> > The answer is yes, you can.
> >>L<
> > "EMartinez" <emartinez...@.gmail.com> wrote in message
> >news:1181327056.703585.10240@.h2g2000hsg.googlegroups.com...
> >> On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> >> How can I format a column so that the email address is clickable and
> >> will
> >> start up a new mail message?
> >> Normally, you can use "mailto:someper...@.someURL.com." I'm not sure if
> >> you can use it as part of an 'a' tag w/html or not. In that case it
> >> would be:
> >> <a href="http://links.10026.com/?link=mailto:someper...@.someURL.com">SomeDescription</a>
> >> Of course, you can append different text/fields as a report
> >> expression, etc. Hope this helps.
> >> Regards,
> >> Enrique Martinez
> >> Sr. Software Consultant
Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
start up a new mail message?On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> How can I format a column so that the email address is clickable and will
> start up a new mail message?
Normally, you can use "mailto:someperson@.someURL.com." I'm not sure if
you can use it as part of an 'a' tag w/html or not. In that case it
would be:
<a href="http://links.10026.com/?link=mailto:someperson@.someURL.com">SomeDescription</a>
Of course, you can append different text/fields as a report
expression, etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||>>I'm not sure if you can use it as part of an 'a' tag w/html or not.
The answer is yes, you can.
>L<
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1181327056.703585.10240@.h2g2000hsg.googlegroups.com...
> On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
>> How can I format a column so that the email address is clickable and will
>> start up a new mail message?
>
> Normally, you can use "mailto:someperson@.someURL.com." I'm not sure if
> you can use it as part of an 'a' tag w/html or not. In that case it
> would be:
> <a href="http://links.10026.com/?link=mailto:someperson@.someURL.com">SomeDescription</a>
> Of course, you can append different text/fields as a report
> expression, etc. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Thanks, both of you got me pointed in the right direction.
I accomplished this by:
Right click on the text box containing an email address
Click Navigation
Enter ="mailto:"+Fields!Email.Value in the Jump to URL
Formatted text box with an Underline
"Lisa Slater Nicholls" <lisa@.spacefold.com> wrote in message
news:uzWENRgqHHA.1168@.TK2MSFTNGP03.phx.gbl...
>>I'm not sure if you can use it as part of an 'a' tag w/html or not.
> The answer is yes, you can.
>>L<
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1181327056.703585.10240@.h2g2000hsg.googlegroups.com...
>> On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
>> How can I format a column so that the email address is clickable and
>> will
>> start up a new mail message?
>>
>> Normally, you can use "mailto:someperson@.someURL.com." I'm not sure if
>> you can use it as part of an 'a' tag w/html or not. In that case it
>> would be:
>> <a href="http://links.10026.com/?link=mailto:someperson@.someURL.com">SomeDescription</a>
>> Of course, you can append different text/fields as a report
>> expression, etc. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>|||On Jun 8, 2:54 pm, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> Thanks, both of you got me pointed in the right direction.
> I accomplished this by:
> Right click on the text box containing an email address
> Click Navigation
> Enter ="mailto:"+Fields!Email.Value in the Jump to URL
> Formatted text box with an Underline
> "Lisa Slater Nicholls" <l...@.spacefold.com> wrote in messagenews:uzWENRgqHHA.1168@.TK2MSFTNGP03.phx.gbl...
> >>I'm not sure if you can use it as part of an 'a' tag w/html or not.
> > The answer is yes, you can.
> >>L<
> > "EMartinez" <emartinez...@.gmail.com> wrote in message
> >news:1181327056.703585.10240@.h2g2000hsg.googlegroups.com...
> >> On Jun 8, 10:26 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> >> How can I format a column so that the email address is clickable and
> >> will
> >> start up a new mail message?
> >> Normally, you can use "mailto:someper...@.someURL.com." I'm not sure if
> >> you can use it as part of an 'a' tag w/html or not. In that case it
> >> would be:
> >> <a href="http://links.10026.com/?link=mailto:someper...@.someURL.com">SomeDescription</a>
> >> Of course, you can append different text/fields as a report
> >> expression, etc. Hope this helps.
> >> Regards,
> >> Enrique Martinez
> >> Sr. Software Consultant
Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Subscribe to:
Posts (Atom)