Sarah S (5/4/2012)

---

Thanks for the replies Dan and Mark.

I tried the RunningValue function. It does not allow subtraction. The middle argument is a function name.

Mark - I have...

Lowell (5/5/2012)

---

sp_senddb_mail Is a service broker; it's already asyncronous

more likely is the person calling the procedure doesn't have permissions to send dbmail, which requires being a user in the DatabasemailUserRole...

pamozer (5/4/2012)

---

So I have an after trigger that sends an email. I want the insert to happen whether the trigger works or not. Meaning if for some reason...

Ok, I have replicated your erroneous output. Your spaces are not being seen a spaces if that makes sense. I changed the spaces in the example before by...

OK if we do the same steps then we can investigate if the issue is setup or data.

1) Add a new report in BIDS using Add New Item (not wizard)

2)...

Not sure what to suggest. The only way I can get it not to split correctly is by having the column width of the textbox to be shorter than...

martin-325528 (5/4/2012)

---

Does anyone have a process that ensures then when a notes field (255 characters) is in a field than can grow it puts in a return in suitable places...

riya_dave (5/3/2012)

---

hi,

in my pie chart i am using expression that shows data in percentage.

now i want to change this expression, to show filedname + percentage.How to do that?

and in my...

lanky_doodle (5/4/2012)

---

Thanks Mark, but that doesn't return the correct data.

As before, if the NAMENO is -93 (Record Department), I want the join to be made on the SIG nametype, therefore...

Assuming that the output is supposed to be SIG overrides EMP then:

use tempdb;

go

create table Name(NameNo int,StaffName varchar(30))

create table...

Sarah S (5/3/2012)

---

I have a report that shows a total amount by client and date.

I created a field named Net Different that subtracts the current amount from the amount on...

riya_dave (5/3/2012)

---

Ichange the y-axis "Cross at:" setting to maximum. However, now the x-axis labels are inside the chart area, and I don't see a property to move the...

It depends. Maybe the subreport has a subreport. The report as listed is linked in someway to the migrated report (my reason for asking about a new report)....

PLease show all DDL (create table etc), the sample data (INSERT INTO...) and the required output. This requirement is illdefined at present and we need to know more to...

lanky_doodle (5/3/2012)

---

Hiya,

I have a table that contains the name type of a user, and a table that contains the user;

NAMES table:

NAMENO | NAME |...