I have a report that has a toggle item that toggles between showing and hiding report items specifically the detail rows, I am wondering can I also used this toggle item to change the font color of other report items. Exampl is I have a toggle item, EmployeeName that toggles the detail rows of the employee from visible to hidden. Can I also use this toggle to change the text color of other report items or highlighting different items.
Hi, I have a matrix report containing a parameter.The count of groups may change based on the parameter's value.Also these groups are connected to each other with toggle property. For example; --If the parameter's value is "year", the report have three (year, month, day) groups.Day is connected to month and month is connected to year with toggle property. --If the parameter's value is "month", the report have two (month, day) groups.Day is connected to month with toggle property. --If the parameter's value is "day", the report have one (day) group.There will be no toggle property.
The question is: I wrote expressions for this report and set the visibility properties of the groups, but when I select the "day" or "month" value for the parameter, no groups are shown.I think the reason is "being connected to each other with toggle property".
I want to toggle the visibility of a report item in my page footer based on whether or not a particular subreport has been rendered.
The report has 3 subreports. The subreport above the subreport in question can span several pages, so the subreport I want information on can render on page 1 (for a short report) or page 12 (for example) on a longer report.
Is there a way to determine within the main report when a particular subreport has been rendered and is currently visible?
I have a report I am creating in sql reporting services 2005 and what I am trying to do is have a single text box with multiple lines of data format each item in the textbox to specific parameters but I have not been able to figure it out. I tried to format my data on the sql side so that it cam out as follows:
tried Monday, Nov. 26, 2007 "Color = Blue FontWeight = Bold " & John Doe & CHAR(9) & "Color = Red FontWeight = Normal " & Jane Smith & CHAR(9) & "Color = Black FontWeight = Bold" John Roberts This did not work
so then I tried Monday, Nov. 26, 2007 "FontColor = Blue FontWeight = Bold " & John Doe & CHAR(9) & "FontColor = Red FontWeight = Normal " & Jane Smith & CHAR(9) & "FontColor = Black FontWeight = Bold" John Roberts
Still did not work What my end result needs to be in a single text box... Monday, Nov. 26, 2007 John Doe Jane Smith John Roberts
If anyone has the answer thanks ahead of time. Mike
I want to change the color of the ssas cube calculated member in formview from red background to white or back to default color settings. This also includes changing the text color back to default. What properties do I have to change?
Greetings, I have five rows in a group header. The top row is a true header row with details that will always be there and will always be visible. The bottom four rows have their Visibility.Hidden property set to 'TRUE'. All four of the bottom rows are assigned the same Visibility.ToggleItem. Of the four bottom rows, any or all of them may not have data at any one time. I want to find a way of allowing the rows to toggle from hidden to visible, but if one or all of the rows have a field item whose value is 0 then that row must remain invisible regardless of whether it is toggled.
I am still working on this puzzle, but if someone can provide me with an easy solution while I struggle, I would greatly appreciate it.
When the value of Downtime is greater than 0:00:10 I would like to have the background of that cell to be Red and its font bold. How to accomplish this in query?
When you set a row's hidden property to true, RS writes a white row. Is there a way to keep the background color the same is it was before the row was hidden and just not display the data?
Hi all, Is it possible with Reporting Services to create a scatter chart where the colour of the report area are dependant upon X or Y axis value? For example: can I specify that if the point values are greater than 75 then the color of those parts shall be red? and other are green as an example.
Furthermore can I get X and Y axis value of chart? also i like to know that i want add a line in scatter report based on a value which is not a Major or Minor gridline.can i do it? pls advice.Looking for your help desparately.
My current report has around 40 subreports corresponding to tests executed by the user. There is a different sub report for each of the tests executed. I first developed the report by just putting the subreports directly on the main report. The problem is if some of my tests are not executed by the user I would like the subreports to not appear in the report.
I have tried doing this two different ways. First I tried creating a table and attaching that table to a dataset that I created that returns all the tests that were executed by the user. I then set up a filter that specified that the name for a specific subreport had to equal the test name. I then dropped the sub report for that particular test into the table. The idea is there would only be one row when data is available and no rows when no data is available so the subreport would not appear. When the data is available the subreport appears great. When it is not available and there is no item in the dataset for that test I get an error from SQL that states there was an internal reporting error and to check the SQL server log for more information. I know my table is set up correctly because when I replace the subreport with text the text will appear only if data is available for that test and the text does not appear if no data is available. I get no errors until I add the subreport and remove the data from the database so the filter does not return any items. Is there a reason why I would be getting this error? I am still pretty green using reporting services so I do not even understand how to get the log from the server to determine why this error is occuring.
Secondly I have tried to use an expression to hide the subreport using the visibility tab for the report. I was able to get this to work by creating a dataset that returns 1 if a specific test has been executed and no rows if not. I then created an expression that would return true if the dataset returned 1. This worked okay in hiding my subreport but I would then have to create 40 datasets, one for each test. Is there anyway to write an expression that would return true if a dataset contained a row with a specific test name? I have not been able to figure this out.
Can someone either help me fix the problem I am having with the table approach or write an expression that would work in the visibility setting for each sub report that did not require 40 datasets? Or is there another approach that I am not even thinking of that might work?
I would like to be able to adjust the multi-value property of a parameter based on the value of another parameter in my report. The controlling paramter would be binary with two options for Single or Multiple selection. I would like my parameter to default to multi-value, which I can do on the screen selection. I have tried to add an IIF statement to the XML code, with no success. Any ideas would be helpful.
I'm trying to write an expression for the "Hidden" property of a column in a table. The column is only populated with data if the group on my table is open. If the group is collapsed, then the column is empty. I'd like to make the column hidden if the group is collapsed. So I'm thinking it would be something like this:
But I can't find anyone who has written this anywhere.
I'm basically trying to make this report do the same thing a matrix does, but the matrix doesn't let me label the columns. I put textboxes above the matrix in line with the columns, but when I deploy the report to ReportManager, the textboxes get thrown all over the place and don't line up with the columns anymore.
So I guess if you can't answer the first question, an alternate question I have is how are you supposed to label the columns (row groups) in your matrix? They don't have headers, if I try to line textboxes up with them they get all messed up during deployment. They have that textbox up there in the top left corner that runs across the top of all of the row group columns, but if I put labels separated spaces in that textbox, the spaces get removed in rendering so the text is pushed all to the left and doesn't line up anymore.
I am trying to add a case/select/if statement in the text color property of reporting services. I want it so if the value of a variable is 1 then "GREEN" else "RED". Any ideas?
I am having a problem trying to do some conditional formatting on the text color.
This textbox is in the Group Footer so i essentially want change the color to red if the SUM of one field in the group is less than the SUM of another field in the same group.
I am doing this: =Iif(Sum(Fields!YTDChargeHours)< Sum(Fields!YTDForecast), "Red", "Black")
but i am getting this error:
[rsRuntimeErrorInExpression] The Color expression for the textbox €˜YTDChargeHours€™ contains an error: Operation is not valid due to the current state of the object.
I have a table that holds notes for item's. I'm want to do a select statement where one of my columns assigns a sequential value to each row based on the item number. Would like data to look like this where doc_no would be my row_number function:
item_no seq_no note doc_no ABC 1 blah 1 ABC 2 blahh 1 ABC 3 bla3 1 XYZ 1 more n 2 XYZ 2 another 2 EFG 1 blahhh 3
When using the back color property for SSAS 2008 R2, is there a good way to match the number to the desired color? I found some color pickers online, but the numbers don't match the same colors in SSAS. How can I best determine the number needed for the color I want?
I have a field in one of my tables that has the RGB colors stored as 255,255,255 format. Is there a way to convert this to Hex color code to be used inside SSRS for a conditional color expression?
in the following procedure i want to pass in a value and as a result of the value I want to change the actual body of the query:
example, I pass in the value 'TS2' and I now want my query to see if TS2MIN < 70
i think I am doing it right, but it is throwing an error saying that "Conversion failed when converting the varchar value 'TS2MIN' to data type int."
any idea on what i am doing wrong?
ALTER proc SPU_YearlyTemp 905,'TS2',70,254,2007 @SITEID INT, @SENSOR VARCHAR(10), @MIN INT, @MAX INT, @YEAR INT
AS DECLARE @S AS VARCHAR(12) SET @S=( SELECT CASE @SENSOR WHEN 'TS1' THEN 'TS1MIN' WHEN 'TS2' THEN 'TS2MIN' WHEN 'TS3' THEN 'TS3MIN' WHEN 'TS4' THEN 'TS4MIN' WHEN 'TS5' THEN 'TS5MIN' WHEN 'TS6' THEN 'TS6MIN' WHEN 'TS7' THEN 'TS7MIN' WHEN 'TS8' THEN 'TS8MIN' END AS SENSORVALUE)
select top(10)* into #tempMin from sitecontroldataarchive where siteid = @SITEID and @S < @MIN --this is where the error occurs, SELECT * FROM #tempMin
I am generating report with my datasource to an OLAP Cube. I have scenario that there are 2 dimension tables pointing to a single fact table. According to a user input, i have to use one dimension table and not the other and vice versa. I tried using IIF statement in the MDX query designer., but was facing errors.
First of all i want to know if this is possible and if yes, how?
Also , Is it possible to open a window form on clicking any report data
(Similar to assigning hyperlink, but i want to open a window form instead!!!)
I have a BOM table with all finished item receipes and semi items recipes. create a query where semi item materials are also listed in finished item recipe.
I am having difficulty constructing a where clause. I have 4 columns in a table. Col1 is never NULL. Col2,3,4 may or may not contain NULL values. Here is the situation.
1. Col2,3,4 are NULL WHERE Col1 = condition
2. Col2 is NULL, 3 may or may not be NULL. When Col3 is NOT NULL, Col4 may or may not be NULL
where col1 and (col3(Not Null values) OR Col4(Not Null values)) = condition.
I'm creating a package that needs to go to an FTP site (FTP Task), download a file, unzip it and then process a series of table loads for the 12 text files that will be unzipped. My problem is that the zip file is a date (yyyymmdd.zip) which is normally the previous day of execution EXCEPT on Mondays when it would be the previous Friday's date. My thought is that IF (magic question) I could determine the day of the week in the SSIS package, I know that Tuesday-Friday is just a formatting exercise of getdate()-1 and Monday would be getdate()-3 but I can't seem to find a way (function?) that will allow me to determine the day of the week?
I’m working with a team of programmers who are in the process of upgrading an older ASP application to ASP.NET 2.0 (VB). The existing application connects to the SQL Server Database using different Logins, depending on the User logged into the ASP Application.
We are hoping to do the same using ASP.NET 2.0, although we haven’t been able to find a simple solution. The most feasible solution we have found includes programmatically trapping all the Selecting etc events and changing the SqlConnection at run time. This allow for ease during Designing of the Web Pages, but implementation requires adding code to each web page (>100 pages).
We are hoping there may be a simple solution which can be implemented once for the application where the event can be trapped at the application level, and the SqlConnection set at this point. Or possibly another type of solution such as creating a new class etc that can be used?
Does anyone have a simple solution where the username / password for the Database Connection can be set at run time?
Here's my problem. I have 2 tasks defined in my Control Flow tab:
EXECUTE SQL--------->EXECUTE DTS 2000 PACKAGE
When I attempt to run it, by right-clicking the EXECUTE SQL task, and selecting "Execute Task", it only runs the EXECUTE SQL part (successfully), and does not "kick off" the EXECUTE DTS 2000 PACKAGE, after it is done running (even though it completes successfully, as shown by the green box).
Yes, they are connected by a dark green arrow, as indicated in my diagram above.
Why is this?? Am I missing something here? Need help.
Hello,Basically, I have a table with 2 fieldsId item#1 33332 33333 22224 22225 22226 33337 33338 3333I would like to only select the last identical Item# which in this case would be the id 6,7 and 8Any idea how could I do that?Thanks
Hi, i was checking books online and run into the sp_OAxxxx stored procs that can give us access to a OLE Object. I am currently developing a VB.Net app that uses a word template to create word documents. So, for example ,i we suppose that the template is : -----Template start ------- This document was created by <!_author_> on <!_date_> -----Template end -------- then, the created document would be : -----Created doc start ------- This document was created by justsarter on 09/13/2007 -----Created doc end --------
All the data are fetched from a database and i have to make muptiple calls to it ,not to mention opening and closing word.application object.
I wonder if that kind of text manipulation in the document can be performed on the server using an SP Thx theodore
Is it possible in SSRS to change the appearance of a Hyperlink based on a MouseOver event? For example can I show the text as say, underlined, only when the Mouse pointer hovers over it.. and normal otherwise?
Hi - I am changing a field from type nvarchar to type text, given thatI need to store strings longer than 255 characters. To do this Ichange the data type in SQL Server, then I change the parameter code inthe calling procedure, as per below:cmd.Parameters.Append(cmd.CreateParameter("@title", adVarWChar,adParamInput, 255, title));becomes:cmd.Parameters.Append(cmd.CreateParameter("@title", adLongVarWChar,adParamInput, 1073741823, title));However, when I do this, for some reason, the field is still limited to255 characters - when I try to update the field with 256 characters,the error 'Application uses a value of the wrong type for the currentoperation.' occurs.Why is this? I've checked that the correct data is contained in theparameter. When I look at the data in the database, the column inquestion shows the content, whereas the next column, which has alwaysbeen of type text, shows '<LongText>' - does this mean anything? Do Ineed to do something special to convert the column from nvarchar totext?Many thanks,Iain
I have an HTMP form and for some reason, when I use a regular TextBox to display a field, Via an ASP conneciton to the database, it cuts it off when it gets to a " (A quote)
Example:
Field: Title Data: Where do "rabbits" come from?
If I try to pull that field into a regular html textbox it dispays,
Where do
Then if I change the textbox to a textarea it displays the entire field
Where do "rabbits" come from?
Is this a setting that causes this in SQL Server on the table.
I am new to SQL Server and am trying to learn these little differences.
