Hi,
I think this is a simple question but I am just not sure how to do it right, as a newbie.
All I want to do is generate a report of company employees grouped by their date of hire.
...
I have a crystal report with two subreports. The subreports are different summaries of the numbers shown on the main report (i.e. should be looking at the exact same data). One of the parame...
It's along story, but I will try make it as short as I can.
RS is installed on the same server with the WebServer. I run this from a
domain network PC:
http://WebServerName/Reports/Pages/F...
Hello
I would like my report to display the following based on the below database information. If the actual achievement date is null then I would like the value to be blank in the report r...
Hi All,
The textbox is using the following expression
= sum(iif( Fields!Opportunity_Type.Value = "Renewal", Fields!DT.Value, 0.00))
Previously in the database when the column DT is of ...
1) when i format a numeric field like #.###,## i want that the , is the decimal separator and . is the thousand operator but its just the opposite while in other applications o...
Hi,
I am using
=FormatDateTime(Fields!myDate.Value,dateformat.shortdate) and it is returning "MM/DD/YY"
My reginal settings are "DD/MM/YY". So why is it returning "MM/DD/YY"??
I ...
i have a matrix that has a series of row groups, and then a few column groups with the data that i am pivoting. what i am trying to do is get the Sum of the data in the row groups and display ...
I am using Reporting Services 2005 and SQL Server 2000. I placed a reportviewer control on my ASP2.0 webpage to display a report.
When I tried to export my report to an Excel file, I g...
Hello,
When we create a grouping for RDLC report, we can insert a total for that grouping on the footer section by using =sum(fields!quantity.value). It works when the value in integer, but c...
How do I format the following:
=Fields!School.Value & " Percentage (" & (Count(Fields!S_SSN.Value) / Max(Fields!StudentPop.Value))*100 & "% )"
so my percent shows now digits to the right of...
Hi all,
I am after creating a custom report generator within my VB.Net 2005 application. It would need to pull information out of a SQL database and allow users to design custom forms in a si...
Hello,
I have an subtotal at the bottom of a matrix associated with a row group. How can I change the color of the background in the subtotal based of the value that subtotalled inside it w...
Is there some way to allow the user to expand all items displayed in a report that are collapsed by default when a report generates?
In SQL Server Reporting Services what have many date parameters declared as DateTime and so they display a pure date with the time of "12:00 AM". We want the DateTime data type for validation...
I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report...
In reporting services I have a report with parameters.
one of the parameters is a select from list and when I run it I get <select a value> and this open the list and I select.
I don't want...
Is there any way to make the width of a table column adjust automatically based on a value returned by the dataset? I have a report that just barely can print in 8.5x11in landscape. If some ...
using reporting services, i have no problem exporting reports to PDF format
however, when i export reports to Excel format, i see 'rubbish/not my stuff' in MS Excel.
how can i solve this ?
Using SQL v2K, reporting services, visual studio 2005, version 8.0.50727.42
I am an RS newbie, I had created a project, nothing crazy, it worked quite fine. Now, however, when I login to VS ...
SSRS 2005 using BIDS/Visual Studio 2005
i have a basic stored procedure and i have added it as a dataset to my report.
this stored procedure requires 1 input parameter. this input paramet...
HI!
I have an SSRS 2005 Reporting Services report with a table that has a drill down group. The report opens with the group details suppressed. The report also has interactive sorting s...
I have created a report using 5 datasets. Some of these datasets require different parameters.
My report works perfectly in Visual Studio 2005. It asks for 5 parameters which are used on al...
In reporting services 2005, how would I call a function in the code behind, and successfully pass a multivalue parameter?
If i have a parameter defined for state that is multi-value, and i w...
Hi!
I have an SSRS 2005 report that contains a table with certain columns that have interactive sorting. At the top of the report there is a subreport that contains an embedded image (a c...
