Advertisement

1 - 10 of 12 containing alltags:("SQL - SSRS") (0 seconds)
I just started at this finanical company, been 3 months, I'm the only programmer,  and I told these guys that this report is much too complicated to take out of Excel, throw in to a Reporting envir...
Zones: MS SQL ServerDate Answered: 03/14/2006 Grade: A Views: 0
I am looking to produce a report which summarises the users with access to each of our SSRS reports. I would assume this is all stored in the [ReportServer] database, but can't find any data str...
Zones: MS SQL Server, SQL Reporting, SQL Se...Date Answered: 05/13/2008 Grade: A Views: 113
I am looking to report on current assigned security roles in SSRS 2005 and have got to the stage where I can pull the roles from a report by path\name, but now need to follow through the tree struc...
Zones: SQL Server 2005, MS SQL ServerDate Answered: 05/20/2008 Grade: B Views: 63
I have an error with my stored procedure that says "the column prefix 'pv' does not match with a table name or alias name used in the query". This sproc is passing in a UDF for purposes of creating...
Zones: MS SQL Server, SQL Reporting, SQL Se...Date Answered: 07/04/2008 Grade: A Views: 0
I am trying to add an additional field to this sproc.  I am having trouble adding it.  The field is located in Doctor Facility table as listname.  I tried adding listname VARCHAR (50) to the table,...
Zones: MS SQL ServerDate Answered: 08/23/2008 Grade: B Views: 0
I have a report I have designed that uses references two functions. This stored procedure takes about 5 minutes to run.  More importantly, the procedure is supposed to return # of total appointment...
Zones: MS SQL Server, SQL ReportingDate Answered: 08/23/2008 Grade: B Views: 4
The below expression passes the SSRS Edit but when I run report it shows up as a error.  Field curr1c is numeric  111111.333333   12/6 If  Curr1c sums up to be 0 I want report to show "  "    ...
Zones: SQL Server 2005Date Answered: 09/23/2008 Grade: A Views: 0
I have been asked to develop some reports in MS SQL SSRS.   I would like suggestiions on books or online tutorials on using MS SQL SSRS mlmcc
Zones: SQL ReportingDate Answered: 08/22/2008 Grade: A Views: 0
In SSRS I need to query a date range. The problem I am having is that this date range is for the week of a currently selected date. What will happen is a user will open the report and select a ...
Zones: SQL Server 2005Date Answered: 05/02/2008 Grade: A Views: 0
SSRS 2005: In Dataset pane/Query string I put the parameter '?' in the SQL query but it won't work. I am using OLE DB with DB2 so I must use the '?' and not the '@' with my SQL's parameters. So how...
 
Related Solutions:
SSRS OLE DB with DB2: The ? parameters don't seem to work...

So I am trying to set and Start Date and End Date using the data picker in SSRS. I can create one...

Tags: sql, ssrs, ole db, db2, parameter
 
Zones: SQL Server 2005, DB2, Visual StudioDate Answered: 05/28/2008 Grade: A Views: 29