Lowering priority: reports

Showing posts with label reports. Show all posts

Monday, March 26, 2012

Maintenance Plan "fails"..

Thanks in advance for any insight.
On occasion, one of my schedule jobs will "fail", in that all tasks
complete, but it still reports failure. Strangely enough, nothing is written
to SQL Server log, but I do have the following entry in the Event Viewer:
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
(Step 1)."
Any ideas on how to troubleshoot this?
Thanks,
MorganAny messages in the report file? (Did you specify a report file, btw?)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> Thanks in advance for any insight.
> On occasion, one of my schedule jobs will "fail", in that all tasks
> complete, but it still reports failure. Strangely enough, nothing is written
> to SQL Server log, but I do have the following entry in the Event Viewer:
> "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
> Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
> was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> (Step 1)."
> Any ideas on how to troubleshoot this?
>
> Thanks,
> Morgan
>|||Hi Tibor,
The only thing in the report file is that it was unable to delete one of the
database backups. Other than that, all of the steps completed. Would that
cause the job to think it failed?
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Any messages in the report file? (Did you specify a report file, btw?)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > Thanks in advance for any insight.
> >
> > On occasion, one of my schedule jobs will "fail", in that all tasks
> > complete, but it still reports failure. Strangely enough, nothing is
written
> > to SQL Server log, but I do have the following entry in the Event
Viewer:
> > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
'Non-Great
> > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The
Job
> > was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> > (Step 1)."
> >
> > Any ideas on how to troubleshoot this?
> >
> >
> > Thanks,
> >
> > Morgan
> >
> >
>|||If I wrote the code, yes a failed deletion of a backup file would cause the job to fail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> Hi Tibor,
> The only thing in the report file is that it was unable to delete one of the
> database backups. Other than that, all of the steps completed. Would that
> cause the job to think it failed?
> Thanks,
> Morgan
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > Any messages in the report file? (Did you specify a report file, btw?)
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Morgan" <abcd@.senditon.com> wrote in message
> news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > > Thanks in advance for any insight.
> > >
> > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > complete, but it still reports failure. Strangely enough, nothing is
> written
> > > to SQL Server log, but I do have the following entry in the Event
> Viewer:
> > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> 'Non-Great
> > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The
> Job
> > > was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> > > (Step 1)."
> > >
> > > Any ideas on how to troubleshoot this?
> > >
> > >
> > > Thanks,
> > >
> > > Morgan
> > >
> > >
> >
> >
>|||Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
seperate job, that way if deleting a previous days backup failed it wouldn't
look like the databases didn't get backed up since that would be a seperate
task with its own status.
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> If I wrote the code, yes a failed deletion of a backup file would cause
the job to fail.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> > Hi Tibor,
> >
> > The only thing in the report file is that it was unable to delete one of
the
> > database backups. Other than that, all of the steps completed. Would
that
> > cause the job to think it failed?
> >
> > Thanks,
> >
> > Morgan
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > Any messages in the report file? (Did you specify a report file, btw?)
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Morgan" <abcd@.senditon.com> wrote in message
> > news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > > > Thanks in advance for any insight.
> > > >
> > > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > > complete, but it still reports failure. Strangely enough, nothing is
> > written
> > > > to SQL Server log, but I do have the following entry in the Event
> > Viewer:
> > > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > 'Non-Great
> > > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed.
The
> > Job
> > > > was invoked by Schedule 35 (Schedule 1). The last step to run was
step 1
> > > > (Step 1)."
> > > >
> > > > Any ideas on how to troubleshoot this?
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Morgan
> > > >
> > > >
> > >
> > >
> >
> >
>|||A "hack" way is to create a script that does a "DIR" in the directory and delete old files. This can be done
using ActiveScript, TSQL of whatever is your preference...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:OPwIwByTEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
> seperate job, that way if deleting a previous days backup failed it wouldn't
> look like the databases didn't get backed up since that would be a seperate
> task with its own status.
> Thanks,
> Morgan
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> > If I wrote the code, yes a failed deletion of a backup file would cause
> the job to fail.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Morgan" <abcd@.senditon.com> wrote in message
> news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> > > Hi Tibor,
> > >
> > > The only thing in the report file is that it was unable to delete one of
> the
> > > database backups. Other than that, all of the steps completed. Would
> that
> > > cause the job to think it failed?
> > >
> > > Thanks,
> > >
> > > Morgan
> > >
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > > message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > > Any messages in the report file? (Did you specify a report file, btw?)
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > >
> > > >
> > > > "Morgan" <abcd@.senditon.com> wrote in message
> > > news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > > > > Thanks in advance for any insight.
> > > > >
> > > > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > > > complete, but it still reports failure. Strangely enough, nothing is
> > > written
> > > > > to SQL Server log, but I do have the following entry in the Event
> > > Viewer:
> > > > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > > 'Non-Great
> > > > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed.
> The
> > > Job
> > > > > was invoked by Schedule 35 (Schedule 1). The last step to run was
> step 1
> > > > > (Step 1)."
> > > > >
> > > > > Any ideas on how to troubleshoot this?
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Morgan
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Monday, March 12, 2012

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

Friday, March 9, 2012

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 Label

Hi,
I have several reports realized with SSRS, in general address lists. I'm
trying to find a way to add to this reports the capability to produce mailing
labels. I'd like to do it with a custom export format (it would be nice to
have it in the "export as" dropdown with pdf, csv and excel formats...). The
idea is to avoid duplicating every report to get a "Mailing label" version,
this to keep everything as DRY as possible.
Is it possible? Are there other ways without keeping multiple copies of
queries and parameters?
--
NPOn Mar 13, 11:31 am, Numerica <numer...@.nospam.nospam> wrote:
> Hi,
> I have several reports realized with SSRS, in general address lists. I'm
> trying to find a way to add to this reports the capability to produce mailing
> labels. I'd like to do it with a custom export format (it would be nice to
> have it in the "export as" dropdown with pdf, csv and excel formats...). The
> idea is to avoid duplicating every report to get a "Mailing label" version,
> this to keep everything as DRY as possible.
> Is it possible? Are there other ways without keeping multiple copies of
> queries and parameters?
> --
> NP
I've heard of other people w/similar needs using tables w/grouping
inside list controls on multi-column reports. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Hi Numerica,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I didn't find any suitable solution, can you hel me?
--
NP
"Wei Lu [MSFT]" wrote:
> Hi Numerica,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello NP,
I don't think that you could directly using the Mailing Label as the export
format because you need to specify the data you could use.
If your report did not have the same data structure, it may be a big
problem to let your custom render know the data structure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
thanks for the answer, let's say in my reports name and address fields have
always the same name or position could it help?
Can you send me some links to documentation for writing custom report formats?
--
NP
"Wei Lu [MSFT]" wrote:
> Hello NP,
> I don't think that you could directly using the Mailing Label as the export
> format because you need to specify the data you could use.
> If your report did not have the same data structure, it may be a big
> problem to let your custom render know the data structure.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello NP,
Here is the sample:
http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/default.aspx
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thanks a lot Wei Lu.
--
NP
"Wei Lu [MSFT]" wrote:
> Hello NP,
> Here is the sample:
> http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/default.aspx
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||My Pleasure, NP.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Wednesday, March 7, 2012

mail merge reports

Hi friends
am wondering is there a way to mail merge reports created by report builder? has any one tried yet?

we have few clients who use report builder to created reports and they want to mail merge some of the reports. for e.g. sending a letter to all customers with a predefined format.

any ideas on this one much appreciated.
Thanks for your help.test

Mail Delivery Fails--Please help!

We just set up Reporting Services on a new server can cannot get mail
delivery of reports to work no matter what we do. Errors appear in the log
like:
ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
How do we resolve Win32 error 1355? The so-called details in the log files
are useless.
--
Larry Menzin
American Techsystems Corp.Larry,
I've encountered this same error with RS emailing reports. You should find
that when you try to email the report as an attachment or as MHTML in the
body you will get the error, but if you just send a link, you will get no
error. In my case, we were running Windows Server 2003 and there was a known
bug that was fixed in Server 2003 sp1. If you are running Server 2003
without the service pack, I would recommend installing it, and it should fix
your problem. Hope that helps.
David
"Larry Menzin" wrote:
> We just set up Reporting Services on a new server can cannot get mail
> delivery of reports to work no matter what we do. Errors appear in the log
> like:
> ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> How do we resolve Win32 error 1355? The so-called details in the log files
> are useless.
>
> --
> Larry Menzin
> American Techsystems Corp.|||Thanks. Win2003 SP1 fixed the problem.
--
Larry Menzin
American Techsystems Corp.
"David Siebert" wrote:
> Larry,
> I've encountered this same error with RS emailing reports. You should find
> that when you try to email the report as an attachment or as MHTML in the
> body you will get the error, but if you just send a link, you will get no
> error. In my case, we were running Windows Server 2003 and there was a known
> bug that was fixed in Server 2003 sp1. If you are running Server 2003
> without the service pack, I would recommend installing it, and it should fix
> your problem. Hope that helps.
> David
> "Larry Menzin" wrote:
> > We just set up Reporting Services on a new server can cannot get mail
> > delivery of reports to work no matter what we do. Errors appear in the log
> > like:
> >
> > ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> > The Report Server has encountered a configuration error; more details in the
> > log files
> >
> > How do we resolve Win32 error 1355? The so-called details in the log files
> > are useless.
> >
> >
> > --
> > Larry Menzin
> > American Techsystems Corp.

Saturday, February 25, 2012

Macintosh Excel v.x Rendering

We have built a new front end to the report server to run reports. When
making calls to the RS Web Service, is there anything special that needs to
be done for Excel (xls) rendering? We have a few clients utlizing Apple MAC
OS X with Office v.x. We thought that SP1 would take care of their ability
to open the xls files as with prior versions of PC xls before Office XP.
After further testing, the MAC version still does not open the excel file
correctly. It only has MIME type values in the file. What are the options
to ensure MAC Excel opens the same as PC Excel with SP1? We currently have
them export to CSV and then open that in excel with the text to columns
re-formatting. Any help you could provide would be greatly appreciated.Have you tried to export the file using a PC, save it to disk and then open
it on the Mac? I wouldn't be surprised if there were some glitches.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <Lance@.discussions.microsoft.com> wrote in message
news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> We have built a new front end to the report server to run reports. When
> making calls to the RS Web Service, is there anything special that needs
> to
> be done for Excel (xls) rendering? We have a few clients utlizing Apple
> MAC
> OS X with Office v.x. We thought that SP1 would take care of their
> ability
> to open the xls files as with prior versions of PC xls before Office XP.
> After further testing, the MAC version still does not open the excel file
> correctly. It only has MIME type values in the file. What are the
> options
> to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> have
> them export to CSV and then open that in excel with the text to columns
> re-formatting. Any help you could provide would be greatly appreciated.|||Yes...It works fine if I save down to Excel 95-2000 workbook and then send
it. The mac opens fine, but that is not a viable solution to our problem as
the mac clients will need to run reports on demand. Do you by chance know
if there is a solution in the works to ensure MAC Excel versions export
without incidence as the PC version?
Thanks...
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Have you tried to export the file using a PC, save it to disk and then
open
> it on the Mac? I wouldn't be surprised if there were some glitches.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > We have built a new front end to the report server to run reports. When
> > making calls to the RS Web Service, is there anything special that needs
> > to
> > be done for Excel (xls) rendering? We have a few clients utlizing Apple
> > MAC
> > OS X with Office v.x. We thought that SP1 would take care of their
> > ability
> > to open the xls files as with prior versions of PC xls before Office XP.
> > After further testing, the MAC version still does not open the excel
file
> > correctly. It only has MIME type values in the file. What are the
> > options
> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> > have
> > them export to CSV and then open that in excel with the text to columns
> > re-formatting. Any help you could provide would be greatly appreciated.
>|||So what happens if you open the workbook directly in Excel on the mac (don't
open it in PC Excel)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Yes...It works fine if I save down to Excel 95-2000 workbook and then send
> it. The mac opens fine, but that is not a viable solution to our problem
> as
> the mac clients will need to run reports on demand. Do you by chance know
> if there is a solution in the works to ensure MAC Excel versions export
> without incidence as the PC version?
> Thanks...
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> Have you tried to export the file using a PC, save it to disk and then
> open
>> it on the Mac? I wouldn't be surprised if there were some glitches.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > We have built a new front end to the report server to run reports.
>> > When
>> > making calls to the RS Web Service, is there anything special that
>> > needs
>> > to
>> > be done for Excel (xls) rendering? We have a few clients utlizing
>> > Apple
>> > MAC
>> > OS X with Office v.x. We thought that SP1 would take care of their
>> > ability
>> > to open the xls files as with prior versions of PC xls before Office
>> > XP.
>> > After further testing, the MAC version still does not open the excel
> file
>> > correctly. It only has MIME type values in the file. What are the
>> > options
>> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
>> > have
>> > them export to CSV and then open that in excel with the text to columns
>> > re-formatting. Any help you could provide would be greatly
>> > appreciated.
>>
>|||The document is garbage...It looks exactly what happens when someone who has
a lower version of excel than XP.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> So what happens if you open the workbook directly in Excel on the mac
(don't
> open it in PC Excel)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
send
> > it. The mac opens fine, but that is not a viable solution to our
problem
> > as
> > the mac clients will need to run reports on demand. Do you by chance
know
> > if there is a solution in the works to ensure MAC Excel versions export
> > without incidence as the PC version?
> >
> > Thanks...
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> Have you tried to export the file using a PC, save it to disk and then
> > open
> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> > We have built a new front end to the report server to run reports.
> >> > When
> >> > making calls to the RS Web Service, is there anything special that
> >> > needs
> >> > to
> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> > Apple
> >> > MAC
> >> > OS X with Office v.x. We thought that SP1 would take care of their
> >> > ability
> >> > to open the xls files as with prior versions of PC xls before Office
> >> > XP.
> >> > After further testing, the MAC version still does not open the excel
> > file
> >> > correctly. It only has MIME type values in the file. What are the
> >> > options
> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
currently
> >> > have
> >> > them export to CSV and then open that in excel with the text to
columns
> >> > re-formatting. Any help you could provide would be greatly
> >> > appreciated.
> >>
> >>
> >
> >
>|||In SP1, we support Excel 97 and 2000. You should not get a MIME document
after applying the service pack.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> The document is garbage...It looks exactly what happens when someone who
> has
> a lower version of excel than XP.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> So what happens if you open the workbook directly in Excel on the mac
> (don't
>> open it in PC Excel)?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> send
>> > it. The mac opens fine, but that is not a viable solution to our
> problem
>> > as
>> > the mac clients will need to run reports on demand. Do you by chance
> know
>> > if there is a solution in the works to ensure MAC Excel versions export
>> > without incidence as the PC version?
>> >
>> > Thanks...
>> >
>> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> >> Have you tried to export the file using a PC, save it to disk and then
>> > open
>> >> it on the Mac? I wouldn't be surprised if there were some glitches.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server Reporting Services
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> >> > We have built a new front end to the report server to run reports.
>> >> > When
>> >> > making calls to the RS Web Service, is there anything special that
>> >> > needs
>> >> > to
>> >> > be done for Excel (xls) rendering? We have a few clients utlizing
>> >> > Apple
>> >> > MAC
>> >> > OS X with Office v.x. We thought that SP1 would take care of their
>> >> > ability
>> >> > to open the xls files as with prior versions of PC xls before Office
>> >> > XP.
>> >> > After further testing, the MAC version still does not open the excel
>> > file
>> >> > correctly. It only has MIME type values in the file. What are the
>> >> > options
>> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> currently
>> >> > have
>> >> > them export to CSV and then open that in excel with the text to
> columns
>> >> > re-formatting. Any help you could provide would be greatly
>> >> > appreciated.
>> >>
>> >>
>> >
>> >
>>
>|||I understand that, but the MAC version still gets this MIME document...The
PC version is fine.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> In SP1, we support Excel 97 and 2000. You should not get a MIME document
> after applying the service pack.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > The document is garbage...It looks exactly what happens when someone who
> > has
> > a lower version of excel than XP.
> >
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> >> So what happens if you open the workbook directly in Excel on the mac
> > (don't
> >> open it in PC Excel)?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> >> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> > send
> >> > it. The mac opens fine, but that is not a viable solution to our
> > problem
> >> > as
> >> > the mac clients will need to run reports on demand. Do you by chance
> > know
> >> > if there is a solution in the works to ensure MAC Excel versions
export
> >> > without incidence as the PC version?
> >> >
> >> > Thanks...
> >> >
> >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> >> Have you tried to export the file using a PC, save it to disk and
then
> >> > open
> >> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >> >>
> >> >> --
> >> >> Brian Welcker
> >> >> Group Program Manager
> >> >> Microsoft SQL Server Reporting Services
> >> >>
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >>
> >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> >> > We have built a new front end to the report server to run reports.
> >> >> > When
> >> >> > making calls to the RS Web Service, is there anything special that
> >> >> > needs
> >> >> > to
> >> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> >> > Apple
> >> >> > MAC
> >> >> > OS X with Office v.x. We thought that SP1 would take care of
their
> >> >> > ability
> >> >> > to open the xls files as with prior versions of PC xls before
Office
> >> >> > XP.
> >> >> > After further testing, the MAC version still does not open the
excel
> >> > file
> >> >> > correctly. It only has MIME type values in the file. What are
the
> >> >> > options
> >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > currently
> >> >> > have
> >> >> > them export to CSV and then open that in excel with the text to
> > columns
> >> >> > re-formatting. Any help you could provide would be greatly
> >> >> > appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Any suggestions or comments?
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I understand that, but the MAC version still gets this MIME document...The
> PC version is fine.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > In SP1, we support Excel 97 and 2000. You should not get a MIME document
> > after applying the service pack.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > The document is garbage...It looks exactly what happens when someone
who
> > > has
> > > a lower version of excel than XP.
> > >
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> > >> So what happens if you open the workbook directly in Excel on the mac
> > > (don't
> > >> open it in PC Excel)?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
then
> > > send
> > >> > it. The mac opens fine, but that is not a viable solution to our
> > > problem
> > >> > as
> > >> > the mac clients will need to run reports on demand. Do you by
chance
> > > know
> > >> > if there is a solution in the works to ensure MAC Excel versions
> export
> > >> > without incidence as the PC version?
> > >> >
> > >> > Thanks...
> > >> >
> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > >> >> Have you tried to export the file using a PC, save it to disk and
> then
> > >> > open
> > >> >> it on the Mac? I wouldn't be surprised if there were some
glitches.
> > >> >>
> > >> >> --
> > >> >> Brian Welcker
> > >> >> Group Program Manager
> > >> >> Microsoft SQL Server Reporting Services
> > >> >>
> > >> >> This posting is provided "AS IS" with no warranties, and confers
no
> > >> > rights.
> > >> >>
> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > >> >> > We have built a new front end to the report server to run
reports.
> > >> >> > When
> > >> >> > making calls to the RS Web Service, is there anything special
that
> > >> >> > needs
> > >> >> > to
> > >> >> > be done for Excel (xls) rendering? We have a few clients
utlizing
> > >> >> > Apple
> > >> >> > MAC
> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
> their
> > >> >> > ability
> > >> >> > to open the xls files as with prior versions of PC xls before
> Office
> > >> >> > XP.
> > >> >> > After further testing, the MAC version still does not open the
> excel
> > >> > file
> > >> >> > correctly. It only has MIME type values in the file. What are
> the
> > >> >> > options
> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > > currently
> > >> >> > have
> > >> >> > them export to CSV and then open that in excel with the text to
> > > columns
> > >> >> > re-formatting. Any help you could provide would be greatly
> > >> >> > appreciated.
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||We aren't generating MIME any more. That code is gone. Something else must
be wrong with the file type. We will take a look but it is not a highly
demanded scenario.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23FHK6dSiEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Any suggestions or comments?
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I understand that, but the MAC version still gets this MIME
>> document...The
>> PC version is fine.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> > In SP1, we support Excel 97 and 2000. You should not get a MIME
>> > document
>> > after applying the service pack.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >
>> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
>> > > The document is garbage...It looks exactly what happens when someone
> who
>> > > has
>> > > a lower version of excel than XP.
>> > >
>> > >
>> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
>> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> > >> So what happens if you open the workbook directly in Excel on the
>> > >> mac
>> > > (don't
>> > >> open it in PC Excel)?
>> > >>
>> > >> --
>> > >> Brian Welcker
>> > >> Group Program Manager
>> > >> SQL Server Reporting Services
>> > >>
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >>
>> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
> then
>> > > send
>> > >> > it. The mac opens fine, but that is not a viable solution to our
>> > > problem
>> > >> > as
>> > >> > the mac clients will need to run reports on demand. Do you by
> chance
>> > > know
>> > >> > if there is a solution in the works to ensure MAC Excel versions
>> export
>> > >> > without incidence as the PC version?
>> > >> >
>> > >> > Thanks...
>> > >> >
>> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
>> message
>> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > >> >> Have you tried to export the file using a PC, save it to disk and
>> then
>> > >> > open
>> > >> >> it on the Mac? I wouldn't be surprised if there were some
> glitches.
>> > >> >>
>> > >> >> --
>> > >> >> Brian Welcker
>> > >> >> Group Program Manager
>> > >> >> Microsoft SQL Server Reporting Services
>> > >> >>
>> > >> >> This posting is provided "AS IS" with no warranties, and confers
> no
>> > >> > rights.
>> > >> >>
>> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > >> >> > We have built a new front end to the report server to run
> reports.
>> > >> >> > When
>> > >> >> > making calls to the RS Web Service, is there anything special
> that
>> > >> >> > needs
>> > >> >> > to
>> > >> >> > be done for Excel (xls) rendering? We have a few clients
> utlizing
>> > >> >> > Apple
>> > >> >> > MAC
>> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
>> their
>> > >> >> > ability
>> > >> >> > to open the xls files as with prior versions of PC xls before
>> Office
>> > >> >> > XP.
>> > >> >> > After further testing, the MAC version still does not open the
>> excel
>> > >> > file
>> > >> >> > correctly. It only has MIME type values in the file. What are
>> the
>> > >> >> > options
>> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
>> > > currently
>> > >> >> > have
>> > >> >> > them export to CSV and then open that in excel with the text to
>> > > columns
>> > >> >> > re-formatting. Any help you could provide would be greatly
>> > >> >> > appreciated.
>> > >> >>
>> > >> >>
>> > >> >
>> > >> >
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>>
>

Machine name works and FQDN fails

Short version:
http://machinename/reports works as does http://machinename/reportserver
http://FQDN/reports repeatedly requests authentication and then fails.
Longer version:
Everything was working perfectly. I attempted to change to Sharepoint
integrated mode from native (after giving up on this - different thread) I
switched back to native mode.
Everything works when I access using machine name, but the FQDN now causes a
repeated request for authentication (does not matter which server or desktop
the request comes from or which user account) the request fails.
This worked before my adventure into sharepoint integration without a
request for authentication, but I can't figure out what I changed
(I broke it and can't fix it) - Please help.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.I am using networkservice account as the webservice identity of my
application pools. So I just needed to update my SPN for the HTTP service on
my Report server
setspn -A HTTP/host.domain.com domain\machinename
--
Fredrick A. Zilz
Director IT
InterHealth N.I.
"Fred Zilz" wrote:
> Short version:
> http://machinename/reports works as does http://machinename/reportserver
> http://FQDN/reports repeatedly requests authentication and then fails.
> Longer version:
> Everything was working perfectly. I attempted to change to Sharepoint
> integrated mode from native (after giving up on this - different thread) I
> switched back to native mode.
> Everything works when I access using machine name, but the FQDN now causes a
> repeated request for authentication (does not matter which server or desktop
> the request comes from or which user account) the request fails.
> This worked before my adventure into sharepoint integration without a
> request for authentication, but I can't figure out what I changed
> (I broke it and can't fix it) - Please help.
> --
> Fredrick A. Zilz
> Director IT
> InterHealth N.I.

Mac users

We are having issues with Mac users accessing our RS reports.
When they use Safari RS refuses their connection and when they use IE 5 they
are prompted for User/Password/Doman (which is OK) but the drop downs
(prompts) aren't showing up.
Is there a solution?
ThanksGive them a PC! :)
Sorry, couldn't resist.
Alex wrote:
> We are having issues with Mac users accessing our RS reports.
> When they use Safari RS refuses their connection and when they use IE
> 5 they are prompted for User/Password/Doman (which is OK) but the
> drop downs (prompts) aren't showing up.
> Is there a solution?
> Thanks|||For a more serious reply, I did some cross-browser testing recently,
both mac and pc and got really poor results. Some of the worst problems
were IE on Mac!
I posted on a microsoft forum somewhere but got no response.
Chris
Chris McGuigan wrote:
> Give them a PC! :)
> Sorry, couldn't resist.
>
> Alex wrote:
> > We are having issues with Mac users accessing our RS reports.
> > When they use Safari RS refuses their connection and when they use
> > IE 5 they are prompted for User/Password/Doman (which is OK) but the
> > drop downs (prompts) aren't showing up.
> >
> > Is there a solution?
> >
> > Thanks|||You want me to be lynched don't you
"Chris McGuigan" wrote:
> Give them a PC! :)
> Sorry, couldn't resist.
>
> Alex wrote:
> > We are having issues with Mac users accessing our RS reports.
> > When they use Safari RS refuses their connection and when they use IE
> > 5 they are prompted for User/Password/Doman (which is OK) but the
> > drop downs (prompts) aren't showing up.
> >
> > Is there a solution?
> >
> > Thanks
>|||I've had success with 1 user being able to get on RS and having the drop
downs show up and work.
They were even able to run reports.
The only hick right now is that when they choose a format to export the
"Export" button never gets activated.
Any idead, anyone
"Chris McGuigan" wrote:
> For a more serious reply, I did some cross-browser testing recently,
> both mac and pc and got really poor results. Some of the worst problems
> were IE on Mac!
> I posted on a microsoft forum somewhere but got no response.
> Chris
>
> Chris McGuigan wrote:
> > Give them a PC! :)
> >
> > Sorry, couldn't resist.
> >
> >
> > Alex wrote:
> >
> > > We are having issues with Mac users accessing our RS reports.
> > > When they use Safari RS refuses their connection and when they use
> > > IE 5 they are prompted for User/Password/Doman (which is OK) but the
> > > drop downs (prompts) aren't showing up.
> > >
> > > Is there a solution?
> > >
> > > Thanks
>

Monday, March 26, 2012

Maintenance Plan "fails"..

Maintenance Plan "fails"..

Maintenance Plan "fails"..

Monday, March 12, 2012

Main Report Page with multiple visible/nonvisible sub reports

Friday, March 9, 2012

Mailing Reports

Mailing Label

Wednesday, March 7, 2012

mail merge reports

Mail Delivery Fails--Please help!

Saturday, February 25, 2012

Macintosh Excel v.x Rendering

Machine name works and FQDN fails

Mac users

Lowering priority

Blog Archive

About Me