I'm a VB6.0 programmer who is new to .Net. I'm having to write a
program in .Net that will call various .rdls in a windows
application. I've done the reports in the Business Intelligence
Studio (2005) pulling from a SQL Server 2005 database, but I don't
have .Net 2005, only Visual Studio 2003 for the VB side. I've read a
lot about using the reportviewer.dll for this, but I can't seem to
find it available for the Visual Studio 2003 or the Express version of
2005. Can someone point me in the right direction?
-wylieThe ReportViewer control assumes the 2.0 Framework and VS2005. It does not
work with 2003. See Chapter 14 of my book for a detailed discussion of this
new control. I also include the ReportViewer control in my (free) INETA
talks and some conference sessions. This is also a good source
http://gotreportviewer.com/.
hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Wylie" <wylie72@.gmail.com> wrote in message
news:1186409091.881661.58640@.l70g2000hse.googlegroups.com...
> I'm a VB6.0 programmer who is new to .Net. I'm having to write a
> program in .Net that will call various .rdls in a windows
> application. I've done the reports in the Business Intelligence
> Studio (2005) pulling from a SQL Server 2005 database, but I don't
> have .Net 2005, only Visual Studio 2003 for the VB side. I've read a
> lot about using the reportviewer.dll for this, but I can't seem to
> find it available for the Visual Studio 2003 or the Express version of
> 2005. Can someone point me in the right direction?
> -wylie
>sql
Showing posts with label various. Show all posts
Showing posts with label various. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
Reports with custom interface
Hello all,
I have been looking at various models and ways to implement a custom
interface for the Reporting Services.
My client wants some kind of a
default website (should be available only in the Intranet)
where he can get
1. an interface with a list of reports.
2. The fields required for the parameters of each report.
3. A submit there should send the params to the RS and the results
should be printed, probably in a frame. I would like to get back the
exact output including all the taskbar items of RS interface.
I have been trying building an ASP.NET webapp or use the reportviewer
control etc. but getting confused.
I am sure someone has done this before. Would like some suggestions on
which is the better option for me and some hints on where to start.
Help will be appreciated very much
Thanks
RaviCheck this site, it should get you started...
http://www.odetocode.com/Articles/128.aspx
--
bs
kingofthegreens.com
"RemoteDeploy" wrote:
> Hello all,
> I have been looking at various models and ways to implement a custom
> interface for the Reporting Services.
> My client wants some kind of a
> default website (should be available only in the Intranet)
> where he can get
> 1. an interface with a list of reports.
> 2. The fields required for the parameters of each report.
> 3. A submit there should send the params to the RS and the results
> should be printed, probably in a frame. I would like to get back the
> exact output including all the taskbar items of RS interface.
> I have been trying building an ASP.NET webapp or use the reportviewer
> control etc. but getting confused.
> I am sure someone has done this before. Would like some suggestions on
> which is the better option for me and some hints on where to start.
> Help will be appreciated very much
> Thanks
> Ravi
>|||Ben,
Thanks for the reply. I have checked that site and created an example
and show that to the client. But they wanted more custom look and feel.
So I am looking at using RS web services interface and I am getting
lost there.
Ravi|||The ReportViewer control is a good place to start. You may need to modify
it a bit to support changing parameters and report links (search this
newsgroup for ReplacementRoot for more info).
You can use the web service interface on a starting page that obtains a list
of reports to put on a web page, and -- it sounds like the way your customer
wants it -- obtains a list of parameters as well. That page can then post
the report and parameters to a report display page with the ReportViewer
control on it, and set the ReportViewer values accordingly there.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1108490439.909791.62940@.g14g2000cwa.googlegroups.com...
> Ben,
> Thanks for the reply. I have checked that site and created an example
> and show that to the client. But they wanted more custom look and feel.
> So I am looking at using RS web services interface and I am getting
> lost there.
> Ravi
>|||hello jeff,
thanks for the advice.
I am trying to use the reportviewer control to publish reports in
another website to provide customised interface.
I am using the example at
http://www.odetocode.com/Articles/128.aspx to try to make it work.
It works fine normal. I get a frame of params and after Submitting i
get the report in another frame.
When I try to hide the paramters frame and send parameters through the
Reportpath property I get the following errors.
When I set a param a value this is the error I get:
An attempt was made to set a report parameter 'param_IdServer' that is
not defined in this report. (rsUnknownReportParameter) Get Online Help
When I dont pass any params but still have the command
rc:Parameters=false& in the URL i get the follow error.
The path of the item '/projectname/reportname,' is not valid. The full
path must be less than 260 characters long, must start with slash;
other restrictions apply. Check the documentation for complete set of
restrictions. (rsInvalidItemPath) Get Online Help
I would like to know where is the problem.
Thanks
Ravi|||Can you provide the full URL that is being passed to the ReportServer? That
might give a clue as to the error. You can munge the server name if you're
concerned about privacy.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1108516594.197188.258640@.g14g2000cwa.googlegroups.com...
> hello jeff,
> thanks for the advice.
> I am trying to use the reportviewer control to publish reports in
> another website to provide customised interface.
> I am using the example at
> http://www.odetocode.com/Articles/128.aspx to try to make it work.
> It works fine normal. I get a frame of params and after Submitting i
> get the report in another frame.
>
> When I try to hide the paramters frame and send parameters through the
> Reportpath property I get the following errors.
>
> When I set a param a value this is the error I get:
>
> An attempt was made to set a report parameter 'param_IdServer' that is
> not defined in this report. (rsUnknownReportParameter) Get Online Help
>
> When I dont pass any params but still have the command
> rc:Parameters=false& in the URL i get the follow error.
>
> The path of the item '/projectname/reportname,' is not valid. The full
> path must be less than 260 characters long, must start with slash;
> other restrictions apply. Check the documentation for complete set of
> restrictions. (rsInvalidItemPath) Get Online Help
>
> I would like to know where is the problem.
>
> Thanks
> Ravi
>|||Hello Jeff,
Thankx for the help. I got it going, but my client doesnt want that
interface.
they dont want any part of the RS interface.
I am figuring out how to implement using the Web Service API.
I am able to print reports with parameters but having issues when there
are images in the reports.
I need to use the RenderStream method to render different streams. But
having a host of issues there.
Thankx
Ravi|||I am back to square one. The customer doesnt want the web service
interface as well. After comparing the pros and cons he wants the
Reportviewer Control.
Here is how its supposed to look.
A frame based page.
Left Frame --> a treeview or a menu like listing of all the reports
Right Frame --> when the user clicks a report I should render the
Reportviewer object for that report.
Now I have some questions of the Reportviewer as well.
1. Can I seperate the params part and the report part into 2 diff
frames ?
Thx
Ravi|||Hello Jeff,
I am using a treeview control from IE web control to provide a
navigation of all reports on the server. My intent is to achieve
scenario where I have the list of reports on the left and click on a
report will open the reportviewer control on the right (i placed inside
a html table).
The problem is i am not able to tie the Url of the treenode to
reportviewer control.
Any ideas on how to achieve this ?
Also any other better way to implement a navigator instead of this
treeview. I have already implemented using the dropdown menu but i want
something that shows all the reports at a time.
Thx
ravi
I have been looking at various models and ways to implement a custom
interface for the Reporting Services.
My client wants some kind of a
default website (should be available only in the Intranet)
where he can get
1. an interface with a list of reports.
2. The fields required for the parameters of each report.
3. A submit there should send the params to the RS and the results
should be printed, probably in a frame. I would like to get back the
exact output including all the taskbar items of RS interface.
I have been trying building an ASP.NET webapp or use the reportviewer
control etc. but getting confused.
I am sure someone has done this before. Would like some suggestions on
which is the better option for me and some hints on where to start.
Help will be appreciated very much
Thanks
RaviCheck this site, it should get you started...
http://www.odetocode.com/Articles/128.aspx
--
bs
kingofthegreens.com
"RemoteDeploy" wrote:
> Hello all,
> I have been looking at various models and ways to implement a custom
> interface for the Reporting Services.
> My client wants some kind of a
> default website (should be available only in the Intranet)
> where he can get
> 1. an interface with a list of reports.
> 2. The fields required for the parameters of each report.
> 3. A submit there should send the params to the RS and the results
> should be printed, probably in a frame. I would like to get back the
> exact output including all the taskbar items of RS interface.
> I have been trying building an ASP.NET webapp or use the reportviewer
> control etc. but getting confused.
> I am sure someone has done this before. Would like some suggestions on
> which is the better option for me and some hints on where to start.
> Help will be appreciated very much
> Thanks
> Ravi
>|||Ben,
Thanks for the reply. I have checked that site and created an example
and show that to the client. But they wanted more custom look and feel.
So I am looking at using RS web services interface and I am getting
lost there.
Ravi|||The ReportViewer control is a good place to start. You may need to modify
it a bit to support changing parameters and report links (search this
newsgroup for ReplacementRoot for more info).
You can use the web service interface on a starting page that obtains a list
of reports to put on a web page, and -- it sounds like the way your customer
wants it -- obtains a list of parameters as well. That page can then post
the report and parameters to a report display page with the ReportViewer
control on it, and set the ReportViewer values accordingly there.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1108490439.909791.62940@.g14g2000cwa.googlegroups.com...
> Ben,
> Thanks for the reply. I have checked that site and created an example
> and show that to the client. But they wanted more custom look and feel.
> So I am looking at using RS web services interface and I am getting
> lost there.
> Ravi
>|||hello jeff,
thanks for the advice.
I am trying to use the reportviewer control to publish reports in
another website to provide customised interface.
I am using the example at
http://www.odetocode.com/Articles/128.aspx to try to make it work.
It works fine normal. I get a frame of params and after Submitting i
get the report in another frame.
When I try to hide the paramters frame and send parameters through the
Reportpath property I get the following errors.
When I set a param a value this is the error I get:
An attempt was made to set a report parameter 'param_IdServer' that is
not defined in this report. (rsUnknownReportParameter) Get Online Help
When I dont pass any params but still have the command
rc:Parameters=false& in the URL i get the follow error.
The path of the item '/projectname/reportname,' is not valid. The full
path must be less than 260 characters long, must start with slash;
other restrictions apply. Check the documentation for complete set of
restrictions. (rsInvalidItemPath) Get Online Help
I would like to know where is the problem.
Thanks
Ravi|||Can you provide the full URL that is being passed to the ReportServer? That
might give a clue as to the error. You can munge the server name if you're
concerned about privacy.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1108516594.197188.258640@.g14g2000cwa.googlegroups.com...
> hello jeff,
> thanks for the advice.
> I am trying to use the reportviewer control to publish reports in
> another website to provide customised interface.
> I am using the example at
> http://www.odetocode.com/Articles/128.aspx to try to make it work.
> It works fine normal. I get a frame of params and after Submitting i
> get the report in another frame.
>
> When I try to hide the paramters frame and send parameters through the
> Reportpath property I get the following errors.
>
> When I set a param a value this is the error I get:
>
> An attempt was made to set a report parameter 'param_IdServer' that is
> not defined in this report. (rsUnknownReportParameter) Get Online Help
>
> When I dont pass any params but still have the command
> rc:Parameters=false& in the URL i get the follow error.
>
> The path of the item '/projectname/reportname,' is not valid. The full
> path must be less than 260 characters long, must start with slash;
> other restrictions apply. Check the documentation for complete set of
> restrictions. (rsInvalidItemPath) Get Online Help
>
> I would like to know where is the problem.
>
> Thanks
> Ravi
>|||Hello Jeff,
Thankx for the help. I got it going, but my client doesnt want that
interface.
they dont want any part of the RS interface.
I am figuring out how to implement using the Web Service API.
I am able to print reports with parameters but having issues when there
are images in the reports.
I need to use the RenderStream method to render different streams. But
having a host of issues there.
Thankx
Ravi|||I am back to square one. The customer doesnt want the web service
interface as well. After comparing the pros and cons he wants the
Reportviewer Control.
Here is how its supposed to look.
A frame based page.
Left Frame --> a treeview or a menu like listing of all the reports
Right Frame --> when the user clicks a report I should render the
Reportviewer object for that report.
Now I have some questions of the Reportviewer as well.
1. Can I seperate the params part and the report part into 2 diff
frames ?
Thx
Ravi|||Hello Jeff,
I am using a treeview control from IE web control to provide a
navigation of all reports on the server. My intent is to achieve
scenario where I have the list of reports on the left and click on a
report will open the reportviewer control on the right (i placed inside
a html table).
The problem is i am not able to tie the Url of the treenode to
reportviewer control.
Any ideas on how to achieve this ?
Also any other better way to implement a navigator instead of this
treeview. I have already implemented using the dropdown menu but i want
something that shows all the reports at a time.
Thx
ravi
Tuesday, March 20, 2012
Reports in various browsers
What's concensus for report behavior in browsers other than MSIE? Once i'd
formatted my report to display all nice in MSIE, i looked at it in NS 4.79
and Firefox, and it looked drastically different.
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comCheck out your local copy of Reporting Services BOL for browser types
supported by Reporting Services. Here is the online version:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsmain/htm/rsc_arch_data_browsers_v1_6jzn.asp
I noticed that my local copy of BOL has Netscape 7.01 on the list, but we
are running RS SP1.
--
erik perez
www.solien.com
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:%23z5GZaCkEHA.1356@.TK2MSFTNGP09.phx.gbl...
> What's concensus for report behavior in browsers other than MSIE? Once i'd
> formatted my report to display all nice in MSIE, i looked at it in NS 4.79
> and Firefox, and it looked drastically different.
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>
formatted my report to display all nice in MSIE, i looked at it in NS 4.79
and Firefox, and it looked drastically different.
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comCheck out your local copy of Reporting Services BOL for browser types
supported by Reporting Services. Here is the online version:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsmain/htm/rsc_arch_data_browsers_v1_6jzn.asp
I noticed that my local copy of BOL has Netscape 7.01 on the list, but we
are running RS SP1.
--
erik perez
www.solien.com
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:%23z5GZaCkEHA.1356@.TK2MSFTNGP09.phx.gbl...
> What's concensus for report behavior in browsers other than MSIE? Once i'd
> formatted my report to display all nice in MSIE, i looked at it in NS 4.79
> and Firefox, and it looked drastically different.
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>
Friday, March 9, 2012
ReportItems in Page Footer
I have several text boxes in the page footer of my report, which reference
various ReportItems. The values are displayed correctly when previewing the
report. However, when I print the report the values are not printed. All of
the other textboxes which contain static information is printing correctly,
so it has something to do with the ReportItems.
Has anyone seen this problem before?Rendering extensions treat report items in the header and footer
differently. The HTML rendering extension seems to have no problem at all
with exposing values in textboxes that somehow reference values in a
dataset. I've had similar problems with PDF rendered reports where the data
showed up in the HTML rendered report but didn't show up in the PDF rendered
version. As a rule, stay away from placing databound data in the header or
footer. You can work around this through diligent use of rectangles and
repeating sections in the body of the report.
-Tim
"Jen Torres" <Jen Torres@.discussions.microsoft.com> wrote in message
news:7B2B4BF4-99F5-42E9-B2B5-9090174290EC@.microsoft.com...
>I have several text boxes in the page footer of my report, which reference
> various ReportItems. The values are displayed correctly when previewing
> the
> report. However, when I print the report the values are not printed. All
> of
> the other textboxes which contain static information is printing
> correctly,
> so it has something to do with the ReportItems.
> Has anyone seen this problem before?
various ReportItems. The values are displayed correctly when previewing the
report. However, when I print the report the values are not printed. All of
the other textboxes which contain static information is printing correctly,
so it has something to do with the ReportItems.
Has anyone seen this problem before?Rendering extensions treat report items in the header and footer
differently. The HTML rendering extension seems to have no problem at all
with exposing values in textboxes that somehow reference values in a
dataset. I've had similar problems with PDF rendered reports where the data
showed up in the HTML rendered report but didn't show up in the PDF rendered
version. As a rule, stay away from placing databound data in the header or
footer. You can work around this through diligent use of rectangles and
repeating sections in the body of the report.
-Tim
"Jen Torres" <Jen Torres@.discussions.microsoft.com> wrote in message
news:7B2B4BF4-99F5-42E9-B2B5-9090174290EC@.microsoft.com...
>I have several text boxes in the page footer of my report, which reference
> various ReportItems. The values are displayed correctly when previewing
> the
> report. However, when I print the report the values are not printed. All
> of
> the other textboxes which contain static information is printing
> correctly,
> so it has something to do with the ReportItems.
> Has anyone seen this problem before?
Subscribe to:
Posts (Atom)