Showing posts with label friends. Show all posts
Showing posts with label friends. Show all posts

Wednesday, March 28, 2012

how to assign null in derived column transformation editor

Dear friends, can any one tell me how to assign null to the expression value in derived column transfromation editor?

thanks,

In the editor dialog, expand the Null Functions folder, and drag the appropriate NULL(your data type here) item to the expression box. For example, you'd use NULL(DT_I4) to create a null integer.

Monday, March 12, 2012

How to add Optional Parameters for SQL Reporting Service 2005

Hi friends,

I am developing reports using SQL Server 2005 Reporting service

I want to pass optional parameters to Report using dropdown

I filled dataset using EmpId and EmpName. and assigned this dataset to

query the values.

I checked properties for Report Parameters of Allow Null, Allow Blank values

Even i checked this properties, it enforces me to Enter some value for dropdown while running or previewing the report

I don't want to enforce the user that value must be selected.

In short, How we can able to pass multiple parameters which are not mandatory.

Pls reply me ASAP

Any suggestion is appreciated

Thanks in Advance.

Regards

Suds

hmm.... if i set the parameter to be multivalue, there'll be error if i want to set it to Allow Null...

my solution is if user does not want to select any specific value, then they can use select all....

i don't know how to put select all as the default value... maybe someone can suggest this...

if you found out, pls share ya....

|||Add a default value of "All" and use this value with in your expressions/queries to allow for a catch all situation

eg: with in the sql where clause add the following:
and case @.empid = 'All' then table.emp_id else @.empid = table.emp_id

It is a little bit messy to write but I believe it gives you the most control over the report.

Sam Vella.|||

minority80 wrote:

i don't know how to put select all as the default value... maybe someone can suggest this...

Report -> Parameters
Select the parameter you want to add a default value to
Select the Non-Queried radio Button
Enter "All" without the quotes into the text box

Sam Vella

Friday, March 9, 2012

How to add Drill down option in the Dataset ( + )

Dear Friends,

I have created a Dataset and displayed in the report. In the report, its showing as expanded values by default. There is no option for me to Collapse and Expand.

If I create a Table with Report Wizard, I am getting the Collapse & Expand ( + ) option in the report.

Is there anyway, I can add the Collapse / Expand in the Dataset kind of reports.

Thanks.

Warm Regards
Rakin
Singapore.

If you investigate the report that is generated through the report wizard, you will notice that the toggle-effect is achieved by setting the Visibility property e.g. of table rows to be toggled by a certain other textbox.

Please also check RS BOL for more information how to add toggles in report designer: http://msdn2.microsoft.com/en-us/library/ms156456.aspx

-- Robert

|||

Thanks Robert.

Now I am able to do that. It works fine.

Regards
Rakin.

Sunday, February 19, 2012

How To access Sqlserver Reporting Two Different Server

Hi Friends ,

I have a problem to access the sqlserver Reporting on different server. Actually I created Sql Server Reporting in one server with in that server i able to access the report. but out of that server that means another server webapplication i unable to access it. how can i rectify this problem.

Redirecting to the RS forum.

Mike

|||

Let's begin by naming your servers Server 1 (Server with Reporting Services) and Server 2 (Web Server with Web Application). I am not quite able to understand the exact problem you are facing. Either you are ok running reports on Server 1 but when you log in to Server 2, you are unable to run the reports (Scenario A). Or you are trying to have a Web Application on server 2 access the reports and display them (Scenario B).

If Scenario A is your problem, then you probably have some type of authentication issue. Is SQL running on Server 1 or is it on a different server? If it is a different server, are you on a domain or are you running under a workgroup? Here is a webcast that speaks to "double-hop" authentication which you will need if you have three different servers involved: http://support.microsoft.com/kb/887682

If Scenario B, take a look at this article by Russell Christopher on impersonation and think about using it on your Web Application: http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx

If none of the above helps, please reply with a precise outline of your problem and setup and I will try again.

Good luck!

Larry Smithmier

How To access Sqlserver Reporting Two Different Server

Hi Friends ,

I have a problem to access the sqlserver Reporting on different server. Actually I created Sql Server Reporting in one server with in that server i able to access the report. but out of that server that means another server webapplication i unable to access it. how can i rectify this problem.

Redirecting to the RS forum.

Mike

|||

Let's begin by naming your servers Server 1 (Server with Reporting Services) and Server 2 (Web Server with Web Application). I am not quite able to understand the exact problem you are facing. Either you are ok running reports on Server 1 but when you log in to Server 2, you are unable to run the reports (Scenario A). Or you are trying to have a Web Application on server 2 access the reports and display them (Scenario B).

If Scenario A is your problem, then you probably have some type of authentication issue. Is SQL running on Server 1 or is it on a different server? If it is a different server, are you on a domain or are you running under a workgroup? Here is a webcast that speaks to "double-hop" authentication which you will need if you have three different servers involved: http://support.microsoft.com/kb/887682

If Scenario B, take a look at this article by Russell Christopher on impersonation and think about using it on your Web Application: http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx

If none of the above helps, please reply with a precise outline of your problem and setup and I will try again.

Good luck!

Larry Smithmier