Hi,
I have a SQL server database called DelveDatabase, it has a table called ORDERS, this orders table currently contains a one record.
I add a CrystalReport item to my project, double click it and it enters design mode.
I right click -> menu -> Database Expert
Select Project Data -> ADO.NET DataSets -> DelveDatabase -> ORDERS then OK.
Add a field from ORDERS using the Field Explorer into the detail band.
Click Main Report Preview.
And the results are varied. Sometimes I get a bunch of records printed with the values of Yellow, Yellow, Red, Green, Blue etc... sometimes I get nothing.
Remeber I have one record in the table (and it does not contain values of colors in it)
So the fields are binding to something but what and where
How do I tell Crystal designer how to fill the dataset i've selected so I can preview my report
Am I missing something
I tried to use OLEDB as a datasource instead, the standard OLEDB cannot see the database, the SQL Client fails with an error about non standard oledb response.
Hmmmm....
Crystal reports designer and VS 2005 how to bind?
Hot Topic
- How do I Edit Word Template in Visual Studio 2005 VSTO
- Newbie Develop Office App using .Net
- control template question
- TargetName Does not work for me.
- vss 6 names.dat may be corrupt
- How can I change the appearence of the scroll bar of a ListBox control?
- WPF DataTrigger and Enums?
- Can Vista Windows Desktop Manager be tested by hooking the D3D calls?
- Troubles with project openning into VS.NET 2003
- Bad exception interception with the VS 2005 RC debugger
Visual Studio
- Calling a page in another xaml browser application, how to pass parameters or data?
- running total with parametric percentile
- unable to install visual web dev 2005 beta
- Export Drill Down Report
- I cannot install WinFX runtime components 3.0
- name value collection in a web service
- VSTO 2005 Document Template
- Elements doesn't appear to the target designer (SDK June CTP)
- Sometimes I'm unable to debug Windows Forms for more than 60 seconds
- Outlook Crash after ThisApplication_Shutdown()
Crystal reports designer and VS 2005 how to bind?
Kerrie S.
So it looks like you are on the right track.
For the Push model of accessing data (using datasets) when you preview the report with the embedded report designer's new Main Report Preview option it puts in random sample data for you to help you design the layout of the report.
To preview the report you will need to put a Crystal Report viewer on a form and then bind the report to it. You will also need to populate your dataset and pass this to the report at runtime. You can review a walkthrough of this at:
http://www.businessobjects.com/global/pdf/dev_zone/cr_vs2005_walkthroughs.pdf
Just go to the section on Connecting to ADO.NET datasets.
Keith - Business Objects