Two Different Addresses In The Navigation Pane?

Sep 14, 2007

I have a report with a Matrix table. When it€™s fully populated I have 5 rows. These rows are different categories in a CRM system. In these categories there are a lot of Opportunities listed. The thing here is that category 1-4 exist in one table, really a view, and category 5 exist in another different view. So to gather all the information into one single Matrix table to later have subtotals and stuff I just made a little Union of the two select queries.

Now one the column in the table is of course Topic. And from here my client wants to be linked to the right CRM card. The problem I have encountered is that how can I have to different addresses on one single cell in the table?

In the Navigation pane in the cell that corresponds to the Topic, for now I have an address like this:
=string.Format("http://{0}/SFA/opps/edit.aspx?id={1}", Parameters!srv.Value, Fields!objectid.Value)

What I need to change when it€™s a category 5 Opportunity is €œopps€? to €œcat5€?and add €œ&etc=10008€? to the end of the address. Any ideas?

PS. {0} and {1} are parameters, one server parameter and one opportunity ID parameter.

Kind Regards

View 3 Replies


ADVERTISEMENT

Load A Text File With Email Addresses And Compare Against A Database Table That Has Email Addresses And User_id

Jul 12, 2007

Hello ALL



what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.



I also want to update some users using a different text file.



Please help me with the best way to do this



Thanks in advance

View 6 Replies View Related

Can't See All Tables In Entities Pane

Dec 22, 2006

Why is it that only SOME of the tables in my database show up in the Entities pane?

There are a total of six tables in my database, yet only three of them are available to me in the Entities pane. I have looked at permissions, etc, and I am using the SA account. It seems like I should see either ALL or NONE of the tables, but that is not the case.

What am I missing?

View 1 Replies View Related

Unable To Edit Row In Results Pane

Jun 11, 2007

When I change some data in a row in my Results Pane and hit enter, I receive a message that "Data has changed since the Results pane was last retrieved." I click the yes button to "commit your changes to the database anyway," but then I get an error message telling me that my row was not updated. The message says "Error Message: The updated row has changed or been deleted since data was last retrieved. Correct the errors and retry or press ESC to cancel the change(s)." This time, the only option I have is to click the OK button. Can anyone give me some idea as to what I need to do to be able to update the row data in this way? Thanks.

View 11 Replies View Related

Grid Pane In The Table In Enterprise Manager

Jan 13, 2004

HI
When you right click open table to return all rows, click on the "Show/Hide Grid pane" icon . When you click on any row the first column called "Column" a dropdown shows all the filed names of that particular table.
This feature used to work fine untill recently wherein when I click on the column, I don't get to see all the filed names but now it just shows TableName.* i.e. all columns.
This is the case when I try to create a view in enterprise manager also. When you add a table to create a view, I cannot see all the filed names . I'm not sure what to do , to get the field names to appear? Is it some kind of setting in enterprise manager.
All the info would be appreciated.
Ta
N

View 2 Replies View Related

2005 Management Studio Results Pane

Feb 8, 2007

Is there any way to have the results pane auto hide ? Im lazy and dont want to manually (ctl-R) hide each time i run something, then starting writing code again

View 1 Replies View Related

Document Map Pane Refreshing ENTIRE Page!

Jul 10, 2006

I am using the ReportViewer control with SRS2005. I have an extremely large report (243 pages) - however. It takes an extremely long time to load the report as well as populate the document map pane.

When one clicks a link in the document map pane, it refreshes the entire page - and thus causes the report to take another 2-3min to repopulate the document map.

However, if I were to access the Report Server directly, clicking a link only causes the main content page to be refreshed.

This is a substantial difference between selectively refreshing as opposed to refreshing the ENTIRE page and hence taking 2-3min between links.

I am defining the report as:

<rsweb:ReportViewer ID="rvMain" runat="server" AsyncRendering="true" ProcessingMode="Remote" ShowParameterPrompts="False" OnPageNavigation="rvMain_PageNavigation" Width="100%" Height="800px" DocumentMapCollapsed="False" DocumentMapWidth="300px">
</rsweb:ReportViewer>

View 1 Replies View Related

Report Builder, Getting Started Pane: OK Greyed Out

Sep 26, 2007



Hi all,

I'm working on a new SSRS implementation, and have created a Report Model against an SSAS database. I launced Report Builder and can see and select the model in the list, but the OK button at the bottom of the pane is greyed out so I'm unable to actually start building a report against it. Any ideas on what I need to change to make the button work? I have already verified that I have full access to the data source as well as the model, in addition to the underlying SSAS DB, so I don't believe it is a permissions issue... But I'm certainly open to any suggestions.


Thanks!

View 3 Replies View Related

Filters &&amp; Parameters Pane Missing In MDX Query Designer

Mar 13, 2007

I'm developing my first Analysis Server report in SRS. Everything was going well when I discovered the filters & parameters pane was missing in the MDX Query Designer in data mode. I have my columns and rows but need to drag a dimension into the filters & parameters pane in MDX Query Designer and set a filter and parameter on it. Any idea how to make it viewable?

View 1 Replies View Related

No Parameter Pane When Reporting In 2005 Against A 2000 AS Cube

Sep 26, 2007

I have this strange issue.

VS2005
SSRS2005
SSAS2000 cube based on data from SQL 2005 database

When i connect to the SSAS cube and create a dataset in a SSRS 2005 report i do not get a parameter pane.
Also, if i right click on a dimension & select "Add to filter" i get the following error message

"Object reference not set to an instance of an object"

It's not my installation of SQL 2005, as I can connect to an SSAS2005 cube and get the filter/parameter pane and do not get the error message. Parameters work fine.

Have i come across a known issue when reporting on SQL 2005 versus a SQL 2000 AS Cube... or can someone shed some light on the issue for me....

If someone can tell me how to display screenshots I can add them to a post

Thanks

Will

View 3 Replies View Related

View Diagram Pane - How Save Layout After I Change It? 2000

Jul 23, 2005

Hello --Is there a way to configure 2000 so it will save a view layout after Ichange it in the diagram pane?Thanks for any help.Larry Mehl

View 2 Replies View Related

VS Built-in Query Builder - Not Possible To Save Diagram Pane Content

Feb 18, 2008

I have VS2008 Express and I am using Sql Server Compact Edition 3.5 which is distributed with it.

As I experienced, there is no possibility to use this database from Sql Server Management Studio (because it is version 3.5 and Management Studio demands version 3.1).

So, the only possibility to design a query is to use the built in Query Builder in Visual Studio Express. This query builder does not save the Diagram Pane content layout. I mean, when a query has 10 tables, I place these tables in the Diagram Pane in some order that makes sense (e.g. to make all relations visible). After saving and reopening the query in Query Builder, all tables are on the left side, in a complete disorder.

Is it possible to somehow save the Diagram Pane content along with the SQL ??

View 1 Replies View Related

IP Addresses

Sep 7, 2005

I'm trying to connect to a local instance of SQL Server using an IP address and its not working. When I looked up the connect string, it shows only the IP address replacing the Server name, not the instance name, i.e. Server=127.0.0.1 - how does it know which instance to use?
Can I use the 127.0.0.1 loopback address for the server (as its on a local machine)?
Do I have to use 'Network Library = DBMSSOCN' to tell the client to use TCP/IP?
(TCP/IP is showing as an enabled protocol in the Client Network Utility)

View 6 Replies View Related

Many Addresses In A Database

Mar 15, 2004

I need to allow for many addresses in my database for each client that is entered. I'm looking for suggestions on how I should handle this. I will need to do mailings to the clients and will need a way to select the address record that the client indicates as the mailing place.

Thanks for any thoughts.

View 2 Replies View Related

SQL Server 7 - IP Addresses

Feb 16, 2001

Morning all!

A quick question for you all, We will be changing the IP address of our SQL 7's server sometime next week. Does any1 know of any issues/problems that could occur if we do so?

Thanks in advance for any and all help

Gurmi

View 2 Replies View Related

Update Bad Addresses

Jan 27, 2007

I got got a pile of bad email addresses to update in our SQL database.I know how to do this for individual records using the update command.Is there a way to execute an update using the list of addresses in anexcel spreadsheet or some other form of list? This kind of scriptingis new territory for me.

View 5 Replies View Related

Replication And IP Addresses

Jan 5, 2007

I want to replicate between 2 servers not on the same network. One has to be addressed by IP. Currently replication does not support IPs - anyone have a workaround. Will this be resolved in the future? Seems this is a pretty common scenario if your db is on a hosted site.

-cg

View 1 Replies View Related

SQL Enterprise Manager Version 8.0 Up-DO YOU WANT TO PROLONG YOUR WORK WITH THE RESULTS PANE AND CONTINUE TO CONSUME RESOURCES

Apr 23, 2007

After opening the Results Pane (though a query or open table); I frequently get the below message.



Is there any way to change the settings so the results pane will stay active for a long length of time?



Message



SQL Server Enterprise Manager

_______________________



Some time ago, you retrieved data from the database with the query or view whose name is XXXX. The returned rows appear in the Results Pane and the database continues to retain the result set in its local memory; which consumes valuable server resources. Because you have not recently used the Results pane, it will be AUTOMATICALLY CLEARED IN ONE MINUTE. The will empty the results pane, discard unsaved changes, and free resources on the database server. Then if you want to REESTABLISH the result set, you can rerun the query or view.



DO YOU WANT TO PROLONG YOUR WORK WITH THE RESULTS PANE AND CONTINUE TO CONSUME RESOURCES ON THE DATABASE SERVER?

--------------------------------------------------------------------

I want this to default to Yes, without this message comming up and if I don't click yes fast enough, my results are gone. I kinow the work arounds, but how can I default this to Yes or so this message stops displaying.



Thank you



watxnd@hotmail.com





View 1 Replies View Related

Registering Servers With IP Addresses

Apr 27, 2000

I hope someone can help me with this problem.
I need to replicate some tables from our store servers
to our corporate server. All of them are 6.5, and
the corporate server will subscribe and the stores
will publish. I have registered
all of our stores on the corporate server so that I can
enable them for replication.

The problem is that to be able to register them I had to create
a system DSN for ODBC, but that would only work if I used the
IP addresses. Unfortunately, then when I try to enable them
on the corporate server I get an error stating that name (which
is the IP address) is not a valid object identifier.

In ODBC I did actually use a real name (not an IP) for the
name, a normal description, and the IP is in the Server
field. Is there some way to use an alias? What am I doing wrong?

View 2 Replies View Related

Remove Duplicate Addresses For Each IDs

Mar 7, 2014

Below is a raw data with SQL script to create the temp table. This table is a scale down version of what I am working with. I am taking the addresses from several different sources and putting them in a temp table. Now, I need to remove the duplicate addresses for each ID. Duplicate addresses are okay for different IDs.

Raw Data
IDAddr1 CityStateZip
26205 N Main STChicagoIL52147
26205 N Main STChicagoIL52147
2685 Park AveChicagoIL52147
3535 Main StAustinTX78715
35976 Ponco StDallasTX79757
359587 MopacAustinTX78715
4558741 Len LnDaytonFL74717
455518 Spring DrDaytonFL74717
45585 Park AveChicagoIL52147

Desired Result
IDAddr1 CityStateZip
26205 N Main STChicagoIL52147
2685 Park AveChicagoIL52147
3535 Main StAustinTX78715
35976 Ponco StDallasTX79757
359587 MopacAustinTX78715
4558741 Len LnDaytonFL74717
455518 Spring DrDaytonFL74717
45585 Park AveChicagoIL52147

CREATE TABLE #tmpTable(
[ID] Int,
[Addr1] [varchar](15) NULL,
[City] [varchar](9) NULL,
[State] [varchar](2) NULL,

[Code] .....

View 5 Replies View Related

Email Addresses To Outlook

Mar 23, 2007

Is there a way to export a list of email addresses to outlook based on certain query conditions? So for example, lets say using pubs, I want to send out an email to a group of authors who have published only one book. So could I essentailly query for the authors and then have those corresponding authors emails sent to outlook so that I could send out a generic email asking them if they are going to write another book or something like that?

The Yak Village Idiot

View 1 Replies View Related

Changing IP Addresses Of The Cluster

Jan 18, 2008

Hello!

We will be moving our two cluster running SQL Server 2005 64-bit SP2 on Windows 2003 to the different datacenter. IP addressed of both nodes will be changed by DNS names remain the same. I was wondering if anyone had issues with this. Out thought is that we just need to update IPs in Cluster Manager.

Comments are welcome.
Igor

View 2 Replies View Related

Remote Connections From Specified Ip Addresses

Oct 18, 2007



Hi,

Is there any way to ony allow remote access to an instance of SQL Server 2005 from a specific set of ip adresses? (and How To..)

My problem is i only want certain machines to access the server. Any other suggestions to achive this are most welcome.

Thanks for your time

Leroy

View 4 Replies View Related

Add Parameter To Navigation Url

Oct 16, 2006

Add parameter to "navigation" url -

Hello,
I'm trying to add a parameter to my JUMP TO URL but it doesn't work.

basiclly i'm useing javascript there:
javascript:window.open('http:www.a.com?num=XXX');

i want to change the XXX with a value from the dataset.
I tried - javascript:window.open('http:www.a.com?num= + Fields!ME.Value ');
or - javascript:window.open('http:www.a.com?num= & Fields!ME.Value ');
it didn't worked :(

any help?

View 9 Replies View Related

Record Navigation

Jan 5, 2007

I have created a one-page client summary report. My problem is that I can only get the report to show one client and there are many. How do I add record navigation functionality to my report?

View 4 Replies View Related

Navigation From The Header

Mar 16, 2007

Hello

I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions
Thanks

Inder

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

View 4 Replies View Related

Linked Server Oracle Tables - Not Able To Add To Query Designers Show Diagram Pane Via Add Table Dialogue

Apr 18, 2008

I am new to sqlserver.


1)I created a linked server to a oracle database, works fine. Now I am writing queries, using "Query Desgner", when I do a "Add table" linked server tables do not appear. Is this a limitation. I can get around the problem by creating a view.

2) When I use "Microsoft OLE DB Provider for Oracle" for linked server, some times connection seems to get lost. On one occassion, the next day it was fine, it re-established itself.

Any ideas thnx.

View 5 Replies View Related

Select Bad Email Addresses From Table

May 31, 2006

Hi all,
I'm having a bit of an issue with this query. I'm not that familiar with MS SQL so please forgive me.
I'm trying to select the bad email addresses in a table so I can remove them or correct them but I'm not getting any results that are helpfull. Bellow are some of the queries I've tried

select email from person where email != "*@*"
returned all addresses plus null fields.

select email from person where email not like "%@%" (this didn't work at all)

And a few other that are similar
Could somebody please kick me in the right direction.

TIA

Jason

View 10 Replies View Related

Parse Out All Email Addresses In A String

Jul 23, 2013

I have a string like this one in my column

Mike@yahoo.com, Bill@aol.com, Dan@yahoo.com, Frank@gmail.com

In my result set I need to display all email addresses that do not have the @yahoo.com domain.

View 7 Replies View Related

Selecting First 10 Addresses In Each City In Each State

Oct 4, 2007

Greetings:

I read with great interest a post on getting hte top 75 per cent by month, but still get through this problem. I have a table containing addresses, city names and state names, Each row has a unique address. I want to get the first ten addresses for each city in each state. I've tried something like the following which didn't work. Suggestions on how to solve the (simple) problem would be appreciated.
Select top (10) city,state,address
from address_list
alan

View 3 Replies View Related

Changing TCP/IP IP Addresses Under Protocols For SQLExpress

Jun 16, 2007

SQL Server Configuraton Manager,

Protocols for sqlexpress,

TCP/IP



When I initially installed SQL Server 2005 Express, it automatically picked up all the IP addresses (60 of them) I had on the server, and filled them in under TCP/IP - IP adresses Tab.



I recently took those IPs off the server and replaced them with 30 new IP addresses. Is there a way to have SQL Server 2005 Express read the Network configuration on the server and take the old IPs off the TCP/IP - IP addresses tab and put the new one's there?



Thanks,

Bill

View 3 Replies View Related

Locking SQL Express To Recieve FROM Certain IP Addresses?

Oct 4, 2007



Hi All,

A client of mine has an update to the software they use which requires SQL ports to be pinholed on the
router to allow direct connctions from point of sale terminals. I'm not happy with the idea but thats not my call.
Is there a way to restrict IP addresses that can connect to SQL Express ? (without havng to get them to buy
a new router)

Cheers.

Irish

View 1 Replies View Related

Simple Navigation Buttons.....

Jan 24, 2007

  Hi all,
I'm trying to design a website with my old MS Access Application as a template, because my users know that style. I use textboxes to display data from the MSSQL 2005 database,  one record and 20 fields per page ....and i would like to navigate through the records with 4 buttons: first, last, next and prior, placed on the page.I tried a lot of things, and my last attemt was a  Stored Procedure with a Cursor to do the trickbut.... it did not work 
It's very easy to do this in MS Access.
Can anyone tell me a simple way to do this ?
 
 

View 5 Replies View Related







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