Crystal Report Viewer

S.Vinothkumar · #1 (**permalink**) 10-12-2007, 11:23 PM

I have written an application in ROR, and have now come to the reporting piece. Reports will be written in Crystal and I'm wondering if ROR will allow me to utilize the Crystal Reports Viewer. Has anyone had any experience with this? Any opinions or advice always appreciated!

Thank you!

krishnakumar · #2 (**permalink**) 10-15-2007, 10:43 PM

Crystal reports can be configured to read XML input and format it accordingly. Hence, you can use a rails handler to output your report data in XML format and that should allow crystal reports to read from it.

amansundar · #3 (**permalink**) 10-15-2007, 11:29 PM

My reports use xml schemas (xsd) and they get fed at runtime using .net dataset. I know this is possible in .net but how is it possible in ROR? How is the xml data fed to these reports in Ruby. Plus what about the report viewer?

krishnakumar · #4 (**permalink**) 10-16-2007, 04:35 AM

If you're using RoR, the part that gets the data should be a method in the model/ directory. For instance:

Code:

class MyData < ActiveRecord::Base
   def self.getmydata(key)
       find(:all, :conditions => ["field1 = ?", key])
   end
end

Then, your controller class would look something like this:

Code:

class mycontroller < ActionController
   def xml_output
       id = params[:id]
       @data = MyData.getmydata(id)
   end
end

and your view template for xml_output.rhtml could look something like this,

Code:

<data>
    <% for item in @data %>
    <item>
        <id><%= item.id %></id>
        <name><%= h(item.name) %></name>
        <desc><%= h(item.desc) %></desc>
    </item>
    <% end %>
</data>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Crystal Report Issues	Sundaram	ASP and ASP.NET Programming	0	03-10-2008 01:53 AM
crystal reports	dips	ASP and ASP.NET Programming	0	10-07-2007 05:00 AM
Export to Excel option is not working in Crystal Report with service pack 2	tsureshk	ASP and ASP.NET Programming	1	10-06-2007 02:57 AM
Implementing Crystal Report in Web Application	oxygen	C# Programming	0	07-15-2007 10:40 PM
Crystal Report in Vb.net	ewriter	VB.NET Programming	1	04-24-2007 07:01 AM