Solved

crystal reports - fields and headers - customise runtime

Posted on 2013-01-29
6
926 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
ID: 38831044
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
ID: 38833085
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
ID: 38834041
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 170 total points
ID: 38837913
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
ID: 38982364
decided on telerik ... customise with report code behind
0
 

Author Closing Comment

by:tjoseph833
ID: 38994969
telerik .net classes
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

778 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