[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] RE: Heading question
- Subject: Re: [sqr-users] RE: Heading question
- From: "jiju vengal" <jijucvengal@gmail.com>
- Date: Sat, 29 Jul 2006 11:49:04 +0530
- Delivery-date: Sat, 29 Jul 2006 02:21:03 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=Bwyqw+2qMbeWHbZ1KQs/T/xCadwb/5q0yvXg4/BI/6HJcIfoK5vE95jvRGzjLX/VZipG/Geo1VTNwQTOnb7sig9fC6OWgA2zJSWZa3cc2HJq0/d8OpczoTtuA50KT7NU5EduiPx0Lw1fkZg5lX+unVt+BrmcfFua3eiaaSXqwwU=
- In-reply-to: <E9A8630947C17449B2E7CE5B385ED1FA08097B@and09.drc.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <E9A8630947C17449B2E7CE5B385ED1FA08097B@and09.drc.com>
Hi David,
I would do it using the ALTER-REPORT function.
I am sure that it should solve the problem.
That is, define different BEGIN-HEADING sections and use the required ones
as per the run time requirement.
Cheers,
-Jiju.
On 7/27/06, White . Denise <DWhite@drc.com> wrote:
>
> Well, I don't really understand your syntax, so I can't tell you why
> it's not working. What is "do print s.lines"? I have never seen "do"
> and "print" together like that; normally when you use "do", it is with a
> procedure name. If you are trying to use "print" commands, I don't
> think that "s.lines" and "d.lines" are valid, either. You need to print
> either a literal or a variable, and those do not appear to be either;
> you also need positioning parameters.
>
> What you are trying to do is possible; I have done it. Before you print
> the first report, set your variable to one value. After finishing the
> first report, and before you start processing for the second report, do
> a new-page and then set the variable to a different value (you might
> also want to reset #page-count at this point). Inside the BEGIN-HEADER
> section, just do the following:
>
> If $variable = 'S'
> ... insert your summary header print statements here ...
> Else
> ... insert your detail header print statements here ...
> End-if
>
> HTH,
> Denise M. White
> EBS Programmer/Analyst III
> Dynamics Research Corporation
> ------------------------------
>
> Message: 2
> Date: Tue, 25 Jul 2006 10:23:12 -0400
> From: "Savage, David M" <dmsavage@StateStreet.com>
> Subject: [sqr-users] Heading question
> To: "This list is for discussion about the SQR database
> reportinglanguage from Hyperion Solutions."
> <sqr-users@sqrug.org>
> Message-ID:
>
> <AD4C7369F0BC5A47A00D2AD3F0E6315702311CAE@INCG2000B.corp.statestr.com>
> Content-Type: text/plain; charset="us-ascii"
>
> I have a question regarding headings. I have a summary and detail report
> (both same report) and need to print a different set of lines of the
> heading depending on particular circumstances. (Whether or not the
> summary is already done.)
>
> I tried to init a variable to a value and perform the following within
> the heading section
>
> 'IF variable = 0 do print s.lines Else print d.lines'. It is not
> working
>
> Any help would be appreciated
>
> Thanks
> Dave
>
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users