Viewing 15 posts - 46 through 60 (of 114 total)
Please post your T-SQL query if possible ?
And also try to use SQL Server profiler to get the exact query being passed along with parameter values selected to the database...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 4:59 am
Lucky's (10/4/2012)
I have a multi value parameter in SSRS report which has a list of values around 600..When the user selects 'SELECT ALL',its passing the long list of values
to...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 4:46 am
Please refer to this post created by you:
http://www.sqlservercentral.com/Forums/Topic1370073-150-1.aspx
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 4:26 am
cnirosky (10/8/2012)
<Report>
<ReportSections>
...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 4:19 am
kothakeerthi (10/8/2012)
2. can I take 1 source from table and other...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 4:14 am
I followed the exact same steps to achieve the required output.
But i was trying to do the same thing as you mentioned of achieving it 'without using a staging table'.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 21, 2012 at 12:36 pm
the only way i can think of is to have the 'commonly viewed parameters' as a seperate 'one-tick' option.
I don't know how to do it.
what about using defaults parameter values?
If...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 21, 2012 at 12:25 pm
Maybe the value of "Fields!AppointmentLetterStage.Value" changes within the rows of the tablix.
Check for its value which maybe includes integers as 1,2,3,....
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 21, 2012 at 1:26 am
It's set in the subreport properties in the master report.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 21, 2012 at 1:04 am
Can you share the sql query and maybe screenshot of the matrix report you have created ?
That may help to suggest the sql query.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 21, 2012 at 1:03 am
ByronOne (9/20/2012)
I have a Matrix table in SSRS 2008 which shows sales data for the past ten financial years. The table consists of Financial years across the top (columns), sales...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 20, 2012 at 11:52 am
It depends on what you need to do.
There are two different cases as follows and also in my earlier post:
Case 1) You can use the lookup/lookupset function in SSRS 2008...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 20, 2012 at 11:44 am
Here's what I have in the hidden property for each sub report:
Sub report 1: =(Fields!field.Value <> 1)
Sub report 2: =(Fields!field.Value = 1)
The field is an int field and can...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 20, 2012 at 11:36 am
You can use the lookup/lookupset function in SSRS 2008 to access data from different data sets.
Also you can get aggregated data from different data sets using aggregation function like this:
=Sum(Fields!Balance.value,...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 20, 2012 at 10:48 am
Maybe this is silly but i only knew the following way to do it :
Suppose there are prompts called 'Year', 'Half Year', 'Quarter', 'Month' and 'Week'.
So the dependency of prompts...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
September 20, 2012 at 2:42 am
Viewing 15 posts - 46 through 60 (of 114 total)