Datasets and Bands Conflict
Hello All
I have seen this item mentioned many times but I am unable to resolve it from other messages.
I have one dataset in which I want to group the report by Ship Name, then I want to list sailing dates (depature and arrival), along with a few other details.
I add the data set to the report via Report->Data menu and tick the appropriate box.
I create a group band and set the group to vessGroup.VesselName
I create a MasterDetail band and add the details. In design mode, I can view the report beautifully. Very Happy. [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Using Delpi 2009, under Vista Business. and Fast Rep. 4.7.120 I run the report from a very simple app. and when the report pops up I get a message:[/img]
If I remove the dataset from the report, I get an error from the data band that the dataset is not in the report. [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> The only places where the data set is refernced is on the Report, Group Header and the MasterDetail band. What am I doing wrong and how can i fix this problem. regards SeaCay[/img]
I have seen this item mentioned many times but I am unable to resolve it from other messages.
I have one dataset in which I want to group the report by Ship Name, then I want to list sailing dates (depature and arrival), along with a few other details.
I add the data set to the report via Report->Data menu and tick the appropriate box.
I create a group band and set the group to vessGroup.VesselName
I create a MasterDetail band and add the details. In design mode, I can view the report beautifully. Very Happy. [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Using Delpi 2009, under Vista Business. and Fast Rep. 4.7.120 I run the report from a very simple app. and when the report pops up I get a message:[/img]
"The following error(s) have occured:
Cannot use the same dataset for Report.DataSet and Band.Dataset"
If I remove the dataset from the report, I get an error from the data band that the dataset is not in the report. [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> The only places where the data set is refernced is on the Report, Group Header and the MasterDetail band. What am I doing wrong and how can i fix this problem. regards SeaCay[/img]
Comments
That connection is used when you run multi-design page reports and is connected to a different dataset( frxuserdataset or frxdbdataset) that will control the number of times the report is run
Yes that was the problem. All fixed now
Many thanks
SeaCay