Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Dataset that this chart uses has been changed. This chart can no longer be rendered.
Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1374154] Thu, 22 May 2014 13:51 Go to next message
Marc Arbour is currently offline Marc ArbourFriend
Messages: 36
Registered: March 2014
Member
Has anyone had this issue,

This is happening on a report that works just fine for which I am adding an expression with expression builder to pass a drill through parameter. (old report, new drill through)

Any help would be appreciated.

Regards

Marc

[Updated on: Thu, 22 May 2014 16:57]

Report message to a moderator

Re: Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1375681 is a reply to message #1374154] Fri, 23 May 2014 05:07 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Can you explain a little more in detail what you've done? Any way you can reproduce the issue with the sample database and attach the design?

Michael

Developer Evangelist, Silanis
Re: Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1376554 is a reply to message #1375681] Fri, 23 May 2014 13:15 Go to previous messageGo to next message
Marc Arbour is currently offline Marc ArbourFriend
Messages: 36
Registered: March 2014
Member
It will not be possible to include a rptdesign with a sample database for the implications would be to much work just to export the tableS required.

The thing is I have a very complex query for the dataset, which is
with param as
(  select ? p_ANFIN, ? p_per_fin, ? p_semaine_id, 1 p_dme, 1 p_dmo, '1,2,3,4,5,6' p_salle, ? niveau from dual)
--SELECT  count(*) --f.*, t.*, s.*, sp.*
select f2.groupement_id, f2.groupement, f2.titre, f2.id_salle, f2.desc_salle, sum(f2.dmo) dmo_som, sum(f2.dme) dme_som, count(dmo) dmo_count, count(dme) dme_count
from (
SELECT  f.dmo,
  f.dme,
  s.id_salle,
  s.desc_salle, 
  case 
     when param.niveau = 1 then to_number(t.anfin_id)
     when param.niveau = 2 then to_number(t.perfin_id)
     when param.niveau = 3 then to_number(t.semaine_id)
     else to_number(t.JOUR_SEMAINE) end groupement_id,
  case 
     when param.niveau = 1 then t.anfin_desc_courte
     when param.niveau = 2 then 'P'||to_char(t.perfin_id)
     when param.niveau = 3 then to_char(t.semaine_id)
     else t.jour_desc_courte end groupement,
case 
     when param.niveau = 1 then ''
     when param.niveau = 2 then ANFIN_DESC
     when param.niveau = 3 then PERFIN_DESC
     else SEMAINE_ANFIN_DESC_COURTE end titre
FROM DIM_TEMPS t
left join FAIT_BLOC_OPERATOIRE f on (  t.id_jour = f.id_jour)
join (select s2.* from dim_salle_bo s2, param
        where id_salle  in (
            select regexp_substr(param.p_salle,'[^,]+', 1, level) from dual
            connect by regexp_substr(param.p_salle, '[^,]+', 1, level) is not null ) or param.p_salle is null
      )s on ( f.id_salle = s.id_salle)
join param
    on ((t.ANFIN_ID = to_char(param.p_anfin) or param.p_anfin is null )
      and (t.PERFIN_ID = param.p_per_fin or param.p_per_fin is null )
      and (t.SEMAINE_ID = param.p_semaine_id or param.p_semaine_id is null )
      and (( f.flg_dmo = to_char(param.p_dmo) and f.flg_dmo = 1)
          or f.flg_dme = to_char(param.p_dme) and f.flg_dme = 1)
    ) where  t.id_jour <= ( SELECT max(dT_REF) FROM IS_BI_PROTO.DATE_REFERENCE_TMP)
  ) f2
    group by f2.groupement_id, f2.groupement,f2.titre,  f2.id_salle, f2.desc_salle


this creates me some columns I use for naming stuff in my report in a cross tab.

But the thing is that I have a graph based on another crosstab and as soon as I put some code with the expression builder to dynamically pass a parameter to my drill through, I receive this error message. As found here there are absolutely no explanation on this error message.

I hope it helps you help me.

Regards.

MArc

[Updated on: Fri, 23 May 2014 13:16]

Report message to a moderator

Re: Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1376600 is a reply to message #1376554] Fri, 23 May 2014 13:45 Go to previous messageGo to next message
Marc Arbour is currently offline Marc ArbourFriend
Messages: 36
Registered: March 2014
Member
No I cannot reproduce the resulta with the sample database for the complexity of the request cannot be reproduced with the simple sample data

OK, I have created the tables dump for you to investigate and I joint the rptdesign

Here they are:

[Updated on: Fri, 23 May 2014 13:55]

Report message to a moderator

Re: Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1377068 is a reply to message #1376600] Fri, 23 May 2014 18:14 Go to previous messageGo to next message
Marc Arbour is currently offline Marc ArbourFriend
Messages: 36
Registered: March 2014
Member
No Message Body
Re: Dataset that this chart uses has been changed. This chart can no longer be rendered. [message #1384634 is a reply to message #1377068] Thu, 29 May 2014 19:31 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Sorry for the delay. So, the complexity matters? It's not just about changing the dataSet?

The chart is bound to the crosstab that has a dataSet change?


Michael

Developer Evangelist, Silanis
Previous Topic:Image displayed only if condition met
Next Topic:Change the maximum value for y axis
Goto Forum:
  


Current Time: Fri Mar 29 00:55:44 GMT 2024

Powered by FUDForum. Page generated in 0.02524 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top