Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

vb .net 2003 crystal reports fields on report do not display when printed.

I have a vb .net 20o3 crystal report that does not display information from a table with fields that I have placed on the report.

I get no errors. I am using the sa account for the database.  It is just blank where all the fields are supposed to show.  What could be the problem?
0
mphillip85
Asked:
mphillip85
  • 5
  • 3
1 Solution
 
mlmccCommented:
Is there data?

Are you filtering the data?

What is the SQL?

What code are you using?

mlmcc
0
 
mphillip85Author Commented:
there is data
I am filtering the data and there is data on what I am filtering for.
Microsoft SQL
vb.net 2003

.SetDatabaseLogon("me", "you", "www.technologybytes.us", "database1")
.RecordSelectionFormula = "{WriteOff_Tracking.SAID} = "  & mySAIDnum & ";"
0
 
mlmccCommented:
If you use a local database does it work?

Are you using a single table?

Are there subreports?

mlmcc
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
mphillip85Author Commented:
I found the problem.  I was linked to a table that had no data, and I do not know how (in crystal reports) to link tables with specified requirements like you can in SQL server.  I need a LEFT JOIN, ALL ROWS FROM TABLE1.  stuff like that I do not know how to do.  So I had to create data on the fly in the table that was missing a record and then the report would populate .

Thanks
0
 
mlmccCommented:
Since I always build against database views, queries, or stored procedures, I don't know how to change that for sure.

In CR8 there is a VISIAUL LINKING EXPERT under the DATABASE menu
In CR XI there is a LINKS tab on the DATABASE EXPERT under the DATABASE menu

From there I can change the links

mlmcc
0
 
mphillip85Author Commented:
The visual linking expert, I do not find much help other than to link common fields together or tie the tables together, other than that it seems quite useless.  Am I missing something?
0
 
mlmccCommented:
The linking is just like in SQL Server.

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now