C1 Community

Hi, I got a problem regarding your C1WebReport control.

 I'm using a subreport in an report and I'll submit the RecordSource of this Subreport via my code with a stored procedure that appears like:

 
ALTER PROCEDURE [dbo].[get_Positions]
(
    @ID nvarchar(50),
    @TYPE nvarchar(50)
)

AS

BEGIN
SELECT * FROM qryITEM_LIST WHERE ID = @BT_ID AND TYPE = @BT_TYPE

end
 

qryITEM_LIST is a View and works without any problems.

My source code is like the following:

this.C1WebReport1.Report.Fields["subReport"].Subreport.DataSource.RecordSource = "get_Positions('" + this.GetUrlParam("ID") + "', '" + this.GetUrlParam("TYPE") + "')";
                

where GetUrlParam is a function to get parameters out of the URL. Everything fine, my goal was to filter the results for the subreport via the ID and TYPE. Works great, but (I have to say the subreport is in the detail section of my main report) it repeats itself over and over again.

For example, I have 2 Items in the ItemList with ID = 2999 and TYPE = ABC.

The report shows me the following:

1  Article

2 Article2

1 Article

2 Article2

1 Article

2 Article2

1 Article

2 Article2

Might you have something to help me with this problem? Sometime sit's different and just shows everything 3 or 2 times. I don't know...

Greetings 

<D-eath> wrote in message news:203476@10.0.1.98...

Hi, I got a problem regarding your C1WebReport control.

 I'm using a subreport in an report and I'll submit the RecordSource of this Subreport via my code with a stored procedure that appears like:

ALTER PROCEDURE [dbo].[get_Positions]
(
    @ID nvarchar(50),
    @TYPE nvarchar(50)
)

AS

BEGIN
SELECT * FROM qryITEM_LIST WHERE ID = @BT_ID AND TYPE = @BT_TYPE

end
 

qryITEM_LIST is a View and works without any problems.

My source code is like the following:

this.C1WebReport1.Report.Fields["subReport"].Subreport.DataSource.RecordSource = "get_Positions('" + this.GetUrlParam("ID") + "', '" + this.GetUrlParam("TYPE") + "')";
                

where GetUrlParam is a function to get parameters out of the URL. Everything fine, my goal was to filter the results for the subreport via the ID and TYPE. Works great, but (I have to say the subreport is in the detail section of my main report) it repeats itself over and over again.

For example, I have 2 Items in the ItemList with ID = 2999 and TYPE = ABC.

The report shows me the following:

1  Article

2 Article2

1 Article

2 Article2

1 Article

2 Article2

1 Article

2 Article2

 

Might you have something to help me with this problem? Sometime sit's different and just shows everything 3 or 2 times. I don't know...

 

Greetings 

---

http://helpcentral.componentone.com/cs/forums/p/74828/203476.aspx#203476

Hi,

 my problem is that it shows every single line of my sql output 3 or 4 times instead of just one time and I can't find the reason.

Greetings
 

<D-eath> wrote in message news:203506@10.0.1.98...

Hi,

 my problem is that it shows every single line of my sql output 3 or 4 times instead of just one time and I can't find the reason.

Greetings
 

---

http://helpcentral.componentone.com/cs/forums/p/74828/203506.aspx#203506

Hi, i guess you're having this problem because your subreport is inside the details section of your main report, which means that the data shown for the subreport is going to be repeated for every single detail you have in your main report.

 Try moving your subreport to the report footer section of the main report and see if that's the result you want.

 Regards, Gabriel

 Hi,

 thanks to Gabriel. That was the silly solution. :-)

 
Greetings