Browse Data

What does it mean when I use the browse data option and there are no results displayed.
LVL 1
mcjannAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Have you checked the SQL run for the report and run it in the database to see that you get a record?

mlmcc
0
 
mlmccCommented:
I would take it to mean either there are no records in the recordset you have selected or for that field all the values are NULL or blank strings

mlmcc
0
 
mcjannAuthor Commented:
Let me start with " I am a CR newbee"

I thought the same thing and verified the dataset and specific record I am selecting into this report (sub report) does exist and has a value assigned.

Trying to troubleshoot why no values pull into the report I found no values present when I browse the field data.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
GJParkerCommented:
If you are selecting browse data on a single filed in teh field explorer then this has nothing to do with the report results.

Browse data should show you all the distinct values for that field in the database i.e. if you were to select tablea.field1 this would be like running the statement "select distinct field1 from tablea" on the database.

To me this suggests that there are no records in your table or all of the values for your field are either null or empty strings.
0
 
mcjannAuthor Commented:
When I SQL the table there was nothing present. When I SQL for table named like INVEST I found the value was stored in a different table. It appears the field was renamed and a table was auto generated for the new name but values remained in the table with the old name.

Grade A for a fast response!!
0
 
GJParkerCommented:
Just as I said
0
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.

All Courses

From novice to tech pro — start learning today.