Viewing 15 posts - 1 through 15 (of 47 total)
March 9, 2018 at 2:43 pm
I tried this in my select:CONVERT(xml, replace(cast(xml_data as varchar(max)),'&','&'), 2) as converted_xml
but got the same error
March 6, 2018 at 12:17 pm
If you can manipulate your code to get the facilities and chart information into the same dataset, you can use a table and group by the facility. The facility...
September 8, 2010 at 10:32 am
I would try using the switch function for the "Y" and "N", and nest the IIFs inside the switch. I'm not positive it would work, but it's worth a...
September 2, 2009 at 11:42 am
only4mithunc (8/29/2009)
=not(join(Prameter!StudentName .Values,",") like "*Anil*") -- for the column Anil_details ,=not(join(Prameter!StudentName .Values,",") like "*Anil Kumar*) -- for the column Anil_Kumar_Details etc..
Could just be a typo. Try Parameter instead of...
August 31, 2009 at 5:35 pm
To display the values of a multi-value parameter, you need to use JOIN. For example, to display the values for the Job_Number separated by a comma, try this:
Join(Parameters!Job_Number.Value,", ")
Hope...
August 27, 2009 at 10:27 am
which tables are growing? Do you keep a lot of report snaphots? Or cached copies?
August 26, 2009 at 4:00 pm
riga1966 (8/20/2009)
I'm using SSRS 2005.I can't change column width in Matrix Table.
Whenever I change it from 1.4in to 0.45in it does not save it.
It goes back to the original 0.4in
Is...
August 26, 2009 at 3:49 pm
Sorry, I'll have to defer to someone else on your follow-up question.
August 24, 2009 at 11:50 am
You need to create a data source in SSRS using the cube (Type = Microsoft SQL Server Analysis Service), and then create your SSRS report using that data source.
You might...
August 21, 2009 at 2:43 pm
View the Properties of the folder and select Security
Click Edit Item Security (click OK on the pop-up message asking if you really want to change it)
Click New Role Assignment
Enter the...
August 21, 2009 at 1:57 pm
Check out the response from DevDells on Sep 19, 2008 from here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/43385efd-b4ff-41ef-b24b-da911c155936
Basically, you need to create a share with the folder where your file will reside, and your Jump...
August 20, 2009 at 11:49 am
If the error is due to the subscription owner being terminated, you do not have to create new subscriptions - you can just reassign ownership of the existing subscriptions.
Take a...
August 19, 2009 at 11:42 pm
You can use a CASE statement in your query:
select COUNT(id) as 'AllShipments', DeliveryDate,
sum(case when status = 2 then 1 else 0 end) as 'FinishedShipments'
from Shipment
group by DeliveryDate
order by...
August 19, 2009 at 11:25 pm
I think you can reference a different dataset by specifying it in your expression. For example, where the second dataset (the one not attached to your table) is called...
August 19, 2009 at 10:59 pm
Viewing 15 posts - 1 through 15 (of 47 total)