How to show both "ID and Name" in the NemeColumn of a dimension?

Hi All,

When creating a new dimension we are restricted in selecting one coulmn from the table to be shown as the "NameColumn" of the dimension; i need to display both ID and Name from the table as the "NameColumn", how could i do this?

Since in AS 2000 this can be done easily

Thanks,

Ghadeer Omari

Since you want to show ID and name, you have to somehow concatinate them. And there could be multiple ways to do that - with space, with dash, etc. I usually in such cases go to data source views and create named calculations :

FullName: ID + '-' + Name

Then I use new named calculation in name column.

Vidas Matelis

|||

Dear Matelis,

Thanks very much this works.

How to share parameter value between main and subreport?

Hi All,

I am really lousy when it comes to creating reports. So I am seeking your expert advise/experience.

I have a report that uses a stored-procedure as its data source. This procedure has a parameter. Within this report, I created a subreport which also sources to yet another stored-procedure that also has a parameter which expects the same value as the param of the main report.

When I run the report, say in preview mode, I do not want to be prompted with the parameter twice (i.e. once for the main report, and another for the subreport). How can I edit/modify subreport so that in its select or formula it will say something like:

{?@.ParamOfSubReport} = {?@.ParamOfMainReport}

Many thanks in advance.

_msd_You need to use shared variable and you can use it anywhere in the report|||Right click on your sub-report and choose "Change sub-report links".

Example:

"?parameter1" in the main report links to "?Pm-?parameter1" in the sub-report, then choose the field in the datasource that the parameter is tested against.

When you enter the parameter in your main report it will be passed to the sub-report preview also.|||How do I pass a value returned from the stored proc in the main report to the sub report. I'm getting an error "cannot link from stored procedure" when I pass the value from main report to subreport using subreport links.

Immediate response would be appreciated. Thanks.|||Assign value to shared variable and use that in Sub report|||Hi, I saw this old thread and I am working on the same issue. I'm working on a simple dumb shell of a report in Crystal 8.5 as a test for how to pass parameters into a sql server 2000 stored procedure via a subreport. I'd like to deliver this as straight Crystal without using vb or other shells to call the report from.

Eventually I need to modify a copy of a main report with data and about 8 subreports, all pulling from stored procedures using one parameter called ID. I am getting many requests for this ID parameter, for each subreport, even though I am linking the parameters via subreport links.

The subreport wants to link into the stored procedure using the parameter name from the stored procedure, which is @.ID. The main report only wants to give the subreport a subordinate link such as ?Pm-@.ID. I cannot name the stored procedure parameter with a name like ?Pm-@.ID because it violates the rules of transact-sql. It sees the hyphen as a subtraction. I can see the logic of using the same variable names, but how do I get rid of that bothersome hyphen?

I have also tried using shared variables and they connect to the subreport ok, but I'm still not closing the loop by linking into the stored procedure based on the shared variable.

I am trying to use the same information in multiple places without making the user enter the same information over and over again.

Has anyone had this problem before?sql

How to setup a fulltext index?

What is the sql syntax for creating a full text index on a table?
I have a table called bookdata with 20 some fields I would like to
index.
Then how do you construct the queries?
Is it something like 'where contains (colname, 'itemtofind')?
http://www.indexserverfaq.com/SQLFTITSQL.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<sdowney717@.msn.com> wrote in message
news:1110309891.262624.164200@.g14g2000cwa.googlegr oups.com...
> What is the sql syntax for creating a full text index on a table?
> I have a table called bookdata with 20 some fields I would like to
> index.
> Then how do you construct the queries?
> Is it something like 'where contains (colname, 'itemtofind')?
>

How to set relationship level when creating diagram?

lets say I have 3 levels of relational table

Level 1 is the master table

Level 2 has 10 tables and all are children table of level 1

level 3 has 100 tables and all are children of tables in level 2

And I am trying to use MS SQL 2005 to create a diagram.

In SQL2000 I used to able to set the relationship level. For example, if I set the level = 0 it will only add the master table. If I set the level = 1 it will add the master table and those 10 tables links to the master table.... so on so forth.

But now in SQL2005 when I choose "Add related tables" I will have to let those 112 tables all squashed in a tiny 17" screen and it become very unmanagable.

Is there any way I can set the relationship level again in SQL2005?

It appears that we did not implement this behavior. Could you file this as an issue on Microsoft Connect? http://connect.microsoft.com/SQLServer/. We will triage it and let you know if/when we can put it into a future release of the product.

Thanks,

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

How to set connection, Send Parameter and Filter data

Dear all .Netter,

I'm newbie in Reporting Services. I'm able to creating raw Reporting Services reports.

I have these questions to you all :

1. How to change connection to server and database when running in ASP.Net form. Currently in development PC, the server name is ServerA and the Database name is DatabaseA. After i copy to production server, the server name is ServerB and the database name is DatabaseB.

2. How to send parameter to Reporting Services report. I want to show name of user that print the report.

3. How to filter data that will be showed in the Reporting Services. I want to print Invoice with no : INV-2007-0001 and next INV-2007-0002

Sorry, if I'm lazy, but i'm running with time to replace Crystal Reports with Reporting Services.

Thanks and Regards,

Kusno.

These are some great links that will give you any answer you want

http://www.codeproject.com/sqlrs/AHCreatRepsAspNet.asp
http://msdn2.microsoft.com/en-us/library/ms170246.aspx
http://www.codeproject.com/sqlrs/ReportViewer2005.asp

Have Fun

How to set a photo path when creating table

Hi all,
I am doing a project which need to use Microsoft SQL Server 2000 as my
database. Now, I am creating a table, that I need to put in a photo.
So, I am facing a problem of setting the photo path. Can u all give me
some help on it. Thks.
Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
Interface. So, I need to do the database linking between my database in
SQL Server to VB. Can I have the sample code which can do the linking
part. Thks.
Whats photo path?
If you are trying to save an image, use image datatype. or keep it in a
particular folder in server and update the location in database.
Use connection string,
"Driver={SQL Server};Server=ServerName;Database=pubs;Uid=sa;Pwd =asdasd;"
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"jyetying" wrote:

> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>
|||Have a look at this.
http://support.microsoft.com/kb/194975/en-us
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jyetying" <yam_jyet_ying@.hotmail.com> wrote in message
news:1158310229.209741.157910@.p79g2000cwp.googlegr oups.com...
> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>

How to set a photo path when creating table

Hi all,
I am doing a project which need to use Microsoft SQL Server 2000 as my
database. Now, I am creating a table, that I need to put in a photo.
So, I am facing a problem of setting the photo path. Can u all give me
some help on it. Thks.
Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
Interface. So, I need to do the database linking between my database in
SQL Server to VB. Can I have the sample code which can do the linking
part. Thks.Whats photo path?
If you are trying to save an image, use image datatype. or keep it in a
particular folder in server and update the location in database.
Use connection string,
"Driver={SQL Server};Server=ServerName;Database=pubs;
Uid=sa;Pwd=asdasd;
"
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"jyetying" wrote:

> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>|||Have a look at this.
http://support.microsoft.com/kb/194975/en-us
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jyetying" <yam_jyet_ying@.hotmail.com> wrote in message
news:1158310229.209741.157910@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>

How to set a photo path when creating table

Hi all,
I am doing a project which need to use Microsoft SQL Server 2000 as my
database. Now, I am creating a table, that I need to put in a photo.
So, I am facing a problem of setting the photo path. Can u all give me
some help on it. Thks.
Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
Interface. So, I need to do the database linking between my database in
SQL Server to VB. Can I have the sample code which can do the linking
part. Thks.Whats photo path?
If you are trying to save an image, use image datatype. or keep it in a
particular folder in server and update the location in database.
Use connection string,
"Driver={SQL Server};Server=ServerName;Database=pubs;Uid=sa;Pwd=asdasd;"
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"jyetying" wrote:
> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>|||Have a look at this.
http://support.microsoft.com/kb/194975/en-us
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jyetying" <yam_jyet_ying@.hotmail.com> wrote in message
news:1158310229.209741.157910@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>

How to send notification to .aspx page...

... as far as I understand, I need to create a custom HTTP protocol. Where do get an example of this? Shyam's book has an example of creating custom protocol that is not HTTP based. There are few remarks on HTTP custom protocol in Chapter 10, but those are not very helpful.

The scenario it is used for is as follows: ASP.NET messenger (an .aspx page) writes messages into SQL server table. The page needs to get notified as soon as new entry appears in the table (from another instance of messenger), so that the first instance of messenger would be able to get new message from the table. Is this appropriate usage of notification services? If not, can you suggest alternative ways to write ASP.NET messenger?

Thank you in advance.

Is this a kinda IM application ? If so NS is not a right choice for Real Time Communication I would prefer to explore RTC (Real Time CommunicationI API with MS Live Communication Server. These two works well for any IM/Messaging related application.

If you mention ur requirements in detail (what do u mean by message etc) i will be more clear... thanks

--Satyen

|||

Query Notifications may be a better technology choice for you in this application.

HTH...

Joe

How to send notification to .aspx page...

... as far as I understand, I need to create a custom HTTP protocol. Where do get an example of this? Shyam's book has an example of creating custom protocol that is not HTTP based. There are few remarks on HTTP custom protocol in Chapter 10, but those are not very helpful.

The scenario it is used for is as follows: ASP.NET messenger (an .aspx page) writes messages into SQL server table. The page needs to get notified as soon as new entry appears in the table (from another instance of messenger), so that the first instance of messenger would be able to get new message from the table. Is this appropriate usage of notification services? If not, can you suggest alternative ways to write ASP.NET messenger?

Thank you in advance.

Is this a kinda IM application ? If so NS is not a right choice for Real Time Communication I would prefer to explore RTC (Real Time CommunicationI API with MS Live Communication Server. These two works well for any IM/Messaging related application.

If you mention ur requirements in detail (what do u mean by message etc) i will be more clear... thanks

--Satyen

|||

Query Notifications may be a better technology choice for you in this application.

HTH...

Joe

How to send notification to .aspx page...

... as far as I understand, I need to create a custom HTTP protocol. Where do get an example of this? Shyam's book has an example of creating custom protocol that is not HTTP based. There are few remarks on HTTP custom protocol in Chapter 10, but those are not very helpful.

The scenario it is used for is as follows: ASP.NET messenger (an .aspx page) writes messages into SQL server table. The page needs to get notified as soon as new entry appears in the table (from another instance of messenger), so that the first instance of messenger would be able to get new message from the table. Is this appropriate usage of notification services? If not, can you suggest alternative ways to write ASP.NET messenger?

Thank you in advance.

Is this a kinda IM application ? If so NS is not a right choice for Real Time Communication I would prefer to explore RTC (Real Time CommunicationI API with MS Live Communication Server. These two works well for any IM/Messaging related application.

If you mention ur requirements in detail (what do u mean by message etc) i will be more clear... thanks

--Satyen

|||

Query Notifications may be a better technology choice for you in this application.

HTH...

Joe