How can I change the Subreport dynamically.

How can I change the Subreport dynamically. i.e at design time I have
mentioned a name for subreport but I need to change the subreport based on
one of the field value in my main report. How can I achive this'
--
vvOn Nov 19, 3:26 am, Xinxu <prajithpra...@.hotmail.com> wrote:
> How can I change the Subreport dynamically. i.e at design time I have
> mentioned a name for subreport but I need to change the subreport based on
> one of the field value in my main report. How can I achive this'
> --
> vv
You can either try using drill through instead of a subreport and use
an expression based on a field in the main report -or- create the
report programmatically based on some specific data, which would be
more work but allow for more flexibility. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

How can I change a column with datatype "text" to "int"?

I made a mistake when I first created the column and just found out when I
tried to calculate. I tried using the design feature on Enterprise Manager,
but got an error message that this couldn't be done. Any help is deeply
appreciate.Don't use Enterprise Manager for this. Open Query Analyzer and connect to
the correct database.
-- add a new column to the table;
ALTER TABLE tablename ADD temp_column INT;
-- copy the data from the text column;
UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
= 1;
-- drop the text column;
ALTER TABLE tablename DROP COLUMN text_column;
-- rename the new column;
EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
Of course, you'll want to put in the correct names for tablename,
text_column, real_column, etc.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>I made a mistake when I first created the column and just found out when I
> tried to calculate. I tried using the design feature on Enterprise
> Manager,
> but got an error message that this couldn't be done. Any help is deeply
> appreciate.|||Thank you, Aaaron. I will use what you provided and make the change. Thanks
mucho. karolus
"Aaron Bertrand [SQL Server MVP]" wrote:
> Don't use Enterprise Manager for this. Open Query Analyzer and connect to
> the correct database.
> -- add a new column to the table;
> ALTER TABLE tablename ADD temp_column INT;
> -- copy the data from the text column;
> UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
> = 1;
> -- drop the text column;
> ALTER TABLE tablename DROP COLUMN text_column;
> -- rename the new column;
> EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
> Of course, you'll want to put in the correct names for tablename,
> text_column, real_column, etc.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Karolus" <Karolus@.discussions.microsoft.com> wrote in message
> news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
> >I made a mistake when I first created the column and just found out when I
> > tried to calculate. I tried using the design feature on Enterprise
> > Manager,
> > but got an error message that this couldn't be done. Any help is deeply
> > appreciate.
>
>

How can I change a column with datatype "text" to "int"?

I made a mistake when I first created the column and just found out when I
tried to calculate. I tried using the design feature on Enterprise Manager,
but got an error message that this couldn't be done. Any help is deeply
appreciate.
Don't use Enterprise Manager for this. Open Query Analyzer and connect to
the correct database.
-- add a new column to the table;
ALTER TABLE tablename ADD temp_column INT;
-- copy the data from the text column;
UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
= 1;
-- drop the text column;
ALTER TABLE tablename DROP COLUMN text_column;
-- rename the new column;
EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
Of course, you'll want to put in the correct names for tablename,
text_column, real_column, etc.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>I made a mistake when I first created the column and just found out when I
> tried to calculate. I tried using the design feature on Enterprise
> Manager,
> but got an error message that this couldn't be done. Any help is deeply
> appreciate.
|||Thank you, Aaaron. I will use what you provided and make the change. Thanks
mucho. karolus
"Aaron Bertrand [SQL Server MVP]" wrote:

> Don't use Enterprise Manager for this. Open Query Analyzer and connect to
> the correct database.
> -- add a new column to the table;
> ALTER TABLE tablename ADD temp_column INT;
> -- copy the data from the text column;
> UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
> = 1;
> -- drop the text column;
> ALTER TABLE tablename DROP COLUMN text_column;
> -- rename the new column;
> EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
> Of course, you'll want to put in the correct names for tablename,
> text_column, real_column, etc.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Karolus" <Karolus@.discussions.microsoft.com> wrote in message
> news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>
>

How can I change a column with datatype "text" to "int"?

I made a mistake when I first created the column and just found out when I
tried to calculate. I tried using the design feature on Enterprise Manager,
but got an error message that this couldn't be done. Any help is deeply
appreciate.Don't use Enterprise Manager for this. Open Query Analyzer and connect to
the correct database.
-- add a new column to the table;
ALTER TABLE tablename ADD temp_column INT;
-- copy the data from the text column;
UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
= 1;
-- drop the text column;
ALTER TABLE tablename DROP COLUMN text_column;
-- rename the new column;
EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
Of course, you'll want to put in the correct names for tablename,
text_column, real_column, etc.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>I made a mistake when I first created the column and just found out when I
> tried to calculate. I tried using the design feature on Enterprise
> Manager,
> but got an error message that this couldn't be done. Any help is deeply
> appreciate.|||Thank you, Aaaron. I will use what you provided and make the change. Thank
s
mucho. karolus
"Aaron Bertrand [SQL Server MVP]" wrote:

> Don't use Enterprise Manager for this. Open Query Analyzer and connect to
> the correct database.
> -- add a new column to the table;
> ALTER TABLE tablename ADD temp_column INT;
> -- copy the data from the text column;
> UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column
)
> = 1;
> -- drop the text column;
> ALTER TABLE tablename DROP COLUMN text_column;
> -- rename the new column;
> EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
> Of course, you'll want to put in the correct names for tablename,
> text_column, real_column, etc.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Karolus" <Karolus@.discussions.microsoft.com> wrote in message
> news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>
>

How can I alter the parameters pane design?

Hi all,
I was wondering if it's possible to somehow change the parameters pane
design. My problem is that some of the reports we write are in right-
to-left languages (hebrew, arabic). We can change the whole report so
it's right-to-left, but the parameters stick to the left.
Is there any way I can change this?
Thanks in advance,
R. GreenI don't believe there is a good way to do it.
you can write your own parameter controls and just interface RS with
SOAP calls.
people who need to use asp 1.1(no report viewer control) have had to
do this for instance.|||Hi Tom,
Thanks for your prompt answer.
I didn't think there's a way to do it too, until I saw Reporting
Services 2000 and the parameters *were* right-to-left when viewing a
hebrew report.
Perhaps I can somehow use CSS to change the parameters pane design?
On Jul 3, 10:16 pm, tomk...@.gmail.com wrote:
> I don't believe there is a good way to do it.
> you can write your own parameter controls and just interface RS with
> SOAP calls.
> people who need to use asp 1.1(no report viewer control) have had to
> do this for instance.sql

How can I add pictures to my database filed in design view?

I have a database called 'Objects' which has many field. One of its fields is called 'Image' and has a data type image.

I want to add pictures to each one of my records offline, is this possible?

i.e. by copying the address from my C drive such as C:\Documents and Settings\fseyedarabi\My Documents\My Pictures

Hi,

From your description, it seems that you want to upload your local image file to the image field in your database, right?

If so, I suggest that you can refer the FileUpload class, The FileUpload class displays a text box control and a browse button that allow users to select a file on the client and upload it to the Web server. The user specifies the file to upload by entering the full path to the file on the local computer (for example, C:\MyFiles\FileName) in the text box of the control. Alternately, the user can select the file by clicking the Browse button, and then locating it in the Choose File dialog box.

After that, just read the file into binary format and save it into the corresponding data filed of your database.

For more information, see:
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.fileupload(VS.80).aspx

Thanks.

How are LOB columns handeled in sqlserver

Hi ,
I am new to sqlserver family.
when doing the database design , i have the following question.
let's say we have emp table which have empid,empname,deptno,
as well as empPicture, empGreeting, empFamilyPict.
Should we store all the lob columns(empPicture, empGreeting, empFamilyPict)
in a seperate table . what is the best practice for sqlserver 2000 & 2005.
The oracle DB takes care of LOB if it is > 4000 bytes
(ie)when you use clobs, they are moved out of the table into their own
segment when they exceed 4000 bytes, the work is done for you, no need to
factor them out
special.
similarly for Bfiles which is always external.
How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
fashion?
thanks in adv
ThirumaranHi
http://www.aspfaq.com/show.asp?id=2149
"thirumaran" <thirumaran@.discussions.microsoft.com> wrote in message
news:530AF331-165C-411D-915D-22D37A78EDC0@.microsoft.com...
> Hi ,
> I am new to sqlserver family.
> when doing the database design , i have the following question.
> let's say we have emp table which have empid,empname,deptno,
> as well as empPicture, empGreeting, empFamilyPict.
> Should we store all the lob columns(empPicture, empGreeting,
> empFamilyPict)
> in a seperate table . what is the best practice for sqlserver 2000 & 2005.
> The oracle DB takes care of LOB if it is > 4000 bytes
> (ie)when you use clobs, they are moved out of the table into their own
> segment when they exceed 4000 bytes, the work is done for you, no need to
> factor them out
> special.
> similarly for Bfiles which is always external.
> How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
> fashion?
> thanks in adv
> Thirumaran
>
>
>
>|||In addition to Uri's answer you may want to check out LOB in BooksOnLine
2005. This part answers part of you question for 2005.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/813586f1-edfe-471e-9338-e55e689a1aaa.htm
Andrew J. Kelly SQL MVP
"thirumaran" <thirumaran@.discussions.microsoft.com> wrote in message
news:530AF331-165C-411D-915D-22D37A78EDC0@.microsoft.com...
> Hi ,
> I am new to sqlserver family.
> when doing the database design , i have the following question.
> let's say we have emp table which have empid,empname,deptno,
> as well as empPicture, empGreeting, empFamilyPict.
> Should we store all the lob columns(empPicture, empGreeting,
> empFamilyPict)
> in a seperate table . what is the best practice for sqlserver 2000 & 2005.
> The oracle DB takes care of LOB if it is > 4000 bytes
> (ie)when you use clobs, they are moved out of the table into their own
> segment when they exceed 4000 bytes, the work is done for you, no need to
> factor them out
> special.
> similarly for Bfiles which is always external.
> How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
> fashion?
> thanks in adv
> Thirumaran
>
>
>
>

How are LOB columns handeled in sqlserver

Hi ,
I am new to sqlserver family.
when doing the database design , i have the following question.
let's say we have emp table which have empid,empname,deptno,
as well as empPicture, empGreeting, empFamilyPict.
Should we store all the lob columns(empPicture, empGreeting, empFamilyPict)
in a seperate table . what is the best practice for sqlserver 2000 & 2005.
The oracle DB takes care of LOB if it is > 4000 bytes
(ie)when you use clobs, they are moved out of the table into their own
segment when they exceed 4000 bytes, the work is done for you, no need to
factor them out
special.
similarly for Bfiles which is always external.
How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
fashion?
thanks in adv
ThirumaranHi
http://www.aspfaq.com/show.asp?id=2149
"thirumaran" <thirumaran@.discussions.microsoft.com> wrote in message
news:530AF331-165C-411D-915D-22D37A78EDC0@.microsoft.com...
> Hi ,
> I am new to sqlserver family.
> when doing the database design , i have the following question.
> let's say we have emp table which have empid,empname,deptno,
> as well as empPicture, empGreeting, empFamilyPict.
> Should we store all the lob columns(empPicture, empGreeting,
> empFamilyPict)
> in a seperate table . what is the best practice for sqlserver 2000 & 2005.
> The oracle DB takes care of LOB if it is > 4000 bytes
> (ie)when you use clobs, they are moved out of the table into their own
> segment when they exceed 4000 bytes, the work is done for you, no need to
> factor them out
> special.
> similarly for Bfiles which is always external.
> How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
> fashion?
> thanks in adv
> Thirumaran
>
>
>
>|||In addition to Uri's answer you may want to check out LOB in BooksOnLine
2005. This part answers part of you question for 2005.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/813586f1-edfe-471e-9338-e55e
689a1aaa.htm
Andrew J. Kelly SQL MVP
"thirumaran" <thirumaran@.discussions.microsoft.com> wrote in message
news:530AF331-165C-411D-915D-22D37A78EDC0@.microsoft.com...
> Hi ,
> I am new to sqlserver family.
> when doing the database design , i have the following question.
> let's say we have emp table which have empid,empname,deptno,
> as well as empPicture, empGreeting, empFamilyPict.
> Should we store all the lob columns(empPicture, empGreeting,
> empFamilyPict)
> in a seperate table . what is the best practice for sqlserver 2000 & 2005.
> The oracle DB takes care of LOB if it is > 4000 bytes
> (ie)when you use clobs, they are moved out of the table into their own
> segment when they exceed 4000 bytes, the work is done for you, no need to
> factor them out
> special.
> similarly for Bfiles which is always external.
> How does Sqlserver 2000 & 2005 handle this . Both handle LOB's in similar
> fashion?
> thanks in adv
> Thirumaran
>
>
>
>

Hotfix for article 831997

How can I obtain the Hotfix noted in Article 831997.
After I applied 8.00.0859, I am now getting the
error "Invalid Cursor State" when in design mode of the
Enterprise Manager.
Thanks!
Did you actually need to apply 8.00.859? I've found that in most cases
people applied this hotfix merely because it was available to the general
public. The reason hotfixes aren't announced and made more readily
accessible is because they aren't fully regression tested, and aren't immune
to issues like this one.
In any case, you can get 878 from http://support.microsoft.com/?kbid=838166
...
Also, see http://www.aspfaq.com/2515 ... if you stop using Enterprise
Manager for data/schema manipulation, amazingly, the invalid cursor state
error goes away.
http://www.aspfaq.com/
(Reverse address to reply.)
"Troy Anderson" <tanderso@.sonoma-county.org> wrote in message
news:2817301c46384$d0604720$a301280a@.phx.gbl...
> How can I obtain the Hotfix noted in Article 831997.
> After I applied 8.00.0859, I am now getting the
> error "Invalid Cursor State" when in design mode of the
> Enterprise Manager.
> Thanks!
|||If you are needing a hotfix, you'd best contact Microsoft PSS Support and
ask for the hotfix. Hotfixes are grace (free) cases.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Hotfix for article 831997

How can I obtain the Hotfix noted in Article 831997.
After I applied 8.00.0859, I am now getting the
error "Invalid Cursor State" when in design mode of the
Enterprise Manager.
Thanks!Did you actually need to apply 8.00.859? I've found that in most cases
people applied this hotfix merely because it was available to the general
public. The reason hotfixes aren't announced and made more readily
accessible is because they aren't fully regression tested, and aren't immune
to issues like this one.
In any case, you can get 878 from http://support.microsoft.com/?kbid=838166
...
Also, see http://www.aspfaq.com/2515 ... if you stop using Enterprise
Manager for data/schema manipulation, amazingly, the invalid cursor state
error goes away.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Troy Anderson" <tanderso@.sonoma-county.org> wrote in message
news:2817301c46384$d0604720$a301280a@.phx.gbl...
> How can I obtain the Hotfix noted in Article 831997.
> After I applied 8.00.0859, I am now getting the
> error "Invalid Cursor State" when in design mode of the
> Enterprise Manager.
> Thanks!|||If you are needing a hotfix, you'd best contact Microsoft PSS Support and
ask for the hotfix. Hotfixes are grace (free) cases.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Hotfix for article 831997

How can I obtain the Hotfix noted in Article 831997.
After I applied 8.00.0859, I am now getting the
error "Invalid Cursor State" when in design mode of the
Enterprise Manager.
Thanks!Did you actually need to apply 8.00.859? I've found that in most cases
people applied this hotfix merely because it was available to the general
public. The reason hotfixes aren't announced and made more readily
accessible is because they aren't fully regression tested, and aren't immune
to issues like this one.
In any case, you can get 878 from http://support.microsoft.com/?kbid=838166
...
Also, see http://www.aspfaq.com/2515 ... if you stop using Enterprise
Manager for data/schema manipulation, amazingly, the invalid cursor state
error goes away.
http://www.aspfaq.com/
(Reverse address to reply.)
"Troy Anderson" <tanderso@.sonoma-county.org> wrote in message
news:2817301c46384$d0604720$a301280a@.phx
.gbl...
> How can I obtain the Hotfix noted in Article 831997.
> After I applied 8.00.0859, I am now getting the
> error "Invalid Cursor State" when in design mode of the
> Enterprise Manager.
> Thanks!|||If you are needing a hotfix, you'd best contact Microsoft PSS Support and
ask for the hotfix. Hotfixes are grace (free) cases.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.