Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts

Wednesday, March 28, 2012

How to make setup of report

Hello all
I made some reports at my machine. Now i installed Sql Server Reporting
Services on other machine which is production machine. I want to make
an installable or setup or any package to install created reports. Can
anyone help me how to do this?
I gone through Publish sample reports, i tried to publish my one
report, but it shows some error. In the script i dont know what to put
infront of parentFolder. can any one help me.
Thanks & Regards
RajThe server should be something like
http://yourservername/ReportServer
If you want the report in my reports...use
My Reports/Yourfoldername
and for data sources
My Reports/Data Sources
replace My Reports with whatever directory under RS you wish your reports to
be deployed ( and that you have permission to do.)
Hope this helps...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Hello all
> I made some reports at my machine. Now i installed Sql Server Reporting
> Services on other machine which is production machine. I want to make
> an installable or setup or any package to install created reports. Can
> anyone help me how to do this?
> I gone through Publish sample reports, i tried to publish my one
> report, but it shows some error. In the script i dont know what to put
> infront of parentFolder. can any one help me.
>
> Thanks & Regards
> Raj
>

Wednesday, March 21, 2012

How to loop this

I have this this setup in crystal

if isnumeric(mid({ServiceInfo.SvcFrequency},2)) then
{ServiceHistory.ServiceDate} + 7 * val(mid({ServiceInfo.SvcFrequency},2))
else
0

My problem is I want to specify a stop date. Now is there a way to look at that formula and repeat it over and over to a specified end date?
Such as
So if the last service date was 1/1/07 and the freqency is w001(every 1 weeks) then the next service dates would be
1/08/07
1/15/07
1/22/07
...
...
Specified end date

And it would display every date that the service occurs on the report?

Thanks.Anyone? Please