Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cfuser10

    Cfselect Question

    Please disregard this post. It is now working.
  2. cfuser10

    Cfselect Question

    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
  3. cfuser10

    Populating Text Box based on CFSelect Value

    That worked! Thank you!
  4. cfuser10

    Populating Text Box based on CFSelect Value

    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...
  5. cfuser10

    CFLDAP and Read only access to pages

    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...
  6. cfuser10

    Nested SubReports

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

    Nested SubReports

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

    Nested SubReports

    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...
  9. cfuser10

    Nested SubReports

    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...
  10. cfuser10

    Subreport Problem.

    I solved my problem. Thanks.
  11. cfuser10

    Subreport Problem.

    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...
  12. cfuser10

    Possible to Pivot Quarterly Grouping?

    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...
  13. cfuser10

    Dynamic Crosstab Query Report

    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!
  14. cfuser10

    Dynamic Crosstab Query Report

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

    Dynamic Crosstab Query Report

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

    Dynamic Crosstab Query Report

    ...[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 =...
  17. cfuser10

    Dynamic Crosstab Query Report

    ...[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 =...
  18. cfuser10

    Dynamic Crosstab Query Report

    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...
  19. cfuser10

    Possible to Pivot Quarterly Grouping?

    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!!!
  20. cfuser10

    Possible to Pivot Quarterly Grouping?

    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...

Part and Inventory Search

Back
Top