create a page index for a long crystal report

I have to create a page index for a long crystal report which is grouped by product group. Is there any way to create a page index using crystal report to identify the page number in which the product group is appear in the reportHi,

I think you can create Table of contents for the report in the Report header. I haven't worked on this as it requires CR 10... Im working on CR 8.x.. You can refer this article, which explains how to do it.

http://support.businessobjects.com/library/kbase/articles/c2011950.asp

Let me know if it works.

Bye,

Praveen|||Hi,

yes it can possible in CR 9 and CR 10 version,but we are using CR 8.x
is it possible in CR 8.x

thanks

sujesh

cr90devwin_en.exe error

Hello,

In our organization we are using a mat work a client registration software.
To generate reports there we are using the Crystal reports.
De client registration application running on 4 Citrix servers.
Last month after an abdate of the application there were problems with the reporting system.
The advice of the application liverancier was the installation of the (cr90devwin_en.exe). I have installed the exe on 3 servers without problems and the problem is resolved.
When I run the exe on the fourth server he begins with the stopping of the www, smtp and IIS manager services, and then I am getting the error message (can not create backup folder). check the attachment

Maybe you know how can i solve this problem.

Thanx in advanceSee if you find answer here

http://support.businessobjects.com/

CR9 Runtime Components ?

Dear All,
I developed an application in VC++ 6.0 with Crystal Reports 9.0.

Now i want to deploy my application on client machine but i don't now what components (files, dll) of CR are required to register or deploy with my application.

Would some body please help me, its really very urgent.Hi! All!

I'm aslo having the same problem in CR9 Runtime Components in Client machine.

I'm using VB 6 & Crystal Reports 9.

What are all the CR9 componenets or dll files need to be installed in Client machine?

Please if anyone help me to solve this problem.

Thanks.

-Raja|||Visit the next urls -->

http://support.businessobjects.com/communityCS/TechnicalPapers/rdc9_deployment.pdf.asp

http://support.businessobjects.com/documentation/installation_resources/crystal_reports/cr9.asp

CR8.5 COM documentation

Hi

I'm a VB and CR newbie.

I have been looking for some documentation about which methods I can use on a crystal report object. I have found at lot of examples using google but almost none of them shows more than just creating the object and open the report.

I would like to send a SQL string to the report and execute it.

I'm using VB5

Where can I find the documentation about this?

cheers
Henryjust do an online search for documentation. i do have it, bt its 5.x MB, so i dont think it'll upload here...i cant remember the exact url i found it...
http://www.businessobjects.com
try that...
Also, try the samples in crystal. it should be in ur Crystal installed folder-->
E:\Crystal\Samples\En\Code\Visual Basic
tons of support!
(I can show u how slove ur prob, bt i only know in vc++)

CR8.5 and VB6 - I dont want it to create the form!

Every time I add a new Crystal Report to my VB6 project it used to ask if I wanted to add a form with the viewer control on it automatically (it also asked something else, but I can't remember what). I got sick of hitting "No" then "OK" so I checked the "don't ask me this question again" style box.

Now, every time I add a report it also adds a form to my project with the viewer control. I don't want it to do this, as it's annoying removing the useless form and it is screwing with my source control. And it does it even though when i checked the "don't ask me... " i told it not to create the form.

So I've checked all the settings I can find and I can't find anything to stop it happening. Does anyone have a quick fix to this before I go trawling through the registry to find a solution?update - i trawled the registry, found some likely candidates, but none of them worked. It's real frustrating, so any help will be appreciated, but I can live with it (I've lived with worse)

CR10 RDC Default Printer Issue

Hi All,

I'm glad to have found this forum! I've slogged thru Crystal issues on my own for quite a while now and it's a relief to have a place to go to share information. I have a few questions today, so please bare with me.

I'm converting an ASP application from CR8 to CR10 CE Embedded. For the most part I'm using RAS to display and print reports. I have a couple of reports where the users send the reports directly to the printer without viewing them first.

First question, is there a way of sending a report directly to the printer and not the viewer in RAS? I haven't come across one and it looks like I'll have to use RDC for those reports.

I'm experimenting with RDC in ASP and I'm having an issue with the default printer.

Second question, how do you set the printer using RDC? I'm using the following code:

Set session ("oApp") = Server.CreateObject("CrystalRuntime.Application.10")

Set session("oRpt") = session("oApp").OpenReport(application("RASReportPath") + "XYTDailySchedule_test.rpt")

session("oRpt").SelectPrinter "winspool.drv", "DuplicationLaserJet", "P3_10.1.2.200"
session("oRpt").PrintOut false

The report keeps printing to the default printer, no matter what I'm setting it to programmatically. I thought maybe it had to do with the printer selected in the Report Designer, so I set that to "No Printer", and that didn't help.

I popped the oRpt object into the debug watch window and observed that the SelectPrinter method did not change the properties in oRpt. Hmmmm! Not sure what is going on there.

Third question, is there a good resource somewhere for learning the RDC and RAS object models? I can see the properties in a debug window, but I have not found good documentation on the methods. I have found that Business Objects has not improved the product documentation since they took over. It would really be nice to find a clear, concise reference of the object models.

Thanks!

LindaSecond question, how do you set the printer using RDC? I'm using the following code:

Set session ("oApp") = Server.CreateObject("CrystalRuntime.Application.10")

Set session("oRpt") = session("oApp").OpenReport(application("RASReportPath") + "XYTDailySchedule_test.rpt")

session("oRpt").SelectPrinter "winspool.drv", "DuplicationLaserJet", "P3_10.1.2.200"
session("oRpt").PrintOut false

I was able to figure this out on my own and am posting the solution in case somebody else is in the same boat. I had an error in the DeviceName and Port parameters. SelectPrinter must do validation before applying the parameters supplied. If the parameters are incorrect SelectPrinter does not change the printer settings. Perhaps there is a property in the RDC to trigger an error if this happens.........it certainly would have been useful to me!

I would still like to hear if anyone knows how to send a report directly to the printer using RAS, or if anyone has come across some good documentation of the RAS and RDC API's.

Thanks!

Linda|||First question, is there a way of sending a report directly to the printer and not the viewer in RAS? I haven't come across one and it looks like I'll have to use RDC for those reports.

VICTORY!!!! Just for the record, I was told months ago by Business Objects that this was impossible. I came across a white paper today, on the Business Objects site, that discusses RAS Server-Server Side printing, and gives you the code sample as well. Here it is:

http://www.buisnessobjects.com/global/pdf/dev_zone/ras_serverside_printing.pdf?ref=devzone_netzone_archive

Linda

CR.NET Logo on the Browser

Hi,
Is there a way to avoid the "Powered By crystal" logo from appearing on the IE Browser.
I'm using VS.NET, C# & CR.NET 2002.
Thanks in advance for replies.
PraveenIf your using Crystal reports viewer, on the properites tab under toolbar set the value of 'Has Crystal Logo" to false OR in code "CrystalReportviewer1.HasCrystalLogo=False"

CR XI Report printing in Landscape instead of Portrait

CR XI Report printing in Landscape instead of Portrait

Even though we specify the orientation of report in Crystal reports XI as Portrait during design time from report designer (i.e. File -> Page Setup), while printing it uses the default printer options i.e. orientation set to Landscape and prints the report in Landscape.

But the same report in Crystal report 7.0, when set to Portrait at design time from report designer, it print as set in the report designer i.e. Portrait and does not take default printer settings.

In Crystal Reports 7.0 have File -> Page Set up and File -> Printer set up options, using which the report orientation can be set, where as in Crystal Report XI has File -> set up options only.

Why is this wierd behaviour using CR XI ? Any idea.

We are using VB 6.0, Could the printer settings be supplied from VB 6.0 programmatically.

I would appreciate if anybody could help in this regard.

Thanks,try this found in crystal report samples.

Thanks

CR to SQL RS

Sorry, already posted this but forgot to use new MSDN nospam alias so
here it goes again...
Has anyone actually found a Crystal 8.5, 9, or 10 conversion tool to
take those reports to MS SQL RS? Seems like this would have been a
great tool for MS to do, but perhaps they're worried about the gov't
slamming them again for stealing biz from Crystal.Hi Brian,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to know whether there
is any tools available to convert RDL from RPT files. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, I am afraid there is no native support in Reporting
Services 2000 to do this. However, check our consulting partners site and
contact them directly for a service/product combination to help you with
this:
http://www.microsoft.com/sql/reporting/partners/consulting.asp
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||I heard that HP have created some tools to help convert rpt to rdl files but
they will not sell or release them as there are some concerns with how their
code accesses the rpt files. In short its a real problem but also an
opportunity. While it would be great to convert a crystal report to an rdl
report it would be better to rebuild the report to take full advantage of
srs features
--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:ZiraR1YkFHA.940@.TK2MSFTNGXA01.phx.gbl...
> Hi Brian,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to know whether there
> is any tools available to convert RDL from RPT files. If I have
> misunderstood your concern, please feel free to point it out.
> Based on my knowledge, I am afraid there is no native support in Reporting
> Services 2000 to do this. However, check our consulting partners site and
> contact them directly for a service/product combination to help you with
> this:
> http://www.microsoft.com/sql/reporting/partners/consulting.asp
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi
The only place I have heard of is http://www.rpttosql.com/
I know nothing about this company and I don't know if they are any
good. I have also heard newsgroup whispers about another (unknown)
company developing, selling and withdrawing an automated tool. I
believe that there were som intellectual property concerns about how
they accessed / reverse engineered crystal reports.
In short, the conversion process will probably be expensive for you and
it may be best to simply start again from scratch...
Anyone who manages to create a piece of software to do the conversion
and can get past any legal problems will be on to a winner!!!
Kulgan.|||"Kulgan" <nickamckenna@.gmail.com> wrote:
>Hi
>The only place I have heard of is http://www.rpttosql.com/
>I know nothing about this company and I don't know if they are any
>good. I have also heard newsgroup whispers about another (unknown)
>company developing, selling and withdrawing an automated tool. I
>believe that there were som intellectual property concerns about how
>they accessed / reverse engineered crystal reports.
>In short, the conversion process will probably be expensive for you and
>it may be best to simply start again from scratch...
>Anyone who manages to create a piece of software to do the conversion
>and can get past any legal problems will be on to a winner!!!
>Kulgan.
Thanks. I think we'll give them a try with their consultant program.
Not too bad for the price.
Sincerely,
Brian S. Bergin
Please post replies here so everyone may benefit.
msdndotnntpdotnospamdot1atcomceptdotnet (replace dot with .)

CR Server ?

Can SQL Server RS coexist with Crystal Report Server - Report Application
Server ?
ThanksAlthough I have not installed both at the same time, SQL RS is simply a DOT
NET ASP Application that should be able to co-exist with almost anything
else. ( expect it's own beta version perhaps.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Stephen" <anonymous@.discussions.microsoft.com> wrote in message
news:%23EJ2zhjeFHA.1328@.TK2MSFTNGP12.phx.gbl...
> Can SQL Server RS coexist with Crystal Report Server - Report Application
> Server ?
> Thanks
>

CR interactivity in question..

I have a web application. When the user presses a button a crystal report comes on screen.

What i need to know is, if there is a possibility to implement this:

"When the user clicks on a certain field on a certain row, i want to run function A in my web application, with parameters the row clicked and the field clicked".

i just wanna add on-click code in field level (or perhaps add in my report a button to do sth), can i do that??

ThanksYou can use parameters to pass the information from your app to Crystal. I don't know that proper syntax though.

Try searching Crystal's website:
http://support.businessobjects.com/search/advsearch.asp

Or Crystal's Forum:
http://support.businessobjects.com/forums/default.asp|||What are you trying to do?
1. Do you want to select a report based on data in selected row?
2. Or do you want to see more data related to the row you selected?

If your option is 1, then use a DataGrid and populate it with records, and then when user clicks on selected row, trap the click event and pass the value of that row to a Crystal Report as the parameter for that report.
For some help with parameters and how to use them in .NET, try this link:
http://support.businessobjects.com/library/kbase/articles/c2010247.asp

If it's 2, design the report so that it has an "On-Demand" subreport, so that user can click the link which will appear in your Details section, which will trigger the subreport based on the data in that report line.

It's helpful if your question details the implementation, "I have a web application." really doesn't tell us enough, so I've presumed it's .NET, because .NET incorporates basic Crystal functionality.

Dave|||I need to put a control, say a button inside the report. When the user presses the button i want something else, irrelevant of the report to happen (e.g. navigate to a certain page).

1) How can i add a button in my report?
2) How do i trap the on-click event?

Thanks

CR in VB.Net

I have one dataset of having values I wants to Create one Report.
How to Create a Crystal Report in Vb.net?You can try Crystal Report available in .NET. It's much easier and has lots of options.|||How to Connect one dataSet to one Crystal Report in VB.net?

CR from only code(VS 2005)

Hey gurus

I need to create a crystal report entirely from code

i have a form where a customer will add table(s) to a list box, depending on the added tables, a list of fields applicable to the respective table can be added to another list. On selection of each of these fields, values may be entered so as to filter the data displayed on the report.

From each of the availble fields that can be "Parametized", a group can be created, with ascending/descending order

Finally summaries can be added such as the sum of all amounts(total,VAT etc) to the end of the report
Report options like drill-down will need to be able to be set dynamically also.

so far everything above here is basicly how to generate my SQL statement, which won'y be that difficult.

But i have no idea how to make my report document show information the way i have described above.

left list < > right list (Panel with combobox, textbox , checkbox(enable/disable))

tables,field, groups are added/removed as depicted above
fields and groups have a panel next to each rightlistbox where parameters can be set like (< = > between like <> asc desc)

at the bottom of the form there are 3 buttons
Preview report data --> shows datagrid of Data retrieved via generated SQL statement
Preview Report --> shows a itempanel with items for each field/group/summary field
Create report - Creates crystal report and shows in report viewer on a tab created before the report begins creation

At this point, i am not very close to being far from completion
any help will be greatly appreciated
Thanks
Jsee attached file of GUI so you can get a better idea of what i am trying to do, sorry bout bad quality 100kb is not alot but sufficient|||I have made some progress on this

The code below shows the population of a dataset and subsequently binding it to a report, then showing that report in a report viewer control on a new tab created here also.

The report is completely blank. There is however data in the TRDS dataset



Private Sub MakeReport()

Dim TRDS As New DataSet

Dim ConString As String = ""

Dim CON As OleDb.OleDbConnection

Dim DA As OleDb.OleDbDataAdapter

Dim NewTabPanel As New DevComponents.DotNetBar.TabControlPanel

Dim RptUC As New ReportOnTab ' Usercontrol with crystal reportviewer on a panel

'Get Data

Try

TRDS = New Report1DataSet

If My.Settings.User_Claims_ManagementConnection_String = "" Then

ConString = My.Settings.Claims_Management_SystemConnectionString.ToString

Else

ConString = My.Settings.User_Claims_ManagementConnection_String.ToString

End If

CON = New OleDb.OleDbConnection(ConString)

DA = New OleDb.OleDbDataAdapter(FullSQL, CON)

'Fill the dataset

DA.Fill(TRDS, "Client")

'Make report on new tab

NewTabPanel.Name = "NewTab_Panel"

NewTabPanel.Text = "This is the new reports panel"

'Report creation

Report = New Report1

'Settings for the report

'Set datasource to the generated dataset

Report.SetDataSource(TRDS)

'At this point there is a blank report, with a dataset attached to it containing, one table and rows filtered by where in FULLSQL

'Set groups

'Add fields that will be shown to detail section

'Add summaries

'Apply formatting

'End of report creation

'Create tab on tab control

ReportTab.CreateTab("Name of this report", -1)

'Attach usercontrol to tab panel and make dock fill

ReportTab.Tabs.Item(ReportTab.Tabs.Count - 1).AttachedControl.Controls.Add(RptUC)

ReportTab.Tabs.Item(ReportTab.Tabs.Count - 1).AttachedControl.Controls.Item(0).Dock = DockStyle.Fill

'Reset the report creation form

ReportDefinitionsClear()

'Select the newly created tab

ReportTab.SelectedTab = ReportTab.Tabs.Item(ReportTab.Tabs.Count - 1)

'Set source of the usercontrol report viewer to this report

RptUC.ReportViewer.ReportSource = Report

Catch ex As Exception

MessageBox.Show(ex.Message)

End Try

End Sub



now the FULLSQL variable is rather dynamic and is generated through use of the above picture's gui, thats 2000 lines, shud i post that to?

anyway, it works, all i need to do now is...

1.! create fields from the SELECT statement on the report

2.! create groups via the ORDERBY statement on the report

3.! Finally add any other summaries,special fields, and so on to the report

My question is how do i achieve such a feat,

How do i add groups via code to the detail section?
How do i add fields via code to my blank reports detail section?
Is it even possible?

So far have discovered that most things within the report1 class are readonly.

I have looked everywhere online, searched for 2 days and found nothing like this

Please help
Thanks
J

CR Format

Hello,

Is there a way to format the data when it is passed into the Crystal Report(CR).. for example.. In the original table, a number may be left aligned, how to change it to right alignment?.. in other words I want to change it's

1. Format: Horizontal Alignment
2. from Left To Right
3. if the data passed in is an Integer, Currency, or DateTime.

4. There is a Format Formula Editor beside it. Does anyone know what's the syntax to do the alignment either in crystal syntax or in basic syntax.

thanx1. You can add a Parameter field in Crystal Report.

2. Pass the value to this Parameter field.
// Solution

Report.ParameterFields(1).AddCurrentValue (strkey1)

Remark : (a) ParameterFields(1) is the FIRST PARAMETER ADDED IN CR.
(b) strkey1 is the value or variable that contains the string or
any value that is received to be passed on to CR.
(c) Place this parameter field wherever you require in CR you
created.

3. You can format this Parameter field in Crystal Report as you WISH.

CR 8.5, dual monitor printing issues, delphi

Hi Guys,

We develop software in Delphi and Crystal Report 8.5 is used as reporting tool. Delphi's crystal component is used for coding.

I have a situation with a potential client. They have toshiba tecra m2 laptop which has GEForce FX 5200 video card which is dual monitor card. The OS is XP with SP2. When I click preview it is fetching data from the database and after that it hangs for ever neither displays view window or print. If the Harware accelaration is changed to 0 and Enable write combining is checked for this hardware properties the reports can be viewed and printed. But the client said these hardware properties are required for other applications on the machine.

Could any one help me resolving the issue? Is there any one have similar kind of problem?

Thanks in advance.

-KtuserThis behaviors can occur because of the 'Hardware acceleration' setting in Microsoft Windows. Reducing hardware acceleration on your computer will resolve these behaviors.

To access the 'Hardware acceleration' setting in Microsoft Windows, click Start > Settings > Control Panel > System > Display > Settings > Advanced > Troubleshooting.

There are typically six possible settings for 'Hardware acceleration': from 'None' to 'Full'. Reduce this value one setting at a time until the above behaviors are resolved.

The behavior of 'Enable write combining' has not been tested so not sure about it. Try the following along with the 'Enable write combining' checked and unchecked.

CR 8.5 - (almost) blank first page

Hi,

Having a problem with crystal reports 8.5 (from within VB6). searched and searched, to no avail, so now I post... :)

i have a report with the following layout:
-Report header
-Page header
-Group header 1
-detail
-group footer 1
-page footer
-report footer

Problem is, if group 1 will not fit on the first page of the report, then the first page will print with only the report header and report footer on it - nothing else.

I've tried unchecking all the "Keep together" options on the sections but it doesn't change a thing. any advice people? i found an article talking about this problem and how V10 fixes it, but surely there is a workaround (or at least something). Frankly, I don't care if it puts half a section on a page if it will fit complete on the next - i just don't want this silly blank first page printing.Have you remembered checking off the Keep Group together option in both the Change Group Options and Format Section Menues? Doing this for all groups has worked for me this far.

- Jukka|||Great stuff - it works. Thanks heaps for actually finding this post and replying to it. I'd given up!

CR 10 creating charts

I am using Visual Studio 2005 VB.NET and Crystal Reports 10. I need to create a line graph on a crystal report by sending it a dataset from the vb.net page. I am new to this. Does anyone have any example code or know of any websites that demonstrate how to do this?Please see here (http://www.dev-archive.com/forum/showthread.php?t=409951)

CR / VB Sort Problem

OS= Windows XP SP2 Professional, Crystal Report XI Developers Edition, Visual Basic 6 Enterprise

Below is the code I am trying to use to print a report. This code except for this "ElseIf" statement is used and works fine to print other reports. The only difference between printing this report and the other reports is 1) the name of the report and 2) this is the only report I have a sortfield.
.
.
.
ElseIf ReportName = "Alternate.rpt" Then
Set craxreport = craxapp.OpenReport(ReportPath & "\" & ReportName)
Set dbTable = craxreport.Database.Tables(1)
craxreport.RecordSortFields(0) = "+{AlternatePart.dbEnterDate}"
End If
craxreport.DiscardSavedData
' ****************************************************************************************
CrystalActiveXReportViewer1.Refresh
Call CrystalActiveXReportViewer1_RefreshButtonClicked(True)
CrystalActiveXReportViewer1.ReportSource = craxreport
CrystalActiveXReportViewer1.ViewReport
Set craxreport = Nothing
When I run this code, if I keep "craxreport.RecordSortFields(0) " I get a "Subscript out of Range" error.

The report is defined as follows:
- It uses a table called "AlternatePart"
- There are 3 fields in the table - (dbOldPn, dbNewPn, and dbEnterDate)
- All fields are described at TEXT
- The report shows all 3 fields.
- I used the Record Sort Expert to set up one sort field and that is "AlternatePart.dbEnterDate"

Can you tell me what is possibly causing the above error?

ThanksI have a little experience with crax.
I think maybe Indexes are not zero based. try index 1|||Yes try using craxreport.RecordSortFields(1) and see if it is working|||Yes try using craxreport.RecordSortFields(1) and see if it is working
That was the problem -- thank you.

Sam

CR &SQL

Hi all,

How to add Query Execution at detailed band of Crystal Report
pls
Here is my Code

Dim strSQL As String
Dim cn As New ADODB.Connection
Dim connectionstring As String

connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Program Files\Microsoft Visual Studio\Vb98\Prepaid Management System\Login.mdb"

cn.Open connectionstring

strSQL = "SELECT i.*, ii.* " _
& "FROM Inwards i LEFT JOIN Inwards_item ii ON i.receipt_no = ii.Receipt_no " _
& "WHERE ii.Receipt_no = " & inputinward.Txtreceiptno.Text
Debug.Print strSQL
CrystalReport1.SQLQuery = strSQL
cn.Execute strSQL
'CrystalReport1.DataSource = strSQL
CrystalReport1.ReportTitle = "Inwards Print Invoice Report"
CrystalReport1.Action = 1

cn.CloseMay be like this:
[code]
...
Dim rs as ADODB.RecordSet
Set rs = cn.Execute strSQL
CrystalReport1.DataSource = rs
CrystalReport1.ReportTitle = "Inwards Print Invoice Report"
...
[code]|||set rs = cn.Execute strSQL

Expectedn End of Statement.........

Couple of Questions about RS2005

My client was using Reporting Services 2000, but is currently leaning toward
Crystal Reports XI. The reason being is that most of their data is filtered
through DLLs providing business logic. In RS2000, the only way to use the
DLLs as a data source was to write an extension and essentially hard code
the calls to methods and parameters inside the extenstion. Their complaint
was that every time they had to add something they had to recompile the
extension, send it to the server admins, wait for installation and so on.
With CRXI, all they had to do was point to the DLL as a data source and they
were prompted for the method to use as well as paramters and so on. Is
something like what CRXI (and CRX for that matter) provides in RS2005? Can
they use a DLL for a Datasource without writing a wrapper every time?
On a second question, another client of mine is using SQL RS2000 with
Oracle providing the data for the reports and VS 2003 as the application.
We are late in the developement of the application but are considering
upgrading to RS 2005. I have been unable to give them several reasons why
upgrading to RS 2005 would benefit them, since i can only see a few
drawbacks. One drawback is that they would have to use a seperate IDE to
create the reports (the VS2005 like IDE). One thing they liked was the
ability to run ad-hoc reports and use an embedded viewer instead of a web
browser (we currently have IE embedded in the app to display reports). I am
under the impression that the Report Viewer component will only work with
VS2005 (.NET 2.0). Is this correct? Is there any way to use the component
with VS 2003 and .NET 1.1? We can't upgrade the app to 2005 anytime real
soon. Also, a list of benefits to RS 2005 would be greatly appreciated.
Thanks,
Rob Edwards
For the first question, I don't see why you need to hard code the method calls. for the query language for their data extension, they can use a syntax like:

class.method (parameter1, parameter2)

They can parse the call, load their assembly, use reflection to grab the class definition and execute the method (look at Type.GetMethod) using the parameters. The extension never needs to change, just the business object.

For the second question, the ReportViewer controls don't work with VS 2003. You can, however, use VS 2003 to publish to RS 2005. You won't get any of the new report design features (multi-value parameters, end user sort, etc.) until you move to VS 2005.