Search results for query: *

In my details section of my report I need to: IIF(Employeeid>0,Fields!PersonFullname,"Open Shift") Works like a charm. However, the personfullname column is stored with "Lastname, Firstname", while the report requirement is to display "Firstname Lastname". This I have solved like this...

Hi. Using visual studio 2005 with SQL 2005 reporting Services. I'm trying to create an expression to check for multiple conditions. Basically I'm doing a sum on TIMEINSECONDS if a paycodeid is 123, 124, 125, 126 or 127. In Crystal I would create a running total and say something like if...

Hi. Using SQL server 2005, Visual studio reporting. By adding "page break at end" you can split your group to display one group item pr sheet when exporting to Excel. However, the sheets are just called Sheet1, Sheet2, Sheet3, Sheet4 etc. Does anyone know of a way to control these names? I'd...

Reporting from SQL server 2003, using CR10. In my report I have grouped on person and date to display number of hours worked pr person pr date. Easy and basic. My problem is that the database does not contain an entry on every day on every person, hence, I cannot display all dates, just the...

Working with CR10, Microsoft SQL server. I'm having som diffuculties formatting my detail section in a nice manner. Problem described here: http://www.intime.no/temp/ I put it out like this as it's easier to explain with images. Thanks, Bjorn

Using CR 9.0, Microsoft sql server 2000. I've created a crosstab report displaying names, date, week number and shift start and stop times. Viewable here: http://intime.no/temp/crosstab.pdf What I would like to do is to format the vertical borders to be double when there's a new week. All...

Hi. Using CR9.0, reporting from MSSQL database. I've made a report consisting of quite a few formulas which calculates percent. i.e numerator / denominator Sometimes the denominator is 0. I'm aware that I can do If denominator <> 0 then numerator / denominator ,but I don't want to go...

Using CR9.0, Microsoft SQL database. I've created a report with a crosstab that's lists number of hours for a specified paycode: I.E. (semicolon seperated for the example) Employee;Paycode;hours Mr.X;Overtime;10 Std_hours;15 Sicktime;7 Total:32 hours Mr.Y;Overtime;15 Std_hours;30 Sicktime;2...

Using cr 9.0, mssql database In my database, I have a view VP_PERSON. I have grouped on VP_PERSON.HOMELABORACCOUNT, which works just fine. Now what I need to do is to have to groups. One where VP_PERSON.HOMELABORACCOUNT=["536", "456"] and one which contains...

Hi. Using cr 9.0 I've seen all tips on how to alternate colors in the details section, but those tips won't work for me, because I need to alternate colors silver/white in my group footer... if(remainder(recordnumber,2)=0) then crsilver else crwhite is one of the options I have tried, but all...

Hi. Using CR 9.0 with Microsoft sql server In my detail section I output shift start and end times like this: (The detail section will be supressed) Time({VP_SCHEDULE.SHIFTSTARTDATE}) Time({VP_SCHEDULE.SHIFTENDDATE}) In my example, this gives me five records Start-time...End-time...

Hi. Using CR9.0, reporting from Microsoft SQL. I've made a report of a shiftplan which is to be printed to paper and hung on the wall. It has the following layout. ...........Mon 06.06--Tue 07-06--Wed 08.06-- etc.. ---------------------------------------------- Employee...

Hi. Using CR 9.0 I have a Running Total (sum) that evaluates on change of "group #2 @Employee Name an Number". This works fine, but what I need to do is to somehow get this into "Use a formula." This is because I need to exclude some records. In the formula I will say...

Hi. I need to create an HTML-page that when accessed automatically redirect the user to mailto:mail@address.no, causing the mail client to pop up. Is this possible? Regards, Bjorn

Using cr9.0 I use this formula to convert a number to hh:mm NumberVar nbrTime := {@number}; NumberVar nbrHour := Truncate(nbrTime); NumberVar nbrHold := (nbrTime-nbrHour)*100; nbrHold := (60*nbrHold)/100; NumberVar nbrMinute := Truncate(nbrHold); ToText(nbrHour,0,"") + ":" +...

Using Crystal Reports 9.0, Microsoft SQL I have a report that has a formula in the details section. This formula gives #hours sick & #hours worked and works fine. What I need to do is to create a formula that says (#hours sick / #hours worked * 100) I've tried using a pie chart, but this...

Hi. Using CR 9.0, Microsoft Sql server Is it possible to create some sort of executable report, so that a pdf-report can be generated and opened by clicking an icon from the desktop? I have a client that means it's way to much hassle to open CR to produce a report... Regards Bjorn

Hi. Using CR 9.0, Microsoft sql server, reporting from within Kronos. Record selection as of now: {dbtable.applydate} in {from timeframe} to {to timeframe} Here I select the dates from within the Kronos system. I need to run this automatically, so it's not an acceptable solution. What I...

Hi. Using CR9.0, reporting from Microsoft SQLserver. I'm currently developing a report which is supposed to be exported to Excel data format. It will loop like this. Name | number | hours worked | hours sick | workplace | ------------------------------------------------------- Bjorn| 53 |...

Using CR9.0, Microsoft SQL server, reporting through WFC5.0 I need to create a report showing statistics on absence due to sickness. We have different pay codes for sickness, i.e. "sick 1-3 days", "sick 4-16 days" etc. It's rather easy to find number of hours and the days for each pay code, but...