Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Populated fields come up blank in subreport

Status
Not open for further replies.

dnovakoff

Programmer
Apr 3, 2002
7
US
I have a subreport which has a simple link from the main report...budget_id. The subreport prints the information from the budget table, but for some reason the field budget.budget_name is coming up blank in the subreport. This field can not be null in the database. It has data. All other fields in the subreport are showing the correct data for the same budget record.

What is going on? I've also noticed this for other fields in different subreports...for database fields that can not be null but are not showing in the subreport.

I even tried linking the Budget Name from the main report as a parameter and print that out, but to no avail.

Thanks for any help/suggestions,
Dave
 
What happens if you browse the field in the subreport? Andrew Baines
Chase International
 
does the subreport run by itself....ie. run the subreport and supply it a BudgetID manually when asked Jim
JimBroadbent@Hotmail.com
 
Thanks for the help, but I ended up just reimporting the subreport from another report that had the same one that worked correctly. This solved the problem. Same exact subreport, same links. Weird.

Thanks again,
Dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top