I've a tablix with alot of rows. I use =Fields!LedningLaengde.Value to set the value in the cell, that's on a row in the Tablix..The new thing, is that the font need to be red if =Fields!LedningLaengde.Value is equal to -1 how can this be done?
View 1 RepliesI have an error ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. and I've been trying to solve this but unfortunately I couldn't get the hack of this error. I'm a newbie in dotNet.
Public Sub LogInContinue(ByVal senter As Object, ByVal e As EventArgs)
Dim LibDS As DataSet = New DataSet
Dim LibDA As OdbcDataAdapter = New OdbcDataAdapter("SELECT * FROM tblUserAccount WHERE Uname='" & txtUserName.Text & "'", LibConn)
[code]......
I am attempting to copy the value of the TimeStamp in cell A6 which has the NOW() formula into cell A5 Based on a change in Cell A4. The catch is I don't want it to update every time the sheet is recalculated due to updating links in other cells on the sheet. ONLY when Cell A4 Changes. What do I do?
View 2 Replieshow to create a report in VB .net 2008 using microsoft report viewer?
View 2 RepliesThese things look about the same to me. Is there any reason I should use one over the other?
View 5 RepliesHow do you change the colour of the labels(not sure what the correct name is) in a Microsoft Chart Control in VB.
By "labels" I mean the text that is overlaid on every column in a StackedColumn chart.
You can change the Axis labels with the following:
<AxisY LineColor="Red">
<LabelStyle ForeColor="Red" />
</AxisY>
[Code].....
What is the equivalent to target the labels?
I am looking for a regular expression that can convert my font tags (only with size and colour attributes) into span tags with the relevant inline css. This will be done in VB.NET if that helps at all.I also need a regular expression to go the other way as well.To elaborate below is an example of the conversion I am looking for:
<font size="10">some text</font>
To then become:
<span style="font-size:10px;">some text</span>
So converting the tag and putting a "px" at the end of whatever the font size is (I don't need to change/convert the font size, just stick px at the end).The regular expression needs to cope with a font tag that only has a size attribute, only a color attribute, or both:
<font size="10">some text</font>
<font color="#000000">some text</font>
[code]....
I also need another regular expression to do the opposite conversion. So for example:
<span style="font-size:10px;">some text</span>
Will become:
<font size="10">some text</font>
As before converting the tag but this time removing the "px", I don't need to worry about changing the font size.Again this will also need to cope with the size styling, font styling, and a combination of both:
<span style="font-size:10px;">some text</span>
<span style="color:#000000;">some text</span>
[code]....
I am extracting basic HTML & text from CDATA tags in an XML file and then displaying them on a web-page.The text also appears in a rich-text editor so it can be edited/translated, and then saved back into a new XML file. The XML is then going to be read by a flash file, hence the need to use old-fashioned HTML.
The reason I want to convert this code is mainly for display purposes. In order to show the text sizes correctly and for it to work with my rich text editor they need to be converted to XHTML/inline CSS. The rich text editor will also generate XHTML/inline CSS that I need to convert 'back' to standard HTML before it is saved in the XML file.I know the temptation will be to tell me a number of different ways to set up my code to do what I want but there are so many other permutations I haven't even mentioned which have forced me down this route, so literally all I want to do is convert a string containing standard HTML to XHTML/inline CSS, and then the same but the other way round.
I'm converting af Crystal report to a MS report.My expression in the Crystal report was like this[code]...
View 3 RepliesI have a VB.Net application with a datagridview consisting of several columns. I would like to be able to increase/decrease the cell font size when the user resizes the cell so that the value fills the cell. I do not see a property that would do this and wonder if there is one or if there is some algorithm by which the appropriate font size can be calculated based on character count and cell width.
View 2 RepliesSimple question and hoping for simple answer :)
Here is the code:=First(Fields!Asiakas1.Value, "DataSet1") & vbCrLf & First(Fields!Asiakas2.Value, "DataSet1") & vbCrLf & First(Fields!Asiakas3.Value, "DataSet1")
how do i make First(Fields!Asiakas1.Value, "DataSet1") Bold?
i am planing to use Microsoft report for my project. i have used crystal reports but never used Microsoft report before.how to create reports using Microsoft report in vb.net 2008. if i change the location of my database do i have to change the database location for each and every Microsoft report i created?
View 2 RepliesI'm making a user control, and I manually draw the text string, but I can't seem to keep it centered. I need it to stay centered no matter what the font, or string length.
View 1 RepliesConsider this SSRS value expression :=IIF(First(Fields!MyCol.Value, "MyDataSet")=0, "yes", "no")
MyCol is a Nullable column. I want "yes" to be output only when MyCol equals 0. The code above correctly evaluates to "yes" when MyCol is 0. However, it also evaluates to "yes" when MyCol is Nothing (i.e. NULL in SQL Server). Is this expected behavior ?
I had to resort to the following longer expression to get the desired result :
=IIF(Not(First(Fields!MyCol.Value, "MyDataSet") is Nothing) And First(Fields!MyCol.Value, "MyDataSet")=0, "yes", "no")Is there a shorter version of this which also works ?
I have the following SQL Expression Field in my Crystal Report 11.5
{fn CONCAT({fn CONCAT("SPR_PRODUCT"."PRODUCT_ID","SPR_PRODUCT_SUB_ITEM"."P_SUB_ITEM_ID" )},{fn CONCAT("SPR_PRODUCT_ITEM"."P_ITEM_ID","SPR_PRODUCT_GROUP"."P_GROUP_ID" )} )}
It works well in the Preview Mode. But when I use the report in my VB.NET 2008 Project it says the following:
[Code]...
I downloaded one type of free code 3 of 9 font but the barcode scanner doesn't read it and the other fonts that I downloaded are not compatible to the crystal report and it says "True Fonts only"(not exact but just like that)
View 4 RepliesI am using a server report, which I am rendering in VB.net using reportviewer.serverreport.render into a PDF document.Strangely, when i do this the text in my graphs is really small compared to in the designer or when I view the report in a web browser.
View 1 RepliesI have created a custom column type for a datagridview. I have created a class for the datagridviewcolumn and a class for the datagridviewcell. Within the datagridcell class I am using the following code for the font.Dim fnt As Font = parent.InheritedStyle.Font How do I change this so that I have control over the font color for that cell? I am fine with the font just not the color.
View 1 RepliesI am filling a DataGridView from a table in SQL Server 2008. There is one column that is a string which contains either "YES" or "NO".When I run and display the DataGridView it displays perfectly. For the User's benefiy, if the field contains "NO" I want to put some emphasis on it by changing the fore color and back coler of the entire row. In the DGV the index for field is (4).I tried this code which threw an error on the word "value" inthe block that fills the DGV.
IF DGV,Columns(4),Value="NO"....
I added a parameter to the rdlc called paramTitleThen I tried this as a demo
Code:
Dim params(0) As Microsoft.Reporting.WinForms.ReportParameter
[code]....
can tell me description or demo in working with microsoft report in in dotnet 2010 ie.. framwork 4.0,iam good in 3.5 framwork microsoft reports, but when i am doing microsoft reports in dotnet 2010 iam getting many errors, can u tell me how to do , is anything new in this or same as 3.5
View 2 RepliesEvery week I generate a CSV report that adds an extra space to the beginning of my date column. Because of the extra space, Excel recognizes the date as text and will not format the information as a date. I have tried the Right() function but once Excel recognizes the date as text, it will not convert to a date. Can I programmatically address this issue in VBA and how?
View 1 RepliesI have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error.
View 8 RepliesI'm looking for help resizing a label's size and its font size based on its window size.That's to say when a window resizes, the label itself adjusts it font and background box to do the same.I know I'm triggering something on the Resize event of the form, but I don't know what.
View 2 RepliesDoes Visual Basic 2010 have any reporting services, ie, Microsoft Report viewer?
View 6 RepliesI'm building an asp.net web application using Microsoft report viewer. It connects to a SQL database using integrated security. However when I first load the report page after it has been published to the server (everything works fine locally), I get this error:
An error has occurred during report processing. Exception has been thrown by the target of an invocation. Login failed for user 'SERVER NAME REMOVED'.
The weird thing is that when I click the refresh button on the report (not IE's refresh button), it loads just fine. I know that login will not work for the database server, but why is the report viewer not using the integrated security I set in the web.config?
i'm using a microsoft access 2007. i've designed a report and i add a print button inside the report. when i click on the button, the report will queue in the microsoft office onenote. how can i make it to print out directly without queue in the onenote?
View 2 RepliesI want to use microsoft word in vb 2008 to print the report. I code it but i will do some other task but i do not know how? The code as follows
Dim objWordApp As Object
Dim objWordDoc As Object
objWordApp = CreateObject("Word.Application")
[Code]....
i am new in vb.net i am designing small application and i am adding reports to it.problem is that 1) in header i text at end of text i need to add zone number from database. like: This is header text " zone number"
zone number after header text from database or from a variable
Quick RegExp problem (i hope). I need to identify a sub string from any string based on a regular expression. For Example, take the following strings:
[Code]...
i am getting a syntax error at drr(5) which 5 is the column i want to base the color change on. this method works when i am using a dataset
Dim Land As String = "Land"
Dim Air As String = "Air"
Dim Cruise As String = "Cruise"
[Code].....