Solved

crystal reports - fields and headers - customise runtime

Posted on 2013-01-29
6
914 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

24 Experts available now in Live!

Get 1:1 Help Now