blank pages in report...

[ericschramm2000]

I'm trying to be sneaky and get around another issue I have with a report, but I'm having some trouble. I need to create a report based on a query (no problem), but I need that report to show no fields. So, I go ahead and put the mandatory one field in from the report wizard, and from the design view I make sure that in the properties of that field visible is set to No and I delete the field. So when I go to preview the report, there are no fields there, BUT it still has the number of pages (all blank) that it would need if you could see the field. How can I stop this???

BTW, I'm going to embed a chart in that report - couldn't get around some issues with the chart wizard.

Thanks!

 

[___]

it still has the number of pages (all blank) that it would need if you could see the field. How can I stop this???

take out the...
="Page " & [Page] & " of " & [Pages]
from the Page Footer.

 

[ericschramm2000]

take out the...
="Page " & [Page] & " of " & [Pages]
from the Page Footer.

Took it out and still no luck... I checked the code too, nothing there except:
Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)

End Sub

 

[Rich]

remove the DataSource of the Report

 

[ericschramm2000]

remove the DataSource of the Report

I need the data source to stay though because I need to show a parameter from that report.

I need a way to just get rid of all of those blank pages, but still have the report based on a query.

 

[Rich]

What do you mean to display a parameter?

 

[ericschramm2000]

What do you mean to display a parameter?

I need to show a begin date and end date on a chart. I've tried every other "normal" method already without any luck - tried putting it on a form and referencing the form, other reports, and other round-about ways...

If I could get rid of the blank pages this way would actually work.

Is there no way of getting rid of the blank pages?!??!?

I think it just comes down to Access 97...

 

[Len Boorman]

Just a thought

I have charts on reports and frequently the chart has date ranges that are parameters. I use test boxes on a form for the user to define the date range and these are picked up by the query that is the source of the chart. So then I usually display the chart on a Form and give the option of printing. Take a report in design view, copy and paste the chart from the form straight into the detail section of the report. Add report header text plus a couple of text boxes whose source's are the text boxes on the Form so that you print the Date Range

So the actual Report does not have a source

HTH

Len B

 

[Pat Hartman]

The report will print the detail section once for EACH row in the input RecordSource. So, if your RecordSource contains 100 records, the detail section will be printed 100 times. Change the RecordSource query so that it returns only a single row.

 

[Captain Chaos]

Not sure what you're up to but,
Have you tried 'Can Shrink' for the groups and controls.
if you have an empty group or field it should squeeze up
Set them to yes.

 

[ericschramm2000]

I'll see if I can explain my main problem here, then you guys (and gals) can see if you can shed some light on this...

FYI- I'm running Access 97, most of my tables are linked to an ODBC database...

The only way I'm able to display anything from a query (including parameters) on reports or forms is if I make the Record Source the query which I want the info from.
In another words, it's not liking my refrences --

It doesn't work if I put something like this in a text box without having a record source:
=[Cycle Time]![Day(s) Late]
...where Cycle Time is the name of my query.

It does work, however, if I change the record source to Cycle Time then write this in a text box:
=[Day(s) Late]

So the major problem is I can't show a couple things from different queries on a form or report. This is also a big problem when I try to show parameters on a chart created from the chart wizard, even though the chart is based on the query.

I've tried getting around this by running the things I want into a form or other report, then typing something like =Reports![Cycle Time]![Day(s) Late] but I haven't had any luck with that either.
(Cycle Time in this case is the name of a report and Day(s) Late is a field in that report.)

I'm thinking this is just a glitch with 97??? Or maybe there's something else I have to do when referencing without a record source??
Help!?!?

Thanks,
Eric

 

[Rich]

You can of course use DLookUp on the query

 

[ericschramm2000]

You can of course use DLookUp on the query

didn't work, maybe I'm typing it in wrong. I tried it a number of ways:

varX = DLookup("[Begin]", "[Cycle Time]", "[TEST_REQUEST_NUMBER] = ")

varX = DLookup("[Begin]", "Cycle Time", "[TEST_REQUEST_NUMBER] = ")

= DLookup("[Begin]", "Cycle Time", "[TEST_REQUEST_NUMBER] = ")

= DLookup("[Begin]", "[Cycle Time]", "[TEST_REQUEST_NUMBER] = ")

It will be the same value (date) for every reccord, so that's why I have it equaling nothing...

 

[Rich]

How many graphs are you trying to display, one for each record or just one?

 

[ericschramm2000]

How many graphs are you trying to display, one for each record or just one?

Just one graph based on all the records from a multiple parameter query.

 

[Rich]

I assume you enter the parameters via a form in which case you can refer to the form directly on your report, just keep the form open while the report is opening.

=Forms!YourForm!YourControl as the controlsource for a textbox will do it

 

[Pat Hartman]

The criteria statement is incomplete:

= DLookup("[Begin]", "[Cycle Time]", "[TEST_REQUEST_NUMBER] = something")

 

[ericschramm2000]

I assume you enter the parameters via a form in which case you can refer to the form directly on your report, just keep the form open while the report is opening.

=Forms!YourForm!YourControl as the controlsource for a textbox will do it

The parameters are entered when you open the report - you're prompted.