Print Page | Close Window

How to add border to pages in crystal report

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12848
Printed Date: 05 May 2024 at 2:34pm


Topic: How to add border to pages in crystal report
Posted By: mukta
Subject: How to add border to pages in crystal report
Date Posted: 07 Apr 2011 at 9:25pm
Plz anyone will tell me How to add border to pages in crystal report..

i want to give border on pages



Replies:
Posted By: hilfy
Date Posted: 08 Apr 2011 at 3:58am

Draw a box on the report that goes from the top of the page header section to the bottom of the page footer section.

 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: mukta
Date Posted: 08 Apr 2011 at 9:19pm
Thank u very much..Madam


Posted By: mukta
Date Posted: 08 Apr 2011 at 11:01pm
Madam i m also trying another way..to give border to our page..by doing customization

but not getting success..i did nt get any output by doing given code
m following procedure are as follows..given
http://msdn.microsoft.com/en-us/library/ms227463(v=VS.80).aspx
Can u see plz...


Posted By: mukta
Date Posted: 11 Apr 2011 at 2:47am
hi madam


Plz can u tell me

To display child record based on parent key selection on same in crystal report.
I want after selecting empCode to display child record
or when i will load my page then it should hav show both parent n child record of particular empCode.
for this i hav to use one Stored processure to display both tables by supplying empcode..
i write SP. but it displaying only first parent table .
plz tell me...
for eg.
EmpCode: E056

EmpName:ABC


child table
               EmpCode  year         salary
                
                  E056     2009      10000
                  E056     2010       20000


Posted By: mukta
Date Posted: 12 Apr 2011 at 6:55pm

Hi...
Hilfy...

I used group by in my report.but when i click on 2nd page then again page is loading and asking me to enter parameters and enter LogOn information like server name and database name..

plz help me....
Thank u in advance


Posted By: hilfy
Date Posted: 13 Apr 2011 at 2:44am
Do you have a subreport on the second page?  Are you viewing the report through Crystal or from another application?
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: mukta
Date Posted: 14 Apr 2011 at 3:06am
hiii.. hilfy
i solved my problem by passing input parameters dynamically to for each page..


Posted By: mukta
Date Posted: 14 Apr 2011 at 3:07am
thank u..


Posted By: mukta
Date Posted: 14 Apr 2011 at 3:11am
hii hilfy..
i got next problem..

i grouped by on 3 fields like date,location and department..k

but when i enter parameter fromdate n ToDate it displays groups from next date..

example.. i entered 4/Mar/2011 to 7/Mar/2011
it displays groups from 5/Mar/2011 to 7/Mar/2011.

plz help me...






Posted By: mukta
Date Posted: 14 Apr 2011 at 3:13am
n if i enter same date for FromDate to ToDate
then it don't display any group records..


Posted By: hilfy
Date Posted: 14 Apr 2011 at 4:32am
How are you using the dates?  Are you using >, >=, or between?
 
You need to be using >= with the start date parameter in order to get what you're looking for.
 
If that's what you're using, you'll need to check the database to see if there's any data for 3/4/2011.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: mukta
Date Posted: 15 Apr 2011 at 1:28am
hii hilfy..

problem solved .

actually that problem was coming on report viever design time ..
when i run my report on web then problem solved.
it displays groups properly on given date

..thank u


Posted By: mukta
Date Posted: 15 Apr 2011 at 1:31am
i already used between from date to todate
..
now working properly...

thank u..



Print Page | Close Window