Link to home
Start Free TrialLog in
Avatar of Jan Mishkin
Jan MishkinFlag for United States of America

asked on

Dynamically change Text on CRytal reports in asp .net 2.0

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.





ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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)
Avatar of Jan Mishkin

ASKER

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)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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
http://aspadvice.com/blogs/rjdudley/archive/2005/05/27/2606.aspx