Topics Search

Report based on query shows no data

Report based on query shows no data
Views: 9
I have created a query and designed a report based on the query in Access 2003, and it was working fine. Fortunately, I exported the results that I needed for today into an rtf file, so I don't have an emergency.

I'm not sure what I changed, but the next time I opened the report, no data appeared - it just shows a few labels that were part of the report format.

I can still see all the data when I view the query in datasheet format.

I tried changing the data source under report properties to use a different query, and then the report works fine. But when go back to using the query that I want to use as a data source, I get no data in the report.

The query I am using is based on external data in Excel files located on another computer on the network.

Before I started having problems, I got a message saying the report had been set up for a different printer, The laptop I am using for Access is not currently set up with a working printer driver. Could that be relevant?
Sponsored Links:

More topics

 

Report Based on Query showing ID's not Data

Preview
I created several tables with Look-Up fields, I have followed the direction for changing the Look-Ups to Text Boxes but that does fix the report.

The Query still shows the data and not the ID's but the report still shows the ID's.
 

What am I missing?

Preview
newbie here, so please be gentle.

I have created an Access 2003 database with several tables and queries.

I have a query that produces data in the order I wish to present it to a report.

Viewing the query in datasheet view shows the data in the correct order.

However when I create a report based on the query, the data is not shown as in the query. It is all over the shop.

Do I need to sort it all over again in the report?, as I do not include some of the sort criteria fields.?
 

Stop auto rounding in a report.

Preview
I have been looking all over for the answer to this, but so far have had no luck. I have a report based off of a query. The feild is currency based and in the query it shows as many decimal places as I would like. When I transfer all of this to my report it does not show any of the decimal places just .00. Is there something that I am missing when I transfer my data to a report to keep it from rounding the number. If you need any more data let me know and I will provide it
 

group records in Reports

Preview
Once a user has a report generated, can he group the records based on a field in the report?

For example, a report pulls all the facilities and tests they can perform. On the report, will the user be able to group the results based on.say city?

So the end result stills shows all the facilities and tests, but all the records are grouped based on city.(i.e. the first 5 rows shows records from city A, the next 10 shows records from city B, etc)

Can this be done directly in the report? or the user has to go back to query and actually specify in the query design criteria
 

Reporting Issue: Combine query

Preview
I have a report that combines 3 queries based on three tables which have one primary key in common (NCR Num). The only issue is that when I combine them together and run the report, I am getting ALL the entries from the tables, instead of just the entries that are associated with that one common primarykey value (NCR Num).

Relationships: Shows the three tables and how they relate

Report Layout: Shows how I have done up the report in design layout

Report Results: Shows the extra values that I do not want. Ex. This is the report for NCR 19 but I am getting information for NCR 20 and 21 in the Problem Section and NCR Employee Section

Data Entry Form: Just shows the data entry for that feeds entries into all three tables.
 

Query shows only records with data

Preview
I have built up a database based on geographical sites. I would like to create a report of each sites with data from related tables. I have created a query, as the base of the report but unfortunately only one site of the recorded 400 turned up in my query. There are a few tables that don't contain any information about most sites yet, still it needs to be part of the query, otherwise I can't build them in the report. I haven't put any criteria to the fields. The report is needed to collect further data about each sites. Shall add '0' or 'NoInfo' as a default to each field? Or is there any other solution
 

Report Based on CrossTab Query

Preview
Hoping someone can help with this. I have a quotes table and want to create a report that shows the total number of quotes created, won and lost over a given period per sales person. I thought a cross tab query would work but having trouble with this.

The quotes created would be a count of quotes created based on DateCreated but the quotes won and lost would be based on StatusChangeDate between dd/mm/yyyy and dd/mm/yyyy.

I can get a query that shows total created and can get a query showing won and lost but can't combine this into 1 query as I get repeating rows for the won and lost columns. Also when a try to create my report from the Won and Lost crosstab query (which works fine as a query) no fields are available to be selected for the report
 

Problem with Report based on Query

Preview
I created a query to extract data from a linked table. The query does not have any sorting. Then I created a Report based on the query. The report does not have any grouping or sorting.

The issue is: When I run the report I get the same data that I get from the query, but it comes out sorted. I cannot even find by which field the data is being sorted.

I have double checked the query and the report and they do not have any sorting or grouping of any kind.
By the way I am using Access 2007.
 

Problem with Report Based on a Query

Preview
I created a query to extract data from a linked table. The query does not have any sorting. Then I created a Report based on the query. The report does not have any grouping or sorting.

The issue is: When I run the report I get the same data that I get from the query, but it comes in a different order.

I have double checked the query and the report and they do not have any sorting or grouping of any kind.
By the way I am using Access 2007.
 

Changin report's fileds with VBA

Preview
I have a report, that is based on a query. I want all the fields in the query to appear on the report. The query uses 3 tables for its data, and one of tables in constantly being deleted/recreated from vba and primary key is being assigned to one of the fields.

Each time the table is recreated, 2 of the fields that are in the query, have their names and data changed. My problem is that when that happens, the query works fine since its SQL is being changed in VBA to reflect the new changes, but the report shows an error in the fields that have beenchanged in the table.

Is there any way for me to dynamically change the report's fields, to the once used in the query.