How to show the border of the table?

hi,
How to adjust/display/hide the table border(including all cells)?
I see in the property page, there is a BorderStyle for the table, but it only changes the outline of the table border style, I want to change the border style including all cells, like we did in html page, is there an easy way to do this, or I have to make the setting for all cells?

Thanks

I don't think there is a way to force gridlines for the table. You'll probably need to specify the borders of the cells.|||

Oh...
When I created a report table by the wizard, it can be set to have the gridlines. From the rdl file, seems it sets this for each cell, not the whole table.

sql

How to set writable property to readonly

Hi all,
Is there any command to change writable property of database or table or
column to readonly.
Thanks in advance.
SupriyaBelow links will be helpful
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/27/read-only-file-group-tables-are-not-really-read-only-in-the-strict-sense.aspx
-
Shiju Samuel
On Sep 11, 1:56 pm, "Supriya Pagadala" <supriya_...@.yahoo.com> wrote:
> Hi all,
> Is there any command to change writable property of database or table or
> column to readonly.
> Thanks in advance.
> Supriya|||Hi Samuel,
Thanks for your response.I think you misunderstood the question.I want
to make particular property to readonly. Not entire table or database.
for example Table has following properties..
Name,NoOfColumns...etc.
If "Name" property is writable , how to make it read only?
"Shiju Samuel" <shiju.samuel@.gmail.com> wrote in message
news:1189502014.158301.151010@.y42g2000hsy.googlegroups.com...
> Below links will be helpful
> http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx
> http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/27/read-only-file-group-tables-are-not-really-read-only-in-the-strict-sense.aspx
> -
> Shiju Samuel
> On Sep 11, 1:56 pm, "Supriya Pagadala" <supriya_...@.yahoo.com> wrote:
>> Hi all,
>> Is there any command to change writable property of database or table
>> or
>> column to readonly.
>> Thanks in advance.
>> Supriya
>sql

How to set up related tables

I have a bunch of data related to a property. On that property, we have
several measurement requirements to perform several calculations. For
instance, I may have data that currently am planning to set up as follows:
PropertyInformation table:
PropertyAddressID, ResidentialPropertyTypeID, PropertyOwner,
CorporatePropertyTypeID
PropertyMeasurement table
PropertyInformationID
Measurement1 (related to Corporate property only)
Measurement 2 (related to Corporate property only)
Measurement 3 (related to Residential property only)
Measurement 4 (related to Residential property only)
Measurement 5 (related to both Corporate and Residential)
Measurement 6 (related to both Corporate and Residential)
Calculation table:
PropertyMeasurementID (FK)
Total (result of Measurements 2, 4, 5, 6)
Date (date calculation done)
In order to perform the final calculations, we must have one residential
property type and one corporate type (which comes from other lookup tables.
I originally was going to base the 2 latter tables on the
PropertyInformation; however, we may not have any property information
whatsoever when the measurements are recorded, all we know is we have one
ResidentialPropertyType and one CorporatePropertyType, but we may not even
know what that type is. My thought is to force an "Unknown" for property
type for the ResidentialPropertyTypeID (the CorporatePropertyTypeID is the
only information we collect on the property, all other fields in that table
relate to the ResidentialProperty, but the combination of the Corporate and
Residential measurements are required for the calculations). And we may
have Property data but no calculations are being done at this time.
My question is not really what to do with the PropertyInformation table
(although I'm open to suggestions), it's what to do with the Measurement
information -- should I leave all measurement information in one table,
requiring 2 fields for Measurements 5 and 6 because there will be
information on both, or should I split out the CorporateMeasurements and the
ResidentialMeasurements? I'm concerned that down the road the measurement
information will change, and it will become more important what properttype
that came from. If I split it out, then my calculations become more
complicated -- do I relate each calculation to the ID of both tables, or do
I fall back on the PropertyInformation to begin with? Or should I split out
only the duplicated fields, then the calculation table would still need to
pull information from both measurement tables...?
I hope this all makes sense, I suspect I may simply have to choose one way
and then stick with it. Any thoughts?--BEGIN PGP SIGNED MESSAGE--
Hash: SHA1
I'd set up the PropertyMeasurement table like this:
CREATE TABLE PropertyMeasurements (
PropertyInformationID INTEGER NOT NULL
REFERENCES PropertyInformation ,
MeasureTypeID TINYINT NOT NULL
REFERENCES MeasureTypes ,
Measure SMALLINT NOT NULL ,
CONSTRAINT PK_PM PRIMARY KEY (PropertyInformationID, MeasureType)
)
I'm not sure where the PropertyInformationID came from, but guessed the
PropertyInformation table. The PK allows only one MeasureType per
PropertyInformationID. If you want to allow more than one MeasureType
per PropertyInformationID you will have to add another attribute to the
table, like a date column.
You didn't say what type of metric unit would be used for the Measure so
I just put SMALLINT. Change to whatever data type you require.
To allow the further expansion of measurement types you should have a
table of MeasureTypes:
CREATE TABLE MeasureTypes (
MeasureTypeID TINYINT IDENTITY(1,1) UNIQUE ,
MeasureTypeName VARCHAR(20) NOT NULL PRIMARY KEY
)
I wouldn't have a calculation table; rather, I'd have a view or stored
procedure to return those calculations.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/ AwUBQjCstIechKqOuFEgEQIO+ACbBGgH6AnoXuC1
kmWwAvoJ1uzEQX0Aniuj
3NTuWjMlvl+f8EDFzU9op+bA
=Wmkm
--END PGP SIGNATURE--
Iams wrote:
> I have a bunch of data related to a property. On that property, we have
> several measurement requirements to perform several calculations. For
> instance, I may have data that currently am planning to set up as follows:
> PropertyInformation table:
> PropertyAddressID, ResidentialPropertyTypeID, PropertyOwner,
> CorporatePropertyTypeID
> PropertyMeasurement table
> PropertyInformationID
> Measurement1 (related to Corporate property only)
> Measurement 2 (related to Corporate property only)
> Measurement 3 (related to Residential property only)
> Measurement 4 (related to Residential property only)
> Measurement 5 (related to both Corporate and Residential)
> Measurement 6 (related to both Corporate and Residential)
> Calculation table:
> PropertyMeasurementID (FK)
> Total (result of Measurements 2, 4, 5, 6)
> Date (date calculation done)
> In order to perform the final calculations, we must have one residential
> property type and one corporate type (which comes from other lookup tables
.
> I originally was going to base the 2 latter tables on the
> PropertyInformation; however, we may not have any property information
> whatsoever when the measurements are recorded, all we know is we have one
> ResidentialPropertyType and one CorporatePropertyType, but we may not even
> know what that type is. My thought is to force an "Unknown" for property
> type for the ResidentialPropertyTypeID (the CorporatePropertyTypeID is the
> only information we collect on the property, all other fields in that tabl
e
> relate to the ResidentialProperty, but the combination of the Corporate an
d
> Residential measurements are required for the calculations). And we may
> have Property data but no calculations are being done at this time.
> My question is not really what to do with the PropertyInformation table
> (although I'm open to suggestions), it's what to do with the Measurement
> information -- should I leave all measurement information in one table,
> requiring 2 fields for Measurements 5 and 6 because there will be
> information on both, or should I split out the CorporateMeasurements and t
he
> ResidentialMeasurements? I'm concerned that down the road the measurement
> information will change, and it will become more important what properttyp
e
> that came from. If I split it out, then my calculations become more
> complicated -- do I relate each calculation to the ID of both tables, or d
o
> I fall back on the PropertyInformation to begin with? Or should I split o
ut
> only the duplicated fields, then the calculation table would still need to
> pull information from both measurement tables...?
> I hope this all makes sense, I suspect I may simply have to choose one way
> and then stick with it. Any thoughts?

How to Set Thousand Separator?

Hi,
This topic has been raised a few time in the newsgroup and the solution
has been to set the 'Langauge' property of the report.
In my report, I can't find the Language propertie, neither in the
properties from he menu in VS nor in the Property Grid.
Can anyone point me in the right direction?
Thanks,
DomDom, in the properties pane (press F4 if you can't see it) there is a
drop-down list at the top where you can select objects. Use this and
choose 'Report' and in the 'Misc' properties section you'll see
Language.
If you want to default new reports to your Windows Language, you can do
Tools|Options|Environment|General|International Settings and change it
to 'Same as Office'. This affects anything you do in VS/VB though.
Chris
DominicB wrote:
> Hi,
> This topic has been raised a few time in the newsgroup and the
> solution has been to set the 'Langauge' property of the report.
> In my report, I can't find the Language propertie, neither in the
> properties from he menu in VS nor in the Property Grid.
> Can anyone point me in the right direction?
> Thanks,
> Dom|||Ace, Chris!
Cheers,
Dom
Chris McGuigan wrote:
> Dom, in the properties pane (press F4 if you can't see it) there is a
> drop-down list at the top where you can select objects. Use this and
> choose 'Report' and in the 'Misc' properties section you'll see
> Language.
> If you want to default new reports to your Windows Language, you can do
> Tools|Options|Environment|General|International Settings and change it
> to 'Same as Office'. This affects anything you do in VS/VB though.
> Chris
> DominicB wrote:
> > Hi,
> > This topic has been raised a few time in the newsgroup and the
> > solution has been to set the 'Langauge' property of the report.
> >
> > In my report, I can't find the Language propertie, neither in the
> > properties from he menu in VS nor in the Property Grid.
> >
> > Can anyone point me in the right direction?
> >
> > Thanks,
> > Dom

How to set the Timeout and Timeoutspecified property?

Hi all
We are getting a 'Operation Timedout' error when trying to render a report
as pdf. Will setting the Timeout and Timeoutspecified property will help
resolve this issue. Based on some criteria this report can take long time.
Also I cant find how to set the timeout and timeoutspecified property?
Please help
Thanks
RahulI think for a report you can set the timeout in the report
manager.
>--Original Message--
>Hi all
>We are getting a 'Operation Timedout' error when trying
to render a report
>as pdf. Will setting the Timeout and Timeoutspecified
property will help
>resolve this issue. Based on some criteria this report
can take long time.
>Also I cant find how to set the timeout and
timeoutspecified property?
>Please help
>Thanks
>Rahul
>
>.
>

How to set QuotedIdentifier property off or on for existing table

Hi All,
How to set QuotedIdentifier property off or on for existing table. I tried
like
SET QuotedIdentifier off.
But the property is not chnaging.
Any idea?
Thanks in advance.
Supriya.Hi
This property is set when you create the table e.g
USE TEMPDB
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE TABLE tablquoteoff ( id int not null )
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE tablquoteon ( id int not null )
GO
SELECT
OBJECTPROPERTY(OBJECT_ID('tablquoteoff'),'IsQuotedIdentOn'),
OBJECTPROPERTY(OBJECT_ID('tablquoteon'),'IsQuotedIdentOn')
John
"Supriya Pagadala" wrote:
> Hi All,
> How to set QuotedIdentifier property off or on for existing table. I tried
> like
> SET QuotedIdentifier off.
> But the property is not chnaging.
> Any idea?
> Thanks in advance.
> Supriya.
>
>|||Thank for response.
I tried this.
SET QUOTED_IDENTIFIER OFF
GO
CREATE TABLE tablquoteoff ( id int not null )
But QUOTED_IDENTIFIER property of table is always true.
Not getting why it is not updating.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:03B62E37-AB8B-4D00-B9BE-4B7355112689@.microsoft.com...
> Hi
> This property is set when you create the table e.g
> USE TEMPDB
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> CREATE TABLE tablquoteoff ( id int not null )
> GO
> SET QUOTED_IDENTIFIER ON
> GO
> CREATE TABLE tablquoteon ( id int not null )
> GO
> SELECT
> OBJECTPROPERTY(OBJECT_ID('tablquoteoff'),'IsQuotedIdentOn'),
> OBJECTPROPERTY(OBJECT_ID('tablquoteon'),'IsQuotedIdentOn')
>
> John
> "Supriya Pagadala" wrote:
>> Hi All,
>> How to set QuotedIdentifier property off or on for existing table. I
>> tried
>> like
>> SET QuotedIdentifier off.
>> But the property is not chnaging.
>> Any idea?
>> Thanks in advance.
>> Supriya.
>>|||Hello, Supriya
The IsQuotedIdentOn property is only meaningful for stored procedures,
triggers, views and UDF-s. For other types of objects (tables,
constraints, etc) it is always 1.
Razvan|||Hi
The script was to show that the value is taken when the table was created
and will not change with your connection setting. To change this setting I
believe you would need to create a new table and transfer the data.
John
"Supriya Pagadala" wrote:
> Thank for response.
> I tried this.
> SET QUOTED_IDENTIFIER OFF
> GO
> CREATE TABLE tablquoteoff ( id int not null )
> But QUOTED_IDENTIFIER property of table is always true.
> Not getting why it is not updating.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:03B62E37-AB8B-4D00-B9BE-4B7355112689@.microsoft.com...
> > Hi
> >
> > This property is set when you create the table e.g
> >
> > USE TEMPDB
> > GO
> >
> > SET QUOTED_IDENTIFIER OFF
> > GO
> >
> > CREATE TABLE tablquoteoff ( id int not null )
> > GO
> >
> > SET QUOTED_IDENTIFIER ON
> > GO
> >
> > CREATE TABLE tablquoteon ( id int not null )
> > GO
> >
> > SELECT
> > OBJECTPROPERTY(OBJECT_ID('tablquoteoff'),'IsQuotedIdentOn'),
> > OBJECTPROPERTY(OBJECT_ID('tablquoteon'),'IsQuotedIdentOn')
> >
> >
> > John
> >
> > "Supriya Pagadala" wrote:
> >
> >> Hi All,
> >>
> >> How to set QuotedIdentifier property off or on for existing table. I
> >> tried
> >> like
> >>
> >> SET QuotedIdentifier off.
> >>
> >> But the property is not chnaging.
> >>
> >> Any idea?
> >>
> >> Thanks in advance.
> >>
> >> Supriya.
> >>
> >>
> >>
>
>

How to set PageBreakAtEnd of a Table

I use a Table in a report.
I have a parameter PageBreak in the report.
How can I set the PageBreakAtEnd property of a Table to the parameter?Ad,
In the properties of the table you can set this @. the general tab. V for a
pagebreak after this table.
Perry
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OgBGdYf1GHA.4388@.TK2MSFTNGP03.phx.gbl...
>I use a Table in a report.
> I have a parameter PageBreak in the report.
> How can I set the PageBreakAtEnd property of a Table to the parameter?
>

How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005

Hello!

I'ave got a problem of setting more than one Variable in ReadOnlyVariables Property of ScriptComponent...I provide comma separated list of names ( As described in the help ) byt VS Studio Editor can not be opoened claiming that there is no a variablle with such a name...Looks like it doesn't treat the list as a collection of names...

Please help.

Vladimir

Make sure there are no spaces in the list.

Var1,Var2,Var3

This will not work:

Var1, Var2, Var3

Also note that variable names are case sensitive.|||Triple-check your spelling and the scope your variables are defined in. I got the error just this morning and it was a spelling problem.
|||

Thanks for your response...

I verified the spelling got rid of spaces...but result is the same

It is interesting thing.. I have only two variables: One is set on a package level and another is on the Data Flow Task level...

When I set one of them in ReadonlyVariables and another in ReadandWriteVariables it allows me to open VS for Applications. If I move both to the same location ( ReadonLy or ReadAnd Write with comma separation and no spaces ) it issues the message I described...

I tried specifying the namespaces for the variables, but with no Luck...

Not usre what to do...

Any ideas will be greately appreciated...

Thanks,

Vladimir

|||What version of SSIS are you using?

RTM? SP1? SP2?

How to set change color for visited links ?

Hello All,
I have a parameterized report (Report1), which has a field that has 'Jump to
Report' property setup. When the user selects their parameters, Report1
displays, say 10 records displayed, and when the user clicks on the 'Jump to
Report' field of the 2nd record from the displayed 10 records, it displays
the second report (Report2). Now this is what I am looking for....When if
the user wants to go back to Report1, is there anyway to show him - by
changing color - the ones he has already viewed and those ones he didn't?
Please help! Thanks in advance.You would have to pass this state back to the original report via a link
('return to report') and parameter. This would not work if you used the back
button on the browser.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"amma" <amma@.discussions.microsoft.com> wrote in message
news:F4EA3D59-9617-4244-B10E-F98136F88770@.microsoft.com...
> Hello All,
> I have a parameterized report (Report1), which has a field that has 'Jump
> to
> Report' property setup. When the user selects their parameters, Report1
> displays, say 10 records displayed, and when the user clicks on the 'Jump
> to
> Report' field of the 2nd record from the displayed 10 records, it displays
> the second report (Report2). Now this is what I am looking for....When
> if
> the user wants to go back to Report1, is there anyway to show him - by
> changing color - the ones he has already viewed and those ones he didn't?
> Please help! Thanks in advance.
>
>|||Brian, Thanks for the reply. I guess my question was not clear..let me try
to explain this better - I have a link in 'Report2' to 'return to report'
(which is Report1 in my case) and that is working ok. I am actually trying
to change the COLOR of the field that I have already clicked to view the
extended report, so that next time when I go back to that report (report1) I
know which one I haven't viewed and which one I have viewed. sorry if I
confuse you...
Thanks in advance.
"Brian Welcker [MSFT]" wrote:
> You would have to pass this state back to the original report via a link
> ('return to report') and parameter. This would not work if you used the back
> button on the browser.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "amma" <amma@.discussions.microsoft.com> wrote in message
> news:F4EA3D59-9617-4244-B10E-F98136F88770@.microsoft.com...
> > Hello All,
> > I have a parameterized report (Report1), which has a field that has 'Jump
> > to
> > Report' property setup. When the user selects their parameters, Report1
> > displays, say 10 records displayed, and when the user clicks on the 'Jump
> > to
> > Report' field of the 2nd record from the displayed 10 records, it displays
> > the second report (Report2). Now this is what I am looking for....When
> > if
> > the user wants to go back to Report1, is there anyway to show him - by
> > changing color - the ones he has already viewed and those ones he didn't?
> > Please help! Thanks in advance.
> >
> >
> >
> >
>
>