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?
mphillip85Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Glad i could help

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.