Hello All,
Is there a possibility to copy a dataprovider inside the same report? I have a quite long query with a lot of objects selected. I need the same query with only few changes in the conditions. Do I really have to rebuild the query again or is there a solution that makes life easier?
ibrahim K. (BOB member since 2002-09-17)
[quote:89393cc92b=“ibrahim K.”]Hello All,
Is there a possibility to copy a dataprovider inside the same report? I have a quite long query with a lot of objects selected. I need the same query with only few changes in the conditions. Do I really have to rebuild the query again or is there a solution that makes life easier?
[/quote]
Hi Ibrahim
There’s no default feature in BO to do this 
.
However, this is a quite common need, so some guys have built an addin (VBA code) that creates a new menu in your BO menus, and that allows you to do that 
.
You can download it there.
Have fuuuuuuuuun.
Pierre 
(BOB member since 2002-09-05)
You can find the macro on the Integra library web page. It works wonderfully! The only catch I’ve found is that you must go back in and make sure that “no duplicate rows” is checked…I’ve missed it more than once…and now I don’t seem to forget! 
Eileen King 
(BOB member since 2002-07-10)
and please please don’t forget to search first, then ask .
Cindy Clayton (BOB member since 2002-06-11)
Hello,
Thanks for your help 
I installed an tried to duplicate the dataprovider and it FAILED!!
error during SQL generation:
one of the properties in the query is not valid (QP0010)
a new dataprovider is created but it is empty. 
ibrahim K. (BOB member since 2002-09-17)
Which add-in are you using? The one of Integra web-site, or Dwayne’s one?
What does your dataprovider look like? Has the generated SQL anything special?
Pierre (BOB member since 2002-09-05)
[quote:d0d9ca40f7=“ibrahim K.”]Hello,
Thanks for your help
I installed an tried to duplicate the dataprovider and it FAILED!!
error during SQL generation:
one of the properties in the query is not valid (QP0010)
a new dataprovider is created but it is empty.
[/quote]
Which of the utilities were you using? I assume the “source” data provider runs successfully first? Is there anything particularly different or complex about the data provider?
Dwayne Hoffpauir (BOB member since 2002-09-19)
That’s funny: different words, but same questions 8)
Pierre (BOB member since 2002-09-05)
first i tried with a subquery, it failed
then deleted the subquery and started again, it failed again.
Something special to the query : I don’t think so.
ibrahim K. (BOB member since 2002-09-17)
[quote:9ef6a71632=“ibrahim K.”]Something special to the query : I don’t think so.
[/quote]
Can you paste your SQL code (without the subquery since the add-in does not handle subqueries)?
And please mention the addin you are using: Integra’s one or Dwayne’s one?
Pierre (BOB member since 2002-09-05)
this is the sql-code:
SELECT
VHCL_ORD.T_CHASSIS,
VHCL_ORD_CFU.PRODLEVEL_SYM,
COUNTRY.COUNTRY,
P_130.LINE_GRP,
VHCL_ORD.PLAN_PRIO_CD_COP,
PRCS2.PLAN_END_DT,
PRCS2.PLAN_END_DATETIME,
PRCS2.ACTU_END_DT,
PRCS2.ACTU_END_DATETIME,
VHCL_ORD.CDDEPT_FO || VHCL_ORD.CDSTOCK_FO,
lpad(STT_PRCS.NM,((to_number(STT_PRCS.LVL_NR)-1)3)+Length(STT_PRCS.NM),’ '),
STT_PRCS.TREE_ORDER,
SUM(PRCS.WKLD_MIN)
FROM
VHCL_ORD,
COUNTRY,
P_130,
VHCL_FAM3,
STT_PRCS,
STT_PRCS STT_PRCS2,
STT_PRCS STT_PRCS1,
PRCS PRCS2,
PRCS,
PRCS PRCS1,
VHCL_ORD_CFU
WHERE
( PRCS.FIRST_ASS_DATETIME=VHCL_ORD.FIRST_ASS_DATETIME and PRCS.VHCL_ORD_ID=VHCL_ORD.VHCL_ORD_ID )
AND ( PRCS.STT_PRCS_ID=STT_PRCS.STT_PRCS_ID )
AND ( VHCL_ORD_CFU.FIRST_ASS_DATETIME=VHCL_ORD.FIRST_ASS_DATETIME and VHCL_ORD_CFU.VHCL_ORD_ID=VHCL_ORD.VHCL_ORD_ID )
AND ( PRCS1.FIRST_ASS_DATETIME=VHCL_ORD.FIRST_ASS_DATETIME and PRCS1.VHCL_ORD_ID=VHCL_ORD.VHCL_ORD_ID )
AND ( PRCS1.STT_PRCS_ID=STT_PRCS1.STT_PRCS_ID )
AND ( PRCS2.STT_PRCS_ID=STT_PRCS2.STT_PRCS_ID )
AND ( VHCL_ORD.FIRST_ASS_DATETIME=PRCS2.FIRST_ASS_DATETIME and VHCL_ORD.VHCL_ORD_ID=PRCS2.VHCL_ORD_ID )
AND ( P_130.VHCL_ORD_ID = VHCL_ORD.VHCL_ORD_ID )
AND ( VHCL_FAM3.FIRST_ASS_DATETIME=VHCL_ORD.FIRST_ASS_DATETIME and VHCL_FAM3.VHCL_ORD_ID=VHCL_ORD.VHCL_ORD_ID )
AND ( COUNTRY.CODE=VHCL_ORD.CTRY_SYM )
AND (
STT_PRCS2.STT_PRCS_ID IN (5654, 94)
AND PRCS2.ACTU_END_DT < PRCS2.PLAN_END_DT
AND PRCS2.ACTU_END_DT >= to_char(sysdate,‘iYYY-IW’)
AND VHCL_ORD.PLAN_PRIO_CD_COP IS NULL
AND STT_PRCS1.STT_PRCS_ID = 2098
AND PRCS1.ACTU_ST_DT IS NULL
AND STT_PRCS.STT_PRCS_ID IN (5654, 94, 92, 118)
AND (VHCL_FAM3.FAM251 IN ('62’, ‘64’, '82’, ‘8*4’)
OR P_130.LINE_GRP = ‘81’)
)
GROUP BY
VHCL_ORD.T_CHASSIS,
VHCL_ORD_CFU.PRODLEVEL_SYM,
COUNTRY.COUNTRY,
P_130.LINE_GRP,
VHCL_ORD.PLAN_PRIO_CD_COP,
PRCS2.PLAN_END_DT,
PRCS2.PLAN_END_DATETIME,
PRCS2.ACTU_END_DT,
PRCS2.ACTU_END_DATETIME,
VHCL_ORD.CDDEPT_FO || VHCL_ORD.CDSTOCK_FO,
lpad(STT_PRCS.NM,((to_number(STT_PRCS.LVL_NR)-1)*3)+Length(STT_PRCS.NM),’ '),
STT_PRCS.TREE_ORDER
ibrahim K. (BOB member since 2002-09-17)
Another “BOB” rant I think. I just realized I’m having the same conversation with the same person in two different threads. Ibrahim, can we please keep to one thread?
Dwayne Hoffpauir (BOB member since 2002-09-19)
Seeing the two threads, I now know you work with Dwayne’s add-in.
Pierre (BOB member since 2002-09-05)
actually I used both add-ins
DB-version is Oracle 817
BO-version: 513
runs OK on DB, without any errors
the data provider runs OK
now I leave, will catch this up again on monday,
nice weekend
ibrahim K. (BOB member since 2002-09-17)
(BOB member since 2002-06-20)