I currently have a few hundred crystal reports which get populated via an ODBC connection. I have to programmatically change this so I can populate a DataSet from a csv file and then populate a report based on the dataset. The main aim is to do this without actually modifying any of the reports (as that would mean months of re-testing of hundreds of reports....and common, who likes to fight with the testing department ;->)
The ideal solution:
My app gets 3 parameters 1) actual report location, 2) report parameter csv file location 3) report data csv file location. To over-ride the ODBC connection specified in the report and populate the report via a dataset populated from the specified csv file.
At the moment I load the report, populate the report's parameters with those specified in the csv file, create a dataset based on the data csv file and set the report dataset with cryReport.SetDataSource(ds.Tables["tableX"]). The table name in the dataset has been kept the same as the default table name used in all the reports.
The problem seems to be that the report is not pulling in any of the data specified in the DataSet? As far as I can gather from searching the net, you can only populate a report with a strongly typed dataset? I don't see how you can create a strongly typed dataset programmatically for each dataset every-time the application is called, as this cannot be done beforehand.
I would appreciate any direction or help with this problem!
I can't help with your problem, but it is a very bad idea to post your email address to any forum - not just codeproject. Unless of course, you really like spam...
Change your name! If anyone really wants to contact you privately, there is a option to allow emails at the bottom of each message - this sends an email to your registered address without revealing it to the sender.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
I'm trying to re-host wf 4.0 designer (done that) and use custom activity controls that have similar behavior with FlowSwitch. Could you tell me how I could do a custom FlowSwitch with modifiable content( I need a custom picture and a custom textbox). If anybody could give me an example would be great.
Another question is how do I register to events like FlowNode click on a flow chart?
I would like emptying TexBox who are in treatment but in the event selectedchanger:
texbox.text = String.Empty , find an error message because the content of the TexBox changes.
can you help me??
Image im = pb.Image; // Assume pb is your PictureBox
Graphics g = Graphics.FromImage(im);
g.DrawRectangle(Pens.Red, pbleft, pbtop, pbwidth, pbheight); // Draw red rectangle in your image.
pb.Image = im;
ActiveXObject is an IE object and not officially supported in FireFox, AFAIK. Most importantly though you are exposing the details of your database, username, password, table, table structure; a huge breach of security.
from the Image, You can see there is an Attribute Column and there is a Value Column, Now what i want to do is that i want to have only one Country and one Event in the Attribute and the Values must be nested underneath each other in a Grid, so basically i need a nested View and the Attribute is the parent and the Values will be grouped according to their parent.
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.