Search results for query: *

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

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.

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

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.

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

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

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

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

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

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

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

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

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

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

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