ASP.NET, SQL Server, WPF, C#, VB.NET

I have a report for which I am setting the RecordSource programmatically when 
 
it opens.  I would also like to programmatically count the number of records 
 
that print on this report and place that in a footer control. 
 
I have to do this programatically because the RecordSource table can vary, 
 
and therefore fields assigned to controls in the detail section of the report 
 
can also vary.

General question. Is it possible to link to an excell file ,import the data 
 
and makes reports from this data?

Background: I am working on a database to track children who attend a 
 
preschool, which classroom(s) they are assigned to, and which days of 
 
the week they attend. Students can attend any combination of classrooms 
 
or days of the week. 
 
I am currently working on a report that will list the children who 
 
attend on a particular day (it will be used as a sign in sheet by the 
 
parents). The report works great, but I am trying to avoid creating 5 
 
different versions of it (one for each  ...

Background: I am working on a database to track children who attend a 
 
preschool, which classroom(s) they are assigned to, and which days of 
 
the week they attend. Students can attend any combination of classrooms 
 
or days of the week. 
 
I am currently working on a report that will list the children who 
 
attend on a particular day (it will be used as a sign in sheet by the 
 
parents). The report works great, but I am trying to avoid creating 5 
 
different versions of it (one for each  ...

I have a report where I am separating the columns of data with a line. I am 
 
using a small vertical line the height of the detail and usually works well. 
 
Once in a while, I have a field ("can grow" property set to "yes") with 
 
enough data to grow. That makes the vertical line look "broken" all across 
 
the row. Is there a way to make all the vertical lines extend their length 
 
to match the new height of the detail when a field needs to grow to 
 
accommodate its data? The width of the  ...

i have a database of employee information and would like to create a report 
 
so that i can print the employee information as a resume. i would like to be 
 
able to search for the employee whose resume i want to create and then send 
 
only that record to the report to print only 1 resume. any help? 
 
katie

I used the following suggestion to condense my group header information onto 
 
the first detail line & it works great: 
 
You should group (View - Sorting and Grouping menu) on the 
 
sequence number eith all but one(?) field in the group 
 
header section.  Place the payment code in the detail 
 
section.  To get the first detail on the same line as the 
 
group header, add this line to the group header section's 
 
Format event: 
 
Me.MoveLayout = False 
 
However, I would like to have that g ...

Is there a way to have an alert pop up if a report that is opened is 
 
empty(Null)? Any help is appreciated..... 
 
-- 
 
Thanx, 
 
Hanksor 
 
Oregon City, Or

Hello ! 
 
I Have a table with a ODBC link. I build a query and a report to get 
 
the worker's schedules. 
 
everything is working fine. The query looks up bewteen date to show the 
 
results. A criteria =ABBETWEEN=BB is used in the query. 
 
Is it possible to create a sort of pop-up window that would ask me 
 
between what dates I would like the query to look for the worker's 
 
scedule ? 
 
What I would like is for the pop-up window to ask me between what dates 
 
and when I would enter the t ...

Hello, 
 
I've been reading the various responses to the question of how to use a 
 
calculated field in a report footer.  I think I've done what I've read, but 
 
with no luck... 
 
I have a text box in section footer1 called T1YESTxt, with the data source 
 
of =IIf([T1TOT]>=([PayGap]*80),1,0).  Format is STANDARD, 0 decimal places. 
 
This works fine. 
 
I have another text box in section footer1 called T1YESNum, with the data 
 
source of: T1YESTxt. 
 
In section footer2, I am trying to eith ...

I'm not sure if this is an error or just a misunderstanding on how the print 
 
preview and displaying a report works. 
 
When you run and display a report, if you select the "print preview" menu 
 
option the report disappears.  So you have to rerun the report to have it 
 
open again. 
 
Can someone clarify this issue? 
 
thanks in advance...

How do l create a report based on my query where the report is created for 
 
each record in the query.This is because when l view my report in print 
 
preview a second page that's completely blank with nothing on it. l did not 
 
create any background on my report . In which property field that l solve my 
 
problem report header, header or detail or any part?

The Report Wizard automatically formats the List Boxes I have in the Details 
 
section with white font and black background.  I don't want that but am 
 
unable to change it.  The format painter doesn't work on it, nor does going 
 
into the Properties and changing the format.  What can I do? 
 
It also automatically shows every category in the list box, rather than just 
 
the value. I figured out how to change that by making the box smaller so only 
 
the selected value shows. 
 
I am used to using Access 97 and this never happened there.

Hello, 
 
I have this big report that summary a lot of data. Sometimes a group 
 
need to be shown if that group has data on it otherwire I dont want to 
 
show the group in the report. So, is there an option to not show the 
 
group if no data is under a group? 
 
Any ideas? 
 
Thank You

Ok, i'm not sure where this would go, in reports, forms, or queries. If this 
 
is in the wrong place, could a mod/admin move it to the correct place? 
 
moving on. 
 
I have records that are generated from a C++ program i wrote.  (the records 
 
track a QA test and save to the db)  I want to print a nice formatted report 
 
with the records, which i already can do, but it prints all the records. 
 
what i want is a way for someone to go to the database and select a number 
 
of criteris (custom ...

Hi there, 
 
I am trying to design and run a report usubg the Report Wizard in Access 
 
2003, it takes very long or just hangs then I click the Finish button for the 
 
report. This report is very simple just a small reference table with about 
 
200 rows of data. After a long while I got it back the report but then when I 
 
click on the Design to customize the layout of the report, it then hangs 
 
again....I wait half it still hangs so, I kill it. 
 
Would anyone know why it hangs? I had uni ...

a) In my report property for text box l choose 
 
Control Source=1 
 
Running Sum = Overall 
 
But l want to know what is the different with "yes" or "No" in Visible 
 
Hopely anyone can understand what did l mean. 
 
b) May l use  label in page header? 
 
Thanks in advance

Hi, 
 
I have to mail out cards to people who are identified by a monthly query. 
 
The card has a message that has to incorporate the text content of a field 
 
into the message body. A person may have more than one incidence of his name 
 
in a query because there may be more than one diferent text content 
 
associated to his name. 
 
J Smith | table 
 
J Smith | chair 
 
J Smith | flower stand 
 
The card should look like 
 
Delivery of table, chair and flower stand                    J Smit ...

I am trying to figure out how best to use the if statement - whether in 
 
a query or in the report.  (I would like to use it in the report).  I 
 
have a field "missed oppt" with a percent 10% and I want to do an if 
 
statement - IIF([missed oppt]<13 then score =1)  Score is an unbound 
 
field on my report.  I was putting the IF statement "on open" for the 
 
report, but it doesn't seem to work.  Any suggestions - can the IF 
 
statement work on a report?

I have a large record that takes 8 pages to display.  I've created 8 reports 
 
each calling the next as a subreport.  When I tried to view it I got the 
 
message about not nesting more than 7.  What can I do to retrieve and display 
 
all the data in these records?  Thanks, ciny

Hi! 
 
Thanks for all help up to this point! 
 
I am still struggeling with having a form where one can specify to years in 
 
a combo box, to get all entries which are in between. I have tried to sort by 
 
date (given by a date() function) which works fine. But the field (year it 
 
goes into production)i want to sort by, through to drop down boxes doesn't 
 
work. 
 
I have been wondering if it is because the field is defined as a text field, 
 
but it should be possible to overcome!! 
 
I ha ...

I have a report set up a lot like the Northwinds Invoice database. The report 
 
is grouped by 'Quotation No' and that group has both a header and a footer. 
 
In between that group header and footer, there is a detail section designed 
 
basically like a spreadsheet. In its current format, the terms of the quote, 
 
signature area, etc. are in the 'Quotation No' footer. This makes that 
 
information move up and down the page depending on how much data is entered 
 
into the detail section. 
 
 ...

I have an unbound main report that contains four unrelated subreports. 
 
Sometimes there is no data for one of the subreports depending on the 
 
criteria the user enters.  When I preview the main report, Access displays 
 
(and prints) a blank page for the subreport that has no data.  Is there a way 
 
to get access to not display (or print) the blank page and skip the subreport 
 
if there is no data?

I work in Access 97 and I have a subreport that I am trying to make it hidden 
 
when certain conditions are met, here is the code: 
 
If parent.[PricingDetails] = "General" Or Me![CredentialCount] = 1 
 
Or Me![CredentialCount] < 1 Then 
 
Me.ReportFooter.Visible = False 
 
Else 
 
Me.ReportFooter.Visible = True 
 
End If 
 
I placed this code in the report footer, detail, and header but nothing 
 
seems to work even thogh the condition is met the footer still shows. any 
 
ideas 
 
thanks 
 
Al

I have figured out how to use the class module function to make my memo boxes 
 
justified, but now everything in the boxes are repeating. Is there a solution 
 
to this problem or does this particular function call for the information to 
 
repeat? Any help on how to correct this will be greatly appreciated!!! Thanks 
 
in advance 
 
kbrad 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200607/1