Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Dynamically change Text on CRytal reports in asp .net 2.0

Posted on 2007-10-17
Medium Priority
Last Modified: 2013-11-07
I have server 2003 a
aap .net 2.0
Crytal reports developer XI
mysql backend

I need to know how to do is dynamically change a text box on the report from the Aspx.vb code and also do I have to recreate my report everytime I change the data connection?  Both of these questions seem simple enough but I can't find a resource to answer them.

Question by:janmishkin
  • 3
  • 2
LVL 101

Accepted Solution

mlmcc earned 1500 total points
ID: 20095985
LVL 14

Expert Comment

by:Jai S
ID: 20098969
you dont need to recreate the report !!!
you can set the connection string as a parameter to your crystal report viewer and the CR will take this server name and db name as the data source along with your query....

and you can have an expression (a formula) which will display a paramter value(@something)...you can have this value being passed from your front end (usual way of setting formalas fron Asp.net)

Author Comment

ID: 20103307
jaiganeshsrinivasan: I don't mean reconnecting to the same data set. I mean - say a I want to have a new report based on a different view with some different fields but I don't want to recreate the full report i.e I want to keep the entire formatt of the report but just reasign and add a few new fields. It seems like it forces me to clear all my field boxs.

mimcc: I will make time to view those pages and then accept solution('s)

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

LVL 101

Assisted Solution

mlmcc earned 1500 total points
ID: 20103893
Unfortunately that is the way Crystal works.  It uses a positional rather than field name to track the fields on the report.

You can try setting the data source inside the report but to do what you want from code probably isnt't possible.


Author Comment

ID: 20124548
In terms of recreating the full report everytime I change the structure to the underlying table - I think this is nuts  and I'm assuming that I'm doing something wrong because I can't believe that the CR would be set up like this. Am I right?

Author Comment

ID: 20124655
OK - I don't think I clearly stated the 2cnd problem

When using xsd as a source when the xsd structure changes how do I update the CR report

her3e is the answer

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Suggested Courses

580 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