pivot information: solve

Showing posts with label solve. Show all posts

Friday, March 30, 2012

Please help me solve this problem

Hello All,
I am new to crystalreport am using crystalreport 8.5. I have to provide the link for
a column whose value is > 1000. i don't want to suppress the values other than1000.
My Problem is the link should be enabled only when the value is > 1000. Please share your experience to solve this problem.
Thanks in advance
Vasuformat the field of the column using a formula..

if(value>100, "link text" & value, value)

?|||Thanks a lot cjard. it works well. the link is enabled for value > 1000
thanks and regards
Vasu

Please Help me 'DrillthroughSourceQuery' parameter is missing a value in report builder

Can u help to to solve my problem . Many time this question arised in the forum no one answer to me to find out the solution for my problem. So please help

I am using report builder thru LocalHost\Report . I want a drill through report by using Report Builder and cube . I created the report but unfortunatly I cannot create a drill through report using parameters .How can I pass parameter in report1 to jump into report2 .

When I running the report after giving drill through properties in report the following error will occure.

'The 'DrillthroughSourceQuery' parameter is missing a value

How can I create a report using parameter for drill down in report builder

I am expecting one answer from u expertise

-Create a report with your needed entities and save it in Report builder as RDL file.

-Import it in a Reporting project

-Design your report as needed

-Deploy it on the Report Server

-Use SSMS to connect to the Reporting Server and navigate to the model

-Connect the Report with the single / multi instance of your entity within the model.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

Could you please elaborate on the steps.

In my scenario the report rdl file is on some other server and the folder is not shared, how do i impport the rdl file in reporting project. Could you please elaborate on "Use SSMS to connect to the Reporting Server and navigate to the model"

Regards

Neeraj

Please Help me ''DrillthroughSourceQuery'' parameter is missing a value in report builder

Can u help to to solve my problem . Many time this question arised in the forum no one answer to me to find out the solution for my problem. So please help

When I running the report after giving drill through properties in report the following error will occure.

'The 'DrillthroughSourceQuery' parameter is missing a value

How can I create a report using parameter for drill down in report builder

I am expecting one answer from u expertise

-Create a report with your needed entities and save it in Report builder as RDL file.

-Import it in a Reporting project

-Design your report as needed

-Deploy it on the Report Server

-Use SSMS to connect to the Reporting Server and navigate to the model

-Connect the Report with the single / multi instance of your entity within the model.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

Could you please elaborate on the steps.

Regards

Neeraj

sql

Monday, March 26, 2012

Please Help

Friday, March 23, 2012

Please Help

Hi all,
I need to solve a problem with SQL replication, I know very little about it,
and it wasn't me that set it up.
However we have 2 servers both with sql server 2000 Lets say server A & B
server A has been setup as the publisher & distributor with a transaction
push subscription to server B that has been setup as a subscriber.
I want this to work both ways but it doesn't seem to be replicating from
server B to A. Does anybody know what I can look into to check out what's
happening here?
Thanks
Gav> I want this to work both ways but it doesn't seem to be replicating
> from server B to A. Does anybody know what I can look into to check
> out what's happening here?
See Merge Replication|||Are you telling me that Transaction replication only works one way?
Gav
"JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
> > I want this to work both ways but it doesn't seem to be replicating
> > from server B to A. Does anybody know what I can look into to check
> > out what's happening here?
> See Merge Replication|||Unless you use "with updating subscribers", modifications will only be applied one-way. From
publisher -> subscriber. You can make sure that each site only update its own subset of data and let
both be subscribers and subscribers, but be very careful...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gav" <spam@.spam.com> wrote in message news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
> Are you telling me that Transaction replication only works one way?
> Gav
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>> > I want this to work both ways but it doesn't seem to be replicating
>> > from server B to A. Does anybody know what I can look into to check
>> > out what's happening here?
>> See Merge Replication
>|||Sorry you have lost me a little bit there... I did say I havn't got much
knowledge in this field, do you have any sources of information on what you
have mentioned here?
Thanks for helping
Gav
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Ose32EY%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
> Unless you use "with updating subscribers", modifications will only be
applied one-way. From
> publisher -> subscriber. You can make sure that each site only update its
own subset of data and let
> both be subscribers and subscribers, but be very careful...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gav" <spam@.spam.com> wrote in message
news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
> > Are you telling me that Transaction replication only works one way?
> >
> > Gav
> >
> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> > news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
> >> > I want this to work both ways but it doesn't seem to be replicating
> >> > from server B to A. Does anybody know what I can look into to check
> >> > out what's happening here?
> >>
> >> See Merge Replication
> >
> >
>|||I misprinted the last sentence, should be "both be both subscriber and publisher". I don't know
offhand where to find more info on this, but I'd start looking in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gav" <spam@.spam.com> wrote in message news:OdQCosY%23EHA.3472@.TK2MSFTNGP14.phx.gbl...
> Sorry you have lost me a little bit there... I did say I havn't got much
> knowledge in this field, do you have any sources of information on what you
> have mentioned here?
> Thanks for helping
> Gav
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Ose32EY%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
>> Unless you use "with updating subscribers", modifications will only be
> applied one-way. From
>> publisher -> subscriber. You can make sure that each site only update its
> own subset of data and let
>> both be subscribers and subscribers, but be very careful...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Gav" <spam@.spam.com> wrote in message
> news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
>> > Are you telling me that Transaction replication only works one way?
>> >
>> > Gav
>> >
>> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
>> > news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>> >> > I want this to work both ways but it doesn't seem to be replicating
>> >> > from server B to A. Does anybody know what I can look into to check
>> >> > out what's happening here?
>> >>
>> >> See Merge Replication
>> >
>> >
>>
>|||Try to look at
http://www.microsoft.com/sql/evaluation/features/replication.asp or Search
Books online for Replication. That will give you an initial knowledge about
Replication.
Regards
Steen
Gav wrote:
> Are you telling me that Transaction replication only works one way?
> Gav
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>> I want this to work both ways but it doesn't seem to be replicating
>> from server B to A. Does anybody know what I can look into to check
>> out what's happening here?
>> See Merge Replication

Wednesday, March 21, 2012

Please any one try to solve this. its Interesting.

the table is
col1
---
M
S
S
Q
L

The expected Result is

Name
----
MSSQL

I need a single query which solves the above problem. please help me out?

Quote:

Originally Posted by Anu139

the table is
col1
---
M
S
S
Q
L

The expected Result is

Name
----
MSSQL

I need a single query which solves the above problem. please help me out?

hi all,
i got the answer for this.

declare @.name varchar(50)

select @.name = coalesce( @.name,'' )+ col1 from tab_name

select @.name 'Name'

Please Advice !

Hi,

I am trying to solve this procedure.

Let me try to explain it...I am getting DEGREEID from one of the SELECT query . I want to OUTPUT (ie , COUNT) from procedure,the number of departments with the degreeid, got from the above query.

With below procedure, Since an employee can have multiple DEGREEID , the cursor is giving OUPTUT ie, COUNT for the LAST Degreeid. Eventhough the previous DEGREEID dont have any DEPARTMENT...but only for the LAST DEGREEID...!

How can I solve this.... whether I can solve this with CURSOR or I have to use someother way...Please advice me !

DATA
---
DEGREE_EARNED
-------
EMPID DEGREEID
-- ----
201 12
201 3
201 250
202 3
202 10
203 17

DEPARTMENT
-----
DEPID DEGREEID
-- ----
10 1 12
111 250
111 12
121 3
121 12
121 250
-----------

---------------------
DECLARE @.vchid int
DECLARE testcursor CURSOR FOR

SELECT degree_id
FROM degree_earned WHERE emp_id= @.empid

OPEN testcursor
FETCH NEXT FROM testcursor INTO @.vchid

WHILE (@.@.FETCH_STATUS <> -1)

BEGIN
Select @.outresult = COUNT(*)
from
department
where degree_id = @.vchid

FETCH NEXT FROM testcursor INTO @.vchid
END
---------------------Can somebody help me,please (:|||So is what you want something like:EMPID DEGREEID DEPT_COUNT
-- --- ----
201 12 2
201 3 1
201 250 2
202 3 1
202 10 0
203 17 0I don't understand exactly what you want, so I can't be much help until I do. Sorry!

-PatP|||Hey Pat,

Thats what i wanted...Can u please show me , how to solve this...Thanks!|||USE Northwind
GO

CREATE TABLE DEGREE_EARNED(EMPID int, DEGREEID int)
CREATE TABLE DEPARTMENT(DEPID int, DEGREEID int)
GO
INSERT INTO DEGREE_EARNED(EMPID, DEGREEID)
SELECT 201, 12 UNION ALL
SELECT 201, 3 UNION ALL
SELECT 201, 250 UNION ALL
SELECT 202, 3 UNION ALL
SELECT 202, 10 UNION ALL
SELECT 203, 17

INSERT INTO DEPARTMENT(DEPID, DEGREEID)
SELECT 101, 12 UNION ALL
SELECT 111, 250 UNION ALL
SELECT 111, 12 UNION ALL
SELECT 121, 3 UNION ALL
SELECT 121, 12 UNION ALL
SELECT 121, 250
GO

SELECT A.DEGREEID, ISNULL(ROW_OCCURS,0)
FROM ( SELECT DISTINCT DEGREEID FROM DEGREE_EARNED) AS A
LEFT JOIN ( SELECT DEGREEID, COUNT(*) AS ROW_OCCURS
FROM DEPARTMENT GROUP BY DEGREEID) AS B
ON A.DEGREEID = B.DEGREEID
GO

--DROP TABLE DEGREE_EARNED
--DROP TABLE DEPARTMENT
GOsql

Friday, March 30, 2012

Please help me solve this problem

Please Help me 'DrillthroughSourceQuery' parameter is missing a value in report builder

Please Help me ''DrillthroughSourceQuery'' parameter is missing a value in report builder

Monday, March 26, 2012

Please Help

Friday, March 23, 2012

Please Help

Please Help

Wednesday, March 21, 2012

Please any one try to solve this. its Interesting.

Please Advice !

pivot information

Blog Archive

About Me