Garbled Text In TextBoxes Containing VbCrLf When Exported To PDF

Apr 17, 2008

Hi

I am using SSRS 2005 on a development server. The access is over https.
Whenever a TextBox of a report contains a vbCrLf and this report is
exported to PDF this text is garbled. Text not containing CR LF is ok.

The text is still latin characters but has nothing to do with the text intended to show.
Character spacing is broken. Sometimes more than one character are rendered
over each other.

I do not have the same problem on a production SSRS box.

The only difference is that the development box has .NET framework 3.5 installed
and production is still on 2.0

Is this a known issue?
Maybe there is already a patch?

orbit

View 4 Replies


ADVERTISEMENT

Text Garbled In Exported PDF(in Vista )

Mar 20, 2008

My environment is
Windows 2003 Server(japanese)+SP2 and SQL Server 2005(English)+SP2



I've been having a problem with Reporting Service.When i export report
to PDF file,the text(mixed japanese and english)gets all garbled and
unreadable in Vista OS.but in windows xp every things is well.i tried
upgrade adobe reader to the recently version ,but there is no help.



this is a known bug?or i missed something?



any ideas



Thanks

View 6 Replies View Related

Export To A Text File, Then Name The Exported File The Date Is Was Exported, Then Zip

Jul 3, 2007



Hi folks



Any help on my request would greatly be appreciated. We are trying to maintain the growth of a particular table, by exporting and deleting data that is older then 90 days. Here are the 4 steps I need to do. I believe I know how to do 1 and 4;

1. Create a job that continously exports data that is older then 90 days to a text file

select *

from table A

WHERE (CREATED < DATEADD(DAY, - 90, GETDATE()))



(the column 'created' datatype is datetime and looks like this '3/5/2007 3:11:44 PM')



2. Have the job automatically name the exported file, the day it was exported (i.e. 07032007 (todays date))

3. Then zip that file (we're using 7-zip)

4. Then delete the data out of the table

delete

from table A

WHERE (CREATED < DATEADD(DAY, - 90, GETDATE()))



Im not a big scripter/coder, so I was wondering if there is anything I could do in SSIS. Im more familiar with DTS, so any kind of baby steps you could provide in SSIS, would go a long way.



Thank you so much.

View 1 Replies View Related

INSERT Using Text From Different Textboxes And Trying To Get It Into SQL Database (NOT WORKING)

Mar 27, 2004

If anyone has examples of pulling the text out of textboxes and passing it to a INSERT statement which then puts the data into a SQL database table please if you could pass this on that would be great.

Regards and thanks in advance.

Ryan J. Boyle

View 1 Replies View Related

Problem Selecting Text In PDFs Exported From RS 2005

May 1, 2008



I have recently converted reports from Crystal Reports 10 to RS 2005. These reports are run daily via a SQL job and exported to PDF files, where users are able to view them.

A user pointed out to me that in the PDF's exported from Crystal Reports, they could select text, starting with the first row of data, and highlight each row by dragging the Adobe Selection tool down the page, row by row.

Now, with the PDF's exported from RS, when you try using the selection tool to highlight each row by dragging down the page, it appears to randomly highlight rows in no particular order.

Anyone know what the problem might be?

View 1 Replies View Related

Reporting Services :: Report Exported To Excel - In Print Preview Footer Text Box Data Truncated

May 6, 2015

I am exporting SSRS report to Excel I am aware that excel doesn't show footer , It shows in print preview but my footer has text box which have text disclaimer more than 255 characters, the data getting truncated.

View 3 Replies View Related

Export To PDF Loses VbCRLF Formatting

Jul 6, 2007

Hi



I've simplified this so I can test it's not me and so it's easier to explain.



I have one table in SQL server called Table1. Five fields called: One, Two, Three, Four, Five. Values of NULL, 2, 3, 4, NULL.



Reporting services, put a table in a report. Two fields. Header of Field1 and Field2.



Value field data for Field1 ="One: " & vbcrlf & "Two: " & vbcrlf & "Three: " & vbcrlf & "Four: " & vbcrlf & "Five: "



Value field data for Field2 =Fields!One.Value & vbcrlf & Fields!Two.Value & vbcrlf & Fields!Three.Value & vbcrlf & Fields!Four.Value & vbcrlf & Fields!Five.Value



Preview the report, all is well, you get this:

Field1 Field2
One:
Two: 2
Three: 3
Four: 4
Five:



Export it to a PDF, all is not well, I get this:
Field1 Field2
One: 2
Two: 3
Three: 4
Four:
Five:

I can make it work by checking the NULL fields and replacing them with a character. But why does it ignore the vbCRLF when exported to a PDF?

Any ideas...

View 4 Replies View Related

How Can I Remove The Line Feed/carriage Return In The Last Line Of The Exported Text File ?

Feb 27, 2007

Hi,
for some AP issue, the file I upload must be without the line feed/carriage return in the last line.
for example:

original fixed-length file (exported from SSIS)
line NO DATA
1 AA123456 50 60
2 BB123456 30 40
3 CC123456 80 90
4 <-- with line feed/carriage return in the last line

The file format that AP request. The file only has 3 records, so it should end in the third line.
line NO DATA
1 AA123456 50 60
2 BB123456 30 40
3 CC123456 80 90

Should I use script component to do it ? I am new for VB . Anyone would help me ?

Thank you all.

View 1 Replies View Related

Storing A Carriage Return Or VbCrLf In An NVARCHAR Column

Sep 7, 2007

Is it possible to store a carriage return value or VbCrLf in an NVARCHAR column ?

I need to display a textbox in Reporting Services using one row, but showing multiple lines as a result of a few carriage returns.

View 3 Replies View Related

Parameter Name Getting Garbled

Sep 3, 2004

I have a function that calls a sproc, and passes in a bunch of parameters. One of the parameters is named @ProcessorEmail. Occasionally, the parameter name apparently gets garbled at runtime, as the following error occurs:

System.Data.SqlClient.SqlException: @ProcessorEm??. is not a parameter for procedure gUser

The "@ProcessorEm" part is always fine, then there will be various characters in place of the "ail" part.

Any ideas?

View 10 Replies View Related

Chinese Garbled In MSSQL2000 - By ASP

Jan 31, 2007

Hi experts,

Here I got some problems with my application. (ASP & English Version SQL Server 2000)

As we are using English MSSQL Server 2000, we got some new functions and we have to facilitate support of Chinese characters in the DB. I have set the collation for those Chinese fields already and those queries or Stored Procs for Chinese are working fine, ONLY if I execute them in Enterprise Manager. Chinese characters can be displayed in the relevant tables.

However here comes the big problem and I got really frustrated. As we will provide user interface in ASP pages, we 'll let users to insert the information which will be sent to the DB. If there's Chinese characters in the query string, the Chinese characters added in the DB would be garbled.

e.g. EXECUTE proc_TestChinese 'XYZ', 'test123' (assume XYZ be those Chinese words)

I am wondering if there's any way I can solve this problem. Should I add special handling for these Chinese words? I have set the ASP pages in UTF-8 or Big5 encoding but it doesn't help. Hope you experts can show me the way out of the mess. Thanks in advance!

Manfred



View 4 Replies View Related

Integration Services :: Chinese Names Export To CSV - Garbled Names

Aug 11, 2015

As part if a recent requirement I have to export Chinese/Singaporean names in a CSV file. The data in the tables is a NVARCHAR(256).

I am using a FlatFile Connection manager where all the present columns from the table are exported as NVARCHARs. My understanding was that the Chinese/Singaporean names would blend seamlessly with NVARCHARs in place. But, they get garbled when pushed to the CSV.

Here is the connection manager setup

There are a lot of suggestions of fixing this by copying/pasting to a notepad file and changing the formatting... But I cant do that since the file is generated using a schedules SSIS package. How can I tweak the process to fix the issue?

View 4 Replies View Related

Grid And Textboxes

Jun 17, 2007

hi, 
now theres something i want to achieve but, again dont know how :-(
In a grid of my site  it needs to be able to select an item, ( not with  checkboxes) but maybe when you click on the item in the FromName column then
the data in the column in my database messageTEXT needs to be able to show in a textbox.( textbox is outside of grid)
now i was thinking that maybe it is need to be done with datareaders or something?
Greetz
Roy

View 5 Replies View Related

Hide Textboxes

Feb 25, 2007

Hello Everyone. I need help again.
I have a reports made in VS business intelligence project with a lot of parameters. So it means it automatically creates textboxes of that parameters. I want to hide those textboxes. Pls help.

Thanks
-Ron-

View 3 Replies View Related

Paragrahs In Textboxes

Apr 2, 2007

Hi,



Can anyone advise me how to force paragraph breaks in a textbox in Reporting Services 2000? I've tried Shift + Enter and in layout view it forces a paragraph break, but as soon as the report is rendered, the breaks disappear.



Thanks.

View 5 Replies View Related

Referencing Textboxes

Feb 7, 2008

Is there a way to reference textboxes in an SSRS table like one would for cells in Excel? For example, something like =textbox1/textbox2? I am trying to replace a spreadsheet by turning it into an automated report and need to do some horizontal formulas and when I put in the grouped total, it always defaults to averaging percetages from the rows above, which isnt a true summary in my case.

View 11 Replies View Related

Update Database With Textboxes

Aug 22, 2007

Hi
 I'm new to all of this. I have a database that holds customer information (fictitious) and i can select that data and display it in a set of textboxes. I also have an SQL command "UPDATE" that is designed to update the text field that i want to edit. However the problem i'm having is that it'll let me write the info in the textbox but as soon as i click my update button it just flashses and goes back to what it says before
 e.g. FIRST NAME: LEE      i enter TOM and then it reverts it back to LEE
  1
2 Partial Class Update
3 Inherits System.Web.UI.Page
4
5 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
6 custIDTextBox.Text = Session("Label2")
7
8 Dim updatepage As System.Data.DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
9
10 For Each update As Data.DataRow In updatepage.Table.Rows
11
12 firstnameTextbox.Text = update.Item("First Name").ToString
13 lastnameTextBox.Text = update.Item("Last Name").ToString
14 addressTextBox.Text = update.Item("Address Line 1").ToString
15 townTextBox.Text = update.Item("Town").ToString
16 postcodeTextBox.Text = update.Item("Postcode").ToString
17 telephoneTextBox.Text = update.Item("Tel Number").ToString
18
19 Next
20
21 End Sub
22
23 Protected Sub updatebutton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles updatebutton.Click
24
25 'Dim parameters firstnameTextBox, lastnameTextBox, addressTextBox, townTextBox, postcodeTextBox, telephoneTextBox
26 'Dim UpdateParameters As QueryStringParameter
27
28 SqlDataSource1.Update()
29 SqlDataSource1.UpdateParameters.Add("@CustomerDetails", System.TypeCode.String)
30 'SqlDataSource1.UpdateParameters.Add("@Last Name", System.TypeCode.String)
31 'SqlDataSource1.UpdateParameters.Add("@Address line 1", System.TypeCode.String)
32 'SqlDataSource1.UpdateParameters.Add("@Town", System.TypeCode.String)
33 'SqlDataSource1.UpdateParameters.Add("@Postcode", System.TypeCode.String)
34 'SqlDataSource1.UpdateParameters.Add("@Tel Number", System.TypeCode.String)
35
36 'Label2.Text = ("Update successful")
37 End Sub
38 End Class
39

This is my SQL UPDATE command statement:
UPDATE CustomerDetails SET [First Name] = @firstnameTextBox, [Last Name] = @lastnameTextBox, [Address line 1] = @addressTextBox, Town = @townTextBox, Postcode = '@postcodeTextBox', [Tel Number] = '@telephoneTextBox' 
 
 

View 2 Replies View Related

Whitespace In Textboxes. How Do I Insert A Tab?

Feb 6, 2007

So...I'm trying to insert a tab (or just a few spaces) at the beginning of a line in a textbox. Is this possible? If so, what do i have to do?

View 1 Replies View Related

How To Count The Number Of Textboxes

Feb 5, 2007

Hi all,
 
In the report I am working on, I have a "textbox39" in a table which has groups. I want to have another "textbox29" outside the table to count the number of "textbox39"s that are actually displayed and also the number of "textbox1"s that have a certain value (e.g. "1") in the final report. I tried to use "Sum(ReportItems!textbox39.Value)" but the compiler complains
 
Error 1 [rsAggregateReportItemInBody] The Value expression for the textbox 'textbox29' uses an aggregate function on a report item.  Aggregate functions can be used only on report items contained in page headers and footers. d:perfperfreportingprojectPerformanceTestDetails v.3.rdl 0 0 

 
Error 7 [rsReportItemReference] The Value expression for the textbox €˜textbox29€™ refers to the report item €˜textbox39€™.  Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope. d:perfperfreportingprojectPerformanceTestDetails v.3.rdl 0 0 
 
Anybody has any idea how to solve it?
Thanks so much,
Zhiyan

View 2 Replies View Related

Displaying Data From Database In Textboxes

Jan 29, 2008

Im trying to display data from a database based on an input value. The value in the Label12.Text which is("hotmail") is the input value thats stored in the database, this value is been searched for in the strSQL.
 Dim strSQL As String = "SELECT Name FROM Jobseeker WHERE Email='" & Label12.Text & "' "
strSQL = Label5.Text
 
the code builds successfully, but Label5.Text appears blank.
 
 

View 2 Replies View Related

How Do I Populate Textboxes In A Form With A Dataset?

Aug 10, 2004

I have successfully built a form page to enter customer info into sqlserver
2000. I would now like to be able to pull up the customer info and edit it in a Windows form
format rather than a datagrid or datalist. Dell computer is doing what I want to do on there customer checkout page.

I have been looking for examples of
VB code to do this with no luck.

Here is the dataset I use to display customrer info,with my feeble attempt to convert it to a form that populates from the database. (The datalist works fine.) Can someone get me started or send me to
good code examples please?

<%@ Page Language="VB" Debug="true" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
sub Page_Load(Sender as Object, e as EventArgs)
Dim objConn As SqlConnection = New SqlConnection("Data Source=localhost;" & _
"Integrated Security=true;UID=Newlogin;PWD=cool147;Initial Catalog=PLF")
dim objCmd as SqlDataAdapter = new SqlDataAdapter _
("select * from Customers where CustomerID like 28", objConn)
dim ds as dataset = new Dataset()
objCmd.Fill(ds, "Customers")

firstname.datasource=ds.tables(0).defaultview

'select data view and bind to server control
'MyDataList.DataSource = ds.Tables("Customers"). _
'DefaultView
'MyDataList.Databind()
objConn.close()
end sub
</Script>



<html>
<head>
</head>
<body>
<link REL="stylesheet" HREF="css/maincss.css" TYPE="text/css">
<form runat="server

<asp:TextBox size="12" id="FirstName" runat="server" Font-Size="10pt" Font-Name="tahoma" />
&nbsp;
<asp:RequiredFieldValidator ControlToValidate="FirstName" Display="dynamic" Font-Name="verdana" Font-Size="9pt" ErrorMessage="'Firstname' must not be left blank." runat="server"></asp:RequiredFieldValidator
</Form>

</body>
</html>

View 1 Replies View Related

Pulling 2 Values From 2 Textboxes Displayed In A Third

Jul 20, 2005

I have a problem trying to get a value from textbox 1 and textbox 2.If those two values match the data in the database then it has toreturn a third corresponding value to a third textbox (or label) aftera user clicks a submit button. Basically, I am trying to allow usersto enter a value of weight in pounds in textbox 1 and a zip code intextbox 2 then pulling the shipping amount from a courier's databaseand returning that dollar amount to a third textbox or label afterthey click submit. How would I write this code in vb.NET?Thanks,TG

View 1 Replies View Related

Blank Space When Hiding Textboxes

Jan 20, 2008

Hello,

Ik have a problem with the free space if I'am hiding textboxes.

I put 2 textboxes in a rectangle and when I hide the rectangle then the textboxes are gone but the space that the rectangle needed is now blank.
Can I suppress the blank space?

Mvg,

Hans

View 3 Replies View Related

Using A Textbox's Value For Format Expression Of Other Textboxes

May 3, 2007

I'm calculating the format string for currency values based upon what's selected as a report currency parameter value. Just to mention, it's a call to a .net dll. Because this call is in every textbox in the details section of the report,I believe it's getting called for every textbox that is displayed on the report - but I really don't need to calculate it at this level. The format string will only be one way per report execution.



Is it possible to only call this function once, stuff the format expression in a textbox (or some method that's similar) and then reference that ReportItems!textbox3.Value for the format string of other textboxes? I threw the calculation in a textbox in the report header and also body, but I get an issue either way:



Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope



I understand that it doesn't seem possible, but can anyone help me think out of the box? I see that a database call and another dataset holding the FormatString might work... I'll try this out, but in the meantime, is there a solution to not do this?

View 3 Replies View Related

Overlay Of Textboxes Are Not Rendering Properly

Sep 12, 2006

In the page header I have a rectangle that has 2 textboxes on the same line and both are the full length of the page. One textbox has text centered and the other has text right justified. When I render report in Studio or print it, the text appears on the same line and justified like I want, but when the report is rendered when I call the report by URL, the textboxes wrap, like it's taking the width of each textbox in account. Has anyone seen this? Any suggestions on how to overlay text on the same line and the text keep their own individual characteristics?

View 5 Replies View Related

How Can I Split The Rows In 2 Textboxes - Urgent

Feb 20, 2007

Hi,

I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right.

I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box.

I am going kinda nuts over this. Can someone please help me.

Regards

Karen

View 15 Replies View Related

Placing Textboxes In Headers Of Reports

Jan 4, 2008

Hi,

After exporting the report the column headers in the rreport should not scroll, it has to fix with report headers. If i move the column headers to report header the columns are merging in excel, some columns are hiding.

For ex: I have 10 columns, it has to take from A to K but it is taking A to P. one column is occupying two columns. how to avoid this merging and how to place the column headers in the report header.

Thanks
Dinesh

View 4 Replies View Related

Ca't Insert Textboxes Values Into A Database Table

Oct 9, 2007

Hello, my problem is that I have 2 textboxes and when the user writes somthing and clicks the submit button I want these values to be stored in a database table. I am using the following code but nothing seems to hapen. Do I have a problem with the Query (Insert)??? Or do I miss something else. Please respond as I can't find this.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Manufacturer2.aspx.cs" Inherits="Manufacturer2" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Name"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<asp:Label ID="Label2" runat="server" Text="Password"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click" />&nbsp;
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="INSERT INTO Manufacturer(Name, Password) VALUES (@TextBox1, @TextBox2)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="TextBox1" PropertyName="Text" />
<asp:ControlParameter ControlID="TextBox2" Name="TextBox2" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
 
</div></form>
</body></html>
 
 

View 10 Replies View Related

Selecting And Placing Values From Sql Query Into Textboxes

Jan 9, 2008

Hi. I have an sql query that i use to insert articles to a sql databse table and for that i use addWithValue to select witch textboxes etc goes where in the database.
Now i need to retrive these values and place them back into some other textboxes (some of them multiline) ,and i wonder if there are any similar ways to retrive values like AddWithparameter so i can easily do textBox.text = //whatever goes here ?

View 4 Replies View Related

Using Textboxes And Dropdownboxes To Update Database Table

Apr 24, 2008

ASP 3.5 VB: Visual Studio 2008, 2005 Developer Server
I'm new to web development so my question may seem basic. I created a stored procedure:CREATE PROCEDURE [dbo].[CaseDataInsert]
@ReportType varchar(50),
@CreatedBy varchar(50),
@OpenDate smalldatetime,
@Territory varchar(10),
@Region varchar(10),
@StoreNumber varchar(10),
@StoreAddress varchar(200),
@TiplineID varchar(50),
@Status varchar(50),
@CaseType varchar(200),
@Offense varchar(200)
 
AS
BEGININSERT CaseData(ReportType, CreatedBy,OpenDate,Territory,Region,StoreNumber,StoreAddress,TiplineID,
Status,CaseType,Offense)
VALUES(@ReportType,@CreatedBy,@OpenDate,@Territory,@Region,@StoreNumber,@StoreAddress,@TiplineID,
@Status,@CaseType,@Offense)
END
 
I created textboxes and dropdownboxes on my asp page, and with a button put the following code behind it:Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim cs As String = "Data Source=localhost;Initial Catalog=Database1.mdf;Integrated Security=True;"Using con As New System.Data.SqlClient.SqlConnection(cs)
con.Open()Dim cmd As New System.Data.SqlClient.SqlCommand
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "CaseDataInsert"cmd.Parameters.AddWithValue("@ReportType", DropDownList1.SelectedItem)
cmd.Parameters.AddWithValue("@CreatedBy", DropDownList2.SelectedItem)cmd.Parameters.AddWithValue("@OpenDate", TextBox1.Text)
cmd.Parameters.AddWithValue("@Territory", TextBox2.Text)cmd.Parameters.AddWithValue("@Region", DropDownList3.SelectedItem)
cmd.Parameters.AddWithValue("@StoreNumber", TextBox3.Text)cmd.Parameters.AddWithValue("@StoreAddress", TextBox4.Text)
cmd.Parameters.AddWithValue("@TiplineID", TextBox5.Text)cmd.Parameters.AddWithValue("@Status", DropDownList4.SelectedItem)
cmd.Parameters.AddWithValue("@CaseType", DropDownList5.SelectedItem)cmd.Parameters.AddWithValue("@Offense", DropDownList6.SelectedItem)
End Using
End Sub
On the web page I can enter the data, click the button, and no data is entered into the database?
I believe that I may have problems with the datasource?
Any help would be appreciated.
 
losssoc 
 

View 7 Replies View Related

Handling Large Data Values In Textboxes

Mar 28, 2007

Hi, Ive got a report using a List item that is vertically displaying the columns from a table. The problem I run into, is that some of the fields in this table contain large blocks of text where the users have entered comments and such.

I am using Textboxes to display this data.

So my report will look something like
-----
Field label 1 Field value 1
Field label 2 Field value 2
Field label 3


<white space>



<page break>

Field value 3 ---> this is a big block of text
Field label 4 Field value 4
etc
------
It appears as though the report attempts to keep the contents of each textbox together even if that means breaking onto an entirely new page to do this. I would prefer for the data to flow more natrually instead where the page breaks in the middle of the data being displayed should it be too large to fit on the page it started on.

-----
Field label 1 Field value 1
Field label 2 Field value 2
Field label 3 Field value 3 --- As much as can fit on this page

<page break>

Field value 3 ---> remaining data that broke over the page
Field label 4 Field value 4
etc
------

Any suggestions would be apprecaited.

View 3 Replies View Related

Summing Textboxes With Values From Diff. Datasets

Apr 28, 2008



hello,

I have the following and what to do SUM the valueS in each in another textbox, what is the proper method?



=count(Fields!Month_Submitted.Value, "SALES")

=count(Fields!Month_Submitted_1.Value, "SALESDIR")

=count(Fields!Month_Submitted_2.Value, "SALESVP")

=count(Fields!Month_Submitted_3.Value, "CREDIT")



Thanks,
Rhonda

View 8 Replies View Related

Bind A Variable To A SQL Data Source For Labels, Textboxes, Etc.

Dec 1, 2007

I am trying to set a variable to be passed to my asp page but the value is not carrying over. I don't even know if this is supposed to work or not below:
 <td colspan="3" style="font-size: 10pt; vertical-align: top; color: <%=Div7fontcolor%>; background-color: <%=Div7bgcolor%>; text-align: center; width: 0px;" id="TopBox" runat="server">
 
The above Div7fontcolor and Div7bgcolor are variables that I set in the VB file as shown below:
 Dim obConnection As SqlConnection = New SqlConnection("Data Source=localhostsqlexpress;Initial Catalog=OrgBoard;Integrated Security=True")Dim obCommand As SqlCommand = New SqlCommand("SELECT Divisions.*, Dept19.*, Dept20.*, Dept21.*, ConfigDisplay.* FROM Divisions CROSS JOIN Dept19 CROSS JOIN Dept20 CROSS JOIN Dept21 CROSS JOIN ConfigDisplay", obConnection)
obConnection.Open()Dim dr As SqlDataReader = obCommand.ExecuteReader()
dr.Read()
Dim Div7bgcolor As String = dr("Div7color").ToString().Trim()Dim Div7fontcolor As String = dr("Div7textcolor").ToString().Trim()
dr.Close()
obConnection.Close()
 
The web page runs fine with no errors but the value does not carry over and change the property correctly.
I am able to set the bgColor value of the TopBox within the VB file if I use "TopBox.BgColor = Div7bgcolor" but I can't set other values on my web page like the font color. If I can do this from the VB file then please correct me. Using variables within the page will allow me to set almost any value but I don't even know if what I want is possible. Any help is greatly apprectiated.
Thank you,
 
Kris

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved