Did a search but must not be using the right keywords. I have been working with CR for over 10 years and I do not recall ever being able to set a default size for CR. How do you change the size of these sections? I really don't care about changing the default size, I just want to change the size for this report.
I only have 2 lines in my footer with no space set for the bottom margin, but when I print the report, it provides the space I see in the Designer.
Also, it does not print more than 10 detail lines per page, when it should be printing at least 16 lines due to font size of the data. Also watch out for 'new page before' or 'new page after' option in each of the sections.
OK, I resolved the Page Footer size problem. Not sure what was there, but something was preventing me from resizing the Page Footer section. Here's what I did: I inserted a section below the Page Footer became Page Footer b, made it just large enough to contain 2 data lines.
Copied the 2 lines from the Page Footer a to Page Footer b. Problem solved, but still cannot understand why I could not shrink the original page Footer. No options were set, such a Keep Together or anything else. Does anyone have any idea what might have caused this? The report insists on creating a new page after printing Details a, so Details b prints on a new page. Never mind, found a couple of Group Headers that had New Page before checked. These sections did not show up unless you used the Section Expert.
After removing the New Page option, all the detail lines print continuously. Still would like to know if anyone had an idea why I could not resize shrink the original Page Footer. I could expand it, but not reduce it. Thanks for your suggestions. You cannot shrink the section past where it is on the section. The other less likely reason was that there was a field in the section that you did not see either because it was shrunk down to a dot or it was using white as the font color.
You cannot shrink the section above the bottom of any field on that section.Log In. Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Already a Member?
Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free!Apply a report template: Crystal Reports 2011
Already a member? Close this window and log in. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. I have a report that has a picture coming from a database. The size of the box is fixed. The problem is that the picture always comes in stretched to fit the box size. Is there a way to set the picture to keep its vertical and horizontal scale and using the maximum portion of the picture box as possible?
Thanks for any help. If you right click the image in the report, and go to format graphic, there are several options.If we take a look at the Preview of our report, we can see the sections of the report labeled on the far right. As you can see below, each row of data is one Details section. That said, let's break down a report even further.
Each piece of data contained in the fields of your report is a data object. By going to either Preview or Design view, we can click on any data object to select it. In Preview, we've clicked on the name of the first customer. You can see a bounding box appear around the data object, along with four handles. We've circled the handles in the snapshot below.
As we take this article to learn how to apply formatting to your report, we will learn how to work with the individual data objects. Take a look at the preview of our report below. As you can see, we have highlighted some of the data in the Address field. We have highlighted these fields because the addresses were cut off. There wasn't enough space for the entire address to appear. We can resize any data object by selecting the data object, then using the handles to resize it.
You can resize data objects in Preview or Design view. We are going to remain in Preview. To resize a data object, select the data object that you want to resize.
Hover your mouse over one of the handles until your cursor turns into a two way arrow that looks like this:. We've chosen the handle on the right side of the data object, because we want to expand the width of the data object.
Once you see the two way arrow, you can then drag your mouse to change the size of the data object, as we've done below. If you look at the snapshot above, you can see that the entire address is now displayed; however, it now bleeds over into the City field.The content you requested has been removed. Ask a question. Quick access.
Picture Resizing in Crystal Reports 10
Search related threads. Remove From My Forums. Answered by:. Archived Forums C-D. Crystal Reports for Visual Studio Retired. Please do not use. Sign in to vote. Hi all I want to set the width of my text object to auto mode is it possible? So anyone having any suggestions on this? Thursday, January 21, AM.
Hi, The width can not be changed automatically, fields may be overlaped since the location of fileds can not be changed or some fields will be out of the report.
You might need to estimate the max legth of the field and set the width of the field to it. Harry Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have any feedback, please tell us. Friday, January 22, AM. Hi Harry, Thanks for your reply. Can we do this thig using report Formulas? Say, If i write a formula and in that formula i get the length of the Database value and set that value as a width of the Text object?
Kindly let me know if this idea is okay.! Happy Coding. Wednesday, January 27, AM. Regards Nkhil Soni. Sunday, November 28, AM.
Help us improve MSDN. Visit our UserVoice Page to submit and vote on ideas! Make a suggestion.This is similar to your other question I answered about inserting a picture. The answer is pretty much the same. If you are using the Crystal viewer control, and click the export button, what you see is what you get.
If you create your own export routine, you can programtically change the report in almost any way you wish and export that. So to answer this question, you can programatically change the page size for exporting, provided that you supply the export code.
You would do it like:. Obviously change the paper size to what you want. There is a problem with this though.
If someone knows of another way, please correct me. It would probably be easier to create two versions of the report, one for viewing and one for export. That way you could write your own export routine to export the other version and not hassle with all of the programming details of resizing.
I am working on Crystal reports xi release 2. It is working fine.
Auto Resize in Crystal Report
We are using. Net Dataset to bind with reports. But the user want us to implement a custom button which will only export the current viewing page.
It is a web application and the export type is in PDF. Please let me know if you need any more clarifications. The content you requested has been removed. Ask a question. Quick access. Search related threads.
Remove From My Forums. Answered by:. Archived Forums C-D. Crystal Reports for Visual Studio Retired. Please do not use. Sign in to vote.
Is it possible to set one page size for viewing the report in crystal report viewer and another page size setting for exporting the report. If yestell me how? Wednesday, May 2, AM.Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Being involved with EE helped me to grow personally and professionally. We've partnered with two important charities to provide clean water and computer science education to those who need it most.
Connect with Certified Experts to gain insight and support on specific technology challenges including:. Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts. View solution. View Solution. Why EE? Courses Ask. Get Access.
Log In. Web Dev.
We help IT Professionals succeed at work. Picture Resizing in Crystal Reports Last Modified: I've looked around but haven't been able to find an exact solution to my problem I have a report that links to the databse displaying the images but they get stretched to the size of the image frame 2. The pictures are all differents sizes so I would like Crystal to resize the pics to fit in the 2. Is this possible in Crystal Reports? Thanks in advance, KaseyB. Start Free Trial. View Solution Only.
Mike McCracken Senior Consultant. Experts with Gold status have received one of our highest-level Expert Awards, which recognize experts for their valuable contributions. Most Valuable Expert This award recognizes tech experts who passionately share their knowledge with the community and go the extra mile with helpful contributions. Top Expert This award recognizes someone who has achieved high tech and professional accomplishments as an expert in a specific topic.
Commented: This one is on us! Author Commented: No, the only checkbox that relates is the "Can Grow" box.
Change Paper Size and Orientation in Crystal Reports .NET
If you check that box the image resizes to its original size from the DB ironically with the correct aspect ratio and distorts the form. So I guess I'm out of luck. Thanks anyway.All the same Lynda.
Plus, personalized course recommendations tailored just for you. All the same access to your Lynda learning history and certifications. Same instructors. New platform. After you create a report section you might find that it is not quite large enough to hold or display all of the controls and data you need to.
Or, it might be too large. Learn how to resize a report section. There's no absolute minimum size for a section but it should be the size of the data controls within it so that they will all appear. If you want to resize a section,…go to the Design view…and you do that by clicking the Design tab,…which is on the tab bar for the report.
Are you sure you want to mark all the videos in this course as unwatched? This will not affect your course history, your reports, or your certificates of completion for this course. Type in the entry box, then click Enter to save your note.
Start My Free Month. You started this assessment previously and didn't complete it. You can pick up where you left off, or start over. Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.
Video: Resize a report section. You are now leaving Lynda. To access Lynda. Visit our help center. Business Intelligence. Preview This Course. Course Overview Transcript View Offline Exercise Files - [Narrator] After you create a Reports section,…you might find that it is not quite large enough…to hold or display all the controls…and data you need it to. Resume Transcript Auto-Scroll. Author Curt Frye. Join author Curt Frye as he shows the essentials you need to get started, and provides tips to get more reporting power from the program.
Learn how to create reports using the Design Wizard, link to multiple data sources, work with sections, sort and group data, use report templates, format reports and individual fields, summarize data, visualize data using charts, focus analysis by selecting which data a report summarizes, display data in subreports and cross-tab reports, and export data.