Print Page | Close Window

How to increase column width of CR at Runtime

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=19197
Printed Date: 18 May 2024 at 5:09am


Topic: How to increase column width of CR at Runtime
Posted By: Ganesh Khuspe
Subject: How to increase column width of CR at Runtime
Date Posted: 01 Mar 2013 at 3:24am
Hi Guys,
I again stuck in one issue @Sastry :-(
I want to change my column width of CR at runtime. how can i do it???
i m using Crosstab report.In which data is retrieving from SQL server.
Can anybody help me????

Thanks in advance...


Replies:
Posted By: hilfy
Date Posted: 01 Mar 2013 at 3:37am
AFAIK, you can't dynamically change the column width in a cross-tab.
 
-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: Ganesh Khuspe
Date Posted: 01 Mar 2013 at 3:47am
thanks for the reply hilfy ,

i appreciate your opinion..But can i remove that column from crosstab and consider it as single column and then retrive data into it???

Posted By: hilfy
Date Posted: 01 Mar 2013 at 4:13am
Yes.  However, you won't be able to easily synch up that column with data in the cross-tab if that's what you're thinking about doing.
 
-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: Ganesh Khuspe
Date Posted: 01 Mar 2013 at 4:17am
Actually all the fields are displaying correctly but only address column which contains more data displaying less data in CR..
Do you have any solution on it,How can i show that columns data????

Posted By: hilfy
Date Posted: 01 Mar 2013 at 4:38am
Unfortunately, the Cross-Tab component doesn't give you many options for formatting the fields internally.  So you're only option is to make the address field as wide as you think it needs to be at its widest.
 
Is there a particular reason why you need to use a cross-tab?  Depending on what you're trying to do, there may be a way to display what you're looking for without the cross-tab.
 
-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: Ganesh Khuspe
Date Posted: 03 Mar 2013 at 11:08pm
There are reasons for using Cross tab...it was client requirement...Can u please explain me the other way, through address field???

Posted By: hilfy
Date Posted: 04 Mar 2013 at 3:31am
You can create what some folks refer to as a "manual cross-tab".  This is a table in your report that looks like a cross-tab but is really just the fields put on the report as if it were a "regular" report.  Using the group header and footer fields with summaries for aggregation, depending on what the columns are for your cross-tab this can be either simple or difficult.
Can you give me a general description of what data you're reporting on?
-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: Ganesh Khuspe
Date Posted: 04 Mar 2013 at 10:49pm
I am fetching lots of data in the report, and in the report.There are some columns which shows record from one column of database as data inserted into that column through XML and i am fetching it through xml. In that column my data is present(ie Address field).I want to show the width of that address field varying as per the data.But cross tab is not allowing to do that.Now i m trying it in another way..through datatable,by taking that address field as individual table,separating it from other datatables..hope this will work...


Print Page | Close Window