I have created a Report Parameter, and set the type of this to "Boolean".
This is displayed as a RadioButton with the options of True or False.
Is there anyway to change this to be displayed as a CheckBox?
Thanks,
Kate
See this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=562091&SiteID=1
Is there a way to force report designer overlook parameter dependencies, so that a report could be displayed by either of the two parameters although one parameter accepts but not requires the other?
For Example:
In my report I have two parameters, DeptID and ProjectID. The two drop downs display Departments and Projects respectively but only if the department is selected, the Projects list becomes active as its expecting a DepartmentID in the stored proc but accepts a null value as well. So, what I would like to achieve is display ALL projects in the Projects list, even if no department is selected. Any ideas how to do that?
Thanks.
Essentially what I need is to be able to filter the Projects List and not necessarily depend on the DepartmentID of the selected value in Department List. Kind of like filtering on Report Parameters without using Cascading Parameters?|||Hello,
why can't you have all Departments selected as default. The the user does not have to select departments id actively in order to select projects.
???? (rsProcessingAborted) ??
??? 'tempDB' ?? (rsErrorOpeningConnection) ??
Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection.
The report can be loaded a few times before and cannot be loaded now.
I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already.
Any idea to solve this problem?
msfriend wrote:
I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows: ???? (rsProcessingAborted) ?? ??? 'tempDB' ?? (rsErrorOpeningConnection) ?? Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection. The report can be loaded a few times before and cannot be loaded now. I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already. Any idea to solve this problem?
Should be authentication problem. Did you find any solution?
I don't seem to find any property set to 8 though.
Also the report is not pulling the records in the order the query pulls them, but in an apparent random order, I don't need to change this but it may help describe the report a bit better.
In Visual Studio, are all the records returned when you execute your SQL statement while you're in the Data tab?
Check to see if you have any filters on your table. Right click on your table and go to Properties, then check the Filters tab. Filters limit your recordset after it is returned to the report, so your query would return it, but it wouldn't show on your report.
This may sound silly, but are you sure the rest of the records are not on another page?
Jarret
|||Yes, the records are all returned without limits in the Data tab, and no there are no extra pages. I was told by the report user that it is intentionally set to, according to him, "8 random records", but for the records appear to be the same 8 every time, just not sorted in any logical order.I checked the filters in the dataset as that didn't occur to me at first but there were no filters for this dataset.
|||
Do you have any grouping in your table? If so, are you hiding the detail records and only showing the group header/footer?
Can you try running Profiler when the report runs to make sure the query is being run correctly?
Jarret
|||There is no grouping, The query is a very simple select, although it calls a Stored Procedure it is working perfectly. I tested it inside the Visual Studio Business Intelligence environment and inside SQL Management Studio, plus ran the simple SQL that is inside the Stored Procedure on it's own, all with the same results (all records being returned.)I was told this report was intentionally designed to show 8 records, I simply was requested to increase it to 10.
|||
Well, I think I will have to defer to someone else to help you. I've never seen RS 'eat' records before without having a filter of some sort. Like a filter on the table, a 'top' in the query, or a 'set rowcount X'.
Can you get in contact with the report creator and see how they got it to only show 8?
You could open the RDL file in notepad and see if you can see an '8' anywhere, and what setting it is on.
Jarret
|||Thank you, i forgot that rpl files where xml. I looked it up and found a filter being applied to a "Table1", oddly it never shows in the interface.
Code Snippet
<Table Name="table1">
<Filters>
<Filter>
<Operator>TopN</Operator>
<FilterValues>
<FilterValue>=8</FilterValue>
</FilterValues>
<FilterExpression>=Fields!Account_Number.Value</FilterExpression>
</Filter>
</Filters>
I understand now. Here, do this:
In your properties window (F4), use the drop-down to select 'table1'. This is the name of the table object in your report. Then, in the properties window, find and click on 'Filters'. It should say (Collection) next to it, click on the '...' button in the filters property. This will open a dialog box with an expression, operator, and value. In your case, you will see the following settings:
Expression: =Fields!Account_Number.Value
Operator: =
Value: =8
Here is where you can change the number of records you want returned.
Jarret
|||Thank you, this information is very useful!What does bother me is the seeming randomness of the length of the ASP-delivered report pages. Some of the pages seem double-lengthed, others triple or more. What gives?
|||I know what you, however, its my users that are complaining about it!
If there was some way of being able to "lock" the table headings it wouldnt be a problem - is there any way this can be done? It is one of the most requested features of my users.
Any help is much apprerciated.|||
In SQL Server 2005, you can 'lock' the headers for a table or a matrix.
If you right click the border of the table in the Layout pane of report designer, on the General tab in the Table Properties dialog, there is a check box called "Header should remain visible while scrolling". If you check that, in HTML the table header will always be shown.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
my report is displayed as one long page when viewed in the browser, while it is displaying correctly in several pages when exported to PDF. Can you please helpe me!!
Regards
Dwarka (hdwarka@.yahoo.com)
What does bother me is the seeming randomness of the length of the ASP-delivered report pages. Some of the pages seem double-lengthed, others triple or more. What gives?|||I know what you, however, its my users that are complaining about it!
If there was some way of being able to "lock" the table headings it wouldnt be a problem - is there any way this can be done? It is one of the most requested features of my users.
Any help is much apprerciated.
|||
In SQL Server 2005, you can 'lock' the headers for a table or a matrix.
If you right click the border of the table in the Layout pane of report designer, on the General tab in the Table Properties dialog, there is a check box called "Header should remain visible while scrolling". If you check that, in HTML the table header will always be shown.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
my report is displayed as one long page when viewed in the browser, while it is displaying correctly in several pages when exported to PDF. Can you please helpe me!!
Regards
Dwarka (hdwarka@.yahoo.com)
What does bother me is the seeming randomness of the length of the ASP-delivered report pages. Some of the pages seem double-lengthed, others triple or more. What gives?|||I know what you, however, its my users that are complaining about it!
If there was some way of being able to "lock" the table headings it wouldnt be a problem - is there any way this can be done? It is one of the most requested features of my users.
Any help is much apprerciated.
|||
In SQL Server 2005, you can 'lock' the headers for a table or a matrix.
If you right click the border of the table in the Layout pane of report designer, on the General tab in the Table Properties dialog, there is a check box called "Header should remain visible while scrolling". If you check that, in HTML the table header will always be shown.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
my report is displayed as one long page when viewed in the browser, while it is displaying correctly in several pages when exported to PDF. Can you please helpe me!!
Regards
Dwarka (hdwarka@.yahoo.com)
What does bother me is the seeming randomness of the length of the ASP-delivered report pages. Some of the pages seem double-lengthed, others triple or more. What gives?
|||I know what you, however, its my users that are complaining about it!
If there was some way of being able to "lock" the table headings it wouldnt be a problem - is there any way this can be done? It is one of the most requested features of my users.
Any help is much apprerciated.|||
In SQL Server 2005, you can 'lock' the headers for a table or a matrix.
If you right click the border of the table in the Layout pane of report designer, on the General tab in the Table Properties dialog, there is a check box called "Header should remain visible while scrolling". If you check that, in HTML the table header will always be shown.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
my report is displayed as one long page when viewed in the browser, while it is displaying correctly in several pages when exported to PDF. Can you please helpe me!!
Regards
Dwarka (hdwarka@.yahoo.com)
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||
Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||
Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.
If anyone knows, it is appreciated.
|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||I am trying to do something similar, but am having a problem.
Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.
For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?
Thanks,
Bob
|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.
In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.
Hope that helps.
|||Thanks for the replies.
The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.
Thanks for the ideas, Bob
|||I think you can work around the text split issue with a rectangle in your table cell.|||
Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?
gisinnovations@.gmail.com
HI
I have a report that I view in Sql 2005 reporting services that contains no header or footer. I do not want these to be displayed in the browser.
I would like to add a header and perhaps footer which will only appear on the printed document but not in the web browser.
Is there any way to accomplish this task?
Thanks
Further to the question posted above, as an alternative ...
Is it possible to view one version of a report and print a different version ?
I am considdering using the ReportViewer control and disabling the print button. Replacing print functionality by putting a link to a second, printable version, of the report and printing it without rendering.
A more elegant approach would be preferred. Any suggestions?
