473,320 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

report not showing all data?

I have a report i put together for a database, and after making some
changes (none of which i thouhgt were too significant) the report only
seems to show the first part of the data. after about the 3rd page, it
will start showing the default values in fields that have it and
everything else is just blank. i have tried a few times to be sure,
and this is happening everytime i run the report. (it was working fine
before the changes were made, just took some things out that werent
needed in the database anymore)

any idea to what is happening would be much appreciated.

i also thought i should mention that the report is also running an
extra page at the end (blank, just the header/footer), which is odd
because it never did this before with more content on it.

thanks in advance!
-Greg
Nov 13 '05 #1
2 2655
Greg <ch******@umbc.edu> posted in
news:f2**************************@posting.google.c om
I have a report i put together for a database, and after making some
changes (none of which i thouhgt were too significant) the report only


apparently they were significant. check the code in the report and the
queries, sort table of report.
may need to do some legwork if it can't be effectively posted here.

--
Phil
Nov 13 '05 #2
ok, it looks like the inserting a picture functions would save the
record while processing, when i took that out, it didnt save at the
end, just half way through. added 'save record' to macro before
opening report and it works fine again. thanks for the help!

-Greg

"Phil" <st***@basketball.net> wrote in message news:<DY***************@newssvr22.news.prodigy.com >...
Greg <ch******@umbc.edu> posted in
news:f2**************************@posting.google.c om
I have a report i put together for a database, and after making some
changes (none of which i thouhgt were too significant) the report only


apparently they were significant. check the code in the report and the
queries, sort table of report.
may need to do some legwork if it can't be effectively posted here.

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: RC | last post by:
I can't quite grasp the concept of creating custom reports depending upon what options a user picks on a Form. For example, the user clicks on a "Print Reports" button and a Form pops up. On the...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
3
by: Diggler | last post by:
I was working on a report that is populated with three different tables in a strongly-typed dataset. The tables are populated from custom objects rather than directly from SQL Server. I loop...
0
by: jaykchan | last post by:
I am looking for a control that allows our users to expand and collapse rows in a report. Currently, the report is being shown in a web page generated from a CGI script. Unfortunately, the...
0
by: Sridhar | last post by:
Hi, I have a Crystal Report which has two sub reports in it. When I try to view this Crystal Report in my local computer, it is showing data for sub reports also. But when I deploy it to the web...
8
by: Ryan | last post by:
I have a SQL view that shows data by Category and Year - so the data may look something like this. Category - Year - Amount Fruit - 2006 - $12,000 Fruit - 2007 - $16,000 Vegetables - 2006 -...
3
by: sfjnet | last post by:
Hi I am relatively new to Access so I hope I am not embarrassing myself with this question. I have created a database showing contract details (contract number, contractors, dates, other...
2
by: THEAF | last post by:
hi im trying to produce a data report for my computing project. the data report shows information on an examiner such as name & address. It also shows the number of scripts that examiner has...
1
by: mahesh123 | last post by:
Hi Folks, I am getting an error in the Data Reports in the Visual Basic 6.0 as I am working on the VB Project. In One system the data showing in the Label which is located in the header part...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.