Crystal report

Hi all,

I have a very simple question on Crystal Reports.

Is it possible to insert lines (horizontal and vertical) in between the datas in DETAIL section of Crystal report. If yes, how can I do this? If no, what is the possibility to make complete table using Crys. Rep.

ThanksYou can draw lines using crystal reports. Click on 'Insert', select 'Line'.

Then you can draw the lines in the form of the boxes. For the vertical lines, make sure that you format the line. In the 'Format Line...' options, check 'Extend to the bottom of the section when Printing'. For the horizontal lines, in the 'Format Line...' option, check 'Move to Bottpn of Section when Printing'.

You can even use 'Insert Box' option, but I find the line option more useful and flexible.|||Thanks,

This was really simple.

Crystal Header Totals

I am a .Net developer and I am trying to print the totals from the detail section of the report into the Header. Is this possible. I am currently trying to Count the detail record that need to be counted and displaying them in the Header. ALL I get in the header is the first record in the Detail. Any help would be great.

ThanksWhy do you want to do this in Page Header? You can do this in Page Footer|||CR won't allow insertion of summary objects into the Page Header. You can put them in the Report Header though.|||CR won't allow insertion of summary objects into the Page Header. You can put them in the Report Header though.

It will show the summary at the end of report not everypage
You can do this pagewise by using formulae

Crystal Equivalent in SQL 2K5?

I have an existing Crystal report that contains a subreport which lists
items across the page rather than down. The subreport has a Header and
Detail section, which are both supressed, and a footer section that is
visible. In the Header section, a field is defined with the following
expression:
WhilePrintingRecords;
global stringvar strItems;
strItems :=""
The Detail section has a field defined with the following expression:
WhilePrintingRecords;
global stringvar strItems;
strItems := strItems + ToText({uspGetItems;1.ItemID}, 0, "") + ", "
The Footer section has a field defined with the following expression:
WhilePrintingRecords;
global stringvar strItems;
If Len(strItems) > 1 Then
strItems := Left(strItems, Len(strItems) - 2)
Is there a way to do this in a SQL report?
Any feedback would be appreciated.
Thanks.You could do something like this in a data set in SQL
Declare @.a varchar(1000)
Select @.a = ''
select @.a =@.A + ISNULL(NAME + ', ','') FROM Production.Product
Select @.a as myList
You'd need to take off the last , ...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jason.pileski@.pacourts.us" wrote:
> I have an existing Crystal report that contains a subreport which lists
> items across the page rather than down. The subreport has a Header and
> Detail section, which are both supressed, and a footer section that is
> visible. In the Header section, a field is defined with the following
> expression:
> WhilePrintingRecords;
> global stringvar strItems;
> strItems :=""
> The Detail section has a field defined with the following expression:
> WhilePrintingRecords;
> global stringvar strItems;
> strItems := strItems + ToText({uspGetItems;1.ItemID}, 0, "") + ", "
> The Footer section has a field defined with the following expression:
> WhilePrintingRecords;
> global stringvar strItems;
> If Len(strItems) > 1 Then
> strItems := Left(strItems, Len(strItems) - 2)
> Is there a way to do this in a SQL report?
> Any feedback would be appreciated.
> Thanks.
>

Crystal Design

Hi,
I've a standard Invoice template with Page header, Group Header and Detail section. Invoice can be of one page or multiple pages depending on the number of invoice line items. I want to print Customer service and payment details (fixed text of about 40 lines) on the back of every page. How do I achieve this. Any help is much appreciated.

thanks & regards
radhastart a new page after group footer. if ur invoice is of one page , then this new page can be printed on back.|||Thanks for this. It works fine when the invoice has one page.
My report is grouped by Invoice Number so for an Invoice with multiple pages group footer prints on the last page of the invoice and the balnk page prints after the last page of the Invoice. My requirement is to print the details on the back of each page. Any help would be much appreciated.

thanks & regards

radha

Cross Application Migration

Migrate your MS SQL Server to Oracle ... i juss in time for further detail contact us
support@.wayne-burt.com
or Visit us at http://www.wayne-burt.comCommercials?|||Do you also pay for the $200,000 Oracle cpu licensing fee for us?