Solved

crystal reports - fields and headers - customise runtime

Posted on 2013-01-29
6
967 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 101

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 101

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

Stressed Out?

Watch some penguins on the livecam!

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 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