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

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

sql

Please help - SQL Server Services are missing

I am running SQL 2K on Windows 2000. Apparently for no reason when I
attempted restarting Win 2K I got the error
\Winnt\System32\Config\System is missing or corrupt.
I tried repairing did not work and I did not have a emergency repair
backup disk I used Win2K got in on Console mode and restore
C:\winnt\repair\system to \winnt\System32\config\system
Now I can boot into my Win2K Server all software works except that my
SQL Server services have all gone missing in Services.
When I use service manager I get the following message "The specified
service does not exist as an service". When I attempt to start SQL
Server I get the following error:
An error 1060-(The specified service does not exist as an installed
service) occurred while performing this service operation on the
MSSQLServer service.
Please advice how I can recreate or regenerate all the SQL Server and
Analysis Services services.
Thanks
SimonHello Simon
Sounds like there was some type of catastrophic error at OS/hardware level.
This most likely resulted in some of the registry being corrupted hence
affecting SQL Server. If registry has corrupted in this manner, chances are
that some/all other applications on that machine may be affected also.
I would advise you to get the System Eventlog from the machine and try to
diagnose what happened. If the issue has been diagnosed and fixed already,
then go ahead and reinstall the OS and all other applications. If you have
a backup of the entire machine (including registry) then it may save you
time just by restoring the backup.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Please help - SQL Server Services are missing

I am running SQL 2K on Windows 2000. Apparently for no reason when I
attempted restarting Win 2K I got the error
\Winnt\System32\Config\System is missing or corrupt.
I tried repairing did not work and I did not have a emergency repair
backup disk I used Win2K got in on Console mode and restore
C:\winnt\repair\system to \winnt\System32\config\system
Now I can boot into my Win2K Server all software works except that my
SQL Server services have all gone missing in Services.
When I use service manager I get the following message "The specified
service does not exist as an service". When I attempt to start SQL
Server I get the following error:
An error 1060-(The specified service does not exist as an installed
service) occurred while performing this service operation on the
MSSQLServer service.
Please advice how I can recreate or regenerate all the SQL Server and
Analysis Services services.
Thanks
SimonHello Simon
Sounds like there was some type of catastrophic error at OS/hardware level.
This most likely resulted in some of the registry being corrupted hence
affecting SQL Server. If registry has corrupted in this manner, chances are
that some/all other applications on that machine may be affected also.
I would advise you to get the System Eventlog from the machine and try to
diagnose what happened. If the issue has been diagnosed and fixed already,
then go ahead and reinstall the OS and all other applications. If you have
a backup of the entire machine (including registry) then it may save you
time just by restoring the backup.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Please help - SQL Server Services are missing

I am running SQL 2K on Windows 2000. Apparently for no reason when I
attempted restarting Win 2K I got the error
\Winnt\System32\Config\System is missing or corrupt.
I tried repairing did not work and I did not have a emergency repair
backup disk I used Win2K got in on Console mode and restore
C:\winnt\repair\system to \winnt\System32\config\system
Now I can boot into my Win2K Server all software works except that my
SQL Server services have all gone missing in Services.
When I use service manager I get the following message "The specified
service does not exist as an service". When I attempt to start SQL
Server I get the following error:
An error 1060-(The specified service does not exist as an installed
service) occurred while performing this service operation on the
MSSQLServer service.
Please advice how I can recreate or regenerate all the SQL Server and
Analysis Services services.
Thanks
Simon
Hello Simon
Sounds like there was some type of catastrophic error at OS/hardware level.
This most likely resulted in some of the registry being corrupted hence
affecting SQL Server. If registry has corrupted in this manner, chances are
that some/all other applications on that machine may be affected also.
I would advise you to get the System Eventlog from the machine and try to
diagnose what happened. If the issue has been diagnosed and fixed already,
then go ahead and reinstall the OS and all other applications. If you have
a backup of the entire machine (including registry) then it may save you
time just by restoring the backup.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Please help - Missing sqlbw.exe of SQL Server 2005

Recently, my SQL server infected with virus which modified some of .exe files on the server. Unfortunatly, the auti-virus software found those infected .exe files and removed them from server including the sqlbw.exe. Now I can't run the management studio. I tried to reinstall the only the management tools but failed. It said that my version is incorrect. I also tried to apply the SP1 but failed too. What can I do to recover only the management studio? I don't want to uninstall the SQL server because I have live database running on it. Please help.

If you cannot have a downtime to the databases then only way is to install another instance of SQL and use those tools to use this database.|||Have you tried uninstalling the original tools?|||

Why are you trying to run sqlbw.exe? You can launch management studio using sqlwb.exe and not sqlbw.exe

Thanks,

Sravanthi

Placeholds for missing rows ... is this possible?

I have a dataset like this that feeds a table data region in a report:

Answer Label Answer Count
Strongly Agree 10
Agree 7
Neutral 12
Disagree 19
Strong Disagree 9

For every Answer Label, I need the table to create a new row that displays the label and count so it looks just like the above. The problem occurs when the dataset does not include one or more Answer Labels because there are no counts associated to them. I still need to see all Answer Labels ... but simply set the count = 0 if it is not found in the dataset.

So working with a resultset like this:

Strongly Agree 10
Neutral 12

My table data region needs to look like such:

Strongly Agree 10
Agree 0
Neutral 12
Disagree 0
Strong Disagree 0

Is there a good way to do this?

Thanks - WaydeIf your dataset doesn't contain the rows it makes no sense to produce them afterwards..
If you have two tables, persons and answers you could left/right join them:

SELECT person.Name, count(answers.answer) as AnswerCount
FROM person LEFT JOIN answers ON person.ID = answers.personID
group by person.ID;

This statement means:
Take ALL persons from person and connect it with found answers of the answer-table, so you always get all persons and blank or "0" values for the answers.. If AnswerCount is empty you could use isnull(count(answers.answer),"0")

|||

Another approach would be:

-- Assume schema:

-- Table: AnswerTypes

-- ID (PK)

-- Label

-- Table: Answers

-- AnswerTypeId (FK)

--

select label, IsNull(a.CountAnswers, 0) as votes from AnswerTypes

left outer join

(

select AnswerTypeId, count(*) as CountAnswers from Answers

group by AnswerTypeId

) a on AnswerTypes.ID = a.AnswerTypeID

PK on computed column

Maybe I am missing something very obvious, but I couldn't do it:

begin tran
go
create table foo (
f1 int not null,
f2 int not null,
f3 as (f1 + f2) not null primary key clustered)
go
rollback tran
go

This returns:
Server: Msg 8183, Level 16, State 1, Line 8
Only UNIQUE or PRIMARY KEY constraints are allowed on computed columns.Never mind, this worked:

begin tran
go
create table foo (
f1 int not null,
f2 int not null,
f3 as isnull((f1 + f2), 0) primary key clustered)
go
rollback tran
go|||My machines don't care for that either, although logically they shouldn't object.

-PatP|||OK...for the life of me....why?|||Actually it sarted with RogerWilco's post (http://www.dbforums.com/t1006214.html (http://www.dbforums.com/t1006214.html)), where I was trying to demonstrate that while having 4 fields instead of 1 does not mean that you will have to perform every join on all 4 fields. And sure enough, you also can make the computed column a PK, and have a UNIQUE constraint defined on it, needless to say create indexes. Of course, when we start talking about doing those things, Brett's belief that "one should leave all connection settings to default" would have to be shattered, because this is exactly the situation where not only you have to change them, but also understand the implications of changing each and one of them...But that may be easily transfered to a dedicated thread...I already see its name...