crystal reports - fields and headers - customise runtime

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.
tjoseph833Asked:
Who is Participating?
 
tjoseph833Connect With a Mentor Author Commented:
decided on telerik ... customise with report code behind
0
 
peter57rConnect With a Mentor Commented:
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
 
mlmccConnect With a Mentor Commented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
tjoseph833Author Commented:
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
 
mlmccConnect With a Mentor Commented:
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
 
tjoseph833Author Commented:
telerik .net classes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.