Creating a crystal report from datasets
Posted on 2003-12-06
I have a visal baisc .net application that is used by security personnel. I want to create a crystal report that uses the datasets withen the application for data. I can't get it to load the data. everytime I select to load the crystalreportpreview I get a message box for logging into the server. I would enter all the correct data, but I would get a logon error.
I then found out there is a way using the ole db interface in crystal report to link to the server. I then could connect to the server and display data, but I cannot limit the report to a specific report that needed to be printed (i.e. print the spicific (form) report that is in the database (not the crystal), but I can't figure out how to just filter what info I need). I would like to have the crystal report data come from the datasets. Is there a way to do this with out it having to connect to the server? In other words.
form1.btnprint (byval.....).handle btnprint.click
dim printform as new frprint()
frprint has a crystal report viewer that its reportsource is crystalreport1.rpt
the crystalreport1.rpt would get its data from the datasets that are in the project. But I want it to do this with out asking for any type of connection string. I have the datasets filled prior to the form opening and I want the crystalreport to use these dataset for data. All the fields in the crystal report would come from the datasets.
I did notice though that when you add the dataset to the crystal report it would link to the server table that the dataset uses. I just want the data to come directly form the dataset not the server. The dataset would already have all the data from the server that it would need. Is there a way to do this? or is there a better way of doing this?