Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
    
Do you need to include a map in the report? –  Kirk Kuykendall Feb 13 '12 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 '12 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 '12 at 16:16

2 Answers 2

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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