Showing posts with label solutions. Show all posts
Showing posts with label solutions. Show all posts

Saturday, February 25, 2012

Reporting Solutions for .NET w/ SQL Server

I've posted this to the .NET groups... but I thought maybe some people in
the SQL Server forums could also give me some feedback.
Thanks : )
Hi all,
We're looking at upgrading our VS.NET Crystal Reporting solution with
something more powerful and user friendly. The reporting solution will be
used for web-based reporting (ASP.NET).
We build distributable apps, so we're looking for a reporting solution
which can be embedded within the product.
The two most important criteria is ease of use and the ability to
dynamically load reports on the fly (i.e. non-compiled reports). We need
to be able to build reports and drop them into a directory and have them
load up.
We were using the "PUSH" data method in Crystal to feed our reports. This
was done because we could not figure out a way to dynamically change the
connection string in Crystal. When we were using Crystal, the PUSH
method required us to create a dataset to define the columns of the
query. Do any reporting solutions allow you to generate the column
definitions directly from a SP - bypassing the need to generate the XML
dataset? Also, do reporting solutions allow for dynamic changes to the
connection string?
In anycase, we've slimmed the choices down to:
ActiveReports
XtraReports
Maybe... Crystal XI.
Any other products that I should look at? Reporting Services has sort of
been ruled out due to the lack of ASP.NET (Form Auth) integration and the
large installation size (not embeddable).
Thanks for any help!You can use the Reportviewer control.
you can render reporting services report or integrated reports.
so you can generate a report by code and render it on the web.
its RDLC report, like RDL (reporting services reports) you have the same
design features and XML schema, but RDLC use dataset has data sources
instead of SQL statements.
so you can fill this dataset by code, open the report by code and finally
render the result!
Reporting Services support form based authentication, but only in the
enterprise edition.
You can also render standard reporting services reports using the
reportviewer and insure the security without problem but filling some hidden
parameters by code.
for example, you create a report where you add a parameter like
"MyuserName", in your code you fill this parameter using the current
username (coming from the form based authentication)
if this paremeter is not filled, just render nothing in the report.
The credential used to access reporting services is the IIS application pool
account or the identity username setup in the web.config file.
the reportviewer webcontrol can be deployed in your solution at no cost.
"Spam Catcher" <spamhoneypot@.rogers.com> wrote in message
news:Xns97BFC0EBBD64Dusenethoneypotroger
s@.127.0.0.1...
> I've posted this to the .NET groups... but I thought maybe some people in
> the SQL Server forums could also give me some feedback.
> Thanks : )
>
> Hi all,
> We're looking at upgrading our VS.NET Crystal Reporting solution with
> something more powerful and user friendly. The reporting solution will be
> used for web-based reporting (ASP.NET).
> We build distributable apps, so we're looking for a reporting solution
> which can be embedded within the product.
> The two most important criteria is ease of use and the ability to
> dynamically load reports on the fly (i.e. non-compiled reports). We need
> to be able to build reports and drop them into a directory and have them
> load up.
> We were using the "PUSH" data method in Crystal to feed our reports. This
> was done because we could not figure out a way to dynamically change the
> connection string in Crystal. When we were using Crystal, the PUSH
> method required us to create a dataset to define the columns of the
> query. Do any reporting solutions allow you to generate the column
> definitions directly from a SP - bypassing the need to generate the XML
> dataset? Also, do reporting solutions allow for dynamic changes to the
> connection string?
> In anycase, we've slimmed the choices down to:
> ActiveReports
> XtraReports
> Maybe... Crystal XI.
> Any other products that I should look at? Reporting Services has sort of
> been ruled out due to the lack of ASP.NET (Form Auth) integration and the
> large installation size (not embeddable).
> Thanks for any help!|||"Jeje" <willgart@.hotmail.com> wrote in
news:OSNFj6IdGHA.3712@.TK2MSFTNGP03.phx.gbl:

> You can use the Reportviewer control.
Forgot to mention I'm using .NET 1.1.

> Reporting Services support form based authentication, but only in the
> enterprise edition.
Also, Reporting Services is not embeddable, which makes deployment a
challenge to customer sites.
But I'll keep Reporting Services in mind - thanks : )

Reporting Solutions for .NET w/ SQL Server

I've posted this to the .NET groups... but I thought maybe some people in
the SQL Server forums could also give me some feedback.
Thanks : )
Hi all,
We're looking at upgrading our VS.NET Crystal Reporting solution with
something more powerful and user friendly. The reporting solution will be
used for web-based reporting (ASP.NET).
We build distributable apps, so we're looking for a reporting solution
which can be embedded within the product.
The two most important criteria is ease of use and the ability to
dynamically load reports on the fly (i.e. non-compiled reports). We need
to be able to build reports and drop them into a directory and have them
load up.
We were using the "PUSH" data method in Crystal to feed our reports. This
was done because we could not figure out a way to dynamically change the
connection string in Crystal. When we were using Crystal, the PUSH
method required us to create a dataset to define the columns of the
query. Do any reporting solutions allow you to generate the column
definitions directly from a SP - bypassing the need to generate the XML
dataset? Also, do reporting solutions allow for dynamic changes to the
connection string?
In anycase, we've slimmed the choices down to:
ActiveReports
XtraReports
Maybe... Crystal XI.
Any other products that I should look at? Reporting Services has sort of
been ruled out due to the lack of ASP.NET (Form Auth) integration and the
large installation size (not embeddable).
Thanks for any help!You can use the Reportviewer control.
you can render reporting services report or integrated reports.
so you can generate a report by code and render it on the web.
its RDLC report, like RDL (reporting services reports) you have the same
design features and XML schema, but RDLC use dataset has data sources
instead of SQL statements.
so you can fill this dataset by code, open the report by code and finally
render the result!
Reporting Services support form based authentication, but only in the
enterprise edition.
You can also render standard reporting services reports using the
reportviewer and insure the security without problem but filling some hidden
parameters by code.
for example, you create a report where you add a parameter like
"MyuserName", in your code you fill this parameter using the current
username (coming from the form based authentication)
if this paremeter is not filled, just render nothing in the report.
The credential used to access reporting services is the IIS application pool
account or the identity username setup in the web.config file.
the reportviewer webcontrol can be deployed in your solution at no cost.
"Spam Catcher" <spamhoneypot@.rogers.com> wrote in message
news:Xns97BFC0EBBD64Dusenethoneypotroger
s@.127.0.0.1...
> I've posted this to the .NET groups... but I thought maybe some people in
> the SQL Server forums could also give me some feedback.
> Thanks : )
>
> Hi all,
> We're looking at upgrading our VS.NET Crystal Reporting solution with
> something more powerful and user friendly. The reporting solution will be
> used for web-based reporting (ASP.NET).
> We build distributable apps, so we're looking for a reporting solution
> which can be embedded within the product.
> The two most important criteria is ease of use and the ability to
> dynamically load reports on the fly (i.e. non-compiled reports). We need
> to be able to build reports and drop them into a directory and have them
> load up.
> We were using the "PUSH" data method in Crystal to feed our reports. This
> was done because we could not figure out a way to dynamically change the
> connection string in Crystal. When we were using Crystal, the PUSH
> method required us to create a dataset to define the columns of the
> query. Do any reporting solutions allow you to generate the column
> definitions directly from a SP - bypassing the need to generate the XML
> dataset? Also, do reporting solutions allow for dynamic changes to the
> connection string?
> In anycase, we've slimmed the choices down to:
> ActiveReports
> XtraReports
> Maybe... Crystal XI.
> Any other products that I should look at? Reporting Services has sort of
> been ruled out due to the lack of ASP.NET (Form Auth) integration and the
> large installation size (not embeddable).
> Thanks for any help!|||"Jeje" <willgart@.hotmail.com> wrote in
news:OSNFj6IdGHA.3712@.TK2MSFTNGP03.phx.gbl:

> You can use the Reportviewer control.
Forgot to mention I'm using .NET 1.1.

> Reporting Services support form based authentication, but only in the
> enterprise edition.
Also, Reporting Services is not embeddable, which makes deployment a
challenge to customer sites.
But I'll keep Reporting Services in mind - thanks : )

Reporting Solutions Charts & graphs needed (similar to Dundas)

Hi my group is checking out charts and graphs available for RS.
We've checked out Dundas but I'd like to know what else is out on the
market and what people have used.
If you have any suggetions, please let me know...I know ChartFX recently introduced charting/graphs for SSRS 2005. I've used
their charts for ASP.NET but haven't checked out their SSRS offerings. It
may be worth a look.
Justin
"jason.harris@.gmail.com" wrote:
> Hi my group is checking out charts and graphs available for RS.
> We've checked out Dundas but I'd like to know what else is out on the
> market and what people have used.
> If you have any suggetions, please let me know...
>|||Dundas is a good one but try SSRS charting and graphs. Excellent but with
some restrictions.
Amarnath
"justinsaraceno" wrote:
> I know ChartFX recently introduced charting/graphs for SSRS 2005. I've used
> their charts for ASP.NET but haven't checked out their SSRS offerings. It
> may be worth a look.
> Justin
> "jason.harris@.gmail.com" wrote:
> > Hi my group is checking out charts and graphs available for RS.
> >
> > We've checked out Dundas but I'd like to know what else is out on the
> > market and what people have used.
> >
> > If you have any suggetions, please let me know...
> >
> >|||I've taken a look at these and we're wanting something a little more
robust. I didn't like Dudas' UI. ChartFX looks good so far. If
anyone has any additional suggestions, I'd appreciate it!|||jason.harris@.gmail.com wrote:
> I've taken a look at these and we're wanting something a little more
> robust. I didn't like Dudas' UI. ChartFX looks good so far. If
> anyone has any additional suggestions, I'd appreciate it!
I tried it. The chart fx stuff had a really nice initial presentation.
If I didn't keep using it after the initial I might have bought it.
But then I used it which is why I went with the dundas chart and gauge
too. What happened you ask? Well, the chart fx software crashed my
visual studio to the point I had to take my battery out of my laptop.
I thought it may have been my toshiba so I kept going. There was no
conversion feature in it like the dundas control so I had to redo all
of my charts. There was no using report parameters or data values for
titles and many more basic features that make this seem like a rushed
product. I was really disappointed in the chart fx software.
The dundas control did not have as flashy of initial impression but it
worked and their support is awesome (they are tight with MS and were
able to prove to me my issues were with SSRS and not their control AND
gave me a link to the right service pack). Their software UI may not
have been using smart tag like behavior but the ui was similar to the
chart in reporting services so there was very little learning. The
dundas chart also had a cool code editor that let me get to the api to
customize the chart where the chart fx control did not.
Basically, at this point I would recommend the dundas chart for
reporting services over the chart fx chart without any question. If
you are just looking for a chart that gives a different look then use
chart fx. If you want an upgrade chart that actually gives more
features, use the dundas chart.
Liam