Solved

crystal reports - fields and headers - customise runtime

Posted on 2013-01-29
6
901 Views
Last Modified: 2013-03-18
Hi, we have a .NET app with Crystal Reports embedded. The report is designed in Visual Studio.

How can users modify existing reports by adding and removing field or changing the order / position that they appear when in runtime?? In addition the user would be able to create custom headers by inserting their own logo and text.

We can in runtime change some of the text objects but am not sure how to change fields and headers (and reorder) during runtime. We tried Cross-Tabs but its not really that flexibile.
0
Comment
Question by:tjoseph833
  • 3
  • 2
6 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 85 total points
Comment Utility
There is no facility in Crystal Reports to do this explicitly.

You could use parameter fields to do a limited amount of customisation but the scale that you are describing would not really be practicable.

If you need to provide this capability you would do better providing a UI to get requirements through your application and then building the report in code.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 170 total points
Comment Utility
Full versions CR XI and earlier provided a set of dlls that allowed you to provide that capability.  There was an additional licensing requirement per user.  A I recall it was a little cheaper than purchasing Crystal.

The .Net versions as far as I know never included it.  I don't believe it even worked in .Net just VB6 and other .COM languages.

The capability was dropped in CR2008 along with support for VB6 and .COM.

Why do the users want this capability?

mlmcc
0
 

Author Comment

by:tjoseph833
Comment Utility
mlmcc, different users need different fields to appear in the report. and some adjust based on length or priority of fields. is there anything besides crystal reports we can use?? how about the .net reporting tool? customer wants it flexible and we can't seem to tweak the CR that comes with VS 2010 any further.

peter57r, how do you build CR reports in code? we have a wizard for user report settings. You have any sample?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 170 total points
Comment Utility
I don't know if you can build reports inside code with the .Net Crystal.

The general method is to use formulas in the report and in code change them to the fields you want.

I have done this from VN6 with full versions of Crystal.
    crReportObject.Formulas(1) = "{Yourfieldname}"

I am not familiar with the .Net assemblies and interface to know if that will work.

How many fields are you potentially using in the report?

I do not believe it is possible to set the location of the fields or the width so the user will have to be happy with a fairly mundane table type report.

I worked a project one time where the user wanted something like this.  We discussed the requirements and came up with a set of fields that everyone wanted and built  basic report.
We then analyzed and determine a second set that a smaller group wanted in addition to the basic set and built a basic+ or medium version of the report.  We then built a final or large version that included the remaining fields so everyone got the information they wanted.

Most of them used the report to pull data for other purposes and I wrote code to export the data to Excel (in the days before the data only option).  Users could then manipulate the data (delete columns, move them around, add totals, etc) in Excel to present the information they were looking for.

mlmcc
0
 

Accepted Solution

by:
tjoseph833 earned 0 total points
Comment Utility
decided on telerik ... customise with report code behind
0
 

Author Closing Comment

by:tjoseph833
Comment Utility
telerik .net classes
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now