Showing posts with label report. Show all posts
Showing posts with label report. Show all posts

Friday, March 30, 2012

How do I allow an end user make modifications to a rdl that I created using Report Designe

Hi,
I have several reports ( .rdl) that I created using report designer, how can
I let the end user make modifications to the text in some of these reports.
As I am unable to use Report Builder to modify reports ( .rdl ) created with
Report designer, what are my options. is there a way I can embed the report
designer within my c# winform application. I have tried converting/creating
a report builder version but with no success..
Thanks in advance..On Mar 2, 3:09 pm, "Rob Dob" <robdob20012...@.yahoo.com> wrote:
> Hi,
> I have several reports ( .rdl) that I created using report designer, how can
> I let the end user make modifications to the text in some of these reports.
> As I am unable to use Report Builder to modify reports ( .rdl ) created with
> Report designer, what are my options. is there a way I can embed the report
> designer within my c# winform application. I have tried converting/creating
> a report builder version but with no success..
> Thanks in advance..
Hi there...if you are running SSRS 2005 I would make the report using
the report builder if at all possible then give the user rights to
change it. There probably are other ways of doing this but I think
this might be the easiest...|||On Mar 2, 5:21 pm, "sullins602" <ben.sull...@.gmail.com> wrote:
> On Mar 2, 3:09 pm, "Rob Dob" <robdob20012...@.yahoo.com> wrote:
> > Hi,
> > I have several reports ( .rdl) that I created using report designer, how can
> > I let the end user make modifications to the text in some of these reports.
> > As I am unable to use Report Builder to modify reports ( .rdl ) created with
> > Report designer, what are my options. is there a way I can embed the report
> > designer within my c# winform application. I have tried converting/creating
> > a report builder version but with no success..
> > Thanks in advance..
> Hi there...if you are running SSRS 2005 I would make the report using
> the report builder if at all possible then give the user rights to
> change it. There probably are other ways of doing this but I think
> this might be the easiest...
Also, depending on the text that needs to be changed, you could allow
certain text report parameters to be filled in by the user and use the
parameter results to set the text in the report.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How do I add Virtual table to Report Model (dsv)?

Hi,

problem: I got "Sale" table that include Employee ID & Manager ID.

I want to connect" Employee" table twice to "Sale"

once: Sale.EmployeeID=Employee.EmployeeID

second: Sale.ManagerID=Employee.EmployeeID

how do I create a virtual table for the second connection? can't I solve it in the model layer or need to add view in the database layer?

Thanks,

Assaf

You need to open DSV in Model Designer and add new relationship with Sale.ManagerID=Employee.EmployeeID (you should already have one relship for Sale.EmployeeID=Employee.EmployeeID).

Then open the model and regen the two involved entities or create two new roles manually.

How do i add symbols like a bullet to a report(urgent)

Hi,

Is there a way i can add a symbol like a bullet a (wingding font) to my report in addition to other text in a text box.

any help will be appreciated.

Regards,

Karen

Sorry Karen, but formatting is applied to the whole textbox. You can't format text differently within the same textbox.

I think your best option is to add another column to the left and add the bullet there.

Jarret

|||

Jarret,

Thanks for your answer, but isnt there a ASCII character that i use with it like something like chr().

Regards,

Karen

|||

Nevermind i did it by,

using alt+0149 and it shows up in the expression.

regards

KAren

How do I add a single column heading row in the detail section?

Could somebody please tell me how to do this?
I've created a report with the wizard that lists Managers. You toggle
a Manager and a detail section of employees opens for that Manager. I
want to put a row of column names at the top of the detail section when
it's opened (not showing when the detail is closed). I've succeeded in
adding a row that shows above each detail record, but that's not what I
want. I just want a single row of column headings.
I've tried looking everywhere, including the Help system, and I can't
find how to do this. Probably simple, right?
Thanks, JulieHi Julie,
Highlight the Managers group, right click and select Insert Row Below.
That will add another row for that group, but since the group only gets
repeated once for each manager this is what you want. Toggle this new
row on the Manager and you're good to go.
take care,
Michelle|||Michelle, thank you, that's what I've been trying to do. That just
leaves me to figure out how to hide this new detail header when the
Manager group is not toggled. Setting the visibility of the detail
header to False makes it invisible all the time. I want it to become
visible when the Manager is toggled, and only for any Manager(s)
toggled.
Michelle wrote:
> Hi Julie,
> Highlight the Managers group, right click and select Insert Row
Below.
> That will add another row for that group, but since the group only
gets
> repeated once for each manager this is what you want. Toggle this
new
> row on the Manager and you're good to go.
> take care,
> Michellesql

How do I add a Percentage Column after the Total on a Matrix?

Hi. I am looking to create a Matrix-based Report in SQL Server 2005 Reporting Services. I have my query, and a dynamic number of both rows and columns. I have Totals on the "bottom" and "right".

What I'd like to do is add a Percentage column to the right of the right-based Totals column. So the columns would read Col1, Col2, .., ColN, Total, Percentage.

Is this possible?

Thanks.

You could do something like - matrixcoltotal / matrixtotal and set your Format Code to P0 on the properties window.

Your expression will look something like this. =Sum(Fields!ReportField.Value,"MatrixGroup")/Sum(Fields!ReportField.Value,"dataset"). Dont forget to change the FormatCode.

|||How would I place this column to the RIGHT of the Subtotal column?

|||

Add an invisible column group which will be grouped by the percentage expression and add the subtotal to this colum group have the which will give you the sum of all individual percentages.

Shyam

|||Here is the error message I am receiving:

"A group expression for the matrix 'matrix1' includes an aggregate function. Aggregate functions cannot be used in group expressions."

I created a new Column group, outside of my month-by-month column group, and made it invisible. I do see a new "Total" to the right....however when I put in my sum(value, "InnerRowGroup")/sum(value, "OuterRowGroup") as the group expression, I get the above error.

Thank you both greatly for your help. I feel about 75% towards getting this to work.

Jason

|||

No, you dont have to group by the aggregate which is an obvious logical error. Just group by the expression without the sum function which would be:

Fields!InnerGroupField/Fields!OuterGroupField

Then using the subtoal would automatically mean a sum which is what you want I guess.

Shyam

|||What if the percentage I want to calculate is the ratio between two columns? Is this possible, or will I have to pivot the data in the database before I send it to SSRS? This would suck since I have to completely revamp the stored proc.

Wednesday, March 28, 2012

How do I add a Percentage Column after the Total on a Matrix?

Hi. I am looking to create a Matrix-based Report in SQL Server 2005 Reporting Services. I have my query, and a dynamic number of both rows and columns. I have Totals on the "bottom" and "right".

What I'd like to do is add a Percentage column to the right of the right-based Totals column. So the columns would read Col1, Col2, .., ColN, Total, Percentage.

Is this possible?

Thanks.

You could do something like - matrixcoltotal / matrixtotal and set your Format Code to P0 on the properties window.

Your expression will look something like this. =Sum(Fields!ReportField.Value,"MatrixGroup")/Sum(Fields!ReportField.Value,"dataset"). Dont forget to change the FormatCode.

|||How would I place this column to the RIGHT of the Subtotal column?

|||

Add an invisible column group which will be grouped by the percentage expression and add the subtotal to this colum group have the which will give you the sum of all individual percentages.

Shyam

|||Here is the error message I am receiving:

"A group expression for the matrix 'matrix1' includes an aggregate function. Aggregate functions cannot be used in group expressions."

I created a new Column group, outside of my month-by-month column group, and made it invisible. I do see a new "Total" to the right....however when I put in my sum(value, "InnerRowGroup")/sum(value, "OuterRowGroup") as the group expression, I get the above error.

Thank you both greatly for your help. I feel about 75% towards getting this to work.

Jason

|||

No, you dont have to group by the aggregate which is an obvious logical error. Just group by the expression without the sum function which would be:

Fields!InnerGroupField/Fields!OuterGroupField

Then using the subtoal would automatically mean a sum which is what you want I guess.

Shyam

|||What if the percentage I want to calculate is the ratio between two columns? Is this possible, or will I have to pivot the data in the database before I send it to SSRS? This would suck since I have to completely revamp the stored proc.

How do I add a Percentage Column after the Total on a Matrix?

Hi. I am looking to create a Matrix-based Report in SQL Server 2005 Reporting Services. I have my query, and a dynamic number of both rows and columns. I have Totals on the "bottom" and "right".

What I'd like to do is add a Percentage column to the right of the right-based Totals column. So the columns would read Col1, Col2, .., ColN, Total, Percentage.

Is this possible?

Thanks.

You could do something like - matrixcoltotal / matrixtotal and set your Format Code to P0 on the properties window.

Your expression will look something like this. =Sum(Fields!ReportField.Value,"MatrixGroup")/Sum(Fields!ReportField.Value,"dataset"). Dont forget to change the FormatCode.

|||How would I place this column to the RIGHT of the Subtotal column?|||

Add an invisible column group which will be grouped by the percentage expression and add the subtotal to this colum group have the which will give you the sum of all individual percentages.

Shyam

|||Here is the error message I am receiving:

"A group expression for the matrix 'matrix1' includes an aggregate function. Aggregate functions cannot be used in group expressions."

I created a new Column group, outside of my month-by-month column group, and made it invisible. I do see a new "Total" to the right....however when I put in my sum(value, "InnerRowGroup")/sum(value, "OuterRowGroup") as the group expression, I get the above error.

Thank you both greatly for your help. I feel about 75% towards getting this to work.

Jason|||

No, you dont have to group by the aggregate which is an obvious logical error. Just group by the expression without the sum function which would be:

Fields!InnerGroupField/Fields!OuterGroupField

Then using the subtoal would automatically mean a sum which is what you want I guess.

Shyam

|||What if the percentage I want to calculate is the ratio between two columns? Is this possible, or will I have to pivot the data in the database before I send it to SSRS? This would suck since I have to completely revamp the stored proc.

How do I add a data source view and report model to an existing project

I have an existing project with the data source and report folder with working reports. I need to create a model for other department members to use Report Builder, not Business Intelligence Developer Studio, to develop their reports from. How do I add a data source view and report model folder to the project so I can then create a view and model?

Report Models are part of a separate project type. Create a new "Report Model" project and you will be able to create the DSV and report model there.

sql

Monday, March 26, 2012

How distribute report to external subscribes?

We need to invoke every evening report for all our customers, and send
to him by email and fax according customer profile.
I read about scheduling and ability to send email but in our situation
it seem more complicated.
I not sure how deal with:
+Invoke report for each subscribe according his profile
+even if i send for all customer the same report, how I make schedule
that invoke the same report for each customer by his ID?
+how make schedule that send to each subcribe by his mail address?
+How I can make schedule to send by Fax (this is can be resolve by
Emailing to some Mail to Fax system, So for now we can ignore this Q)
I'm familiar with .NET and I have some experience to build Window
Services so if SQL Reporting not fit to our goal, I can write some
Service, but I not sure how I can Call to Reporting service to Invoke
for me Report and svae it to some format, withoute dealing with GUI.
In short, i need to invoke report and save it programmatically?I find somthing:
Tutorial: Creating a Data-Driven Subscription
at:
MSDN Library > Enterprise Servers and Development > SQL Server > SQL
Server 2005 Documentation > SQL Server 2005 Tutorials > Reporting
Services Tutorials > Creating a Data-Driven Subscription
from: SQL Server 2005 Books Online
hear the excec link:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx

Friday, March 23, 2012

How could I make sure order total is at the bottom of the page?

I have to show mutiplie orders in a report. Order total of one order has to show at the bottom of the page. Now if the order has only one or two items, the order total won't go to the bottom of the page. How can I make sure this order total is at the bottom of the page just as Crystal Report do( set Group Footer at the bottom of the page).

one way you could do it, is to use a textbox, and place it at the bottom of the page then set the value of the textbox to the value of the total in the table. Once you have done that you could hide the specific textbox in the table.
The other thing you could try is setting the height of the table to be exactly the height of the page - margins.|||No. It doesn't work|||Heres how I do,..
Drag a new table onto your design surface, Delete the Header and Detail rows,...
Your left with a footer, place it at the bototm of your report, and It will persist at the bottom, hopefully. And it wont go labeling off multiple rows, it will act as your "Grand Total" area if ya like

How could I create an end user sort report?

Hi all,
I want to create a report that let end user sort the table by click head
of the any column, ascending and descending. How to do that in reporting
service?
My reporting service is in Visual Statdio .Net 2003
Best Regards,
SebastianHi Sebastian
I have not had to do this but would expect that one way would be to:
1) Have the order determined by a hidden parameter (eg intSort = 1
sorts by Name, intSort = 2 sorts by City)
2) use labels for the sort column names using Navigation properties to
call the report again with a parameter indicating the sort required.
I"ve done something similar to allow dynamic grouping
Hope that helps
BrianK
www.bolign.com

How controls a range of dates?

I have a report that asks for two dates and wanted to control that the
difference between two dates is not superior to two months.
Exists some way to control the dates before clicking the button of "View
Report"?
Thanks,On 28 Jun., 12:18, Cetel Sistemas
<CetelSiste...@.discussions.microsoft.com> wrote:
> I have a report that asks for two dates and wanted to control that the
> difference between two dates is not superior to two months.
> Exists some way to control the dates before clicking the button of "View
> Report"?
> Thanks,
Hi
If I understand you right, I think a solution would be to make the
second date dataset dependent of the first selected date parameter.
You could use the datedif() function. In that way you only display
dates for the second date that in is the allowed range.
-Henrik.

Monday, March 19, 2012

How can you tell if SP1 was applied?

Especially in a multi-server environment where I have RS installed with
separate servers for the DB and IIS Report Manager.
I'm guessing there's some kind of @.@.version or version number hidden
somewhere, but where?
I am inheriting a deployment from a previous dba and I don't know if
SP1 was ever installed.
TIA!Go to http://yourserver/Reportserver
It should show version this at the bottom of the page displayed:
Microsoft SQL Server Reporting Services Version 8.00.878.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave" <macleary2000@.yahoo.com> wrote in message
news:1108055493.899520.289400@.z14g2000cwz.googlegroups.com...
> Especially in a multi-server environment where I have RS installed with
> separate servers for the DB and IIS Report Manager.
> I'm guessing there's some kind of @.@.version or version number hidden
> somewhere, but where?
> I am inheriting a deployment from a previous dba and I don't know if
> SP1 was ever installed.
> TIA!
>|||Found it. Thank you.
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> It should show version this at the bottom of the page displayed:
> Microsoft SQL Server Reporting Services Version 8.00.878.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave" <macleary2000@.yahoo.com> wrote in message
> news:1108055493.899520.289400@.z14g2000cwz.googlegroups.com...
> > Especially in a multi-server environment where I have RS installed with
> > separate servers for the DB and IIS Report Manager.
> >
> > I'm guessing there's some kind of @.@.version or version number hidden
> > somewhere, but where?
> >
> > I am inheriting a deployment from a previous dba and I don't know if
> > SP1 was ever installed.
> >
> > TIA!
> >
>
>

How can you deploy a simple report in a folder below the ReportServer?

Hello,
I would like to deploy report into folder named HOME3 located under the
ReportServer directory.
For example:
http://[hostname]/ReportServer/HOME3
How do I type in the TargetServerURL so that report is deployed in HOME3?
I appreciate the help. Thanks.
SteveHi, Steve
In " TargetFolder " enter HOME3 then deploy the report.
Angi
"steve kwon" <steven,kwon@.lmco.com> ¼¶¼g©ó¶l¥ó·s»D:ehmIW7RfFHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I would like to deploy report into folder named HOME3 located under the
> ReportServer directory.
> For example:
> http://[hostname]/ReportServer/HOME3
>
> How do I type in the TargetServerURL so that report is deployed in HOME3?
> I appreciate the help. Thanks.
> Steve
>

Monday, March 12, 2012

How can we RETAIN the Tooltip value shown on report into in Excel Sheet

Is there any way in which i can carry or retain the tooltip value which is shown on my report into Excel sheet ...

i mean when i export the report into Excel sheet, tooltip value is gone?? how can i retain the tooltip value when i export into excel ??

is it possible if so ...any hints? thanks a lot in advance

any thoughts on this...at least can anyone suggest me how to control the export feature of report?? i mean can i write custom rendering events etc?

i really appreciate...if some reply to this thread

How can we RETAIN the Tooltip value shown on report into in Excel

Is there any way in which i can carry or retain the tooltip value which is
shown on my report into Excel sheet ...
i mean when i export the report into Excel sheet, tooltip value is gone'
how can i retain the tooltip value when i export into excel '
thanks a lot in advanceOn May 9, 1:23 pm, Dia <D...@.discussions.microsoft.com> wrote:
> Is there any way in which i can carry or retain the tooltip value which is
> shown on my report into Excel sheet ...
> i mean when i export the report into Excel sheet, tooltip value is gone'
> how can i retain the tooltip value when i export into excel '
> thanks a lot in advance
As far as I know, there is not a way to do this. I believe the only
export format that supports tooltips is Web Archive. Sorry that I
could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

How can we limit the data regions in a specific report page?

Hi, all experts here,

Thank you very much for your kind attention.

I wanna know how can we limit the data regions in a specific report page. How can we achieve this? Really need help.

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Hiya,

Would please any expert here give me any guidance and advices for that?

Thanks a lot.

With best regards,

Yours sincerely,

How can we have 'optional' parameters?

Is there anyway in SQL2005RS to have optional parameters?
Eg supposing we have a report where we want the user to be able to
select a category, but if the user makes no selection we see ALL
catagories. Is this possible.
The sql dataset is something like
select col1
from table
where category=@.category
.....is it possible to make the where clause optional? Ie if category
is NOT selected then dont do the where at all? It also seems like the
SQL2k5RS client MAKES the user select a category?
Al.Use this query instead:
select col1
from table
where category in (@.category)
and make the parameter multi-value. Your drop down will have checkboxes next
to each value, plus a selection at the top that says "All".
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"scubaal" <al@.blakes.net> wrote in message
news:bb8fd4f4-23c7-4fc8-9195-cd984397947f@.u36g2000prf.googlegroups.com...
> Is there anyway in SQL2005RS to have optional parameters?
> Eg supposing we have a report where we want the user to be able to
> select a category, but if the user makes no selection we see ALL
> catagories. Is this possible.
> The sql dataset is something like
> select col1
> from table
> where category=@.category
> .....is it possible to make the where clause optional? Ie if category
> is NOT selected then dont do the where at all? It also seems like the
> SQL2k5RS client MAKES the user select a category?
> Al.|||The other option is to have a selection called 'All'. Then in your query do
this (I use this trick a lot).
select col1 from table where (category=@.category or @.category = 'All')
This gives you an example of a query to create your category list for your
parameter.
select category as label, category as value from categorytable union
select 'All' as lable, 'All' as value
order by label
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:%23LobPxnpIHA.5916@.TK2MSFTNGP04.phx.gbl...
> Use this query instead:
> select col1
> from table
> where category in (@.category)
> and make the parameter multi-value. Your drop down will have checkboxes
> next to each value, plus a selection at the top that says "All".
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "scubaal" <al@.blakes.net> wrote in message
> news:bb8fd4f4-23c7-4fc8-9195-cd984397947f@.u36g2000prf.googlegroups.com...
>> Is there anyway in SQL2005RS to have optional parameters?
>> Eg supposing we have a report where we want the user to be able to
>> select a category, but if the user makes no selection we see ALL
>> catagories. Is this possible.
>> The sql dataset is something like
>> select col1
>> from table
>> where category=@.category
>> .....is it possible to make the where clause optional? Ie if category
>> is NOT selected then dont do the where at all? It also seems like the
>> SQL2k5RS client MAKES the user select a category?
>> Al.
>|||My preferred variation (although the others are quite good):
select col1
from table
where category LIKE @.category
You can then define a drop down list within report parameters to
display 'All' to the user, while submitting '%' as the real parameter
value.
On Apr 24, 7:39 pm, scubaal <a...@.blakes.net> wrote:
> Is there anyway in SQL2005RS to have optional parameters?
> Eg supposing we have a report where we want the user to be able to
> select a category, but if the user makes no selection we see ALL
> catagories. Is this possible.
> The sql dataset is something like
> select col1
> from table
> where category=@.category
> .....is it possible to make the where clause optional? Ie if category
> is NOT selected then dont do the where at all? It also seems like the
> SQL2k5RS client MAKES the user select a category?
> Al.|||Another option is to set the report parameter to 'Allows Nulls', and the in
you sql use:
select col1
from table
where
(category=@.category
OR
@.category is null)
-- Original Message --
From: "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com>
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Sent: Friday, April 25, 2008 10:23 AM
Subject: Re: How can we have 'optional' parameters?
> The other option is to have a selection called 'All'. Then in your query
> do this (I use this trick a lot).
> select col1 from table where (category=@.category or @.category = 'All')
> This gives you an example of a query to create your category list for your
> parameter.
> select category as label, category as value from categorytable union
> select 'All' as lable, 'All' as value
> order by label
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:%23LobPxnpIHA.5916@.TK2MSFTNGP04.phx.gbl...
>> Use this query instead:
>> select col1
>> from table
>> where category in (@.category)
>> and make the parameter multi-value. Your drop down will have checkboxes
>> next to each value, plus a selection at the top that says "All".
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "scubaal" <al@.blakes.net> wrote in message
>> news:bb8fd4f4-23c7-4fc8-9195-cd984397947f@.u36g2000prf.googlegroups.com...
>> Is there anyway in SQL2005RS to have optional parameters?
>> Eg supposing we have a report where we want the user to be able to
>> select a category, but if the user makes no selection we see ALL
>> catagories. Is this possible.
>> The sql dataset is something like
>> select col1
>> from table
>> where category=@.category
>> .....is it possible to make the where clause optional? Ie if category
>> is NOT selected then dont do the where at all? It also seems like the
>> SQL2k5RS client MAKES the user select a category?
>> Al.
>
"scubaal" <al@.blakes.net> wrote in message
news:bb8fd4f4-23c7-4fc8-9195-cd984397947f@.u36g2000prf.googlegroups.com...
> Is there anyway in SQL2005RS to have optional parameters?
> Eg supposing we have a report where we want the user to be able to
> select a category, but if the user makes no selection we see ALL
> catagories. Is this possible.
> The sql dataset is something like
> select col1
> from table
> where category=@.category
> .....is it possible to make the where clause optional? Ie if category
> is NOT selected then dont do the where at all? It also seems like the
> SQL2k5RS client MAKES the user select a category?
> Al.

Friday, March 9, 2012

How can remove a row from my report if the results is empty or a n

How can remove a row from my report if the results is empty or a null?
If i have a null value , then i get a white space row in report - this is
not looking good !
Can somebody help me, please !?
Thank you!victoras wrote:
> How can remove a row from my report if the results is empty or a null?
> If i have a null value , then i get a white space row in report - this is
> not looking good !
> Can somebody help me, please !?
You need to write your SQL query to exclude that row, something like:
SELECT col1, col2 ... FROM mytable WHERE col1 IS NOT NULL
Luke|||or just use an iif statement on the row which toggles the visibility.
click the row, go to properties and visibility. choose expression
type
=iif(fields!afield.value is system.dbnull.value or fields!afield.value = "",
true, false)
basically says if your field is null or an empty string then do not show
else do show. True means don't show and false means do show.
"Luke Plant" <luke@.mailinator.com> wrote in message
news:do8hgo$9vq$1$8302bc10@.news.demon.co.uk...
> victoras wrote:
>> How can remove a row from my report if the results is empty or a null?
>> If i have a null value , then i get a white space row in report - this is
>> not looking good !
>> Can somebody help me, please !?
> You need to write your SQL query to exclude that row, something like:
> SELECT col1, col2 ... FROM mytable WHERE col1 IS NOT NULL
> Luke

How can my c#.net app open a rs report?

Ok,
I have just developed the c# app and the rs report...how does my c# app
open the report (and how does it pass parameters)?
Thanks,
TrintTwo ways to integrate. Either with URL integration (embed the IE control and
give it the appropriate URL) or web services. URL integration is easier.
With Widbey and Yukon their will be available a winform and webform controls
but for now you need to use one of these other integration methods.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1104503150.525220.298270@.c13g2000cwb.googlegroups.com...
> Ok,
> I have just developed the c# app and the rs report...how does my c# app
> open the report (and how does it pass parameters)?
> Thanks,
> Trint
>|||Look at the ReportViewer control that is part of the Sample
Applications that are installed with RS. It is designed to view the
report in a web page, but might be helpfull.