filtering dynamic column from a cross tab in birt report

Hi All,

I am new to birt. I will like to create a report which will have a mix of static and dynamic fields as shown below:-

Subj(st.field) ScrinUnittst1 ScrinUnittst2 Student1 Student 2 Student3 ....

Now depending on the student the subject name and score will apprear in the report.

In the main report all the Students name will appear as columns as shown above(the students' names will be retrieved from database) and in the sub report only one students name will appear as the column

So,the report of Student 2 will look like ths:-

Subj(st.field) ScrinUnittst1 ScrinUnittst2 Student 2

I am using dyanmic cross tab to get the main report.However i am not able to get the individual report for a single student.

Anybody having any idea please help.

Thanks,
Aniruddha

Find more posts tagged with

Comments

Virgil Dodson

Hi Aniruddha,

Can you give me a better idea of what you mean by sub report? Are you hyperlinking out to another report, or embedding a table within a crosstab?

ani125

Hi Virgil,

I was able to ultimately filter the cross tabs. What i meant by the subreport is just a hyperlink to a more detailed report for a column element.

I have attached a screenshot of the same.

Thanks,
Aniruddha.

rajputbirt

Hi Aniruddha,

Well I am facing similar kind of problem like you.

Actually I want the values of a specific cloumn in the cross tab to have hyperlinks while others will not have any hyperlinks.

Please suggest how you had filtered the data.

Bhagwat

ani125

Hi Bhagwat,

What i did was to create an hyperlink for my column dimension with the following :-

1. Select the coloumn dimension you want to have hyperlinked to.
2. Go to property Editor>>Hyperlink.
3. In the Hyperlink options window select "Drill-through" as the hyperlink type and then select the Target report and mention the parameter with the required values selecting the appropiate parameter name and the value.

But I son't think this satisfy the optional hyperlink that you require.

A propable solution to this may be to add a extra group to your data cube with customised rows retrieved from the data set which requires the hyperlink and another group with customised rows retrieved from even another data set with rows that do not require the hyperlink.YOu can then add them to the coloumn dimension and create the hyperlink as mentioned above. Give it a try and let me know .

Thanks,
Aniruddha

shweta2830

Hi Aniruddha,

I am facing the same problem.

Problem description.

I have the one report which i have created based on the cross tab.
From summary filed of cross tab , need to drill down detail report.
Example

Suppose my summary filed have count 4 (4 student got xx marks in that subject) when I will click on count 4 , I should get the detail information of those four stdent.

I have created hyperlink on summary filed( on 4) and paasing the parameter using Group to drill down report , but when I tried this , drill down report did not return any rows.
It seems like that it is not able to pass the paramer to drill down report.

Kindly help me with this, it seems to be critical issue for me.

Thanks in advance

mwilliams

Hi shweta2830,

What version of BIRT are you using?

shweta2830

Hi ,
Now I am able to drill down the report from the cross Tab.

Thanks for the reply.

But now I have another Issue.
I have one JSP page from that JSP I am passing the parameter as Input to the Cross Tab.
Based on input Cross tab should have diffrent dimenssion (Group) and Measure (Detail).

I tried with applying formula while setting the level of Group but was unable to implemet that.

I am using the 2.3.1 version of BIRT.

This is very critical issue for me , as this can be easily implemented in Qlickview so It a big challenge for me to implemet in BIRT.

Thanks in advance.

Manis13

Hi Everyone,

I'm successfully able to drill down from summary report to detail report.

But, in case of cross tab, hyperlink is not working. Parameters are not passing in cross tab.

Can any one please help me to resolve this issue.

I'm in critical.

Thanks and Regards,
Manikandan.