Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access is denied (login-mapping)
I am using crystal 8.5 SQL Server 2000 I have created a main report off of my SQL Server database which is accessing the data fine, the problem comes into my subreport. I have multiple linked servers which I have created a view in my database off of...my subreport is using this view as it's...- simonsez
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Set Row ID for Set of Like Values?
I figured it out by using the event_datetime instead of the event_id for the last condition.... Thanks anyway simonsez- simonsez
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Set Row ID for Set of Like Values?
...con't The result is giving me the total count of line items for that season; the number appearing in every row. What is wrong? simonsez- simonsez
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Set Row ID for Set of Like Values?
I am trying to accomplish a version of this SQL statement. I am trying to assign a row number (gameNum) that corrisponds to the Season and the grouping of that line item. Season begins in August & ends in July The grouping is the first three characters of the eventCode So the first game in...- simonsez
- Post #5
- Forum: Microsoft SQL Server: Programming
