Main Report Page with multiple visible/nonvisible sub reports

Hi,
I have mainly the problem, that when I use a lot of subreports and
I get error messages by the report server.
Even I think it will not a got solution in matter of performance.
But how can I create a report, which will be configured by a
a field record ?
Up to now, I only use the sub reports with the function "hide " sub report.
The main page of the report will have the parameter selection box, to select
the datasets.
Depending on a record field information, I show only the depending reports,
which are shown different datas from different tables. Even different chart
data.
But I get the impression, that internally all query will be execute, even,
when the
visible flag is set to "hidden".
Need help for a better solution.
Best regards
RichardOn Nov 26, 8:59 am, Ritchie <Ritc...@.discussions.microsoft.com> wrote:
> Hi,
> I have mainly the problem, that when I use a lot of subreports and
> I get error messages by the report server.
> Even I think it will not a got solution in matter of performance.
> But how can I create a report, which will be configured by a
> a field record ?
> Up to now, I only use the sub reports with the function "hide " sub report.
> The main page of the report will have the parameter selection box, to select
> the datasets.
> Depending on a record field information, I show only the depending reports,
> which are shown different datas from different tables. Even different chart
> data.
> But I get the impression, that internally all query will be execute, even,
> when the
> visible flag is set to "hidden".
> Need help for a better solution.
> Best regards
> Richard
In terms of the auto-execution of datasets, I'm not sure; however, you
might want to include all the subreports in the main report as table
controls (where applicable). Then toggle the visibility of the
individual table controls (via: right-clicking the top-left corner of
the table control >> select Properties >> select Visibility >> select
'Visibility can be toggled by another report item' >> then select a
control from the list below 'Report item:'). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

main page blank after new install ?

Hi,
I installed reporting services on 2003 (IIS6, front page ext, asp.net, no
vb.net). When connecting to http://server im directed to
http://server/Reports/Pages/Folder.aspx . The main form header shows HOME /
MY SUBSCRIPTIONS / HELP but the main page is blank.
Anyone know why and how to sort ?
Thanks
Scottim just wondering if its because i didnt install VB.net 03 so the report
designer is not available.|||on the hosting server i enter http://localhost and get the Report Manager
with all the options.
From a client i get a blank home page. I assume because nothing is setup yet
which is fine.

Mailing Labels

Is it possible to do mailing labels through Reporting Services. I can't
figure out a way to display three columns of information per page'?
anybody have any examples?I set up a report to print Avery 5162 labels yesterday. I had to play with
the margins, font size, textbox positioning, and textbox spacing to get the
data to fit on the labels correctly. After adding a blank report and creating
a dataset here are the steps I took to create the report.
Hope it helps. 1) Change Report Properties Margins to: 0.125in, 0.125in,
0.825in, 0in (Your's will probably be different.)
2) Change Body Layout Properties: Columns=2, ColumnSpacing=0.25in, Size=4in,
1.375in(the label size)
3) Add a List object: Location=0in, 0in, Size=4in, 1.375in(the label size)
4) Add a Rectangle object: Location=0in, 0in, Size=4in, 1.375in(the label
size)
5) Add and arrange data fields When you first view the report on the Preview
tab it will only show one column. You'll need to switch to Print Preview to
see the two column report.|||Thanks.. .I actually already did practically the same thing.... take care...
"GORAMS" wrote:
> I set up a report to print Avery 5162 labels yesterday. I had to play with
> the margins, font size, textbox positioning, and textbox spacing to get the
> data to fit on the labels correctly. After adding a blank report and creating
> a dataset here are the steps I took to create the report.
> Hope it helps. 1) Change Report Properties Margins to: 0.125in, 0.125in,
> 0.825in, 0in (Your's will probably be different.)
> 2) Change Body Layout Properties: Columns=2, ColumnSpacing=0.25in, Size=4in,
> 1.375in(the label size)
> 3) Add a List object: Location=0in, 0in, Size=4in, 1.375in(the label size)
> 4) Add a Rectangle object: Location=0in, 0in, Size=4in, 1.375in(the label
> size)
> 5) Add and arrange data fields When you first view the report on the Preview
> tab it will only show one column. You'll need to switch to Print Preview to
> see the two column report.

mail merge problem

Hi there,
maybe you can help me. is there way to
skip lines in the mail sticker? we
are using 20 mail stickers/page paper and
usually the user uses only 4-5 stickers
we want to maximize the use of the unprinted
stickers is there way to skip the already
printed sticker by passing parameter "no. of skips"?
we are connected to an oracle database and uses
pl-sql with cursor ref.
thanks.Maybe you could just put something in the report header to skip the relevant amount of space. Here's two things I can think of:
1) A formula that writes 'n' * 'parameter' empty lines, assuming you can exactly match 'n' lines to a sticker.
2) An 'empty' sticker in a subreport, and force 'parameter' detail records to skip the space by using the command statement
select * from (select level from dual connect by level <= {?parameter})

(Beware, DO NOT run that statement without the <= clause!)|||thanks for your reply.
actually thats what i did below is current program running,
just asking maybe other solution by not doing this like for loop etc.

SELECT
FROM DUAL
where 1 <= p_noskip
union all
SELECT
FROM DUAL
where 2 <= p_noskip
union all
SELECT
FROM DUAL
where <till 19> <= p_noskip|||So replace those 19 unioned select from dual statements with one single statement:

select * from (select level from dual connect by level <= {?parameter})

Remember to create the parameter in the add command screen, not the field explorer/|||ThanksJagan, it works! I just added connect by level.
select '' from dual connect by level <= <parameter>|||Yeah, that'll work too - you don't need the extra select around the outside if you just want 'n' records as you do.
However, the nice thing about the full statement is that you get an ordered, contiguous set of values from 1..n
As level's a reserved word, I suppose it's more correct to actually write

select x from (select level as x from dual connect by level <= {?parameter})

so that you don't have to select * (literally, the * character)
If you write
select level from (select level from dual connect by level <= {?parameter})
then you find that you get 'parameter' records all with value 0

But hey, this is a Crystal forum not an Oracle one...but someone might find this useful...

Magic Blank Page

Getting the magic blank 2nd page for a report that seems to be well within 1
page (brings back Access memories). Can't seem to figure out how to diag or
what to look for.
--
William Stacey [MVP]This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I'm with ya pal. I have 5 charts + a header all easily fitting on a =8.5x11.0 with point 25s all the way around and print preview is actual =pages * 2.
Unfortunately, this is one of those engagements where printing is =important.
-- TIM ELLISON
"William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message =news:%23Bw5dDTHGHA.3532@.TK2MSFTNGP14.phx.gbl...
Getting the magic blank 2nd page for a report that seems to be well =within 1 page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.
-- William Stacey [MVP]

--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

I'm with ya pal. I have 5 charts =+ a header all easily fitting on a 8.5x11.0 with point 25s all the way around and =print preview is actual pages * 2.
Unfortunately, this is one of those =engagements where printing is important.
-- TIM ELLISON
"William Stacey [MVP]" = wrote in message news:%23Bw5dDTHGHA.=3532@.TK2MSFTNGP14.phx.gbl...Getting the magic blank 2nd page for a report that seems to be well within 1 =page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.-- William Stacey [MVP]

---

--=_NextPart_000_0015_01C61D8A.A9892E70--