|
|
Browse by Tags
- 2005
- Dynamic Report Width
- image size
- layout
- MDX
- microsfoft
- microsoft
- ms reporting
- OLAP
- Page Header
- performance
- PL-SQL
- Print Layout
- Reporting Services
- SQL
- SQL Reporting
- SQL Server
- SQL Server 2005
- sql server 2205
- SQL Server Reporting Services
- SQL Server Reporting Services Query COMPLETE WHERE CLAUSE PARAMETER?
- SSAS
- SSRS
- SSRS 2008
- timeout
- VB Expression
- vb expressions
-
SQL Server Reporting Services Query COMPLETE WHERE CLAUSE PARAMETER?
Hi, Is it possible for me to pass the where clause to the Sql server report (dataset)? Select * from where FromDate =@FromDate and ToDate =@ToDate AND strWhere -
How to format date in SQL Server 2005 in a concatenated string in a report title text box
Hi, In a report in SSRS 2005 I want to set the title text box to be say "My report for 08/02/2010 to 14/02/2010" and I need some help with the date format. The code below gives me the mm/dd/yyyy and I want dd/mm/yyyy. The server os is Windows Server 2003 and the regional settings for the os... -
Blank Page before the last set of group detail
I have a structure of report like this: Group1 Header Detail Group1 Sub Header Detail Group2 Header Detail Group3 Header Detail Group3 Sub Header Detail Group3 Sub Header Detail Group4 Header Detail Details Details Details Group3 Footer Detail Group3 Footer Detail Table Footer Table Footer Table Footer... -
table tables in SSRS?
Hi, I am trying to insert two tables in the Sql server report. I have two dataset for each of two tables. I have two date parameters to both tables. Two datasets are trying to create two sets of two date parameters. How can I just have one set of date parameters which go into each of two datasets? Parameters... -
Set non printable area in SSRS
How to set a specific non-printable area in SSRS report design where in the specified non-printable area should be exported to excel but it should not be printed. -
Export to excel in ssrs 2008
This is an issue related with ssrs 2008, l have a text box, which has time value coming from database, I have to add or subtract a second to it while rendering the report so my expression is =dateadd(dateinterval.second, 1, fields!abc.value) this renders fine and everything looks good until I export... -
SSRS Remove A User Account
Hello - I granted a user administrative access to the ssrs web app, and now can't revert back to what it was like before I added him (blank screen). I have removed him from all the report folders securities, and removed his ssrs memberships from his user profile on the domain controller. However... -
Group sum calculated fields (which contain aggregate function) by group
I have been fighting with this one for days. I have a report that pulls $$ per quarter for all projects, and it is grouped by project manager. To get the $$ by quarter, I have a complex expression like: "=(iif(Fields!Planned_x0020_Start_x0020_Date.Valueeters!SOCQ2.Value and Fields!Planned_x0020_End_x0020_Date... -
Calculate value of previous month using VB expression in SSRS report
I am creating a report using SSRS 2008, and I pass two parameter i.e Month and Year to get my report generated. Now my question is: the current months value and Year's values on the report is shown by ="Filter Value: " & MonthName(Parameters!ipv_firstPeriodMonth.Value) & "... -
How do I change the html for the default page on <a rel="nofollow" href="http://localhost/reports" target="_blank">http://localhost/reports</a> ?
I haven't been able to find the file that keeps the html code for the reportserver layout. I would like to make some modifications on the default page, but aren't able to find the file that keeps the code. Where is the code located?