Tuesday, February 21, 2012

Reporting in SQL Server

Hi,
I am developing a Intranet application using the Internet Browser as the cli
ent interface. My client needs various kinds of reports which he has to view
in the Browser. Are there any standard API's that generate the reports in H
TML format in SQL Server. A
ny help would be much appreciated. One more thing, I need to print the repor
ts to a local Dot Matrix printer. Is there any place where I can get some in
formation.
Thanks in advance
Aditya.Seen this? http://www.microsoft.com/sql/reporting/
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Aditya" <anonymous@.discussions.microsoft.com> wrote in message
news:8C056CC2-FAF8-463E-9F40-DA598685D628@.microsoft.com...
Hi,
I am developing a Intranet application using the Internet Browser as the
client interface. My client needs various kinds of reports which he has to
view in the Browser. Are there any standard API's that generate the reports
in HTML format in SQL Server. Any help would be much appreciated. One more
thing, I need to print the reports to a local Dot Matrix printer. Is there
any place where I can get some information.
Thanks in advance
Aditya.|||Hi Narayana Vyas,
Thank you for the reply. I have seen that. Presently I cannot recommend this
for the client for two reasons:
1. The reporting service is still in Beta
2. The application I am developing has been written in ASP and not .Net
I am currently writing server side components that do the complex database
interactions and the ASP that generates the dynamic HTML pages to display
the reports. I find this process too complicated and time consuming and
error prone. I was looking for any other efficient means for doing this
task.
I have another issue in this. I need to send the data (the report which the
user views in the browser) to a dot-matrix printer and it has to print in
text mode. Can you suggest any way for this?
Thanks in advance
Aditya.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OYXFlFE4DHA.2276@.TK2MSFTNGP10.phx.gbl...
quote:

> Seen this? http://www.microsoft.com/sql/reporting/
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Aditya" <anonymous@.discussions.microsoft.com> wrote in message
> news:8C056CC2-FAF8-463E-9F40-DA598685D628@.microsoft.com...
> Hi,
> I am developing a Intranet application using the Internet Browser as the
> client interface. My client needs various kinds of reports which he has to
> view in the Browser. Are there any standard API's that generate the

reports
quote:

> in HTML format in SQL Server. Any help would be much appreciated. One more
> thing, I need to print the reports to a local Dot Matrix printer. Is there
> any place where I can get some information.
> Thanks in advance
> Aditya.
>
|||1) Its release date is less than a week away
2) Its a web service so you can use it from ASP, you don't need the app to
be written in .NET however you'd probably find it a lot easier in .NET even
if you are not that familiar with it. You can also use URL access which may
be simpler in your scenario
Also,it is highly extensible, you can write delivery extensions for
Reporting Services such as Printer Delivery extensions. It in fact includes
a Printer Delivery Extension in the devloper samples with it. I agree its
not ideal if you are not familiar with .NET but it might be well worth
getting to know it :-)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:%2342SQNE4DHA.2404@.TK2MSFTNGP10.phx.gbl...
quote:

> Hi Narayana Vyas,
> Thank you for the reply. I have seen that. Presently I cannot recommend

this
quote:

> for the client for two reasons:
> 1. The reporting service is still in Beta
> 2. The application I am developing has been written in ASP and not .Net
> I am currently writing server side components that do the complex database
> interactions and the ASP that generates the dynamic HTML pages to display
> the reports. I find this process too complicated and time consuming and
> error prone. I was looking for any other efficient means for doing this
> task.
> I have another issue in this. I need to send the data (the report which

the
quote:

> user views in the browser) to a dot-matrix printer and it has to print in
> text mode. Can you suggest any way for this?
> Thanks in advance
> Aditya.
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OYXFlFE4DHA.2276@.TK2MSFTNGP10.phx.gbl...
to[QUOTE]
> reports
more[QUOTE]
there[QUOTE]
>
|||Hi Jasper Smith,
Thanks for the information. I will give it a try. Meanwhile, if you get any
other information, please pass them.
Thank you
Aditya.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#nQ8AFF4DHA.2380@.TK2MSFTNGP09.phx.gbl...
quote:

> 1) Its release date is less than a week away
> 2) Its a web service so you can use it from ASP, you don't need the app to
> be written in .NET however you'd probably find it a lot easier in .NET

even
quote:

> if you are not that familiar with it. You can also use URL access which

may
quote:

> be simpler in your scenario
> Also,it is highly extensible, you can write delivery extensions for
> Reporting Services such as Printer Delivery extensions. It in fact

includes
quote:

> a Printer Delivery Extension in the devloper samples with it. I agree its
> not ideal if you are not familiar with .NET but it might be well worth
> getting to know it :-)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:%2342SQNE4DHA.2404@.TK2MSFTNGP10.phx.gbl...
> this
database[QUOTE]
display[QUOTE]
> the
in[QUOTE]
the[QUOTE]
has[QUOTE]
> to
> more
> there
>

No comments:

Post a Comment