sql server reporting services: Subreports -- sql server reporting services

You're in the

sql server reporting services

group:

Subreports

Willo
3/29/2007 1:54:08 PM

sql server reporting services:

Hi;

i dont know if this is possible; i have 3 reports and each report has 4
parameters (parameters names are the same between them).

i want to integrate those 3 reports on one single report, I BELIVE that i
need to declare the parameters on the main report and link subreport's
parameters with main report's parameters (im correct?); anyway i did that
already, but subreports dont display, any sugestions?

TIA

Re: Subreports

Willo
3/29/2007 2:34:11 PM

do you think the parameter names are the problem?.. (they are the same on
the main report and subreports)

i did map the subreport's parameters to main report's parameters

another question:
main report does not have any data, im just using it to concentrate the
subreports

[quoted text, click to view]

Re: Subreports

Bruce L-C [MVP]
3/29/2007 3:17:51 PM

As far as I can tell you have it correct.
Do these steps:
1. Create each report that will be a sub report and test it on its own
2. Drag and drop onto a report with the parameters that you want
3. Right mouse click on the subreport and map the parameters.

This should work without a problem.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Subreports

Bruce L-C [MVP]
3/29/2007 4:08:39 PM

I didn't think it should be a problem having them the same. Try changing the
main report parameters and then map it.

And no, you don't have to have any data in the main report.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Subreports

Willo
3/29/2007 4:24:56 PM

didn't work...

id changed main report parameters and remaped them again against
subreport's, still does not show me subreports, when i test each subreport
individually they work great, i guy told me that maybe the problem lies on
one parameter that contains the DATABASE name, because it has to be dynamic.

this is the data code on one of the subreports (the code is almost the same
for each subreport); as you can see, it expects 4 parameters, BASEDATOS wich
contains database name, MESF is an integer, ANOF another integer and AP wich
is a hidden-internal parameter with a single quote as a value.

the main report has the same 4 parameters but id add a 2 after the name
(BASEDATOS2, MESF2, ANOF2 and AP2), so i maped (BASEDATOS to BASEDATOS2),
(MESF to MESF2) and so on....

im still stuck on this...

declare @ANOACT CHAR(4);
declare @MESACT CHAR(2);
declare @MESESC VARCHAR(300),@MESESA VARCHAR(300);
declare @MESESC1 VARCHAR(300),@MESESA1 VARCHAR(300);
declare @INCREMENT INT,@INC char(2);

SET @MESACT=CONVERT(char(2),@MESF)
SET @ANOACT=CONVERT(char(4),@ANOF)

IF @MESF < 10
begin
SET @MESACT='0' +RTRIM(LTRIM(@MESACT))
end

SET @MESESC='s.c01'
SET @MESESA='s.a01'

SET @INCREMENT=2
WHILE @INCREMENT <= @MESF
BEGIN
SET @INC=CONVERT(char(2),@INCREMENT)
IF @INCREMENT < 10
begin
SET @MESESC=@MESESC+'+s.c0' +RTRIM(LTRIM(@INC))
SET @MESESA=@MESESA+'+s.a0' +RTRIM(LTRIM(@INC))
end
else
begin
SET @MESESC=@MESESC+'+s.c' +RTRIM(LTRIM(@INC))
SET @MESESA=@MESESA+'+s.a' +RTRIM(LTRIM(@INC))
end
SET @INCREMENT=@INCREMENT+1
END

exec('Select c.Nombrecuenta,c.Codigotipocuenta,t.Nombretipocuenta,'+

'(s.SaldoInicial+(CASE when c.Naturaleza='+@AP+'D'+@AP+' then
(('+@MESESC+')-('+@MESESA+')) else (('+
@MESESA+')-('+@MESESC+')) end)) as Saldo'+

' from '+@BASEDATOS+'.dbo.cnt_saldos s'+
' inner join Grupovilla.dbo.CuentasContables c on
s.id_cuentascontables=c.id_cuentascontables'+
' inner join Grupovilla.dbo.TiposdeCuenta t on
c.codigotipocuenta=t.codigotipocuenta '+
' where c.nivel = 1 and LEFT(c.codigotipocuenta,1)='+@AP+'A'+@AP+' order by
c.codigotipocuenta,c.cta')

[quoted text, click to view]

Re: Subreports

Willo
3/29/2007 7:10:54 PM

i've give up!....

im trying to get rid of the subreports appoach using tables, but i need to
print 3 tables each one with it's own dataset...

table 1 needs to print on the left side of the page, table 2 needs to be
printed on the right side of the page and table 3 needs to be printed below
table 2,

how can i tell rs to ajust automatically tables vertical sizes depending of
dataset's data?

[quoted text, click to view]

Re: Subreports

Bruce L-C [MVP]
3/30/2007 12:00:00 AM

Can you put all this code into a stored procedure instead? Perhaps that is
your problem.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn