2

I am looking for suggestions from user community regarding some options for complex reporting. I would like to allow users to browse for data and then based on their selection they can generate a preformatted report and download the reprot as PDF. I want to have reporting logic on server so that we can accommodate any future technology changes and be able to use existing development

I have looked at number of third party controls like Infragistics/Comopnent One/Pertpetuum/ Dev Express/Telrik/Active Reports. I am not sure Crystal reports are an option. Most of the third party controls that I have seen are based on client side.

Appreciate any feedback.

Thanks Jay

Improve this question
3
  • Do you need to include a map in the report?
    – Kirk Kuykendall
    Feb 13, 2012 at 18:39
  • There are a variety of ways you can do this; in the past I have had a webservice on my server that would take the query as passed from the client-side UI that would build a resultset on the server, then write a PDF file using appropriate controls and send to the user the link when ready; usually via email since some could be long running and I wouldn't want to have the user locked in waiting.
    – D.E.Wright
    Feb 13, 2012 at 19:28
  • Thanks for the responses. Kirk, Map is not a requirement but it would be nice to have. D.E., I think this is the direction that I am heading. Would you mind sharing some more details on how you implemented your solution. In my case report will be a complex report leveraging various data sources in oracle DB. Thanks Jay
    – jay
    Feb 15, 2012 at 16:16

2 Answers 2

Reset to default
4

I am a big fan of SQL Server Reporting Services (free with SQL Server 2008) and personally prefer it over Crystal.

Although there is no native support for it with ArcGIS (although promote the idea here) I have seen some people integrate the two using Query Layers with v10.

This forum post has more details and a video, and also some info on how to grab a map image via REST and some server side .NET code.

I also understand that at 10.1, there has been some work on reporting and having it exposed via ArcPy means you will be able to utilise it via a geoprocessing service, meaning no reliance on a 3rd party reporting tool.

I am associated with a product called Dekho, but it does have great reporting functionality built into the product - more info you can check out some blog posts on integrating it with SSRS here.

Improve this answer
1

Latitude Geographics' product Geocortex Essentials is one option. You are able to create report templates that can generate a PDF based on what you are looking at ("print templates") or from a selection of data in a viewer ("layer reports").

Reports are generated server-side with the intent that you can replace the viewer with another technology without having to re-create your reports.

Disclaimer: I work at Latitude Geographics, although not directly on the Essentials product.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.