4

This will do it select UserName, EventDate, row_number over (partition by UserName order by EventDate asc) as EventNumber from AllEvents


3

In SSRS you don't join them in the result set (unless you do it in the data source) but you can use expressions in the design to show them concatenated in your report. Have a look at Expressions (Report Builder and SSRS). Your expression would be something like =Fields!FirstName.Value & Fields!LastName.Value


1

=IIF(Fields!txtCurrentSubjectReportName.Value="", Fields!txtSubjectArchivedName.Value, Fields!txtCurrentSubjectReportName.Value) = "School Life" OR IIF(Fields!txtCurrentSubjectReportName.Value="", Fields!txtSubjectArchivedName.Value, Fields!txtCurrentSubjectReportName.Value) = "My goal for this term..." OR IIF(Fields!...


1

In my humble opinion, it depends on the complexity of the details view. If I'm showing a sample list of values in each view then I'd rather use a List inside a List, inside a List. For example: [+] Customer Id + Customer Name [+] DeviCe Id + Device Name |------------|-----------------| | Job Id Job | Job Description | |---------...


1

After a lot of digging around, I didn’t get anywhere, then eventually I got Microsoft involved to help me with the problem. MS solution architect confirmed that the Report Builder requires a direct connection to SQL Server when launched hence the working with data sets in the report builder failed. Apparently this is BY DESIGN and it is not going to change....


1

I discovered that the named instance does not use default SQL port, but uses port 8000 (which is open on the firewalls). I tried specifying the port number in the connection string like this: Yes, but the named instance ports are dynamic and managed internally by SQL browser service which use the port number 1434. In your case port# 8000 should not be used ...


1

It appears that SQL Reports actually does what I want automatically - but only if the parameter with the dependent query immediately follows the first query. We were modifying the report for other reasons and moved the offending drop down higher up the parameter list so it was second (after the query that filled in the location drop down). Having done that, ...


1

I found the solution for my situation... I went into Printer Settings & checked the "Always Use Driver Settings" under the "Override Application Default Settings." This caused the printer to always print in the correct orientation.


1

Another workaround, which seems to work quite nicely - place a parent group of the group you want to selectively break on, then in Group Properties for that, group on a derived expression of either the group field, or a fixed value. And then tick the box for that grouping as per your screenshot. e.g. Assuming a parameter called "BreakPages", and a grouping ...


1

Yeah, SSRS can be a little cumbersome with its handling of empty/null values. Try adding an explicit isnothing() before the yellow option: =Switch(Fields!DaysToExpiration.Value > 31, "Green", Fields!User_Certification_Status.Value = 8, "Firebrick”, Fields!User_Certification_Status.Value = 13, “Orange”, Fields!User_Certification_Status.Value ...


Only top voted, non community-wiki answers of a minimum length are eligible