tag:blogger.com,1999:blog-14521551.post114848535314501901..comments2024-01-01T04:30:26.017-08:00Comments on BIRT World: Joined Data Sets with BIRT 2.1Pipebaumhttp://www.blogger.com/profile/03537553362087737960noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-14521551.post-40886409888553096172009-03-24T10:24:00.000-07:002009-03-24T10:24:00.000-07:00Here is the bug link :https://bugs.eclipse.org/bug...Here is the bug link :<BR/><BR/>https://bugs.eclipse.org/bugs/show_bug.cgi?id=251178<BR/><BR/>Skandy.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14521551.post-85240489076741485202009-03-23T17:29:00.000-07:002009-03-23T17:29:00.000-07:00Alright,I've just tested with 2.3.2 and it works. ...Alright,<BR/><BR/>I've just tested with 2.3.2 and it works. I can drag the joint data set to insert it in the report. I can even use the joint data set for creating another joint data set. I can see all the output columns. :)<BR/><BR/>here is my post with the sample report:<BR/><BR/>http://www.birt-exchange.com/forum/designing-birt-reports/14359-problem-inserting-joint-data-set.html<BR/><BR/>Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14521551.post-82360953873800954102009-03-23T10:21:00.000-07:002009-03-23T10:21:00.000-07:00I tried to create a joint data set (still in 3.2.1...I tried to create a joint data set (still in 3.2.1) from two data sets that don't contain parameters. I was able to insert the joint data set in my report.<BR/><BR/>It seems like the designer won't let me insert a joint data set of data sets that contains parameters. Is this a limitation?<BR/><BR/>Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14521551.post-48547514442053601322009-03-23T09:53:00.000-07:002009-03-23T09:53:00.000-07:00I'm using Windows XP Pro. I will try BIRT 2.3.2.Bu...I'm using Windows XP Pro. I will try BIRT 2.3.2.<BR/><BR/>But in your example, you're using an older version (2.1) aren't you?<BR/><BR/>I don't understand why the designer don't let me insert a joint dataset. Do i need to modify something in the default output columns? Even when i try to use a joint data set in a new joint data set, no columns are displayed in the wizard.<BR/><BR/>Help...<BR/><BR/>Thank you..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14521551.post-18288427123954642872009-03-23T09:34:00.000-07:002009-03-23T09:34:00.000-07:00What os are you using? Also have you tried 2.3.2?...What os are you using? Also have you tried 2.3.2?Jason Weathersbyhttps://www.blogger.com/profile/13114050439576571984noreply@blogger.comtag:blogger.com,1999:blog-14521551.post-22154110223189160902009-03-23T09:23:00.000-07:002009-03-23T09:23:00.000-07:00Hi,i'm working with BIRT 2.3.1 and Joint Data Sets...Hi,<BR/><BR/>i'm working with BIRT 2.3.1 and Joint Data Sets. The designer won't let me drag/insert a Joint Data Set in my report. The preview for the joint data set works great but i can not drag it in the report neither use it to create another Joint Data Set.<BR/><BR/>Any idea? Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14521551.post-49356262377856830312009-02-03T08:36:00.001-08:002009-02-03T08:36:00.001-08:00http://www.eclipse.org/birt/phoenix/examples/repor...http://www.eclipse.org/birt<BR/>/phoenix/examples<BR/>/reports/birt2.1<BR/>/querymod/index.phpJason Weathersbyhttps://www.blogger.com/profile/13114050439576571984noreply@blogger.comtag:blogger.com,1999:blog-14521551.post-50808883312811794532009-02-03T08:36:00.000-08:002009-02-03T08:36:00.000-08:00Yes you can do that. You can modify the query usi...Yes you can do that. You can modify the query using property binding or script. Take a look at this example:<BR/><BR/>http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/querymod/index.phpJason Weathersbyhttps://www.blogger.com/profile/13114050439576571984noreply@blogger.comtag:blogger.com,1999:blog-14521551.post-24703844397970070262009-02-02T23:43:00.000-08:002009-02-02T23:43:00.000-08:00Sory for this OOT question, but I got trouble with...Sory for this OOT question, but I got trouble with this. Can we make dynamic sql query for the dataset?<BR/>I need something like a dynamic "Where" clause... I need to make a report that ask user which field used by user to query the data.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14521551.post-1152889324873539632006-07-14T08:02:00.000-07:002006-07-14T08:02:00.000-07:00You could modify the sql query at runtime to appen...You could modify the sql query at runtime to append a where clause using the username. Is this what you need?<BR/><BR/>JasonJason Weathersbyhttps://www.blogger.com/profile/13114050439576571984noreply@blogger.comtag:blogger.com,1999:blog-14521551.post-1152825906650026642006-07-13T14:25:00.000-07:002006-07-13T14:25:00.000-07:00How do you custom extend a dataset so as to restri...How do you custom extend a dataset so as to restrict what a user can see. I mean, how can restrict a user from seeing data that he is not supposed to see when viewing a birt report ? All I have in the context is a username at the point of executing a reportAnonymousnoreply@blogger.com