Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dbpr
  • Order by date
  1. dbpr

    Change to a SQL Union Query

    I don't understand why you need to rename the View. Crystal by default will not reprocess the query and after digesting it will use ordinal numbers for the columns for speed. When a table or view changes you should run "Verify Database" from the database menu. If you are running the the report...
  2. dbpr

    Non Database Data Source

    You don't actually say what development environemtt you intend to use. If its a .NET platform you can also look at pushing a DataSet into the Report and fabricating the data in the middle tier API. But you will have to use ASPX, VB.NET or C#. I am using this currently to prevent an...
  3. dbpr

    Wrong data when joining multiple tables

    This sounds familar, but its a little difficult to diagnose exactly. Crystal has problems with complicated joins and mainly when criteria is put on a secondary table and none on the primary/root table. In these cases it goes a little mad and collects too much data then 'forgets' to filter the...
  4. dbpr

    Report from multiple Datasets (VB.NET)

    You will need a sub-report to display the orders list. Each report or sub-report can only handle one DataTable from a DataSet at a time. Use the main report to deal with the customer records and the sub-report for the orders belonging to the customer. If you have the dataset already filled with...
  5. dbpr

    Can I populate a report from a dataset thats from a datagrid

    Yes you can is the simple answer. With your CrystalReport you pass the dataset into it: MyReport.SetDataSource(myDataSetObject) Then pass your report into the appropriate viewer control web or Windows UI. Be careful with large amounts of data as this makes a copy of the entire dataset, but...

Part and Inventory Search

Back
Top