Best practices for multiple report developers?

Two crystal reports developers are about to join me writing reports for
Reporting Services. Neither has used RS before and I don't believe either
has ever used Visual Studio.
I am concerned about what will happen when they build/deploy a project.
Will we end up with multiple unwanted folders and data sources? I thought
maybe we could all use copies of the same solution but I also want to use
SourceSafe and i dont want to worry about checking different versions in on
top of each other.
I would really like something like Visual InterDev 6 where multiple
developers connect their own solutions to a web application and all of the
resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a good
way to do this with the Report Designer?
Any thoughts or links regarding multi-developer coordination issues would be
greatly appreciated.I always use shared data sources. Once a shared data source is deployed it
is not overwritten unless you explicitly do so. When you deploy it will try
to deploy the data source, see that one is there and just give you a warning
that it was not deployed.
If you decide on the folder structure and name your projects the same, then
you should not have a problem (as long as you don't name the reports the
same.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:EF163B30-8423-4F02-8B09-FC9C50D6A070@.microsoft.com...
> Two crystal reports developers are about to join me writing reports for
> Reporting Services. Neither has used RS before and I don't believe either
> has ever used Visual Studio.
> I am concerned about what will happen when they build/deploy a project.
> Will we end up with multiple unwanted folders and data sources? I thought
> maybe we could all use copies of the same solution but I also want to use
> SourceSafe and i dont want to worry about checking different versions in
> on
> top of each other.
> I would really like something like Visual InterDev 6 where multiple
> developers connect their own solutions to a web application and all of the
> resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a
> good
> way to do this with the Report Designer?
> Any thoughts or links regarding multi-developer coordination issues would
> be
> greatly appreciated.|||Is it possible for the Report Designer to "download" or otherwise learn about
the available shared data sources or is the only way to add the *.RDL file to
the project?
Thanks!
PS: Sorry for all the duplicates, I goofed up while trying to sign up for
passport at the same time as writing my question.
"Bruce L-C [MVP]" wrote:
> I always use shared data sources. Once a shared data source is deployed it
> is not overwritten unless you explicitly do so. When you deploy it will try
> to deploy the data source, see that one is there and just give you a warning
> that it was not deployed.
> If you decide on the folder structure and name your projects the same, then
> you should not have a problem (as long as you don't name the reports the
> same.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Al" <Al@.discussions.microsoft.com> wrote in message
> news:EF163B30-8423-4F02-8B09-FC9C50D6A070@.microsoft.com...
> > Two crystal reports developers are about to join me writing reports for
> > Reporting Services. Neither has used RS before and I don't believe either
> > has ever used Visual Studio.
> >
> > I am concerned about what will happen when they build/deploy a project.
> > Will we end up with multiple unwanted folders and data sources? I thought
> > maybe we could all use copies of the same solution but I also want to use
> > SourceSafe and i dont want to worry about checking different versions in
> > on
> > top of each other.
> >
> > I would really like something like Visual InterDev 6 where multiple
> > developers connect their own solutions to a web application and all of the
> > resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a
> > good
> > way to do this with the Report Designer?
> >
> > Any thoughts or links regarding multi-developer coordination issues would
> > be
> > greatly appreciated.
>
>|||If you've made shared data sources you should have an .rds file which
is the actual data source.
Once it's been migrated to the rs server it doesnt' get updated unless
it's deleted or someone explicitly updates it, so for developing local,
we've just emailed the rds to each other. ( you can find it in My
documents/Visual Studio Projects/ProjectName... or if you're using
source safe they should be able to grab a copy from there)|||On Shared Data Sources, there is also a flag in the Properties
Pages/Configuration Properties/General for "OverwriteDataSources" which
defaults to False. Just make sure no one sets that to True or else you WILL
overwrite your data sources in deployments.
"Al" wrote:
> Is it possible for the Report Designer to "download" or otherwise learn about
> the available shared data sources or is the only way to add the *.RDL file to
> the project?
> Thanks!
> PS: Sorry for all the duplicates, I goofed up while trying to sign up for
> passport at the same time as writing my question.
>
> "Bruce L-C [MVP]" wrote:
> > I always use shared data sources. Once a shared data source is deployed it
> > is not overwritten unless you explicitly do so. When you deploy it will try
> > to deploy the data source, see that one is there and just give you a warning
> > that it was not deployed.
> >
> > If you decide on the folder structure and name your projects the same, then
> > you should not have a problem (as long as you don't name the reports the
> > same.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Al" <Al@.discussions.microsoft.com> wrote in message
> > news:EF163B30-8423-4F02-8B09-FC9C50D6A070@.microsoft.com...
> > > Two crystal reports developers are about to join me writing reports for
> > > Reporting Services. Neither has used RS before and I don't believe either
> > > has ever used Visual Studio.
> > >
> > > I am concerned about what will happen when they build/deploy a project.
> > > Will we end up with multiple unwanted folders and data sources? I thought
> > > maybe we could all use copies of the same solution but I also want to use
> > > SourceSafe and i dont want to worry about checking different versions in
> > > on
> > > top of each other.
> > >
> > > I would really like something like Visual InterDev 6 where multiple
> > > developers connect their own solutions to a web application and all of the
> > > resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a
> > > good
> > > way to do this with the Report Designer?
> > >
> > > Any thoughts or links regarding multi-developer coordination issues would
> > > be
> > > greatly appreciated.
> >
> >
> >

Best Practice for Rendering in Winform

Support for Rendering Reports in a Winform appears to be missing - no render
component (a.k.a. Crystal Reports).
It seems the report must be downloaded (PDF or HTML) as file then open Adobe
or IE to view.
More work yet to view within Windows app.
What is best approach and are there any examples?Today you have two options. URL Integration (embed the ie browser control in
your winform). Or to use web services but then you still need to get it in
some format (could be pdf) and then have a viewer for that.
The story for Winforms gets much stronger with version 2. There will be both
a winform and webform control. This ships with the next beta of Yukon and
Widbey. Release date of version 2 is supposed to be sometime this summer
(best way to know how this is going is to track what is being said in the
press about Yukon and Widbey). Depending on your requirements you could
develop reports, test out with the beta of the control (I would think the
next beta wouldn't be too far off but I haven't been keeping track). The
next version of Widbey might have a go live license, I don't know if that
will include using the controls or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John Amason" <jamason@.ics-associates.com> wrote in message
news:e7xSic4DFHA.3256@.tk2msftngp13.phx.gbl...
> Support for Rendering Reports in a Winform appears to be missing - no
render
> component (a.k.a. Crystal Reports).
> It seems the report must be downloaded (PDF or HTML) as file then open
Adobe
> or IE to view.
> More work yet to view within Windows app.
> What is best approach and are there any examples?
>
>|||I am using the IE control imbedded in a windows form and it works
beautifully. I just recently found the code that allows me to enumerate the
reports in a directory on the reportserver so that all the user sees is the
actual report and no longer sees report manager.
--
--Eric Cathell, MCSA
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eoxFzl4DFHA.2032@.tk2msftngp13.phx.gbl...
> Today you have two options. URL Integration (embed the ie browser control
> in
> your winform). Or to use web services but then you still need to get it in
> some format (could be pdf) and then have a viewer for that.
> The story for Winforms gets much stronger with version 2. There will be
> both
> a winform and webform control. This ships with the next beta of Yukon and
> Widbey. Release date of version 2 is supposed to be sometime this summer
> (best way to know how this is going is to track what is being said in the
> press about Yukon and Widbey). Depending on your requirements you could
> develop reports, test out with the beta of the control (I would think the
> next beta wouldn't be too far off but I haven't been keeping track). The
> next version of Widbey might have a go live license, I don't know if that
> will include using the controls or not.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John Amason" <jamason@.ics-associates.com> wrote in message
> news:e7xSic4DFHA.3256@.tk2msftngp13.phx.gbl...
>> Support for Rendering Reports in a Winform appears to be missing - no
> render
>> component (a.k.a. Crystal Reports).
>> It seems the report must be downloaded (PDF or HTML) as file then open
> Adobe
>> or IE to view.
>> More work yet to view within Windows app.
>> What is best approach and are there any examples?
>>
>|||The report controls will be included in Visual Studio 2005 (Whidbey),
starting with Beta 2. The report controls will not be included in Yukon.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eoxFzl4DFHA.2032@.tk2msftngp13.phx.gbl...
> Today you have two options. URL Integration (embed the ie browser control
> in
> your winform). Or to use web services but then you still need to get it in
> some format (could be pdf) and then have a viewer for that.
> The story for Winforms gets much stronger with version 2. There will be
> both
> a winform and webform control. This ships with the next beta of Yukon and
> Widbey. Release date of version 2 is supposed to be sometime this summer
> (best way to know how this is going is to track what is being said in the
> press about Yukon and Widbey). Depending on your requirements you could
> develop reports, test out with the beta of the control (I would think the
> next beta wouldn't be too far off but I haven't been keeping track). The
> next version of Widbey might have a go live license, I don't know if that
> will include using the controls or not.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John Amason" <jamason@.ics-associates.com> wrote in message
> news:e7xSic4DFHA.3256@.tk2msftngp13.phx.gbl...
>> Support for Rendering Reports in a Winform appears to be missing - no
> render
>> component (a.k.a. Crystal Reports).
>> It seems the report must be downloaded (PDF or HTML) as file then open
> Adobe
>> or IE to view.
>> More work yet to view within Windows app.
>> What is best approach and are there any examples?
>>
>|||Thanks for the clarification.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rajeev Karunakaran [MSFT]" <rajeevkarunakaran@.online.microsoft.com> wrote
in message news:OYYtQUKEFHA.2180@.TK2MSFTNGP12.phx.gbl...
> The report controls will be included in Visual Studio 2005 (Whidbey),
> starting with Beta 2. The report controls will not be included in Yukon.
> --
> Rajeev Karunakaran [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eoxFzl4DFHA.2032@.tk2msftngp13.phx.gbl...
>> Today you have two options. URL Integration (embed the ie browser control
>> in
>> your winform). Or to use web services but then you still need to get it
>> in
>> some format (could be pdf) and then have a viewer for that.
>> The story for Winforms gets much stronger with version 2. There will be
>> both
>> a winform and webform control. This ships with the next beta of Yukon and
>> Widbey. Release date of version 2 is supposed to be sometime this summer
>> (best way to know how this is going is to track what is being said in the
>> press about Yukon and Widbey). Depending on your requirements you could
>> develop reports, test out with the beta of the control (I would think the
>> next beta wouldn't be too far off but I haven't been keeping track). The
>> next version of Widbey might have a go live license, I don't know if that
>> will include using the controls or not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "John Amason" <jamason@.ics-associates.com> wrote in message
>> news:e7xSic4DFHA.3256@.tk2msftngp13.phx.gbl...
>> Support for Rendering Reports in a Winform appears to be missing - no
>> render
>> component (a.k.a. Crystal Reports).
>> It seems the report must be downloaded (PDF or HTML) as file then open
>> Adobe
>> or IE to view.
>> More work yet to view within Windows app.
>> What is best approach and are there any examples?
>>
>>
>|||Would you please provide location of the code that allows you access report
and no longer sees report manager
"ECathell" <ecathell@.nospam.mountaire.com> wrote in message
news:#L2sOD5DFHA.3596@.TK2MSFTNGP12.phx.gbl...
> I am using the IE control imbedded in a windows form and it works
> beautifully. I just recently found the code that allows me to enumerate
the
> reports in a directory on the reportserver so that all the user sees is
the
> actual report and no longer sees report manager.
> --
> --Eric Cathell, MCSA
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eoxFzl4DFHA.2032@.tk2msftngp13.phx.gbl...
> > Today you have two options. URL Integration (embed the ie browser
control
> > in
> > your winform). Or to use web services but then you still need to get it
in
> > some format (could be pdf) and then have a viewer for that.
> >
> > The story for Winforms gets much stronger with version 2. There will be
> > both
> > a winform and webform control. This ships with the next beta of Yukon
and
> > Widbey. Release date of version 2 is supposed to be sometime this summer
> > (best way to know how this is going is to track what is being said in
the
> > press about Yukon and Widbey). Depending on your requirements you could
> > develop reports, test out with the beta of the control (I would think
the
> > next beta wouldn't be too far off but I haven't been keeping track). The
> > next version of Widbey might have a go live license, I don't know if
that
> > will include using the controls or not.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "John Amason" <jamason@.ics-associates.com> wrote in message
> > news:e7xSic4DFHA.3256@.tk2msftngp13.phx.gbl...
> >> Support for Rendering Reports in a Winform appears to be missing - no
> > render
> >> component (a.k.a. Crystal Reports).
> >>
> >> It seems the report must be downloaded (PDF or HTML) as file then open
> > Adobe
> >> or IE to view.
> >>
> >> More work yet to view within Windows app.
> >>
> >> What is best approach and are there any examples?
> >>
> >>
> >>
> >
> >
>

Best parctices in SSRS 2000 reports development

Any ideas or known approaches on how to better develop reports. I have
about 30 Crystal Reports based on stored procedures. Now I need to develop
SSRS 2000 reports. What is the best way to achieve this in terms of layout
development? Is there any kind of a style sheet or templates in SSRS 2000 ?
( many reports look alike, and most of them are just tables, with no charts
or any other complicated structures). From what Iâ've known so far ( I
developed quite a few reports in RS), Iâ'd develop it one by one , changing
all color/font settings for each report individually. Is it possible to do
it in a more sophisticated way?
Any response/ideas would be really appreciated
LenaI'd reccomend figuring out how to do this with SQL Server 2005 instead
of SQL Server 2000.
2005 is a very nice product
Lena wrote:
> Any ideas or known approaches on how to better develop reports. I have
> about 30 Crystal Reports based on stored procedures. Now I need to develop
> SSRS 2000 reports. What is the best way to achieve this in terms of layout
> development? Is there any kind of a style sheet or templates in SSRS 2000 ?
> ( many reports look alike, and most of them are just tables, with no charts
> or any other complicated structures). From what I've known so far ( I
> developed quite a few reports in RS), I'd develop it one by one , changing
> all color/font settings for each report individually. Is it possible to do
> it in a more sophisticated way?
> Any response/ideas would be really appreciated
> Lena

Beginning and End of Month Dates

Basically what I am trying to do is as Crystal reports goes through records I want it to check a date field to see if they are the first day or last day of the month. If the first day of the month falls on a Saturday, (DayofWeek = 7), I want it to decrement the date by 1 and if the last day of month falls on a Sunday, (DayofWeek = 1), I want it to decrement the date by 2.

Any ideas?The way of distinguishing between both months can be done like this:

If Month({DateField}) <> Month({DateField}+1) //Obviously is -1 to check for the 1st day
if DayOfWeek({DateField})=6 then
Do This
else if DayOfWeek({DateField})=7 then
Do That

I cant recall if DayOfWeek was 1-based or 0-based but the concept applies. :)|||I don't understand what you mean by:
"If Month({DateField}) <> Month({DateField}+1)"

What does this formula do?|||This formula only does the next set of steps IF the datefield is the last day of the month.

Ie, if you ran this today (31/5/05) :
"If Month({DateField}) <> Month({DateField}+1)"

If Month(31/5/05) <> Month(1/6/05)

...which is true. Today is the last day of the month.

If you want to know if the date is the first of the month, use -1.

beginner here help me

hello friends,
I have been asked to work on crystal reports on vb6.0. I want very begginner level examples to understand and learn crystal reports.
any help will be appreciated,
varshaVarsha,
See Crystal Reports help for better understanding. Be strong in Formula, Parameter concepts. Refer this also http://www.uk.businessobjects.com/products/reporting/crystalreports/default.asp

Beginner - Help needed in parameter passing

Hello,
I want to pass the parameter from VB6 to crystal report to get the reports. I want to pass the string and date parameters. I tried. But, I am getting errors. Pl. help and give the syntax for passing (both the types of parameters).To pass a string

Cr.Parameter(0)='" & string & "'

To pass a Date

Cr.Parameter(0)=#" & date & "#|||When passing parameters like the one you give, it shows syntax error (expecting expression) during the run time. Is anything has to be done in CR?|||Which version of CR you are using?|||CR version 8.5. VB 6 - Actually there is no "parameter" property. I selected parameter field property. It shows the syntax error. When parameter alone is given it shows "missing expression" error. Pl. help .
Meenakshi.R|||Pl. help me in parameter passing. I used the following code

crystalreport1.selectionformula="{servmst.mrtcd}=' "&wmrtcd&" ' "

by following a book I referred. wmrtcd is the variable I assigned to get the value at run time. But the code shows the error message 'Syntax error'. Pl. help me in completion of my project|||What is the datatype of mrtcd?
If it is numeric, then
crystalreport1.selectionformula="{servmst.mrtcd}= "&val(wmrtcd)&""|||wmrtcd is a string value. I typed like this
CrystalReport1.SelectionFormula = "{servmst.mrtcd}= "&wmrtcd&""
It shows syntax error.|||Anybody Pl. help me in parameter passing.|||How about using Selection formula from the menu?
Open the report goto Report->Selection Formulas->Record
then write this code
{servmst.mrtcd}= parametername|||Sir,
I wrote the code as you given. But whenever I select the parameter from the VB code it displays the first record only. What to do? But I am selecting some other record. Here I have listed the code I used. Pl. guide me

Private Sub Cmd_run_Click()
MsgBox wmrtcd
CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.Action = 1

With the message box, I can get the parameter I selected.|||Hi!

plz try this format

String :
---

wmrtcd="{emp_det.emp_id} = '"& trim(your_id) &"'"

CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd
CrystalReport1.Action = 2

Numeric :
----

wmrtcd="{emp_det.emp_id} = "& trim(your_id) &""

CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd
CrystalReport1.Action = 2

Date :
---

Dim da, str As Variant
Dim a, b, c, e As Variant

da=cdate(rsEmp.fields("emp_det.emp_doj").value)

a = Day(da.Value)
b = Month(da.Value)
c = Year(da.Value)

d = "#" & c & "/" & b & "/" & a & "#"

wmrtcd="{emp_det.emp_doj} = '"& d &"'"

CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd
CrystalReport1.Action = 2

note : crystal report date format is "YYYY/MM/DD"|||Hi,
I can't understand what is "your_id". But I tried this code
MsgBox wmrtcd
wmrtcd = "{servmst.mrtcd} = '" & Trim(wmrtcd) & "'"
CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd

CrystalReport1.Action = 1

It shows the following error.
Run Time error '20515'
Error in file f:\meena\project\test\sermst.rpt
Error in formula <Record_Selection>
' The remaining text does not appear to be part of the formula.

What to do? Pl. help me.|||Make sure you have given the correct column name|||Hi!

Its a Parameter Value.

EmpID='ii-0406'
EmpSal=6000
EmpDoj="13/09/2004"

String :
---

wmrtcd="{emp_det.emp_id} = '"& trim(EmpID) &"'"

CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd
CrystalReport1.Action = 2

Numeric :
----

wmrtcd="{emp_det.emp_id} = "& trim(EmpSal) &""

CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd
CrystalReport1.Action = 2

Date :
---

Dim da, str As Variant
Dim a, b, c, e As Variant

da=cdate(EmpDoj)

a = Day(da.Value)
b = Month(da.Value)
c = Year(da.Value)

d = "#" & c & "/" & b & "/" & a & "#"

wmrtcd="{emp_det.emp_doj} = '"& d &"'"

CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wmrtcd
CrystalReport1.Action = 2|||Hai,
I tried with the following code.
MsgBox wmrtcd
wsel = "{servmst.mrtcd} = '" & Trim(wmrtcd) & "'"
MsgBox wsel
CrystalReport1.ReportFileName = "f:\meena\project\test\sermrtcd.rpt"
CrystalReport1.SelectionFormula = wsel

But still gets the same error. With the mesg box it shows
servmst.mrtcd='A001'

When debugging the error, it shows
wsel = "{servmst.mrtcd}='A001'" (when mouse is dragged over the line.

Pl. help me from coming out of this problem.

Regards|||Hi! see this link

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

else

plz try to add the report as dsr.

1) Visual Basic -->Project Explorere-->Add-->More ActiveXdesigner-->Crystal Reports8.5

then customize ur report as u like.

i am attaching a sample report here plz see this.

regards
muthu|||Hai,
I have included that crystal report using designer. But how to name the object "Crystal viewer". In the sample code it is written as crviewer1. I have tried with crystalviewer, crviewer. But whatever I type it shows " No object". Pl. help.

Regards|||Help me in completion of the project|||You need to use Crystal Viewer and use that name in the code|||Hi! see this link

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

else

plz try to add the report as dsr.

1) Visual Basic -->Project Explorere-->Add-->More ActiveXdesigner-->Crystal Reports8.5

then customize ur report as u like.

i am attaching a sample report here plz see this.

regards
muthu