Search results for query: *

Please disregard this post. It is now working.

Hello, I have a cfselect box that has a list of staff people. Is there is way for someone to start typing a last name and have the select box drop down to that name as it is typed? I have searched online, but have not really found anything helpful. Thank you in advance for any suggestions. Lisa

That worked! Thank you!

Hello, I have a form that is used to input attendance. The attendance field is a cfselect from which the user chooses if the student was: present, absent, etc. There is also a comment field that is required to be completed for each student based upon their behavior in that class. If the...

Hello, I'm not very advanced in coldfusion programming. I'd like to use CFLDAP to authenticate a user against active directory. Then, depending on what group they are in, I'd like to limit their access to certain pages. I have the authentication part working, but not sure how to use active...

Scratch that last post. I did get it to work by putting it in the report header section. Thank you!!

I moved the subreports in each report to the report header section, but the nested subreport is still not showing.

The two separate reports (report1 and report2) each have the same subreport(subreport1) which works when I run them individually. The crosstabs are working. It's when I try to layer them together that things stop working. I do have the column headings set. Here is what I would like it to...

Hello, I have two reports (report1, report2) that each contain a subreport(sub1). The subreport is the same in each report. I would like to take report1 and report2 and insert them as subreports into a main report. Each report has a different parameter crosstab query as the datasource. The...

I solved my problem. Thanks.

Hello, I would like to create a report that has a subreport. I would like to use two parameter crosstab queries - 1 for the main report and a 2nd one for the subreport. First, when I tried to insert a subreport control into the main report the crosstab query fields would not show up in the...

Duane, I have a question regarding this thread. Based on my most recent posting on another thread, I now am able to use a dynamic crosstab query in a report. I would like to do something similar with this crosstab query that you helped me with. I would like to have a report that looks like this...

Duane, Right before you responded, I figured out that I was not keeping the form open, so that is working now. Also got the date format figured out. Thank you!

I would like to show the Month Name and the Year in the column headings.

I have the following expression for the column label which is an text box: =DateAdd("m",0,[Forms]![frmEnterDates]![EndDate])

...[Forms]![frmEnterDates]![EndDate] DateTime; TRANSFORM Round(((Sum(Abs([status]='complete')))/((Count([status]))-(Sum(Abs([status]="NA")))))*100) AS compliance SELECT tblDept.Dept, Round(Avg([compliance])) AS [Total Of compliance] FROM tblHistory INNER JOIN tblDept ON tblHistory.Dept =...

...[Forms]![frmEnterDates]![EndDate] DateTime; TRANSFORM Round(((Sum(Abs([status]='complete')))/((Count([status]))-(Sum(Abs([status]="NA")))))*100) AS compliance SELECT tblDept.Dept, Round(Avg([compliance])) AS [Total Of compliance] FROM tblHistory INNER JOIN tblDept ON tblHistory.Dept =...

Hello, I would like to make a dynamic report from a crosstab query that will have a different date range everytime it is run. It will be computing a quarterly compliance percentage. The crosstab query is based on a table that was created using two queries to compute values. The table...

Oops, never mind. It was taking the min value of the Month column. I changed it to AVG and got the value I wanted. Thank you so much for all your help!!!

Ahhh! It was the data type that I did not have correct! Got the crosstab to work! I have just one more question. The total column does not seem to be figuring the percentage correctly. I'm not sure how it is getting the value in that field. Is that coming from my second query or something...