Hello.
I have written an application VB.NET using Visutal Studio 2005 (using the 180 day trial edition). I now wanted to deploy this on the traget machine and having followed many different sets of instructions I still get no output in the reports of the application.
When I run the application on the development machine it runs as expected however, on the target machine all I can see is the static text of the report but no data pulled from the DB, and there are no obvious errors generated.
The application is working in every other respect inserting, updating the db etc., it's only the reports that don't work. I've been trying to fix this for nearly two days and I'm now at the point of self destruction.
Can anyone help me out with this.
No Data in Report
Hot Topic
- Calendar Date Range
- Large text field problems with PDF export in VS 2005 version
- Supplying Data To Report
- Solution ( VSTO doesn't work in a custom ActiveDocument host)
- How to consume vss2005 web service interface
- Use custom attribute to execute some actions
- Recursive checkout with a specific file name
- How to build a project containing Reporting Service project
- Recommended Book for VS2005 Extensibility
- Visual Studio 2005 Remote Debugger (Windows Service)
Visual Studio
- CreateToolWindow2
- Language Service and IVsEditorFactory?
- WPF, Refactoring, Projects and Solutions.
- Capturing the events regarding switching between code /design view
- DataContext Serialization and Distribute Architecture
- Inspecting the DataBindings property
- Practical questions
- Direct Printing to LPT Port - Please Help
- Problem of Office add-in (C#)
- cannot add code behind files
No Data in Report
toehlke
Hi there!! I don;t know if this has anything to do with your problem, but it caused me 3 weeks worth of grief. I could run my reports from my deployment machine but could not get them to run for my users. The problem was with my stored procedure: right click on the sp and then click on "Permissions". Make sure that "EXEC" is checked. Hope that helps
David789
It, s true
I also tried to get data to reports using .mdf file for the app but no result. At books the only explanation how to populate the reports is for odbc data. This is not useful. Cause You build the reports directly with Crystal reports 10.0 and filter them with their syntax language invoking them at the app. No need to use dataset connections with crystal reports.
Rama.NET
To me not yet data on crystal reports with vs 2005 professional. Even crystal reports xi did not resolve the case.
I'm trying now to use Sql Server repoting sevices but for me they are still far beyond the crystal reports. Do not find there how to group records how to insert subtotals, how to adoperate formulas ecc.
It was report machine on vb 6.0 which i never used cause was to poor.
Strange how Microsoft has not created a reporting an advanced reporting machine to associate with vb.
lorentzeng
Hello
Thanks for the reply.
Shall try the codes You sent. My point is like this. I have built the reports with crystal reports module inside VB 2005. They can be created and saved normally but no data in them. Ok up to now. Then at the reportviewer in dbug or exe mode reports are empty.
My way of creating reports has been that they are created outside vb directly fm the tables, wiews or stored procedures and invoked on vb app as they are without saving data on them to spare space. Then for the dynamic filtering i have used the .SelectionFormula method and up to now the job has gone nicely.
As i understand we have the common problem; we create reports , we use parameters od selection formulas everything is ok but the reports are empty. Our problem is that we can use only datasets to bind reports(if not odbc). Datasets are empty copies of the recordsets filled as we require. And there is a namespace for these. For crystal repots i have not found yet any binding instrument or we have to create ourselves any namespace or class module to bind report with sql server 2005 data.
Hope its resolved at the last issue of Crystal Decisions the Crystal Reports XI second edition.
Today
rven
If anything I think it's a licensing issue as all of the documents I've refered to make reference to adding your Registration number to the License field of the msm module. However, I've no way of doing this as the field isn't even there!
I had assumed that this was because it 'knew' it was a bundled .NET version and it took care of the licensing itself when. But now I have my doubts.
MichaelBorg
As a result most of my code is in the preparation of binding the parameters for the stored procedures used by the report. With that said it still doesn't explain why I can't get any data to appear in the reports on the target machine. Does anyone know where I'm going wrong
It may be that you're not allowed to redistribute this version of Crystal Reports because the software is for evaluation purposes. Can anyone verify this
ldt