Could some body suggest some good books and online resources for:
1. T-SQL Intermediate level/Advanced
2. SQL Server 2005
Thanks a bunch
Csharplearner
Hi,
Here are some links:
T-SQL/SQL Server Books - List of books with customer reviews
sql
Showing posts with label body. Show all posts
Showing posts with label body. Show all posts
Tuesday, March 27, 2012
Monday, March 19, 2012
Body values in Header and header values in body
Hi,
I want to display a value from db in the header section. I have read a couple of information that I should place the value in a in-visible text field an reference it in the header with the ReportItems. This works great with the first page but on the second page the header information are empty (I think because the Textfield is on Page 1 not Page 2)... So is there a way to accomplish that for all pages? Not only the first page....
My second one, hope you don't mind that I post it in the same thread, is:
My Report needs to display the total size of pages in the body. I did not realy found anything useful where I can retrieve from the total size of pages of my reports....
thanks for any help
f.
I have run into issues with wanting to display data in the report headers. I have pretty much moved on from wanting to do it since it is such a pain.
Also to show the total pages I put this code in the page footer, ="Page " & Globals!PageNumber & " of " & Globals!TotalPage. This will show the current page out of how many pages at the bottom of each page.
|||I have tried Globals!TotalPage but it cannot be placed in the body... I got an error message|||The Globals!TotalPages can only be used in a page header or footer, not in the body. You will have to add a page header or footer and then put it in a textbox there.
Body type not supported by Remote Host issue
I have recently setup a 2003 server with ISA firewall and an inbound SMTP re
lay to provide message filtering etc and SMTP command
scanning (such as it may be). This server relays to my internal SMTP server
which is an Exchange 5.5. Prior to this my Exchange
server received the email directly from the sending server with even less pr
otection by the ISA server. Since putting the 6.0
SMTP server in, I have been receiving (as admin) NDRs on in bound messages w
ith the error 'Body type not supported by Remote
Host'.
1) - I am not sure that these message really can't be handled by my 5.5. ser
ver. The reason I question this is that the NDR has
the original message as an attachment and I can open many of them in Outlook
that accesses the 5.5 server) and read them just
fine. Some of them are gibberish.
2) - I would really like the messages to continue on to the Exchange server
and let the chips fall as they may as they did before
I put the inbound relay was put in place.
3) - If I must have the NDR on the inbound messages, I would like to prevent
NDRs from being returned to the sender of these
messages. In fact, I think I could live without any NDRs returned to sender
from this relay. I have a 3 rd party spam filtering
service that discards messages to my domain for addresses without mailboxes
and my Exchange server should really provide what ever
other type of NDR that is required.
I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP,
but I am not sure that it applies because
1) - I really expect the procedure is different.
2) - The rejected messages don't indicate an 8bitmime type
3) - MS did not provide an equivalent article for Server 2003
Any information about the error message Body type not supported by Remote Ho
st or suggests would be most appreciated.
Thanks
---
Roy Chastain
KMSystems, Inc.Sorry about the mis-post. My mousing skills seem to be getting worse with a
ge.
On Wed, 23 Jun 2004 08:04:37 -0400, Roy Chastain <roy@.kmsys.com> wrote:
>I have recently setup a 2003 server with ISA firewall and an inbound SMTP r
elay to provide message filtering etc and SMTP command
>scanning (such as it may be). This server relays to my internal SMTP serve
r which is an Exchange 5.5. Prior to this my Exchange
>server received the email directly from the sending server with even less p
rotection by the ISA server. Since putting the 6.0
>SMTP server in, I have been receiving (as admin) NDRs on in bound messages
with the error 'Body type not supported by Remote
>Host'.
>1) - I am not sure that these message really can't be handled by my 5.5. se
rver. The reason I question this is that the NDR has
>the original message as an attachment and I can open many of them in Outloo
k that accesses the 5.5 server) and read them just
>fine. Some of them are gibberish.
>2) - I would really like the messages to continue on to the Exchange server
and let the chips fall as they may as they did before
>I put the inbound relay was put in place.
>3) - If I must have the NDR on the inbound messages, I would like to preven
t NDRs from being returned to the sender of these
>messages. In fact, I think I could live without any NDRs returned to sende
r from this relay. I have a 3 rd party spam filtering
>service that discards messages to my domain for addresses without mailboxes
and my Exchange server should really provide what ever
>other type of NDR that is required.
>I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP
, but I am not sure that it applies because
>1) - I really expect the procedure is different.
>2) - The rejected messages don't indicate an 8bitmime type
>3) - MS did not provide an equivalent article for Server 2003
>Any information about the error message Body type not supported by Remote H
ost or suggests would be most appreciated.
>Thanks
>---
>Roy Chastain
>KMSystems, Inc.
---
Roy Chastain
KMSystems, Inc.
lay to provide message filtering etc and SMTP command
scanning (such as it may be). This server relays to my internal SMTP server
which is an Exchange 5.5. Prior to this my Exchange
server received the email directly from the sending server with even less pr
otection by the ISA server. Since putting the 6.0
SMTP server in, I have been receiving (as admin) NDRs on in bound messages w
ith the error 'Body type not supported by Remote
Host'.
1) - I am not sure that these message really can't be handled by my 5.5. ser
ver. The reason I question this is that the NDR has
the original message as an attachment and I can open many of them in Outlook
that accesses the 5.5 server) and read them just
fine. Some of them are gibberish.
2) - I would really like the messages to continue on to the Exchange server
and let the chips fall as they may as they did before
I put the inbound relay was put in place.
3) - If I must have the NDR on the inbound messages, I would like to prevent
NDRs from being returned to the sender of these
messages. In fact, I think I could live without any NDRs returned to sender
from this relay. I have a 3 rd party spam filtering
service that discards messages to my domain for addresses without mailboxes
and my Exchange server should really provide what ever
other type of NDR that is required.
I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP,
but I am not sure that it applies because
1) - I really expect the procedure is different.
2) - The rejected messages don't indicate an 8bitmime type
3) - MS did not provide an equivalent article for Server 2003
Any information about the error message Body type not supported by Remote Ho
st or suggests would be most appreciated.
Thanks
---
Roy Chastain
KMSystems, Inc.Sorry about the mis-post. My mousing skills seem to be getting worse with a
ge.
On Wed, 23 Jun 2004 08:04:37 -0400, Roy Chastain <roy@.kmsys.com> wrote:
>I have recently setup a 2003 server with ISA firewall and an inbound SMTP r
elay to provide message filtering etc and SMTP command
>scanning (such as it may be). This server relays to my internal SMTP serve
r which is an Exchange 5.5. Prior to this my Exchange
>server received the email directly from the sending server with even less p
rotection by the ISA server. Since putting the 6.0
>SMTP server in, I have been receiving (as admin) NDRs on in bound messages
with the error 'Body type not supported by Remote
>Host'.
>1) - I am not sure that these message really can't be handled by my 5.5. se
rver. The reason I question this is that the NDR has
>the original message as an attachment and I can open many of them in Outloo
k that accesses the 5.5 server) and read them just
>fine. Some of them are gibberish.
>2) - I would really like the messages to continue on to the Exchange server
and let the chips fall as they may as they did before
>I put the inbound relay was put in place.
>3) - If I must have the NDR on the inbound messages, I would like to preven
t NDRs from being returned to the sender of these
>messages. In fact, I think I could live without any NDRs returned to sende
r from this relay. I have a 3 rd party spam filtering
>service that discards messages to my domain for addresses without mailboxes
and my Exchange server should really provide what ever
>other type of NDR that is required.
>I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP
, but I am not sure that it applies because
>1) - I really expect the procedure is different.
>2) - The rejected messages don't indicate an 8bitmime type
>3) - MS did not provide an equivalent article for Server 2003
>Any information about the error message Body type not supported by Remote H
ost or suggests would be most appreciated.
>Thanks
>---
>Roy Chastain
>KMSystems, Inc.
---
Roy Chastain
KMSystems, Inc.
Body type not supported by Remote Host issue
I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command
scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
server received the email directly from the sending server with even less protection by the ISA server. Since putting the 6.0
SMTP server in, I have been receiving (as admin) NDRs on in bound messages with the error 'Body type not supported by Remote
Host'.
1) - I am not sure that these message really can't be handled by my 5.5. server. The reason I question this is that the NDR has
the original message as an attachment and I can open many of them in Outlook that accesses the 5.5 server) and read them just
fine. Some of them are gibberish.
2) - I would really like the messages to continue on to the Exchange server and let the chips fall as they may as they did before
I put the inbound relay was put in place.
3) - If I must have the NDR on the inbound messages, I would like to prevent NDRs from being returned to the sender of these
messages. In fact, I think I could live without any NDRs returned to sender from this relay. I have a 3 rd party spam filtering
service that discards messages to my domain for addresses without mailboxes and my Exchange server should really provide what ever
other type of NDR that is required.
I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP, but I am not sure that it applies because
1) - I really expect the procedure is different.
2) - The rejected messages don't indicate an 8bitmime type
3) - MS did not provide an equivalent article for Server 2003
Any information about the error message Body type not supported by Remote Host or suggests would be most appreciated.
Thanks
Roy Chastain
KMSystems, Inc.
Sorry about the mis-post. My mousing skills seem to be getting worse with age.
On Wed, 23 Jun 2004 08:04:37 -0400, Roy Chastain <roy@.kmsys.com> wrote:
>I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command
>scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
>server received the email directly from the sending server with even less protection by the ISA server. Since putting the 6.0
>SMTP server in, I have been receiving (as admin) NDRs on in bound messages with the error 'Body type not supported by Remote
>Host'.
>1) - I am not sure that these message really can't be handled by my 5.5. server. The reason I question this is that the NDR has
>the original message as an attachment and I can open many of them in Outlook that accesses the 5.5 server) and read them just
>fine. Some of them are gibberish.
>2) - I would really like the messages to continue on to the Exchange server and let the chips fall as they may as they did before
>I put the inbound relay was put in place.
>3) - If I must have the NDR on the inbound messages, I would like to prevent NDRs from being returned to the sender of these
>messages. In fact, I think I could live without any NDRs returned to sender from this relay. I have a 3 rd party spam filtering
>service that discards messages to my domain for addresses without mailboxes and my Exchange server should really provide what ever
>other type of NDR that is required.
>I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP, but I am not sure that it applies because
>1) - I really expect the procedure is different.
>2) - The rejected messages don't indicate an 8bitmime type
>3) - MS did not provide an equivalent article for Server 2003
>Any information about the error message Body type not supported by Remote Host or suggests would be most appreciated.
>Thanks
>---
>Roy Chastain
>KMSystems, Inc.
Roy Chastain
KMSystems, Inc.
scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
server received the email directly from the sending server with even less protection by the ISA server. Since putting the 6.0
SMTP server in, I have been receiving (as admin) NDRs on in bound messages with the error 'Body type not supported by Remote
Host'.
1) - I am not sure that these message really can't be handled by my 5.5. server. The reason I question this is that the NDR has
the original message as an attachment and I can open many of them in Outlook that accesses the 5.5 server) and read them just
fine. Some of them are gibberish.
2) - I would really like the messages to continue on to the Exchange server and let the chips fall as they may as they did before
I put the inbound relay was put in place.
3) - If I must have the NDR on the inbound messages, I would like to prevent NDRs from being returned to the sender of these
messages. In fact, I think I could live without any NDRs returned to sender from this relay. I have a 3 rd party spam filtering
service that discards messages to my domain for addresses without mailboxes and my Exchange server should really provide what ever
other type of NDR that is required.
I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP, but I am not sure that it applies because
1) - I really expect the procedure is different.
2) - The rejected messages don't indicate an 8bitmime type
3) - MS did not provide an equivalent article for Server 2003
Any information about the error message Body type not supported by Remote Host or suggests would be most appreciated.
Thanks
Roy Chastain
KMSystems, Inc.
Sorry about the mis-post. My mousing skills seem to be getting worse with age.
On Wed, 23 Jun 2004 08:04:37 -0400, Roy Chastain <roy@.kmsys.com> wrote:
>I have recently setup a 2003 server with ISA firewall and an inbound SMTP relay to provide message filtering etc and SMTP command
>scanning (such as it may be). This server relays to my internal SMTP server which is an Exchange 5.5. Prior to this my Exchange
>server received the email directly from the sending server with even less protection by the ISA server. Since putting the 6.0
>SMTP server in, I have been receiving (as admin) NDRs on in bound messages with the error 'Body type not supported by Remote
>Host'.
>1) - I am not sure that these message really can't be handled by my 5.5. server. The reason I question this is that the NDR has
>the original message as an attachment and I can open many of them in Outlook that accesses the 5.5 server) and read them just
>fine. Some of them are gibberish.
>2) - I would really like the messages to continue on to the Exchange server and let the chips fall as they may as they did before
>I put the inbound relay was put in place.
>3) - If I must have the NDR on the inbound messages, I would like to prevent NDRs from being returned to the sender of these
>messages. In fact, I think I could live without any NDRs returned to sender from this relay. I have a 3 rd party spam filtering
>service that discards messages to my domain for addresses without mailboxes and my Exchange server should really provide what ever
>other type of NDR that is required.
>I saw an article about disabling 8bitmime advertising for Windows 2000 SMTP, but I am not sure that it applies because
>1) - I really expect the procedure is different.
>2) - The rejected messages don't indicate an 8bitmime type
>3) - MS did not provide an equivalent article for Server 2003
>Any information about the error message Body type not supported by Remote Host or suggests would be most appreciated.
>Thanks
>---
>Roy Chastain
>KMSystems, Inc.
Roy Chastain
KMSystems, Inc.
Body Size
Hi,
I have report which requires a long body. But it seems RS doesnt allow body
size more than 160 inches.
Pz anybody suggests how can we overcome this problem.
ThanksWe already have report which has lists on that and in each list has
respective tables/chart and query. Now we need to add more sections to the
existing report. If I add more lists of a page size, i run out of the body.
The other option is to add sub reports. But there is issue is like We have a
table of contents on first section which verifies if the any of the section's
query doesnt return result, dont print in table of content as the same is not
going to be there in report. So to verify I need to write the same query at 2
different place.. If there is a way to find if the subreport is going to have
data or not OR Sub report can write to one of the text box in main report (
table of content), The it will be done.
Thanks !!!
"Jeff A. Stucker" wrote:
> I should have said XML tranformation instead of style sheet.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> > Why do you need such a long body size? You can get around almost anything
> > on the output side by using XML and then linking it to a style sheet.
> > That takes a bit of programming, though.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "manish" <manish@.discussions.microsoft.com> wrote in message
> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> Hi,
> >>
> >> I have report which requires a long body. But it seems RS doesnt allow
> >> body
> >> size more than 160 inches.
> >> Pz anybody suggests how can we overcome this problem.
> >>
> >> Thanks
> >
> >
>
>|||There is a property you can set on subreports that defines something to
display if the subreport is empty. I wonder if you can play with that...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> We already have report which has lists on that and in each list has
> respective tables/chart and query. Now we need to add more sections to the
> existing report. If I add more lists of a page size, i run out of the
> body.
> The other option is to add sub reports. But there is issue is like We have
> a
> table of contents on first section which verifies if the any of the
> section's
> query doesnt return result, dont print in table of content as the same is
> not
> going to be there in report. So to verify I need to write the same query
> at 2
> different place.. If there is a way to find if the subreport is going to
> have
> data or not OR Sub report can write to one of the text box in main report
> (
> table of content), The it will be done.
> Thanks !!!
> "Jeff A. Stucker" wrote:
>> I should have said XML tranformation instead of style sheet.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> > Why do you need such a long body size? You can get around almost
>> > anything
>> > on the output side by using XML and then linking it to a style sheet.
>> > That takes a bit of programming, though.
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "manish" <manish@.discussions.microsoft.com> wrote in message
>> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> >> Hi,
>> >>
>> >> I have report which requires a long body. But it seems RS doesnt allow
>> >> body
>> >> size more than 160 inches.
>> >> Pz anybody suggests how can we overcome this problem.
>> >>
>> >> Thanks
>> >
>> >
>>|||Yeah! I lef with this choice only in this scenario.. Thanks Jeff !!!
"Jeff A. Stucker" wrote:
> There is a property you can set on subreports that defines something to
> display if the subreport is empty. I wonder if you can play with that...
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> > We already have report which has lists on that and in each list has
> > respective tables/chart and query. Now we need to add more sections to the
> > existing report. If I add more lists of a page size, i run out of the
> > body.
> > The other option is to add sub reports. But there is issue is like We have
> > a
> > table of contents on first section which verifies if the any of the
> > section's
> > query doesnt return result, dont print in table of content as the same is
> > not
> > going to be there in report. So to verify I need to write the same query
> > at 2
> > different place.. If there is a way to find if the subreport is going to
> > have
> > data or not OR Sub report can write to one of the text box in main report
> > (
> > table of content), The it will be done.
> >
> > Thanks !!!
> >
> > "Jeff A. Stucker" wrote:
> >
> >> I should have said XML tranformation instead of style sheet.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> >> > Why do you need such a long body size? You can get around almost
> >> > anything
> >> > on the output side by using XML and then linking it to a style sheet.
> >> > That takes a bit of programming, though.
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "manish" <manish@.discussions.microsoft.com> wrote in message
> >> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> >> Hi,
> >> >>
> >> >> I have report which requires a long body. But it seems RS doesnt allow
> >> >> body
> >> >> size more than 160 inches.
> >> >> Pz anybody suggests how can we overcome this problem.
> >> >>
> >> >> Thanks
> >> >
> >> >
> >>
> >>
> >>
>
>|||Why do you need such a long body size? You can get around almost anything
on the output side by using XML and then linking it to a style sheet. That
takes a bit of programming, though.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> Hi,
> I have report which requires a long body. But it seems RS doesnt allow
> body
> size more than 160 inches.
> Pz anybody suggests how can we overcome this problem.
> Thanks|||I should have said XML tranformation instead of style sheet.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Why do you need such a long body size? You can get around almost anything
> on the output side by using XML and then linking it to a style sheet.
> That takes a bit of programming, though.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> Hi,
>> I have report which requires a long body. But it seems RS doesnt allow
>> body
>> size more than 160 inches.
>> Pz anybody suggests how can we overcome this problem.
>> Thanks
>
I have report which requires a long body. But it seems RS doesnt allow body
size more than 160 inches.
Pz anybody suggests how can we overcome this problem.
ThanksWe already have report which has lists on that and in each list has
respective tables/chart and query. Now we need to add more sections to the
existing report. If I add more lists of a page size, i run out of the body.
The other option is to add sub reports. But there is issue is like We have a
table of contents on first section which verifies if the any of the section's
query doesnt return result, dont print in table of content as the same is not
going to be there in report. So to verify I need to write the same query at 2
different place.. If there is a way to find if the subreport is going to have
data or not OR Sub report can write to one of the text box in main report (
table of content), The it will be done.
Thanks !!!
"Jeff A. Stucker" wrote:
> I should have said XML tranformation instead of style sheet.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> > Why do you need such a long body size? You can get around almost anything
> > on the output side by using XML and then linking it to a style sheet.
> > That takes a bit of programming, though.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "manish" <manish@.discussions.microsoft.com> wrote in message
> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> Hi,
> >>
> >> I have report which requires a long body. But it seems RS doesnt allow
> >> body
> >> size more than 160 inches.
> >> Pz anybody suggests how can we overcome this problem.
> >>
> >> Thanks
> >
> >
>
>|||There is a property you can set on subreports that defines something to
display if the subreport is empty. I wonder if you can play with that...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> We already have report which has lists on that and in each list has
> respective tables/chart and query. Now we need to add more sections to the
> existing report. If I add more lists of a page size, i run out of the
> body.
> The other option is to add sub reports. But there is issue is like We have
> a
> table of contents on first section which verifies if the any of the
> section's
> query doesnt return result, dont print in table of content as the same is
> not
> going to be there in report. So to verify I need to write the same query
> at 2
> different place.. If there is a way to find if the subreport is going to
> have
> data or not OR Sub report can write to one of the text box in main report
> (
> table of content), The it will be done.
> Thanks !!!
> "Jeff A. Stucker" wrote:
>> I should have said XML tranformation instead of style sheet.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> > Why do you need such a long body size? You can get around almost
>> > anything
>> > on the output side by using XML and then linking it to a style sheet.
>> > That takes a bit of programming, though.
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "manish" <manish@.discussions.microsoft.com> wrote in message
>> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> >> Hi,
>> >>
>> >> I have report which requires a long body. But it seems RS doesnt allow
>> >> body
>> >> size more than 160 inches.
>> >> Pz anybody suggests how can we overcome this problem.
>> >>
>> >> Thanks
>> >
>> >
>>|||Yeah! I lef with this choice only in this scenario.. Thanks Jeff !!!
"Jeff A. Stucker" wrote:
> There is a property you can set on subreports that defines something to
> display if the subreport is empty. I wonder if you can play with that...
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> > We already have report which has lists on that and in each list has
> > respective tables/chart and query. Now we need to add more sections to the
> > existing report. If I add more lists of a page size, i run out of the
> > body.
> > The other option is to add sub reports. But there is issue is like We have
> > a
> > table of contents on first section which verifies if the any of the
> > section's
> > query doesnt return result, dont print in table of content as the same is
> > not
> > going to be there in report. So to verify I need to write the same query
> > at 2
> > different place.. If there is a way to find if the subreport is going to
> > have
> > data or not OR Sub report can write to one of the text box in main report
> > (
> > table of content), The it will be done.
> >
> > Thanks !!!
> >
> > "Jeff A. Stucker" wrote:
> >
> >> I should have said XML tranformation instead of style sheet.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> >> > Why do you need such a long body size? You can get around almost
> >> > anything
> >> > on the output side by using XML and then linking it to a style sheet.
> >> > That takes a bit of programming, though.
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "manish" <manish@.discussions.microsoft.com> wrote in message
> >> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> >> Hi,
> >> >>
> >> >> I have report which requires a long body. But it seems RS doesnt allow
> >> >> body
> >> >> size more than 160 inches.
> >> >> Pz anybody suggests how can we overcome this problem.
> >> >>
> >> >> Thanks
> >> >
> >> >
> >>
> >>
> >>
>
>|||Why do you need such a long body size? You can get around almost anything
on the output side by using XML and then linking it to a style sheet. That
takes a bit of programming, though.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> Hi,
> I have report which requires a long body. But it seems RS doesnt allow
> body
> size more than 160 inches.
> Pz anybody suggests how can we overcome this problem.
> Thanks|||I should have said XML tranformation instead of style sheet.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Why do you need such a long body size? You can get around almost anything
> on the output side by using XML and then linking it to a style sheet.
> That takes a bit of programming, though.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> Hi,
>> I have report which requires a long body. But it seems RS doesnt allow
>> body
>> size more than 160 inches.
>> Pz anybody suggests how can we overcome this problem.
>> Thanks
>
BODY not getting assigned BackgroundColor and BODY does not have CanShrink property: REPOS
I have simplified the problem I am having down by creating an empty report
with and Page Header, Body and PageFooter. I have set the BackgroundColor
of all three to "White".
I am using VS.NET to design the Report and ASP.NET with C# to call the
Reporting Services web service Render method using HTML4.0 format to render
the report inline on my web page with a blue background.
The css (a1_s) for the Body does not a Background color as seen below in the
Supporting Examples:
The bigger problem is that I have a Table in the Body. Both do not have a
CanGrow or CanShrink property, at least exposed in VS.NET. The Table is the
only thing in the Body. The Table has a Header, Group, Detail and Footer.
If the report returns no detail, I see the Table Header and the Table
Footer. It knew to collapse/shrink the Group and Detail sections but did
not shrink the Table and/or the Body. Under the Table Footer and before the
Page Footer is a gap which is the transparent area.
The Lame workarounds I have found so far are:
- reduce the Height of the Body and the Table to the smallest allowed by the
VS.NET, but during design you have to increase it and not forget to decrease
it when you are done
- put the Table in a rectangle with a "White" BackgroundColor but there is
still a big gap between the Table Footer and Page Footer
Supporting Examples:
The RDL is:
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>89d2899d-7bc6-4d9d-b3f5-1bee26df10a3</rd:ReportID>
<PageFooter>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageFooter>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
The CSS snippet is:
.a1_s{HEIGHT:50.80mm;overflow:hidden;WIDTH:165.10mm}
.a3{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
.a5{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
The generated HTML for the report is
<div id="oReportDiv" onresize="javascript:OnResizeDiv()" style="OVERFLOW:
auto; WIDTH: 100%; HEIGHT: 100%">
<table cellpadding="0" cellspacing="0">
<tr>
<td id="oReportCell" style="PADDING: 10px">
<DIV class="a3"> </DIV>
<DIV class="a1_s"> </DIV>
<DIV class="a5"> </DIV>
<script language="javascript" type="text/javascript">
<!--
var docMapIds = [];
//-->
</script>
</td><td style="WIDTH: 100%; HEIGHT: 0px"></td>
</tr><tr>
<td style="WIDTH: 0px; HEIGHT: 100%"></td>
</tr>
</table>
</div>Hi Douglas,
I am looking into this issue, I will keep you updated as soon as I find
there is anything useful to add :)
Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Douglas,
From your descriptions, I understood that you are not able to generate
html as you expected when using Render method called from web service. If I
have misunderstood your concern, please feel free to point it out.
BODY do not has CanShrink property, but I am not sure why you are not able
to assign BackgoundColor property? Is it possible for you to assign the
BackgoundColor in the Report Designer?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I am able to assign BackgroundColor in the Report Designer as confirmed by
the RDL I supplied in my first post.
The class generated for the Body ("a1_s") does not have a background-color
where as the Header ("a3") and Footer("a5") do have it. This can also be
seen by the Style Sheet and HTML provided in my first post.
Why doesn't a background-color get generated for the Body?
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:CzW6x8ENFHA.2900@.TK2MSFTNGXA03.phx.gbl...
> Hi Douglas,
> From your descriptions, I understood that you are not able to generate
> html as you expected when using Render method called from web service. If
I
> have misunderstood your concern, please feel free to point it out.
> BODY do not has CanShrink property, but I am not sure why you are not able
> to assign BackgoundColor property? Is it possible for you to assign the
> BackgoundColor in the Report Designer?
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi Doug,
You may also manually write the code to change the background of HTML code
after calling Web service render method as workaround for your scenario.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
So, is this a known issue?
If so, might it be corrected in SP2?
With the workaround you suggested, since I have one container for all
reports, a User Control, I would have to query the report to see what color
to change it to.
The only way I have found to query the report is to call the
GetReportDefinition Method of the ReportingService Class and then parse the
.rdl.
Is there an easier way?
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:nacubipNFHA.2720@.TK2MSFTNGXA03.phx.gbl...
> Hi Doug,
> You may also manually write the code to change the background of HTML code
> after calling Web service render method as workaround for your scenario.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi Douglas,
Thanks for your kindly patience:)
Yes, I am sorry to say that this is currently by design feature of
Reporting Services now.
If the body of the report does not have a border, the background color is
taken to be the background color for the entire page, not just the body. As
a result, it is placed on the <BODY> element rather than in the CSS for the
<DIV> corresponding to the body of the report.
I don't think SP2 will fix this.
Thanks again for your patience and corporation. If you have any questions
or concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I tested your findings and setting the BODY border color to white and solid
is the best workaround so far and much more manageable.
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:9sYecjlOFHA.3136@.TK2MSFTNGXA01.phx.gbl...
> Hi Douglas,
> Thanks for your kindly patience:)
> Yes, I am sorry to say that this is currently by design feature of
> Reporting Services now.
> If the body of the report does not have a border, the background color is
> taken to be the background color for the entire page, not just the body.
As
> a result, it is placed on the <BODY> element rather than in the CSS for
the
> <DIV> corresponding to the body of the report.
> I don't think SP2 will fix this.
> Thanks again for your patience and corporation. If you have any questions
> or concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi Doug,
Thanks for your understanding:) If you have any questions or concerns next
time, don't hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
with and Page Header, Body and PageFooter. I have set the BackgroundColor
of all three to "White".
I am using VS.NET to design the Report and ASP.NET with C# to call the
Reporting Services web service Render method using HTML4.0 format to render
the report inline on my web page with a blue background.
The css (a1_s) for the Body does not a Background color as seen below in the
Supporting Examples:
The bigger problem is that I have a Table in the Body. Both do not have a
CanGrow or CanShrink property, at least exposed in VS.NET. The Table is the
only thing in the Body. The Table has a Header, Group, Detail and Footer.
If the report returns no detail, I see the Table Header and the Table
Footer. It knew to collapse/shrink the Group and Detail sections but did
not shrink the Table and/or the Body. Under the Table Footer and before the
Page Footer is a gap which is the transparent area.
The Lame workarounds I have found so far are:
- reduce the Height of the Body and the Table to the smallest allowed by the
VS.NET, but during design you have to increase it and not forget to decrease
it when you are done
- put the Table in a rectangle with a "White" BackgroundColor but there is
still a big gap between the Table Footer and Page Footer
Supporting Examples:
The RDL is:
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>89d2899d-7bc6-4d9d-b3f5-1bee26df10a3</rd:ReportID>
<PageFooter>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageFooter>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
The CSS snippet is:
.a1_s{HEIGHT:50.80mm;overflow:hidden;WIDTH:165.10mm}
.a3{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
.a5{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
The generated HTML for the report is
<div id="oReportDiv" onresize="javascript:OnResizeDiv()" style="OVERFLOW:
auto; WIDTH: 100%; HEIGHT: 100%">
<table cellpadding="0" cellspacing="0">
<tr>
<td id="oReportCell" style="PADDING: 10px">
<DIV class="a3"> </DIV>
<DIV class="a1_s"> </DIV>
<DIV class="a5"> </DIV>
<script language="javascript" type="text/javascript">
<!--
var docMapIds = [];
//-->
</script>
</td><td style="WIDTH: 100%; HEIGHT: 0px"></td>
</tr><tr>
<td style="WIDTH: 0px; HEIGHT: 100%"></td>
</tr>
</table>
</div>Hi Douglas,
I am looking into this issue, I will keep you updated as soon as I find
there is anything useful to add :)
Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Douglas,
From your descriptions, I understood that you are not able to generate
html as you expected when using Render method called from web service. If I
have misunderstood your concern, please feel free to point it out.
BODY do not has CanShrink property, but I am not sure why you are not able
to assign BackgoundColor property? Is it possible for you to assign the
BackgoundColor in the Report Designer?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I am able to assign BackgroundColor in the Report Designer as confirmed by
the RDL I supplied in my first post.
The class generated for the Body ("a1_s") does not have a background-color
where as the Header ("a3") and Footer("a5") do have it. This can also be
seen by the Style Sheet and HTML provided in my first post.
Why doesn't a background-color get generated for the Body?
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:CzW6x8ENFHA.2900@.TK2MSFTNGXA03.phx.gbl...
> Hi Douglas,
> From your descriptions, I understood that you are not able to generate
> html as you expected when using Render method called from web service. If
I
> have misunderstood your concern, please feel free to point it out.
> BODY do not has CanShrink property, but I am not sure why you are not able
> to assign BackgoundColor property? Is it possible for you to assign the
> BackgoundColor in the Report Designer?
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi Doug,
You may also manually write the code to change the background of HTML code
after calling Web service render method as workaround for your scenario.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
So, is this a known issue?
If so, might it be corrected in SP2?
With the workaround you suggested, since I have one container for all
reports, a User Control, I would have to query the report to see what color
to change it to.
The only way I have found to query the report is to call the
GetReportDefinition Method of the ReportingService Class and then parse the
.rdl.
Is there an easier way?
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:nacubipNFHA.2720@.TK2MSFTNGXA03.phx.gbl...
> Hi Doug,
> You may also manually write the code to change the background of HTML code
> after calling Web service render method as workaround for your scenario.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi Douglas,
Thanks for your kindly patience:)
Yes, I am sorry to say that this is currently by design feature of
Reporting Services now.
If the body of the report does not have a border, the background color is
taken to be the background color for the entire page, not just the body. As
a result, it is placed on the <BODY> element rather than in the CSS for the
<DIV> corresponding to the body of the report.
I don't think SP2 will fix this.
Thanks again for your patience and corporation. If you have any questions
or concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I tested your findings and setting the BODY border color to white and solid
is the best workaround so far and much more manageable.
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:9sYecjlOFHA.3136@.TK2MSFTNGXA01.phx.gbl...
> Hi Douglas,
> Thanks for your kindly patience:)
> Yes, I am sorry to say that this is currently by design feature of
> Reporting Services now.
> If the body of the report does not have a border, the background color is
> taken to be the background color for the entire page, not just the body.
As
> a result, it is placed on the <BODY> element rather than in the CSS for
the
> <DIV> corresponding to the body of the report.
> I don't think SP2 will fix this.
> Thanks again for your patience and corporation. If you have any questions
> or concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi Doug,
Thanks for your understanding:) If you have any questions or concerns next
time, don't hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Body is overlapping header
Hello~
I have a report with a header and body.
The header has the usual stuff, title, logo, parameter fields, etc
The body is a table.
When I run the report, the table overlaps the header... I don't
understand why this is happening...
So... what I'm doing right now is I have to leave an inch of blank
space just before the table in the body. But cosmetically the report
doesnt look right...
Thanks!On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> Hello~
> I have a report with a header and body.
> The header has the usual stuff, title, logo, parameter fields, etc
> The body is a table.
> When I run the report, the table overlaps the header... I don't
> understand why this is happening...
> So... what I'm doing right now is I have to leave an inch of blank
> space just before the table in the body. But cosmetically the report
> doesnt look right...
> Thanks!
This seems like a unique situation. I would suggest putting the
contents of the header into one rectangle and doing the same for the
table control in the body. Also, you might want to right-click inside
the blank area of the header -> select Properties -> and increase the
BorderWidth. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 12, 9:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> > Hello~
> > I have a report with a header and body.
> > The header has the usual stuff, title, logo, parameter fields, etc
> > The body is a table.
> > When I run the report, the table overlaps the header... I don't
> > understand why this is happening...
> > So... what I'm doing right now is I have to leave an inch of blank
> > space just before the table in the body. But cosmetically the report
> > doesnt look right...
> > Thanks!
> This seems like a unique situation. I would suggest putting the
> contents of the header into one rectangle and doing the same for the
> table control in the body. Also, you might want to right-click inside
> the blank area of the header -> select Properties -> and increase the
> BorderWidth. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Under the properties tab for the report itself, try changing the
margins it may or may not help.
I have a report with a header and body.
The header has the usual stuff, title, logo, parameter fields, etc
The body is a table.
When I run the report, the table overlaps the header... I don't
understand why this is happening...
So... what I'm doing right now is I have to leave an inch of blank
space just before the table in the body. But cosmetically the report
doesnt look right...
Thanks!On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> Hello~
> I have a report with a header and body.
> The header has the usual stuff, title, logo, parameter fields, etc
> The body is a table.
> When I run the report, the table overlaps the header... I don't
> understand why this is happening...
> So... what I'm doing right now is I have to leave an inch of blank
> space just before the table in the body. But cosmetically the report
> doesnt look right...
> Thanks!
This seems like a unique situation. I would suggest putting the
contents of the header into one rectangle and doing the same for the
table control in the body. Also, you might want to right-click inside
the blank area of the header -> select Properties -> and increase the
BorderWidth. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 12, 9:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Jul 12, 4:55 pm, OogleGoogle <Yvonh...@.gmail.com> wrote:
> > Hello~
> > I have a report with a header and body.
> > The header has the usual stuff, title, logo, parameter fields, etc
> > The body is a table.
> > When I run the report, the table overlaps the header... I don't
> > understand why this is happening...
> > So... what I'm doing right now is I have to leave an inch of blank
> > space just before the table in the body. But cosmetically the report
> > doesnt look right...
> > Thanks!
> This seems like a unique situation. I would suggest putting the
> contents of the header into one rectangle and doing the same for the
> table control in the body. Also, you might want to right-click inside
> the blank area of the header -> select Properties -> and increase the
> BorderWidth. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Under the properties tab for the report itself, try changing the
margins it may or may not help.
Body BackgroundImage not displayed in browser
I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.
However, if the report is printed, or exported to PDF or Excel, the background displays correctly.
It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.
Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?
This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.
-Chris
|||
I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?
Thanks!
Body BackgroundImage not displayed in browser
I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.
However, if the report is printed, or exported to PDF or Excel, the background displays correctly.
It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.
Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?
This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.
-Chris
|||I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?
Thanks!
Wednesday, March 7, 2012
Block Port 1433 on windows 2000 server
Hi
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
AnnIPSec can be used or a Personal Firewall.
813878 How to Block Specific Network Protocols and Ports by Using IPSec
http://support.microsoft.com/?id=813878
If this computer is on the internet it should be behind a firewall. By
default a firewall will block all incoming traffic, unless you specifically
allow it.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||The issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:
>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/se...s/mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/g...odtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techin...t.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.com...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/...le_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP[vbcol=seagreen]|||Sorry. i forgot it was a Windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:
>Sorry. i forgot it was a Windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.
>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
AnnIPSec can be used or a Personal Firewall.
813878 How to Block Specific Network Protocols and Ports by Using IPSec
http://support.microsoft.com/?id=813878
If this computer is on the internet it should be behind a firewall. By
default a firewall will block all incoming traffic, unless you specifically
allow it.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||The issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:
>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/se...s/mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/g...odtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techin...t.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.com...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/...le_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP[vbcol=seagreen]|||Sorry. i forgot it was a Windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:
>Sorry. i forgot it was a Windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.
>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.
Block Port 1433 on windows 2000 server
Hi
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
Ann
IPSec can be used or a Personal Firewall.
813878 How to Block Specific Network Protocols and Ports by Using IPSec
http://support.microsoft.com/?id=813878
If this computer is on the internet it should be behind a firewall. By
default a firewall will block all incoming traffic, unless you specifically
allow it.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||The issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann
|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:
>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff
|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/sec.../mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/gu...dtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techinf...ty/default.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.c om...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann
|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/d...e_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP[vbcol=seagreen]
|||Sorry. i forgot it was a windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni
|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:
>Sorry. i forgot it was a windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.
>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
Ann
IPSec can be used or a Personal Firewall.
813878 How to Block Specific Network Protocols and Ports by Using IPSec
http://support.microsoft.com/?id=813878
If this computer is on the internet it should be behind a firewall. By
default a firewall will block all incoming traffic, unless you specifically
allow it.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||The issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann
|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:
>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff
|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/sec.../mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/gu...dtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techinf...ty/default.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.c om...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann
|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/d...e_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP[vbcol=seagreen]
|||Sorry. i forgot it was a windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni
|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:
>Sorry. i forgot it was a windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.
>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.
Block Port 1433 on windows 2000 server
Hi
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
AnnThe issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:
>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/se...s/mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/g...odtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techin...ity/default.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.c om...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/...le_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP
> >I have a question regarding the SQL Server(SQL Server 7) port 1433.
> >Some body is trying to hack into our Windows 2000 server through port
> >1433. Is there a way i can close this port?|||Sorry. i forgot it was a windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:
>Sorry. i forgot it was a windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.
>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.
Thursday, February 16, 2012
blank page in pdf report
When I export my report to PDF, I get a blank page that shows up. The
header and footer are on the second page, but the body is blank. There
isn't enough data for a second page. Why is one being created? Any ideas?Most likely, something in your footer is touching one or more of your
margins. Make sure everything is inside the margins and you should be
good.
header and footer are on the second page, but the body is blank. There
isn't enough data for a second page. Why is one being created? Any ideas?Most likely, something in your footer is touching one or more of your
margins. Make sure everything is inside the margins and you should be
good.
Subscribe to:
Posts (Atom)