I am using ssrs 2005 .My text field contains the following data As follow : Database is as:i am getting value as :Total Population (in 1000s)but in ssrs it is displaying as like this : (Total Population (in 1000sBut i want as like in Database.Please let me know what is to be done at the earliest
View 2 Replies
How can I remove the inherited properties?
View 2 RepliesI use SSRS to generate an XML file using XSLT. All is fine, except that the XML file starts with the letters 'EF BB BF' which I need to get rid of. How do I generate an XML file without it?
View 3 RepliesIt is possible to remove unused legends from chart.
For Example.
in below chart Pen-$ and Book-Rs is unused . How to hide these ones.
I need to be able to add and remove columns dynamically depending on the results of the datasource (stored proc).
View 15 RepliesI am currently working on an invoice report which may or may not span across multiple pages. I have a header which I have setup to only be displayed on the first page, and a footer which I have setup to only be displayed on the last page. The problem is, the hidden header/footer reserves unwanted whitespace and messes up the report layout (see the screenshot). The black areas represent space that is reserved by the header/footer. There must be a simple way to remove this unwanted space.
View 2 RepliesI got below code from [URL] aspx for adding custom property in webpart tool pane. What does square bracket ([]) mean in the below code?
[Category("Custom Properties")]
[WebPartStorage(Storage.Personal)]
[FriendlyNameAttribute("Custom Color")]
[Description("Select a color from the dropdown list.")]
[Browsable(true)]
[XmlElement(typeof(System.Drawing.KnownColor))]
public System.Drawing.KnownColor MyColor
{
get
{
return _myColor;
}
set
{
_myColor = value;
}
}
I have two text boxes that are for collecting a users alias and password.
<asp:TextBox CssClass="alias-login" ID="txtAlias" runat="server" BorderStyle="None">ALIAS</asp:TextBox>
When the page is loaded the initial text in the text box will read "ALIAS". And when the user clicks into this text box, I want the text to dissapear. Does anyone know how I can achive this?
I am having a table in rdlc that displays the data from a dataset. My problem is the value of one of the fields is long contineous string because of which my report is getting expanded horizontally. i want to wrap the text in this field so that it occupies fixed width of column & gets wrapped. I cant manipulate the text as i have to export the report to PDF.
View 3 RepliesI have a field that may or may not contain comma.
if the field contain some word and separated by comma
how can i remove specific word in the field.
e.g. the field contain --> 11,12,13
how can i remove the number 12 and remain 11,13 in the field?
suppose I am having sample table like below.
I need to remove duplicate orderid's and i need all column names also while doing query.
note that rows are not in the order. Order will be like this only.
I am able to get the records which are duplicated but not able to delete further.
In this case how to delete?
My consideration is that only distinct orderid's should be there in the table. Not bothering about the which orderid row is being deleted.
name orderid destination
a 1 aaa
d 2 ddd
b 1 bbb
f 3 fff
e 2 eee
g 4 ggg
h 3 hhh
c 1 ccc
I am asked to save and output a tournament bracket, like NCAA or US Open, two parties play and the winner move on to next round. To display the whole bracket, I need to find a way to maintain the hierarchy, say I have the following class:
[Code]....
This is good for a single contest inside the tournament, but how do I change the class or use other classes to support hierarchy? Also if possible can someone show me the best way to model this in SQL server tables?
I need an algorithm to determine who match who in the tournament bracket, say I have 32 ( number could be flexible) contestants seeded 1 to 32, at round 1, seed 1 matches with 32, seed 2 with 31 and so forth. What about 2nd, 3rd, 4th and 5th round? I need an algorithm to be programmed into computer.
View 3 Repliesis there a way in crystal report to remove blank space between two data field for example
Field 1 Field 2
how do i make it the distance between Field 1 and Field 2 become closer and look like this
Field 1 Field 2
without changing the position of the Field 2 in the report design... i need this cause the data in Field 1 is different for each user and i need the Field 2 to have a smaller font size than the Field 2 so i cant use formula since formula only allow 1 font size.
On our webform, I do I remove the vertical lines parallel to each field column?
Visit the webform at [URL]
View snippet code, below:
[Code]....
I have in my database the News Table which consist of => Id, Title, txt . I need to be able to get a description text from the whole text which exist in txt Field , but without any codes like <...> , just a pure text !! how can I do this?
View 3 RepliesI have a gridview that calculate net balance by taking deposit - withdraw. So when the withdraw is more than the deposit, it will result in a negative value, how do I detect that and replace the minus sign with bracket?
[code]....
I have an excel header that has the following header title : "REMARKS (i.e. awarded etc.)"
but it seems that it can't read the cell with the brackets or it is there is a certain length of the excel header?
While reader.Read()
Dim DataRow As DataRow = dtDataTable.NewRow()
DataRow("Remarks") = Trim(reader("REMARKS i.e. awarded etc.").ToString)
dtDataTable.Rows.Add(DataRow)
End While
how to show plain text in password field and then make it regular password field on focus
View 3 RepliesI have an old database that still contains depreciated Text fields. I need to pull from these fields and display the results. You would think this should be easy... First my select statement caused a problem:
Code:
SELECT DISTINCT ..., CustomerInstructions, ... FROM Orders
where CustomerInstructions is a Text field.
The error I get: "The text data type cannot be selected as DISTINCT because it is not comparable." A quick search shows I can cast the text field as a varchar(max).
Code:
SELECT DISTINCT ..., CAST(CustomerInstructions AS VARCHAR(MAX)), ... FROM Orders
Now I get an error while trying to load the instructions into a text box: "Specified argument was out of the range of valid values. Parameter name: index"
Not sure what the problem is here. I have text and a text box. What's with the "out of range" crap?
I dont know if this is possible or not, but I have a column that I need to remove a bunch of exponent superscript references from a html field (and leave the rest). Does anyone know how to do this with SQL?
View 9 Repliesi have a textbox showing -450 as output but i want it displays out put as 450 by removing - from 450 ....
View 1 Repliesi've written the code in expression field...
=format(sum(fields!salary.value),"##,##,##,##,##,##,##0.00")
the code is for printing the number in this format(12,23,23,34,123.00)
now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas
are printed.. i dont want to print the extra commas.. how the word length is there that much it
should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...
i've tried by removing some of the #'s but it is for fixed number..
writting the following Field Expression in SSRS
View 2 RepliesI have a ReportViewer control on my aspx page that displays a report defined in an rdlc file. The rdlc has a textbox on a table control that displays the number of rows on the report.
I am looking for a way to retrieve the value of this textbox in my code-behind.
