Failed to open Rowset after adding parameter to BV

[gshadz37]

Hi All,
In CR10,I have recently added a parameter to my Data Foundation in hopes of passing the record selection to the server. The parameter was originally in the subreport of the report I am trying to optimize.
Now that it is in the BV, and I have updated the subreport links, I am getting a "Failed to open Rowset" error when running it.

Creating a new report against this BV runs without a problem, which leads me to believe the issue is being caused somewhere in the report.

I appreciate any help.

 

[Madawc]

Are you using an SQL Command? I got similar errors when I was using them, though the exact circumstances were different.

Please also explain what you mean by added a parameter to my Data Foundation

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[gshadz37]

Madawc - in the Data Foundation, for the business view, I added a new parameter called {Application Number}, and then added it to the Where of the SQL Command for the table in the data foundation, which looks like this:

select
'3319' as site_id,
applic.ap_name,
parms.q_ring,
parms.q_delay,
parms.q_ctype,
parms.q_reserved,
parms.q_network,
calldetail.applic_num,
calldetail.call_type,
calldetail.disposition,
calldetail.trans_type,
calldetail.ring_time,
calldetail.queue_time,
calldetail.delay_time,
calldetail.hold_time,
calldetail.talk_time,
calldetail.wrapup_time,
calldetail.ctype_time,
calldetail.dial_time,
calldetail.network_time,
calldetail.select_time,
calldetail.handws,
calldetail.orig,
calldetail.orig_type,
calldetail.orig_group,
calldetail.dest,
calldetail.dest_type,
calldetail.dest_group,
calldetail.ass_party,
calldetail.ass_type,
calldetail.dnis_digit,
calldetail.dial_digit,
calldetail.cflag,
calldetail.cflag1,
calldetail.cflag2,
calldetail.orig_date,
calldetail.orig_time,
calldetail.term_date,
calldetail.term_time,
calldetail.noise,
calldetail.volume,
calldetail.echo,
calldetail.call_id,
calldetail.track_num,
calldetail.track_seqno,
calldetail.track_node,
calldetail.to_node,
calldetail.from_node,
calldetail.calldata_a,
calldetail.calldata_b,
calldetail.calldata_c,
calldetail.calldata_d
from
calldetail@aspect_roch, applic@aspect_roch, parms@aspect_roch
where
calldetail.applic_num = applic.ap_num AND
calldetail.calldata_f != parms.company AND
(calldetail.term_date >= {?StartDate} AND
calldetail.term_date <= {?EndDate}) AND
(calldetail.term_time >= {?StartTime} AND
calldetail.term_time <= {?EndTime}) AND
calldetail.applic_num in ({Application Number}) [/color green]

UNION ALL

select
'3319' as site_id,
applic.ap_name,
parms.q_ring,
parms.q_delay,
parms.q_ctype,
parms.q_reserved,
parms.q_network,
call_today.applic_num,
call_today.call_type,
call_today.disposition,
call_today.trans_type,
call_today.ring_time,
call_today.queue_time,
call_today.delay_time,
call_today.hold_time,
call_today.talk_time,
call_today.wrapup_time,
call_today.ctype_time,
call_today.dial_time,
call_today.network_time,
call_today.select_time,
call_today.handws,
call_today.orig,
call_today.orig_type,
call_today.orig_group,
call_today.dest,
call_today.dest_type,
call_today.dest_group,
call_today.ass_party,
call_today.ass_type,
call_today.dnis_digit,
call_today.dial_digit,
call_today.cflag,
call_today.cflag1,
call_today.cflag2,
call_today.orig_date,
call_today.orig_time,
call_today.term_date,
call_today.term_time,
call_today.noise,
call_today.volume,
call_today.echo,
call_today.call_id,
call_today.track_num,
call_today.track_seqno,
call_today.track_node,
call_today.to_node,
call_today.from_node,
call_today.calldata_a,
call_today.calldata_b,
call_today.calldata_c,
call_today.calldata_d
from
call_today@aspect_roch, applic@aspect_roch, parms@aspect_roch
where
call_today.applic_num = applic.ap_num AND
call_today.calldata_f != parms.company AND
(call_today.term_date >= {?StartDate} AND
call_today.term_date <= {?EndDate}) AND
(call_today.term_time >= {?StartTime} AND
call_today.term_time <= {?EndTime}) AND
call_today.applic_num in ({Application Number}) [/color green]


UNION ALL

select
'10400' as site_id,
applic.ap_name,
parms.q_ring,
parms.q_delay,
parms.q_ctype,
parms.q_reserved,
parms.q_network,
calldetail.applic_num,
calldetail.call_type,
calldetail.disposition,
calldetail.trans_type,
calldetail.ring_time,
calldetail.queue_time,
calldetail.delay_time,
calldetail.hold_time,
calldetail.talk_time,
calldetail.wrapup_time,
calldetail.ctype_time,
calldetail.dial_time,
calldetail.network_time,
calldetail.select_time,
calldetail.handws,
calldetail.orig,
calldetail.orig_type,
calldetail.orig_group,
calldetail.dest,
calldetail.dest_type,
calldetail.dest_group,
calldetail.ass_party,
calldetail.ass_type,
calldetail.dnis_digit,
calldetail.dial_digit,
calldetail.cflag,
calldetail.cflag1,
calldetail.cflag2,
calldetail.orig_date,
calldetail.orig_time,
calldetail.term_date,
calldetail.term_time,
calldetail.noise,
calldetail.volume,
calldetail.echo,
calldetail.call_id,
calldetail.track_num,
calldetail.track_seqno,
calldetail.track_node,
calldetail.to_node,
calldetail.from_node,
calldetail.calldata_a,
calldetail.calldata_b,
calldetail.calldata_c,
calldetail.calldata_d
from
calldetail@aspect_grby, applic@aspect_grby, parms@aspect_grby
where
calldetail.applic_num = applic.ap_num AND
calldetail.calldata_f != parms.company AND
(calldetail.term_date >= {?StartDate} AND
calldetail.term_date <= {?EndDate}) AND
(calldetail.term_time >= {?StartTime} AND
calldetail.term_time <= {?EndTime}) AND
calldetail.applic_num in ({Application Number}) [/color green]

UNION ALL

select
'10400' as site_id,
applic.ap_name,
parms.q_ring,
parms.q_delay,
parms.q_ctype,
parms.q_reserved,
parms.q_network,
call_today.applic_num,
call_today.call_type,
call_today.disposition,
call_today.trans_type,
call_today.ring_time,
call_today.queue_time,
call_today.delay_time,
call_today.hold_time,
call_today.talk_time,
call_today.wrapup_time,
call_today.ctype_time,
call_today.dial_time,
call_today.network_time,
call_today.select_time,
call_today.handws,
call_today.orig,
call_today.orig_type,
call_today.orig_group,
call_today.dest,
call_today.dest_type,
call_today.dest_group,
call_today.ass_party,
call_today.ass_type,
call_today.dnis_digit,
call_today.dial_digit,
call_today.cflag,
call_today.cflag1,
call_today.cflag2,
call_today.orig_date,
call_today.orig_time,
call_today.term_date,
call_today.term_time,
call_today.noise,
call_today.volume,
call_today.echo,
call_today.call_id,
call_today.track_num,
call_today.track_seqno,
call_today.track_node,
call_today.to_node,
call_today.from_node,
call_today.calldata_a,
call_today.calldata_b,
call_today.calldata_c,
call_today.calldata_d
from
call_today@aspect_grby, applic@aspect_grby, parms@aspect_grby
where
call_today.applic_num = applic.ap_num AND
call_today.calldata_f != parms.company AND
(call_today.term_date >= {?StartDate} AND
call_today.term_date <= {?EndDate}) AND
(call_today.term_time >= {?StartTime} AND
call_today.term_time <= {?EndTime}) AND
call_today.applic_num in ({Application Number})[/color green] [/color red]

 

[Madawc]

Sorry, outside of my experience. Can anyone else help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[beltmanjr]

Ok, I should know this one as I ran into it soo often.

But I cant remember the exact solution. I remember it to be something with the linking between tables in crystal and guess I had to erase all links and redo them. Probably verify the database too.

This error, your description of being able to build a new report of the same BV confirming this, seems to lay within the report only. You may therefore also wish to double check the source of each table you are using just in case.

And please let us all know the exact solution.