Reports with lines white

[Frank Dulk]

I have a query where I pass the parameters of the dates between [Dates Ini]
and [ Dates end] but in the report him only display the dates where has
registrations, wanted him to show the other dates days with lines in white.

 

[GVaught]

Because your query is requesting dates between certain dates your data
returned will only reflect data that falls between those dates. Thus if you
ask 6/10/04 for [Dates Ini] and 6/15/04 for [Dates end] that is all you will
get. Anything before 6/10 and after 6/15 will not show or be available.

 

[John Spencer (MVP)]

One possible method would be to have a table of all possible dates and do an
outer join (Left or Right) to force blank records for those dates. You can also
use a table of numbers 0 to N to build the dates with dateadd function.

SELECT WorkTable.DateDefaults, YourTable.*
FROM WorkTable Left Join YourTable

 

[Frank Dulk]

That I already made John Spencer, but it exists some criteria that it limits
the date, for that wanted that was done direct in the report.

One possible method would be to have a table of all possible dates and do an
outer join (Left or Right) to force blank records for those dates. You can also
use a table of numbers 0 to N to build the dates with dateadd function.

SELECT WorkTable.DateDefaults, YourTable.*
FROM WorkTable Left Join YourTable

I have a query where I pass the parameters of the dates between [Dates Ini]
and [ Dates end] but in the report him only display the dates where has
registrations, wanted him to show the other dates days with lines in

white.

 

[John Spencer (MVP)]

Well, I don't have any other suggestions other than to enter blank records in
your data table with only the dates. That is probably NOT a good idea, as it
might cause errors or problems with other queries, reports, and forms.

That I already made John Spencer, but it exists some criteria that it limits
the date, for that wanted that was done direct in the report.

One possible method would be to have a table of all possible dates and do an
outer join (Left or Right) to force blank records for those dates. You can also
use a table of numbers 0 to N to build the dates with dateadd function.

SELECT WorkTable.DateDefaults, YourTable.*
FROM WorkTable Left Join YourTable

I have a query where I pass the parameters of the dates between [Dates Ini]
and [ Dates end] but in the report him only display the dates where has
registrations, wanted him to show the other dates days with lines in

white.

 

[Frank Dulk]

With I followed to do using a temporary table, does she doubt now it is?

How to repeat those dates for each employee?

Example:

Date ini 01/01/06 and Dates end 30/01/06

Report:

Employee: Test

days
1
2
3
4
5
6
....
30

Another page

Employee Teste1

days
1
2
3
4
5
6
....
30

and and so on.

Well, I don't have any other suggestions other than to enter blank records in
your data table with only the dates. That is probably NOT a good idea, as it
might cause errors or problems with other queries, reports, and forms.

That I already made John Spencer, but it exists some criteria that it limits
the date, for that wanted that was done direct in the report.

One possible method would be to have a table of all possible dates and

do
an

outer join (Left or Right) to force blank records for those dates.

You
can also

use a table of numbers 0 to N to build the dates with dateadd function.

SELECT WorkTable.DateDefaults, YourTable.*
FROM WorkTable Left Join YourTable
On WorkTable.DateDefaults = YourTable.[DateField]
Where WorkTable.DateDefaults Between [Dates Ini] And [Date End]

Frank Dulk wrote:

I have a query where I pass the parameters of the dates between

[Dates
Ini]

and [ Dates end] but in the report him only display the dates where has
registrations, wanted him to show the other dates days with lines in

white.