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!

Recent content by Vi08

  1. Vi08

    Parameter for top margin format

    Hello, I am using reporting 2008 and I created a parameter_Top Margin Format where it displays a list for top margin format i.e. 0.5;1.0;1.5;2.0. How do I incorporate this into the report so it would dislay top margin based on what was passed thru the parameter? Is it possible? Thanks so...
  2. Vi08

    Datepart

    Hello everyone, just want to let you know know Thank you so much for everyone help! I am getting close to what is needed. Again, thank you.
  3. Vi08

    Datepart

    Sorry, I am a little bit slow here:-( Dec 31 or Jan 1 are just my example that they are variable. They could be any months or dates like November thru Jan or Feb or March.... or October thru jan, feb, march and etc. birth date between end month and day and dec 31 or birth date between jan...
  4. Vi08

    Datepart

    I am so sorry for the confusion. Yes or No were just my validation. Basically, I want to be able to get people birth date when their dates are in the range entered regardless they enter how they enter month start and month end.
  5. Vi08

    Datepart

    Hello, I am using reporting 2008. Here is our formulas: datepart (month, date_of_birth) * 100 + datepart (day, date_of_birth) between (@tb_StartBirthMonth * 100) + @tb_StartBirthDay and (@tb_EndBirthMonth * 100) + @tb_EndBirthDay. This formulas works fine if people entering dates in...
  6. Vi08

    Show only last Status Entry

    I am so sorry for confusions! I actually got what I need. For some reasons, same grouping if I have my running total under Group Header, it only calculate the 1st entry. However, under Group Footer, it gives me the correct running total. The bottom line is that I finnaly get what I am...
  7. Vi08

    Show only last Status Entry

    My detail section would show as follows: Customer Name Proj# Business Name Hrs Enter ABC 24841JH Programming 1.15 Programming 2.88 Programming 4.03...
  8. Vi08

    Show only last Status Entry

    just so you have more details about my problem report. If I have a running total and put it to my detail section, I then will have all entries. however, if a project has 4 entries and I put it under details section, I will have it shows 4 times. If I group it by project, it will show only 1...
  9. Vi08

    Show only last Status Entry

    Hello, I am able to show only the last status entered based on your suggestion below. However, I now have a different problem. In the report, I also want to show total hours entered per project. By doing the Group Select of isnull({tblStatus.EnteredDate}) or {tblStatus.EnteredDate} = Maximum...
  10. Vi08

    Show only last Status Entry

    Hello, It's me again. This might help to understand my question. in my tblProjects, I would have something like: ProjectNum CustomerID 123BC 1 124DS 2 tblStatus: Project Num Status...
  11. Vi08

    Show only last Status Entry

    I am so sorry for the confusion. What I am trying to get is a report to show a list of all pending projects. Within these pending projects, there are projects, which lots of STATUSES entered per project; however, I only want to show last STATUS entered and the date for the project. Something...
  12. Vi08

    Show only last Status Entry

    Hello, I am using CR10. In the report, I am trying to show something as follows: Customer Name Project Num Business Name Last Status Entry ABC 123BC Training Onsite Sent out quote to the customer EDS 124DS Programming For the Last Status Entry, I want to show only last entry status...
  13. Vi08

    SQL Server Enterprise Manager-Error adding a record

    I did not do it in a query. I add it directly by doing as follows: In SQL Server Enterprise Manager, I right mouse click tblProjects, then Click on Open Table, then Return all rows. I then add it by type in a project# and so on, if I do not assign CBUID with a value. I will receive an error...
  14. Vi08

    SQL Server Enterprise Manager-Error adding a record

    Well, I don't want to put a default value because I plan to permanently remove that column name soon. However, as I mentioned, I deleted it and tried to add a new record, I still receive the same error message. Even after I deleted the linked table and re add. I also received the same error...
  15. Vi08

    SQL Server Enterprise Manager-Error adding a record

    Hello, In the past, in our tblProjects, we used the field name "CBUID" and Data Type is smallint. Now, we also have RegionID. CBUID is basically no longer needed. However, if a person tries to add a new project into our SQL Server Database using Forms in MS Access and if I do not include the...
See more

Part and Inventory Search

Back
Top