Search results for query: *

That worked perfectly!!! Thank you :)

Crystal 9. Sql Server 2005 I have a week group on the report which is based on the following formula: datepart("ww",{CompTimeBlocks.StartDate}) In the group header section i have placed text boxes that display "Mon" "Tue" "Wed" ...."Sat" Now my goal is based on the date range entered display...

I did that but as a result: Team1 it shows me all blocks which is correct Team2 it suppressed all the time block but I was expecting to see 07:00 AM- 5:00 PM because this is the largest of the overlapping blocks and hence should not be suppressed.

Oh no... I am so sorry.....I mistyped the example of Team4. It's wrong, the start time for some of them are pm not am. My range will always include times between 7AM to 6PM that is the company time. Here is the correct version of the example: Team 4 07:00 AM- 2:30 PM 02:30 PM- 6:00 PM 11:00...

Thank you lbass, for helping me with this, really appreciate it. As you see in my example for Team2 , the starttime and endtime of the overlapping blocks may not match. I have a report which shows the available time slots for a certain date for the teams. These time blocks that you see in the...

Yes,I am sorry. The range is a result of a complicated formula which based on all the scheduled job finds the open time slots for the team, but following the part of the formula which gives the daterange display. ToText(Time({WorkOrders.StartDateTime}), "hh:mm tt")& " - " & ToText(Time...

I could also have something like this, the time blocks are not always sequential. Team 4 07:00 AM- 2:30 PM 02:30 AM- 6:00 PM 11:00 AM- 2:30 PM 04:00 AM- 6:00 PM In this case I would see 07:00 AM- 2:30 PM because this is the largest of the overlapping block 11:00 AM- 2:30 PM AND 02:30 AM-...

Crystal 9 backend Sql Server 05 The details section of my report shows the following time blocks.And there is a group on Team. Team 1 07:00 AM-11:00 AM 11:00 AM- 2:00 PM 02:00 PM- 5:00 PM Team 2 07:00 AM- 5:00 PM 03:30 PM- 4:30 PM Team 3 07:00 AM-11:30 AM 07:00 AM- 6:00 PM 07:00 AM- 2:30 PM...

Awesome, it worked perfectly!!!! Thank you.

Lets say pending jobs, the running total field to summarize is JobID, type of summary is distinct count, evaluate using fromula StatusID = 4 which is pending, reset on change of group EmployeeName.

I am using running totals for the count of jobs in each status. Like count of jobs in Pending, Cancelled, Completed etc. I am using a formula in the running totals to check for the statusid and display the counts accordingly.

Yes crosstab expert->summarized fields->horizontal->show labels works in 9.0 as well. But you are right its not handling running totals correctly. :( Well in that case I think I will have to create a subreport.

Thats rights... that worked well... I have a couple of more totals other then the job even some running totals. Would I be able to display them left to right instead of one below the other as it does when you add the summurized fields? Thanks.

Crystal 9 I have the report with Group1 as the Type and Group2 Employees CPT Jobs Mike Smith 2 Joe Nance 6 Total for CPT 8 UPH Mike Smith 3 Joe Nance 3 Total for UPH 5 Total Mike Smith 5 Joe Nance...

I used this code that you gave me in access 2003 hoping it will work there too. But I also need a function that will call the stored procedure so i used my above code that does that but it gives me an error at objCom.Parameters.Append (objpara) objCom.Parameters.Append (objpara2)...

I have created a Windows Application Project in VS2005

I used xlbook.SaveAs("c:\maidpro\newTEST.xls"), but still the same. c:\maidpro\TEST.xls is my pre-formatted template in which I have added a chart and a calculation in the 11th column of the spreadsheet. My stored procedure returns 10 columns, so my spread sheet has a calculated field. I...

Throws the following error: MissingMemberException was unhandled Public member 'SaveAs' on type 'ApplicationClass' not found.

I am a beginner in this area, so let me know if I forgot to list some info. Following is the code I have so far and this runs without any errors but it does not allow me to save the output of the stored procedure to an existing excel pre formatted template. How do I modify the code to do that...

Hi CrysRptDev, I didnt see your post ealier... yes I too get that block of space for each row in the crosstab. I think thats the way its supposed to be and we will have to live with it if we go for the Original Style of the crosstab. Unless if there are some other suggestions....