#AWS

[srakkiyannan]

Hi there,

 

I have connected MY Sql from AWS Jasper.

I am able to view the tables and can do the Graph if the tables are related, but i am not able to do if the tables are not related.

 

For example, i have Table A and Table B and these 2 tables are not related each other. How can get the data from both tables in Graph to compare.

Can you please advise is there way to do this?

 

Also, is there any way to call Stored procedure present in MY Sql from AWS Jasper?

If yes how?

 

Regards,
Senthil

[marianol]

To be able to see data from both tables in the same domain they need to have some type of relation between them, you do nto expand on how your data is laid out but since you mention "compare" there must be a common key between them. As an example let's say I have Table 1 with my quartery actuals and Table 2 with my quarterly budger, I can join those columns in the domain by the Qarter number they represent and then bring them in a crosstab or chart to show Actual vs Budget or use a calculated field to do Actual - Budget , etc. 

Whithout knowing more about your data that is the best I can do...

Re: Store Procs

You can use Store Procedures that return a cursor when using JasperSoft Studio Reports see http://community.jaspersoft.com/wiki/calling-microsoft-sql-stored-procedures-ireport 

Here ( http://community.jaspersoft.com/questions/524853/stored-procedures) you will also find an explanation on how to modify and create store procs that can be used also in domains.