Recent content by acessn

Have you tried formatting the display field with N.

Solved it by removing -1 from the formula, and instead wrapped a Replace(String,",","") around it.

If these reports of yours is independent of one another, you might try using several datasets and tables within your report, instead of/in addition to sub reports.

A sub report in SQL reporting is just another report within your main report which is triggered by one or more parameters. I typically use it to get data which is unreachable from my main dataset. Beware that there might be performance issues with sub reports, especially if used in huge...

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 Geoff, That didn't work, but I solved it by using a workaround with assigning all paycodeids to a string and used instr() within the IIF. It also worked with a switch statement. Thanks for your time! Regards, Bjorn

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

That should do the trick BBurnell. Fields!FieldName.Value/100.00

Your selection criteria in SSRS is pure SQL. Just add parameters to your report, and reference them in your query with @timeframeparameter and maybe just use a datediff. You will have to create your new report from scratch. Something like Select * from mytable where (datefield >=@startdate...

Drop the concatenation. Just format the field as percentage. Right click->properties->format Format code is P

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

Yes, if you write this as a calculated field, you could also do similar logic on the remainer of the string in the textbox you dispay it in. Just search for the comma position, and do a left. You could of course do it directly in your calculated field, but the code gets rather messy and...

Try creating a calculated field with something like this: = Right((Fields!test.Value), Len(Right((Fields!test.Value),(Len((Fields!test.Value))-Instr((Fields!test.Value),","))))- Instr( Right((Fields!test.Value),(Len((Fields!test.Value))-Instr((Fields!test.Value),","))) ,",") ) This will...

Your picture isn't showing, but my best guess is that it has something to with your date criteria. I've had to use different ways of formatting date claues between sql server and visual studio reporting. Try removing your date criteria. If it works, format the where clause in a different way.

I would have created a duplicate report for excel exporting. I don't think it's possible to control the output of a report based on which format you are exporting it to. Create a formula which counts the number of rows in your detail section, and let the rest be plain text. Something like...