Viewing 15 posts - 91 through 105 (of 237 total)
Yes I think you can.
In the text box properties, there is an 'Action' section.
You can set this to Go to URL
In there you can use a mailto:
e.g.
mailto:name@email.com
March 5, 2013 at 5:59 pm
In SSRS 2005 I think you would need to have the sales values for different dates returned in the same row in the dataset. So that involves modifying your query...
March 5, 2013 at 5:51 pm
How about
Expression: =CDec(Fields!Collected.Value/Fields!Discounted.Value)
Value: =0.01
I suspect that dividing two decimals is giving you a float datatype, so convert them to decimal after the division.
March 5, 2013 at 5:45 pm
You can refer to parameter values in the report using an expression like this:
=Parameters!Parametername.value
If the parameter is a date datatype, you can use the dateadd function
=dateadd(DateInterval.Day,-21,Parameters!Parametername.value)
Then write this into...
March 5, 2013 at 5:28 pm
SSRS is designed for reporting (read-only), not for data input. If you want to make a survey, a basic webpage that writes to a database using .NET or javascript is...
March 5, 2013 at 5:18 pm
meghna.bhargav (2/22/2013)
I am going to introduce SSRS to develop reports , now I need to know what are the prerequisites / Requirements and access required to make simple SSRS...
March 5, 2013 at 5:10 pm
This is pretty much what reporting solutions like crystal reports and reporting services were designed to do. It's not complicated.
I highly recommend Jessica Moss's stairway to SSRS as an introduction...
March 5, 2013 at 4:42 pm
I always found this site useful for whacky connection string help:
http://www.connectionstrings.com/teradata
The annoying part about those "?" parameters is that if you have lots of them you can't easily see which...
March 5, 2013 at 4:35 pm
I have to echo SQLRNNR here. The queries are taking a long time for not many rows, but of course row count is not necessarily an indicator of complexity.
Optimising...
March 5, 2013 at 4:30 pm
The answers to those questions definitely depend on your environment.
What version of SQL Server is it?
Is this machine a production application database? Or a datawarehouse?
If you have investigated the...
March 4, 2013 at 11:37 pm
The issue is likely due to the SSIS server (or it's service account) not having permission on the linked Oracle server, especially if SSIS is on a separate server to...
March 4, 2013 at 11:32 pm
It's hard to provide a translation without the rest of the code, and I don't believe blindly translating it for you would benefit you at all.
I can give you some...
March 4, 2013 at 11:29 pm
What sort of datasource connection are you using? TERADATA or odbc?
With ODBC you can just use a single question mark in place of parameters in the query.
I've not connected to...
March 4, 2013 at 11:20 pm
Can you post the calculation that defines [Measures].[Net Lost Commitments] in the cube?
Has it perhaps been designed as an accumulated measure?
What happens if you run this query?
select
[Measures].[Net Lost Commitments]
on...
March 4, 2013 at 10:59 pm
Sounds OK.
I would make the Calendar table a lot longer, like to 2050 or something. The table won't be very big even with 365/366 rows per year that's only...
March 4, 2013 at 10:24 pm
Viewing 15 posts - 91 through 105 (of 237 total)