Solved

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

Posted on 2007-04-09
8
228 Views
Last Modified: 2010-05-18
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
Comment
Question by:mphillip85
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 18880086
Is there data?

Are you filtering the data?

What is the SQL?

What code are you using?

mlmcc
0
 

Author Comment

by:mphillip85
ID: 18880233
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 18882132
If you use a local database does it work?

Are you using a single table?

Are there subreports?

mlmcc
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mphillip85
ID: 18886350
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 18886573
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
 

Author Comment

by:mphillip85
ID: 18886926
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 18887224
The linking is just like in SQL Server.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18887480
Glad i could help

mlmcc
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question