Search results

I have a field in the details row of my SSRS report. that formula is: =Fields!minetpay.Value * Fields!approvedby_i.Value * ((13-Fields!reviewmonth.Value)*4) So in my table Footer i want to sum up all the records wiht the above formula so i have it like this: =Sum(Fields!minetpay.Value *...

I am using datediff to figure out the years of service for an employee. I am having trouble getting it to show decimals. with my current sql piece for this im just getting hole numbers. Below is my code. If an employee has worked here under a year its giving them 1 year of service, i think...

Thanks. i hope someone out there has done this or seen this?

Thats what ive been find out. The current report is in Crystal report and we are moving away from that, and going to SSRS, which i like alot better.

IM using just access for this report, the table in my access DB has a field called dateandtimeofevent and i want the user to imput a date they want to pull info for

where would i set up the UDF?

I thought about that being wrong about the SQL parameter part. Anyone else have any ideas on what the access parameter would be when passing one through?

I have an ODBC connection to the access datbase, and then using the ODBC connection in my Datasource. i also get the error, ODBC does not support named parameters, Use unnamed parameters?

I have an access database that i want to create a reporting services report from. The data lies in 1 table called main. THIS is my sql statement in my dataset but i get no results. Is there something different i have to do when using parameters and getting data from Access, because if i use...

what do you mean by a "fake Folder" and by XP location do you mean the same location of the my documents folder on windows 7 and windows xp

I am implementing windows 7 soon at work and i have a test machine i have been working with. At my business we use the syncing of offline files in this way. Currently with XP all of our users My Documents are stored on the server and mapped to the users my documents on there PC I have been...

i just noticed that as i sent my post Thanks again

i attached the DB, the report is called Daily HTST & PKG Targets

http://support.microsoft.com/kb/303134 i used the above article, and in the article i followed the steps, and it says its in group leavel 0 but i still cant find it.

i had a field named "first vat" i decided to change it to "firstvat". everything runs fine in the query but now when i run the report i get a parameter box asking for a input for a field "first vat". I can no where find on the report where "first vat" is being used. any help?

I was wondering if anyone new what the default storage quota's were.

im using this in my where clause where bol.ldhshipdate between getdate() and dateadd("d",6,getdate()) my issue is its pulling the next 6 days after today what i would want is to include today 9/28/2010 and then next 6 days. any help would be great.

it needs to be getdate() and not date()

Msg 195, Level 15, State 10, Line 24 'date' is not a recognized built-in function name. thats the error im getting i dont think it likes the date() part?

where bol.shipdate between date() and dateadd("d",6,date()) thats what i have, and im getting an error, i think i have my date field in the wrong spot?