Iron Speed Technical Forums
Register Latest Topics
 
 
 


Reply
  Author   Comment   Page 2 of 3      Prev   1   2   3   Next
Gerard

Registered:
Posts: 588
Reply with quote  #16 
I would also like to see and, or in the query wizard. ISD has the opportunity here to take the lead and put in warning if required to show effects of and - or if required
Gerard
barry_

Registered:
Posts: 5
Reply with quote  #17 
Yes it would be great to have a report designer, or certainly make it easier to alter the reports. The ability to drag and drop fields etc onto the report layout. My main issue is that we want to display the filter criteria used in generating the report, on the first page. At the moment the only workaround is adding all this data on one line instead of the ReportTitle. Looks terrible.
jadach

Registered:
Posts: 203
Reply with quote  #18 
I would love the ability to create a Master/Detail report similar to this right in the UI:
http://demos.devexpress.com/xtrareportsdemos/reporttypes/MasterDetail.aspx

Thanks for asking!

__________________
Jerry
bowskill

Registered:
Posts: 60
Reply with quote  #19 

1.      Do you need reports that have a completely different layout(and data) than what you have on existing pages?  Or, do want report layouts that match existing pages in your application?

I tend to use a different layout. eg an Invoice. No need for an ISD page to match the printable report. Same for label printing.

2.      Would you prefer a separate report designer?  If so, what would be the “must have” features for this report designer?

I use Telerik Reports, which has both a standalone designer as well as integrated into Visual Studio and it meets all my needs except one (see below in point 4). Would be great if it was easier to reuse Ironspeed business objects as the report datasource though. 

3.      What are you most commonly trying to accomplish with reporting in your Iron Speed Applications?

Invoices, labels, any form that needs an ink signature, any formatted data that must be emailable (as PDF) or printable.

4.      What are you using now for reporting?  Iron Speed Designer reporting or third party reporting tools?  Likes/dislikes?

Telerik Reports. Fantastic. Easily integrated into Ironspeed apps except for sharing datasources (can be done but I often take the easy route of just creating a new datasource in the report designer). Meets all my needs except PRINTING from ANDROID!

 

5.      What is the most important feature or aspect of reporting functionality in your applications?

There are many. But the one I struggle with is the simplification of printing from any device - desktop or mobile. Google Cloud Print comes the closest. I want my app to able to print from a mobile device direct to printer without having to download, open a separate app and print from file. There are ways to do this from a web server which works  in an Intranet app but not an Internet app. So direct from client would be better.

Rendering speed AND send to print speed are quite important. Ability to send direct to print without screen rendering.

pk_davidson

Registered:
Posts: 223
Reply with quote  #20 
We use Telerik Reporting.
Integrate it and you have your solution ;-)

Seriously, we looked a lot at report generators.
For us it was DevExpress or Telerik. 
Basically Telerik won the coin toss.

We still do a fair bit of basic reporting using Excel exports straight out of ISD.

But as soon as you need to Group, which we do a lot, then ISD is out.
Telerik is very powerful right down to the field level using field expressions.

As pinbot said, why reinvent the wheel.
The problem of course is that there are 4-5 existing reporting tools in use.
Crystal, DevExpress, Telerik, SSRS, FastReports and I'm sure others.

Not like you had an overwhelming response to one generator in this thread.
Seems like SSRS might have the most users but that's probably due to its cost than capabilities.  i.e. bundled with SQL...

Pitch for Telerik, I hired a guy who spent a year doing Crystal reports for a massive Oracle based hospital system.   He hated Crystal (who doesn't) and really liked Telerik the first time he picked it up.

__________________
Paul
rmanzelc

Registered:
Posts: 67
Reply with quote  #21 
We use Telerik here, as well. We went down the SSRS path for awhile, but it just didn't work well for us -- we're having great luck with Telerik integrated into IronSpeed.

The only thing we use from IronSpeed 'reporting' is the basic PDF exports for simple library tables. We'd use the excel if more things were customizable (headers, values with custom code, etc.) like they are in the PDF/Word.

Many of our reports need children / sub tables/reports, that you really need a powerful report engine to produce and look good. 

RJ
Progytech

Registered:
Posts: 13
Reply with quote  #22 
I would prefer better direct integration with 3rd party reporting tool like DevExpress.
__________________
Edhy Rijo
Progytech (Computer Consultants)
The makers of CardTracking.Net
http://www.progytech.com
HorKar

Registered:
Posts: 71
Reply with quote  #23 
Hi Kirill,

I do not know whether this is your point, but I need to build a report as a PDF, DOC, RTF, XLS  ... which is directly send by mail (as mail text or attachement) instead of printing it. I posted this some weeks ago, but did not succeed until now (http://sjc.ironspeed.com/post/writing-a-file-and-sending-it-as-mail-enclosureello-6804441?pid=1281989100#post1281989100). 

Thank you and best regards

Horst
scrimej

Avatar / Picture

MVP Developer
Registered:
Posts: 236
Reply with quote  #24 
Any updates on this thread.  

I have a few projects in production and several coming down the line that will require some advanced reporting (grouping etc) and I though I have a good experience with SSRS for internal applications, I can't recommend it for public web sites.  My primary issue is the need to be alerted to install a client print control the first time you print from SSRS on the client side.   This leads to many issues, including but not limited to the fact that you need to install this control as an administrator.

I am going to do some exhaustive research particularly on Fast Reports and Telerik Reports but would hate to invest that time and money only to have Iron Speed take action on this issue in an upcoming release.

Can Iron Speed provide any feedback based on users comments of the direction they intend on heading and whether this is months or years away?

Thanks,
Jeremy
pinbot

Avatar / Picture

MVP Consultant
Registered:
Posts: 952
Reply with quote  #25 
Jeremy,

If you have any questions about Fast Reports I'd be happy to help you.

[biggrin]

__________________
C. Bryan Patrick II
Iron Speed Designer MVP Consultant
Pseudo Consulting
scrimej

Avatar / Picture

MVP Developer
Registered:
Posts: 236
Reply with quote  #26 
Thanks Bryan, I appreciate the offer and do have a couple of questions.  

I downloaded the demo of Fast Report and it was easy to integrate into Iron Speed.  Only took me an hour or so from start to finish to install, build a report, add the dll's to the project (thanks to your video), and then create a sample page with a button to stream the report to a PDF on the client.

Of course this was a simple list report, no parameters, etc.  My main questions are as follows:

1) Is it just as easy to build a report with Filter Criteria or do you let Iron Speed handle management of the filter values and pass those selections to the report object?

2) The demo on their site, shows the report in a preview mode rather than as a button that downloads a PDF.  Are the buttons for Save, Export to, etc built into a Fast Report viewer control or do you have to build that infrastructure from scratch?  

I guess what I'm getting at is that we have several reports that either default blank or to the "most popular selections" and then render the report in SSRS in the Report Viewer Control.  From this point, the users can change the filter criteria (these are SSRS filters, not Iron Speed), click the view report and the report is re-rendered with the updated information.  With Fast Report, how much work goes into getting a preview of a Fast Report report within an ASP.Net Iron Speed web application and then having the search, pagination, filters, and different export/print formats readily available?

The big issue I'm looking to solve is the need to install the SSRS client print control in a public setting.  SSRS works great for us internally but too many concerns with the client print control and rendering issues in various non IE browsers.  Do you have either of these issues with Fast Reports?

In the end, I think we'll still have a use for SSRS as we use the reportserver functionality to allow report subscriptions, auto deliver reports, and use the built in windows authentication to prevent unauthorized access to report folders.  However, I am not comfortable with SSRS as a public solution.  I don't know how far Iron Speed is going to go with their reporting solution or when it will be available and the price of Fast Report is certainly not excessive.

Thank You for sharing your experience with Fast Report.

Jeremy


pinbot

Avatar / Picture

MVP Consultant
Registered:
Posts: 952
Reply with quote  #27 
Hey Jeremy,

Sorry I didn't see your post until now.

1.  I've done it both ways.  It's very easy to pass filter parameters to the report.  So you design your report in the designer with "default" parameters and change them at run time.  On other applications I have a list of records I can check off and then I modify the SQL in the report's databand directly.  I can give you the code that retrieves the filters/sort order for a showtable and sets the appropriate SQL for FastReports.

2.  You don't need buttons to save/export/etc.  Or even the ReportViewer control.  Just call the Export function on the report object.  I usually stream the pdf output to a memory stream and then directly to the browser (need to set smooth panel updates to false).  So no saved temp files needed.  

Here's the entire button_click to export a pdf report, passing a couple of parameters and exporting PDF file to the browser.

Code:

       FastReport.Report Rpt = new FastReport.Report();
        Rpt.Load(Page.Server.MapPath("../App_Data/MgtCoPortfolio.Frx"));
        Rpt.SetParameterValue("MgtCoId", SubjectId);
    Rpt.SetParameterValue("Market", Session["Market"].ToString());
    
        Rpt.Prepare();
        FastReport.Export.Pdf.PDFExport export = new FastReport.Export.Pdf.PDFExport();
        export.PrintOptimized = false;
        export.OpenAfterExport = false;
    export.EmbeddingFonts = true;
        System.IO.MemoryStream s = new System.IO.MemoryStream();
        Rpt.Export(export, s);
        s.Position = 0;
        Page.Response.ClearHeaders();
        Page.Response.Clear();
        Page.Response.Cache.SetMaxAge(new TimeSpan(0));
        Page.Response.Cache.SetExpires(new DateTime(0));
        Page.Response.Cache.SetNoServerCaching();
        Page.Response.ContentType = System.Net.Mime.MediaTypeNames.Application.Pdf;
        Page.Response.AppendHeader("Content-Disposition", "Attachment;filename=\"Portfolio.pdf\"");
        Byte[] buffer = new Byte[s.Length];
        s.Read(buffer, 0, (int)s.Length);
        Page.Response.BinaryWrite(buffer);
        Page.Response.Flush();
        Page.Response.End();

__________________
C. Bryan Patrick II
Iron Speed Designer MVP Consultant
Pseudo Consulting
Gerard

Registered:
Posts: 588
Reply with quote  #28 

 
I know a new edition is due soon but:

Recently a local news paper has been running a series of data intensive interactive maps.
and I see a big scope for this sort of thing in the future with better graphics
It would be neat  to see a tool that can build this sort of thing quickly.
3 differing styles
http://www.nzherald.co.nz/nz/news/article.cfm?c_id=1&objectid=11283273
http://www.nzherald.co.nz/nz/news/article.cfm?c_id=1&objectid=11254133
http://www.nzherald.co.nz/nz/news/article.cfm?c_id=1&objectid=11254032
http://www.nzherald.co.nz/nz/news/article.cfm?c_id=1&objectid=11170255

Dreaming

Gerard
pk_davidson

Registered:
Posts: 223
Reply with quote  #29 
Gerard:
You're now into the world of GIS with that request.
ESRI is the big player of course.  ArcMap, ArcView, ArcCatalog, etc....

Regarding the original posting:  integrate Telerik Reports ?  Bundle it?  We're very happy with that product.  It will do about anything you want.  I've had some frustrating moments though with updates and installs.

__________________
Paul
Gerard

Registered:
Posts: 588
Reply with quote  #30 
the reporting tool for the roading is a standard 3d reporting tool  I am told.
In todays market we also don't need ESRI  there are many groups collecting data and linking it to google maps which ISD already supports.
All the data driving the maps is available to the public.
My view is that the Guys at ISD are Smart but I see a package that improves incrementally

with a few bug fixes and some nice  to have features. Yet there are many areas that ISD can show leadership in this space by leveraging what ISD knows about our databases 
and what is likely to be asked regarding the data. examples
Grouping could do auto sub totals and totals. A lot of the things happening in the formula space could be simplified and the underlying data used to build the code  ( Think how excel does all this ( I know its not directly comparable ) Reporting needs to get away from paper reports it needs to be visual. Start reading up on Generation Z if you want to see the future. 5 screens at a time ? not 2 or 3. 
Gerard
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Download Iron Speed Designer

Terms of Service Privacy Statement