CrosS tab

i am getting this error when i am trying to design the Cross tab report. i want to find out where can i get the detailed error message.current the actuate eclise is throwing the following error

Report Generation Failed. cause : An exception occurred during processing. please see the following message for details:
exception.error

/***** there is no clear error description ***/

Find more posts tagged with

Comments

KavithaD

Hi,

Can you share your rpt design file or else can you create a sample report with classic model and post it.

Thank you,
Kavitha

pems

<blockquote class='ipsBlockquote' data-author="'KavithaD'" data-cid="66604" data-time="1279706745" data-date="21 July 2010 - 03:05 AM">
Hi, 
 
Can you share your rpt design file or else can you create a sample report with classic model and post it. 
 
Thank you, 
Kavitha </blockquote>
 
Hi kavitha, 
nice to meet you. we are doing experiments with eclipse Birt basically checking for the following. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/20060-percentage-on-grand-total/'>http://www.birt-exchange.org/org/forum/index.php/topic/20060-percentage-on-grand-total/</a> 
 
but when we contated the actuate people they asked to use their installer and when i tried to do the same it crated the error like that. now we able to do that with the classic model.can you please let me know how to compute the Grand Total and also the how to calculate the percentage on the grand total. the Birt s/w which we got from actuate is not not not showing the property to select the grand total. please see the following image

mwilliams

Hi pems,

So, you're using Actuate BIRT? Is this with any crosstab you try to create? Can you recreate the issue with the sample database?

mwilliams

pems,

Sorry, looks like I didn't see some posts. You have a crosstab working right now, but are unable to get the grand total to work? If so, you should just have to click on the icon to the right of the dimension there in your crosstab and the option to have grand totals should be there. Does it not have that option?

pems

mwilliams, 
in Bird is there any way that we can find out percentage on Grand total. that is what i am trying to find out.please go through the link if you get a chance <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/20060-percentage-on-grand-total/'>http://www.birt-exchange.org/org/forum/index.php/topic/20060-percentage-on-grand-total/</a> 
 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66731" data-time="1280171540" data-date="26 July 2010 - 12:12 PM">
pems, 
 
Sorry, looks like I didn't see some posts. You have a crosstab working right now, but are unable to get the grand total to work? If so, you should just have to click on the icon to the right of the dimension there in your crosstab and the option to have grand totals should be there. Does it not have that option? </blockquote>

mwilliams

pems,

You can create a percentage by dropping a data binding into the grand total column and making the expression to be something like data["fieldName_Group/DimensionName"]/data["fieldName"]. Then you'll just have to format the number to show a percentage. Using a grid inside the grand total area can help you arrage the items how you'd like as well. Hope this helps. Let me know if you have questions.