Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Cross tab: column area
leilaw
Hi,
I'm new in birt and I'm developing a cross tab report. I have two layers column area which I want to add a culomn next to the second layer as a description. under that description I want to have measurment details based on the first layer of the group. I am stucking on this isse. Please assist me on this issue.
Thanks in advance.
Find more posts tagged with
Comments
mwilliams
Hi leilaw,
Sorry for the delay in response. Do you think you could show an example of what you're talking about to help me understand exactly what you're wanting?
leilaw
Hi Michael,
I have another issue now, which I have attached the sample also.
I this report service locations are not static and are retrived from database. the number of service locations and its tales depends on the data in database. I need to know is there any way to develop such a report in birt design?
would you please guide me?
Thank you,
Regards,
Leila.
mwilliams
Hi Leila,
If the columns are all the same for all tables, it looks like you could just create a grouped outer table by service location and then embed a table from another dataSet and bind them using a filter or using dataSet parameter binding.
jeswin24
Hi William,<br />
<br />
can you please explain me in detail how to bind tables and crosstabs ? I have attached a file in my current format.<br />
Now the service location is in the left hand side and i need it to be displayed in the TOP<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73685" data-time="1298393429" data-date="22 February 2011 - 09:50 AM"><p>
Hi Leila,<br />
<br />
If the columns are all the same for all tables, it looks like you could just create a grouped outer table by service location and then embed a table from another dataSet and bind them using a filter or using dataSet parameter binding.<br /></p></blockquote>
jeswin24
<blockquote class='ipsBlockquote' data-author="'jeswin24'" data-cid="73725" data-time="1298452157" data-date="23 February 2011 - 02:09 AM"><p>
Hi William,<br />
<br />
can you please explain me in detail how to bind tables and crosstabs ? I have attached a file in my current format.<br />
Now the service location is in the left hand side and i need it to be displayed in the TOP<br /></p></blockquote>
mwilliams
Do you mean you need it at the top as the "title" or you want location at the top of the crosstab?
Let me know.
jeswin24
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73754" data-time="1298480036" data-date="23 February 2011 - 09:53 AM"><p>
Do you mean you need it at the top as the "title" or you want location at the top of the crosstab?<br />
<br />
Let me know.<br /></p></blockquote>
<br />
not as the title. The location should be at the top of each category. So it will have a layout specified in the .doc file...
mwilliams
Oh, you're talking about Leila's file above. This can be done how I said in the post following where the file was attached. If you create a list or table that consists of just the location, group it, and embed the detail table within the group, you can use filters or dataSet parameter binding to limit the detail data to the outer group value.
jeswin24
Hi,<br />
<br />
I have a PIE CHART and BAR CHART in ther report which also have a CROSSTAB in it.<br />
I want the user to be able to choose EITHER PIE CHART OR BAR CHART with or without the CROSSTAB.<br />
<br />
How can I attain this ? <br />
<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73831" data-time="1298550207" data-date="24 February 2011 - 05:23 AM"><p>
Oh, you're talking about Leila's file above. This can be done how I said in the post following where the file was attached. If you create a list or table that consists of just the location, group it, and embed the detail table within the group, you can use filters or dataSet parameter binding to limit the detail data to the outer group value.<br /></p></blockquote>
mwilliams
Meaning you want the user to be able to choose what they see in the report? Please explain a little more. Did you get the category issue thing done from above?
jeswin24
No, the category is still an issue. I was able to get the location as desired. But only the first location in the database is displayed and the crosstab is repeating the number of times of the service location. and the value inside each crosstab is the same.<br />
<br />
It would be really helpfull if you can provide me with an example.<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73952" data-time="1298645118" data-date="25 February 2011 - 07:45 AM"><p>
Meaning you want the user to be able to choose what they see in the report? Please explain a little more. Did you get the category issue thing done from above?<br /></p></blockquote>
mwilliams
What is your BIRT version? I'll make a quick exmaple.
jeswin24
BIRT 2.6, Using Eclipse Helio.<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74038" data-time="1298904541" data-date="28 February 2011 - 07:49 AM"><p>
What is your BIRT version? I'll make a quick exmaple.<br /></p></blockquote>
jeswin24
Hi, I have another question.
Can i make a table or crosstab dynamic... meaning the coloumns displayed should be chosen by the user.
mwilliams
A crosstab would do this automatically if you parameterize your query based on a user input. With a table, you'd have to know the available columns, ask the user to select what they want to see and then use the visibility property to hide the unneeded columns or create your table from scratch in script using the parameter to set up columns and bindings.
mwilliams
Here's a sample report showing how to embed a crosstab in a grouped table and get the correct data in the crosstab using a filter.
jeswin24
Hi, thanks for the reprt.
I am currently trying to make my reports mre interactive. I came across interactive viewer from actuate. i would like to know which viewer is best for interactivity and pricing of those...
mwilliams
Have you seen the product page for Actuate IV? You can download a free trial and see what you think there. I have pasted the link below. It is definitely a good solution for interactivity. I'm not in sales, so I don't know about pricing and all that, so I'll have to figure out the best way for you to go about finding that out and let you know. The "contact us" button in the top right corner might be a good start though.
http://www.birt-exchange.com/be/products/birt-user-experience/interactive-viewer/features/
