Locked out of Report Manager on my own machine!

I must have inadvertently "touched" something in my configuration, but I
don't know what, or how to fix it. Here's what's happening:
1) Running Windows XP Professional, ISS, SQL Server 2000, Reporting Services
2000 SP2. All are installed on my laptop and have been running normally for
over a year.
2) I am logged in to my machine as Administrator.
3) When I try to open Report Manager via http://localhost/Reports, I get the
prompt
"Enter username and password for "" at http://localhost".
I enter "Administrator", then the password as usual.
4) Normally, Report Manager then opens up. However, now, I can't get past
this dialog! It immediately gives me the same prompts again, and again, and
again...
5) I have tried every user and password on this machine. I have reset the
Admin password and tried again. I have rebooted many times.
6) The IIS Security settings are the same everywhere: Integrated Windows
Authentication, NO anonymous access. This is set:
* At the Web Sites level
* At the Default Web Site level
* At the Reports virtual directory
* At the ReportServer virtual directory
===================
Hope you can help! I am completely locked out. (How can IIS not allow THE
ADMINISTRATOR access?)
Thanks,
C17Problem solved -- it's something to do with the HTTP Keep-Alive property.
In IIS, if you go to the Default Web Site, and un-check the "HTTP
Keep-Alive" property, you will experience the bizarre problem of being
locked out of your own machine, even as Administrator.
If you check the property, all is well.
--C17

Lock Report Header

I know this question was asked back in 2004 and haven't seen any updates on
it...
Is it possible to lock the report column headers - as in Excel - so as you
scroll, you'll always see the column title/header?
Thanks!!I believe you are looking for either "repeat header on each page" or "header
should remain visible when scrolling" on the table properties.
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:FF3F5EA6-3322-4F32-BCD5-1F35FD562FFD@.microsoft.com...
>I know this question was asked back in 2004 and haven't seen any updates on
> it...
> Is it possible to lock the report column headers - as in Excel - so as you
> scroll, you'll always see the column title/header?
> Thanks!!|||A thousand thank you's , Jason...!!
Don't know how I didn't see that earlier...
"jason" wrote:
> I believe you are looking for either "repeat header on each page" or "header
> should remain visible when scrolling" on the table properties.
>
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:FF3F5EA6-3322-4F32-BCD5-1F35FD562FFD@.microsoft.com...
> >I know this question was asked back in 2004 and haven't seen any updates on
> > it...
> >
> > Is it possible to lock the report column headers - as in Excel - so as you
> > scroll, you'll always see the column title/header?
> >
> > Thanks!!
>

lock pdf export

Hi
i just create a report in c#. The user can export this report in .pdf format. Now i want to lock the content of this .pdf files. How can i do this in crystal report 10?
Thank'sSet the EnableExportButton to False
Add a command button to the Viewer and customize the allowed export options...
But remember, that the user could have a PDFPrinter

Location of ReportServer\Styles

Hi,

I have successfully modified HTMLViewer.css to a different version, and using rc:stylesheet = <stylesheet> can view the modified report control bar by running the report via a URL.

However, is it possible to relocate the styles directory from its default location of

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Styles

so it can reside with our report configurations?

Regards

Kevin.

You can not change the location where RS picks up the styles.

Location of reports?

I cannot find the original copy of a report that is uploaded onto my Report
Server. Where does Reporting Services store the uploaded reports? I need a
physical location so I may copy the .rdl file and edit it.
Is there any other way to copy the report file from inside Reporting
Services?it is in the directory of the report project if you are using VS.NET.
another alternative for the rdl is to select the report properties and
'Update' it (specifying the location of the .rdl - which is what we do for
production here).
Also, you may upload from RM basically anything (it doesn't have to be an
RDL). Let's say for instance that the folder for a department needs a monthly
.XLS for all to work from...
r
"Amon Borland" wrote:
> I cannot find the original copy of a report that is uploaded onto my Report
> Server. Where does Reporting Services store the uploaded reports? I need a
> physical location so I may copy the .rdl file and edit it.
> Is there any other way to copy the report file from inside Reporting
> Services?
>
>|||I was not as complete as I should have been with my answer from post.
if in doubt, look in the ReportServer database (if you used the default name
fom the install) and open the Catalog table. the name and path for the report
are located there.
r
"tutor" wrote:
> it is in the directory of the report project if you are using VS.NET.
> another alternative for the rdl is to select the report properties and
> 'Update' it (specifying the location of the .rdl - which is what we do for
> production here).
> Also, you may upload from RM basically anything (it doesn't have to be an
> RDL). Let's say for instance that the folder for a department needs a monthly
> .XLS for all to work from...
> r
> "Amon Borland" wrote:
> > I cannot find the original copy of a report that is uploaded onto my Report
> > Server. Where does Reporting Services store the uploaded reports? I need a
> > physical location so I may copy the .rdl file and edit it.
> >
> > Is there any other way to copy the report file from inside Reporting
> > Services?
> >
> >
> >|||Amon, the report is stored by RS in the database. It does not exist as a
file. You can use Report Manager to retrieve it (properties of report,
edit).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tutor" <tutor@.discussions.microsoft.com> wrote in message
news:A431F911-100A-4FCE-852E-D7E2E5CC523E@.microsoft.com...
>I was not as complete as I should have been with my answer from post.
> if in doubt, look in the ReportServer database (if you used the default
> name
> fom the install) and open the Catalog table. the name and path for the
> report
> are located there.
> r
> "tutor" wrote:
>> it is in the directory of the report project if you are using VS.NET.
>> another alternative for the rdl is to select the report properties and
>> 'Update' it (specifying the location of the .rdl - which is what we do
>> for
>> production here).
>> Also, you may upload from RM basically anything (it doesn't have to be an
>> RDL). Let's say for instance that the folder for a department needs a
>> monthly
>> .XLS for all to work from...
>> r
>> "Amon Borland" wrote:
>> > I cannot find the original copy of a report that is uploaded onto my
>> > Report
>> > Server. Where does Reporting Services store the uploaded reports? I
>> > need a
>> > physical location so I may copy the .rdl file and edit it.
>> >
>> > Is there any other way to copy the report file from inside Reporting
>> > Services?
>> >
>> >
>> >sql

Location of Report Files on Server

Does anyone know which directory contains the report (.rdl) files on the SQL
Server Reporting Services server? I'd like to access these files on the
server.
Thank you.There are no rdl files on the server. The process of deploying causes the
rdl to be stored in the database. If you need to retrieve the rdl that was
deployed you can do to report manager, click on the report, properties, edit
and give it a file name to put the rdl into.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian P" <BrianP@.discussions.microsoft.com> wrote in message
news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> Does anyone know which directory contains the report (.rdl) files on the
> SQL
> Server Reporting Services server? I'd like to access these files on the
> server.
> Thank you.|||Bruce,
Understood. Thanks for the reply.
Brian
"Bruce L-C [MVP]" wrote:
> There are no rdl files on the server. The process of deploying causes the
> rdl to be stored in the database. If you need to retrieve the rdl that was
> deployed you can do to report manager, click on the report, properties, edit
> and give it a file name to put the rdl into.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Brian P" <BrianP@.discussions.microsoft.com> wrote in message
> news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> > Does anyone know which directory contains the report (.rdl) files on the
> > SQL
> > Server Reporting Services server? I'd like to access these files on the
> > server.
> >
> > Thank you.
>
>

location of rdl files on report server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.RDL files are not stored as files on the server. They are stored in the
database. Essentially you have to redeploy the rdl file which you can do by
using webservices. However, you cannot do this for a specific user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"unixbf" <bondfranco@.gmail.com> wrote in message
news:448b5c16-8146-48b0-a412-8e38d873955d@.v67g2000hse.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.

LocalReport: Object-in-Object as DataSource not working?

Hi,
I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
I have the object objCompany, which contains a public property MyAdress
(instance of objAdress). objAdress has a propert Street.
When I add objCompany as a DataSource, I want to be able to show the
Street-property of MyAdress. So I do a drag-and-drop of that property from
the Data Sources - Window to the Report. Everything seems fine: I get a
textbox on my report with Value "=First(Fields!Street.Value,
"MyApplication_objCompany")".
But when I run the report, it doesn't show any value in it...
Does anybody knows why this happens? I somehow think because of the fact
that Street isn't directly on MyApplication_objCompany, but when I change it
into MyApplication_objCompany_MyAdress is complains about the fact that it
doesn't exist...
How should I do this?
Thanks a lot in advance,
PieterI found the solution here for nested objects and reporting services
localreport in the reportviewer:
http://www.gotreportviewer.com/objectdatasources/index.html
Apparently I have to do something like "=First(Fields!MyAdress.Value.Street,
"MyApplication_objCompany")".
It gave me these 2 errors:
The Value expression for the textbox 'Adresse' refers to the field
'ReportAdresse'.
Report item expressions can only refer to fields within the current data set
scope or, if inside an aggregate, the specified data set scope.
The Value expression for the textbox 'textbox19' has a scope parameter that
is not valid for an aggregate function.
The scope parameter must be set to a string constant that is equal to either
the name of a containing group, the name of a containing data region, or the
name of a data set.
But sddenly it started to work...
strange... :-/
"Pieter" <pietercoucke@.hotmail.com> wrote in message
news:u64%23GAkiGHA.1204@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
> I have the object objCompany, which contains a public property MyAdress
> (instance of objAdress). objAdress has a propert Street.
> When I add objCompany as a DataSource, I want to be able to show the
> Street-property of MyAdress. So I do a drag-and-drop of that property from
> the Data Sources - Window to the Report. Everything seems fine: I get a
> textbox on my report with Value "=First(Fields!Street.Value,
> "MyApplication_objCompany")".
> But when I run the report, it doesn't show any value in it...
> Does anybody knows why this happens? I somehow think because of the fact
> that Street isn't directly on MyApplication_objCompany, but when I change
> it into MyApplication_objCompany_MyAdress is complains about the fact that
> it doesn't exist...
> How should I do this?
> Thanks a lot in advance,
> Pieter
>

LocalReport.Render creates PDFs 10x the size of RS 2000

I'm using LocalReport.Render to create PDFs from my VB.Net 2005 application.
The resulting PDF is about 10x the size of the same report rendered from RS
2000. Looking inside the generated PDF file, I see that the main body of the
report is no longer using any compression.
Is there any way to force LocalReport.Render to use the compression that RS
2000 was using?This is a known bug:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134219&SiteID=1
--
Robert Jeppesen
Durius
http://www.durius.com/
"davedave" <davedave@.discussions.microsoft.com> wrote in message
news:7929FEFC-3427-4864-A817-B3A83269F92D@.microsoft.com...
> I'm using LocalReport.Render to create PDFs from my VB.Net 2005
> application.
> The resulting PDF is about 10x the size of the same report rendered from
> RS
> 2000. Looking inside the generated PDF file, I see that the main body of
> the
> report is no longer using any compression.
> Is there any way to force LocalReport.Render to use the compression that
> RS
> 2000 was using?

Localize Report

I've read several places that there isn't a way to localize reports at run
time of a report, so I wanted to ask what is the "best practice" of deploying
the reports if you have some clients that might want to view 'English'
reports and others who might want to view 'German' reports. I'd like to
avoid having duplicate reports, but it really sounds like this is my only
option.
Any ideas you have or suggestions of articles to read on the topic would be
greatly appreciated!
DanYou could put all of the formatting and vocabulary in functions, and vary
them based on a parameter, using =Iif(...) or =Switch(...)
With this approach, or with a duplicate report approach, you could adopt an
automated search/replace process to go through the RDL file and alter it to
support multiple languages.
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:1666568A-5499-4452-8132-B9BEE7893157@.microsoft.com...
> I've read several places that there isn't a way to localize reports at run
> time of a report, so I wanted to ask what is the "best practice" of
> deploying
> the reports if you have some clients that might want to view 'English'
> reports and others who might want to view 'German' reports. I'd like to
> avoid having duplicate reports, but it really sounds like this is my only
> option.
> Any ideas you have or suggestions of articles to read on the topic would
> be
> greatly appreciated!
> Dan

Localization/Language/Culture Parameter

Where can I obtain a list of the languages as used in the report language property for populating a parameter?

Currently if I put the list that is in the Language Dropdown (Ex. "French (France)") it does not work. I have to use "fr - Fr"

Thanks

BobP

Found a list here...

http://msdn2.microsoft.com/en-us/library/system.globalization.cultureinfo.aspx

Localization/Language/Culture Parameter

Where can I obtain a list of the languages as used in the report language property for populating a parameter?

Currently if I put the list that is in the Language Dropdown (Ex. "French (France)") it does not work. I have to use "fr - Fr"

Thanks

BobP

Found a list here...

http://msdn2.microsoft.com/en-us/library/system.globalization.cultureinfo.aspx

Localization problem

Hi
I have a report with a "Jump to report" navigation field to a second report
, some of the parameters to the second report are DateTime values, when my
Local Settings are setted to English (United States) the link works fine,
but when I change my Local Settings to Spanish I get a Type Mismatch
message for this DateTime parameters. The "Language" property of both
reports are "Default", and when I execute by my self the second report
specifying each parameter with the correct locale datetime format it works
fine.
Any idea?
Thanksthis could happend because of session/caching of the subreport.
Click "Refresh" button on the toolbar when viewing the subreport.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
news:uqK6c$2mEHA.404@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a report with a "Jump to report" navigation field to a second
> report
> , some of the parameters to the second report are DateTime values, when my
> Local Settings are setted to English (United States) the link works fine,
> but when I change my Local Settings to Spanish I get a Type Mismatch
> message for this DateTime parameters. The "Language" property of both
> reports are "Default", and when I execute by my self the second report
> specifying each parameter with the correct locale datetime format it works
> fine.
> Any idea?
> Thanks
>|||Thanks for your answer, but I think that is not the problem.
Let me explain the problem again, I have a first report with two parameters,
"Start Date" and "End Date" that are used when the report is executed to get
some information from some DB for this time range, this information is
showed in a table where the first column values are links to other report
(not a subrerport), this second report also uses date range parameters and
its values should be the same of the first report parameters, this means
that also should be specified in the link.
So when I click the link to open the second report and I have Spanish or
other locale selected for my system regional options a type mismatch message
is showed instead of the second report:
"The value provided for the report parameter 'EndDate' is not valid for its
type. (rsReportParameterTypeMismatch)"
My intuition is that the problem is with the date format, the date format
for Spanish locales is 'dd/mm/yyyy' and for english locale 'mm/dd/yyyy' I
think that the second report is trying to build its date time parameters
with the English locale and here is where the exception is raised. E.g. set
a value greater than 12 as month.
When I execute the second report specifying the parameters values manually
with the correct locale date format the report is showed without problems.
When I see the "Language" property of both reports in design mode is set to
default, I suppose that means that the report should works with the system
locale settings and use the correct date formats.
Thanks
Mauricio
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:e8ju$c4mEHA.648@.tk2msftngp13.phx.gbl...
> this could happend because of session/caching of the subreport.
> Click "Refresh" button on the toolbar when viewing the subreport.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
> news:uqK6c$2mEHA.404@.TK2MSFTNGP12.phx.gbl...
> > Hi
> > I have a report with a "Jump to report" navigation field to a second
> > report
> > , some of the parameters to the second report are DateTime values, when
my
> > Local Settings are setted to English (United States) the link works
fine,
> > but when I change my Local Settings to Spanish I get a Type Mismatch
> > message for this DateTime parameters. The "Language" property of both
> > reports are "Default", and when I execute by my self the second report
> > specifying each parameter with the correct locale datetime format it
works
> > fine.
> > Any idea?
> > Thanks
> >
> >
>|||What are parameters values that you pass to second report? What do you put
into Parameter Value cell of Parameters dialog?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
news:%23HlTA0AnEHA.3196@.TK2MSFTNGP10.phx.gbl...
> Thanks for your answer, but I think that is not the problem.
>
> Let me explain the problem again, I have a first report with two
> parameters,
> "Start Date" and "End Date" that are used when the report is executed to
> get
> some information from some DB for this time range, this information is
> showed in a table where the first column values are links to other report
> (not a subrerport), this second report also uses date range parameters and
> its values should be the same of the first report parameters, this means
> that also should be specified in the link.
>
> So when I click the link to open the second report and I have Spanish or
> other locale selected for my system regional options a type mismatch
> message
> is showed instead of the second report:
>
> "The value provided for the report parameter 'EndDate' is not valid for
> its
> type. (rsReportParameterTypeMismatch)"
>
> My intuition is that the problem is with the date format, the date format
> for Spanish locales is 'dd/mm/yyyy' and for english locale 'mm/dd/yyyy' I
> think that the second report is trying to build its date time parameters
> with the English locale and here is where the exception is raised. E.g.
> set
> a value greater than 12 as month.
>
> When I execute the second report specifying the parameters values manually
> with the correct locale date format the report is showed without problems.
> When I see the "Language" property of both reports in design mode is set
> to
> default, I suppose that means that the report should works with the system
> locale settings and use the correct date formats.
>
> Thanks
> Mauricio
>
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:e8ju$c4mEHA.648@.tk2msftngp13.phx.gbl...
>> this could happend because of session/caching of the subreport.
>> Click "Refresh" button on the toolbar when viewing the subreport.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
>> news:uqK6c$2mEHA.404@.TK2MSFTNGP12.phx.gbl...
>> > Hi
>> > I have a report with a "Jump to report" navigation field to a second
>> > report
>> > , some of the parameters to the second report are DateTime values, when
> my
>> > Local Settings are setted to English (United States) the link works
> fine,
>> > but when I change my Local Settings to Spanish I get a Type Mismatch
>> > message for this DateTime parameters. The "Language" property of both
>> > reports are "Default", and when I execute by my self the second report
>> > specifying each parameter with the correct locale datetime format it
> works
>> > fine.
>> > Any idea?
>> > Thanks
>> >
>> >
>>
>|||The same values of the first report parameters:
Parameter Name Parameter Value
StartDate =Parameters!StartDate.Value
EndDate =Parameters!EndDate.Value
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:%23uc293FnEHA.3452@.TK2MSFTNGP15.phx.gbl...
> What are parameters values that you pass to second report? What do you put
> into Parameter Value cell of Parameters dialog?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
> news:%23HlTA0AnEHA.3196@.TK2MSFTNGP10.phx.gbl...
> > Thanks for your answer, but I think that is not the problem.
> >
> >
> >
> > Let me explain the problem again, I have a first report with two
> > parameters,
> > "Start Date" and "End Date" that are used when the report is executed to
> > get
> > some information from some DB for this time range, this information is
> > showed in a table where the first column values are links to other
report
> > (not a subrerport), this second report also uses date range parameters
and
> > its values should be the same of the first report parameters, this means
> > that also should be specified in the link.
> >
> >
> >
> > So when I click the link to open the second report and I have Spanish or
> > other locale selected for my system regional options a type mismatch
> > message
> > is showed instead of the second report:
> >
> >
> >
> > "The value provided for the report parameter 'EndDate' is not valid for
> > its
> > type. (rsReportParameterTypeMismatch)"
> >
> >
> >
> > My intuition is that the problem is with the date format, the date
format
> > for Spanish locales is 'dd/mm/yyyy' and for english locale 'mm/dd/yyyy'
I
> > think that the second report is trying to build its date time parameters
> > with the English locale and here is where the exception is raised. E.g.
> > set
> > a value greater than 12 as month.
> >
> >
> >
> > When I execute the second report specifying the parameters values
manually
> > with the correct locale date format the report is showed without
problems.
> > When I see the "Language" property of both reports in design mode is set
> > to
> > default, I suppose that means that the report should works with the
system
> > locale settings and use the correct date formats.
> >
> >
> >
> > Thanks
> >
> > Mauricio
> >
> >
> >
> > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > news:e8ju$c4mEHA.648@.tk2msftngp13.phx.gbl...
> >> this could happend because of session/caching of the subreport.
> >> Click "Refresh" button on the toolbar when viewing the subreport.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
> >> news:uqK6c$2mEHA.404@.TK2MSFTNGP12.phx.gbl...
> >> > Hi
> >> > I have a report with a "Jump to report" navigation field to a second
> >> > report
> >> > , some of the parameters to the second report are DateTime values,
when
> > my
> >> > Local Settings are setted to English (United States) the link works
> > fine,
> >> > but when I change my Local Settings to Spanish I get a Type Mismatch
> >> > message for this DateTime parameters. The "Language" property of both
> >> > reports are "Default", and when I execute by my self the second
report
> >> > specifying each parameter with the correct locale datetime format it
> > works
> >> > fine.
> >> > Any idea?
> >> > Thanks
> >> >
> >> >
> >>
> >>
> >
> >
>|||I have having the very same problem. Did you ever solve this? And how
if you did?!
Thanks|||I have this problem as well, even though my report language is set to English
(United Kingdom), my Asp.Net app that calls the reporting service web service
is using en-GB as culture. It still thinks that my parameter End Date should
be in mm/dd/yyyy format and pukes when it sees something like 14/12/2004
(December 14, 2004) come over.
"Gearoid" wrote:
> I have having the very same problem. Did you ever solve this? And how
> if you did?!
> Thanks
>|||Adam,
Check the "Language Settings" for your browser.
Open IE, goto Tools->Internet Options->Click 'Languages...' button on the
General tab. Check that your language is English (United Kingdom)
I have got MSRS to work fine with UK English format dates... apart from
when reports are linked using 'Jump to' action.
Joe
"AdamB" wrote:
> I have this problem as well, even though my report language is set to English
> (United Kingdom), my Asp.Net app that calls the reporting service web service
> is using en-GB as culture. It still thinks that my parameter End Date should
> be in mm/dd/yyyy format and pukes when it sees something like 14/12/2004
> (December 14, 2004) come over.
> "Gearoid" wrote:
> > I have having the very same problem. Did you ever solve this? And how
> > if you did?!
> >
> > Thanks
> >
> >|||Try this and see if it works
Parameter Name Parameter Value
StartDate =Format(Parameters!StartDate.Value,
"dd-MMMM-yyyy")
EndDate =Format(Parameters!EndDate.Value,
"dd-MMMM-yyyy")
Cheers,
Harry
"Mauricio Cadima" wrote:
> The same values of the first report parameters:
> Parameter Name Parameter Value
> StartDate =Parameters!StartDate.Value
> EndDate =Parameters!EndDate.Value
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:%23uc293FnEHA.3452@.TK2MSFTNGP15.phx.gbl...
> > What are parameters values that you pass to second report? What do you put
> > into Parameter Value cell of Parameters dialog?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
> > news:%23HlTA0AnEHA.3196@.TK2MSFTNGP10.phx.gbl...
> > > Thanks for your answer, but I think that is not the problem.
> > >
> > >
> > >
> > > Let me explain the problem again, I have a first report with two
> > > parameters,
> > > "Start Date" and "End Date" that are used when the report is executed to
> > > get
> > > some information from some DB for this time range, this information is
> > > showed in a table where the first column values are links to other
> report
> > > (not a subrerport), this second report also uses date range parameters
> and
> > > its values should be the same of the first report parameters, this means
> > > that also should be specified in the link.
> > >
> > >
> > >
> > > So when I click the link to open the second report and I have Spanish or
> > > other locale selected for my system regional options a type mismatch
> > > message
> > > is showed instead of the second report:
> > >
> > >
> > >
> > > "The value provided for the report parameter 'EndDate' is not valid for
> > > its
> > > type. (rsReportParameterTypeMismatch)"
> > >
> > >
> > >
> > > My intuition is that the problem is with the date format, the date
> format
> > > for Spanish locales is 'dd/mm/yyyy' and for english locale 'mm/dd/yyyy'
> I
> > > think that the second report is trying to build its date time parameters
> > > with the English locale and here is where the exception is raised. E.g.
> > > set
> > > a value greater than 12 as month.
> > >
> > >
> > >
> > > When I execute the second report specifying the parameters values
> manually
> > > with the correct locale date format the report is showed without
> problems.
> > > When I see the "Language" property of both reports in design mode is set
> > > to
> > > default, I suppose that means that the report should works with the
> system
> > > locale settings and use the correct date formats.
> > >
> > >
> > >
> > > Thanks
> > >
> > > Mauricio
> > >
> > >
> > >
> > > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > > news:e8ju$c4mEHA.648@.tk2msftngp13.phx.gbl...
> > >> this could happend because of session/caching of the subreport.
> > >> Click "Refresh" button on the toolbar when viewing the subreport.
> > >>
> > >> --
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >>
> > >> "Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
> > >> news:uqK6c$2mEHA.404@.TK2MSFTNGP12.phx.gbl...
> > >> > Hi
> > >> > I have a report with a "Jump to report" navigation field to a second
> > >> > report
> > >> > , some of the parameters to the second report are DateTime values,
> when
> > > my
> > >> > Local Settings are setted to English (United States) the link works
> > > fine,
> > >> > but when I change my Local Settings to Spanish I get a Type Mismatch
> > >> > message for this DateTime parameters. The "Language" property of both
> > >> > reports are "Default", and when I execute by my self the second
> report
> > >> > specifying each parameter with the correct locale datetime format it
> > > works
> > >> > fine.
> > >> > Any idea?
> > >> > Thanks
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>
>

Localization Controls

Does Report Designer support Localization or Internationlization controls?
E.g. when you a run a report which has currency column the report designer
should format the column with the currency format present in the system's
control panel (Regional Settings)In short, both are supported. Localisation is easy, with the in-built
format codes, eg. 'c' for currency.
Globalisation is trickier, requiring some code. Generally the
System.Globalization namespace has most things in that you'll need.
One thing to note though is that the designer is an absolute pig with
non-US dates. Generally the reports are OK when deployed though.
--
Regards
Chris
Dan Krish wrote:
> Does Report Designer support Localization or Internationlization
> controls?
> E.g. when you a run a report which has currency column the report
> designer should format the column with the currency format present in
> the system's control panel (Regional Settings)|||Can you provide some functions that are used within the Report Designer for
localizing currencies & dates based on the regional settings? I tried using
FORMATCURRENCY in my reports, but it did not help
"Chris McGuigan" wrote:
> In short, both are supported. Localisation is easy, with the in-built
> format codes, eg. 'c' for currency.
> Globalisation is trickier, requiring some code. Generally the
> System.Globalization namespace has most things in that you'll need.
> One thing to note though is that the designer is an absolute pig with
> non-US dates. Generally the reports are OK when deployed though.
> --
> Regards
> Chris
>
> Dan Krish wrote:
> > Does Report Designer support Localization or Internationlization
> > controls?
> >
> > E.g. when you a run a report which has currency column the report
> > designer should format the column with the currency format present in
> > the system's control panel (Regional Settings)
>|||Dan,
In the "format" property of a cell, if you use "c2" for currency (with
2 decimal places) it will format the currency and number format
according to the locale of the users PC. e.g In UK, 12345.99 would be
£12,345.99 in the US $12,345.99 and in France (I'm guessing a bit
here!) I would expect something like 12.345,99â?¬. 'n' for numeric I
believe work's the same.
In RS2000 BOL a list of format codes can be found at;
ms-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_layout_v1_365w.htm
and try these links for further info.
ms-help://MS.RSBOL80.1033/rsadmin/htm/drp_deploying_v1_0vaa.htm
ms-help://MS.RSBOL80.1033/RSCREATE/htm/rcr_creating_building_v1_31bn.htm
As for some sample code, I wrote this some time ago in RS2000.
Essentially the report had to show group figures so I had to change
number & currency formats depending on which country I was
displaying.The Globalization namespace has lots of goodies in it and I
suggest you study the documentation on that;
Public CultureInfo As System.Globalization.CultureInfo
Public Culture As String
Public CurrencyValue As Decimal
Public CurrencyFormat As String
Public CurrencyPositivePattern(3) As String
Public CurrencyNegativePattern(15) As String
Public Function Main() As String
Dim str As String
CurrencyPositivePattern(0) = "$n"
CurrencyPositivePattern(1) = "n$"
CurrencyPositivePattern(2) = "$ n"
CurrencyPositivePattern(3) = "n $"
CurrencyNegativePattern(0) = "($n)"
CurrencyNegativePattern(1) = "-$n"
CurrencyNegativePattern(2) = "$-n"
CurrencyNegativePattern(3) = "$n-"
CurrencyNegativePattern(4) = "(n$)"
CurrencyNegativePattern(5) = "-n$"
CurrencyNegativePattern(6) = "n-$"
CurrencyNegativePattern(7) = "n$-"
CurrencyNegativePattern(8) = "-n $"
CurrencyNegativePattern(9) = "-$ n"
CurrencyNegativePattern(10) = "n $-"
CurrencyNegativePattern(11) = "$ n-"
CurrencyNegativePattern(12) = "$ -n"
CurrencyNegativePattern(13) = "n- $"
CurrencyNegativePattern(14) = "($ n)"
CurrencyNegativePattern(15) = "(n $)"
str = SetCulture("en-GB", "GBP")
Return ("")
End Function
Public Function GetCurrencyFormat(ByVal Culture As String) As String
Dim nfi As System.Globalization.NumberFormatInfo
Dim pos As String
Dim neg As String
Dim sym As String
Dim sep As String
Dim sb As System.Text.StringBuilder
Dim cpp As Integer
Dim cnp As Integer
CultureInfo = New System.Globalization.CultureInfo(Culture,
False)
nfi = CultureInfo.NumberFormat
sym = nfi.CurrencySymbol
sep = nfi.CurrencyGroupSeparator
cpp = nfi.CurrencyPositivePattern
cnp = nfi.CurrencyNegativePattern
sb = New System.Text.StringBuilder(CurrencyPositivePattern(cpp))
sb.Replace("$", sym)
sep = ","
sb.Replace("n", "###" & sep & "###" & sep & "##0")
pos = sb.ToString
sb = New System.Text.StringBuilder(CurrencyNegativePattern(cnp))
sb.Replace("$", sym)
sep = ","
sb.Replace("n", "###" & sep & "###" & sep & "##0")
neg = sb.ToString
CurrencyFormat = pos & ";" & neg
Return CurrencyFormat
End Function
Public Function SetCulture(ByVal Culture As String, ByVal Currency
As String) As String
CurrencyFormat = GetCurrencyFormat(Culture)
Return Currency
End Function
Public Function ToCur(ByVal Value As Double) As String
CurrencyValue = Value
Return Value.ToString("c0", CultureInfo)
End Function
Public Function ToCur(ByVal Value As Double, Culture As String) As
String
CultureInfo = New System.Globalization.CultureInfo(Culture,
False)
CurrencyValue = Value
Return Value.ToString("c0", CultureInfo)
End Function

localization and RS

Hi,
i want to make a report which could be called in several countries.
My question is, what kind of regional settings do RS use ?
I tried the VB.NET Functions FormatCurrency etc and i
set the regional settings on (server + client) from german to english,
but the currency value is still in german format...
example:
German currency format: 99.999, 99
English format: 99,999. 99
How can i solve this problem?
regards
PatrickWould be nice if someone got an idea!
"Patrick Ruhnow" <pruhnow@.dornbracht.de> schrieb im Newsbeitrag
news:%23rdstRlbEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hi,
> i want to make a report which could be called in several countries.
> My question is, what kind of regional settings do RS use ?
> I tried the VB.NET Functions FormatCurrency etc and i
> set the regional settings on (server + client) from german to english,
> but the currency value is still in german format...
> example:
> German currency format: 99.999, 99
> English format: 99,999. 99
>
> How can i solve this problem?
> regards
> Patrick
>|||Yes, just set the language property on the entire report or on individual
textboxes. If you set the report language to "Default", then the language
during execution will depend on the requesting client (e.g. in IE: Tools -
Internet Options - Languages). More details on localization are available in
BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_building_v1_31bn.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0vaa.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick Ruhnow" <pruhnow@.dornbracht.de> wrote in message
news:uBz%23$WtcEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Would be nice if someone got an idea!
> "Patrick Ruhnow" <pruhnow@.dornbracht.de> schrieb im Newsbeitrag
> news:%23rdstRlbEHA.3512@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > i want to make a report which could be called in several countries.
> > My question is, what kind of regional settings do RS use ?
> > I tried the VB.NET Functions FormatCurrency etc and i
> > set the regional settings on (server + client) from german to english,
> > but the currency value is still in german format...
> >
> > example:
> > German currency format: 99.999, 99
> > English format: 99,999. 99
> >
> >
> > How can i solve this problem?
> >
> > regards
> > Patrick
> >
> >
>

localhost/reports not found

Everything works ok at work and so I decided to install it at home on Windows 2003.

For some odd reason I can run my report this way:

http://localhost/ReportServer?%2fReport+Project1%2fReportFirstTest&rs:Command=Render

But if I try this..

http://localhost/reports

all I get is "The page cannot be found"

I can also get to the report by clicking on links found on the page I get usinghttp://localhost/ReportServer

I'd guess an IIS setting got messed up somehow, anyone know?

1. Make sure that Home.aspx is a default webpage for the related web site in the IIS, or try thishttp://localhost/reports/home.aspx ; 2. Make sure that the asp.net 2.0 version is selected for this web site; 3. It's better to have an own pool for asp.net 2.0 applications in the win 2003.

Local ReportViewer - Printing margins off by ~1/8 inch

I am printing my reports from my local report viewr, and the margins are
off by 1/8 inch if I include a header. It looks like printing shifts the
contents of the report 1/8 inch to the right, borking everything.
1. Report has a "header" area. Without this header, the printing is fine.
2. Report body is 7" wide
3. Margins are .75" (6/8) inch on all sides
4. Print Preview mode displays the report properly, centered
5. Output is similarly skewed on all printers (tried 4)
6. This is using the VS SP1 version of the RS dll's.
Setting the margins to Left: 0.625, Right: 0.875 (5/8&7/8) actually causes
it to print centered, so I know it is paying attention. When I do this, the
print layout mode shows the contents shifted to the left 1/8", as expected.
I assume that people print using this control, or at least it was tested,
so has anyone else seen this or is it a confirmed bug?
Thanks,
// Andrew Backer
P.S. In a related bug, if I include the header then the local viewer __insists__
on rendering the page at 8.5 inches wide, regardless of the fact that the
body is still 7". This doesn't seem to affect printing, but without the
header it only renders at the body width, 7", rather than giving me 1.5"
of blank spaceCheck the "Spacing" property under the Layout Tab of the Report Properties
window.
Set it to "0in".

Local reports with ADO.NET Dataset help

I'm trying to use a local report in a Windows Forms application that
uses an ado.net dataset. The trouble is that I'm trying to figure out
how to access data within related tables. If the dataset has a table
called Customers with two records in it, how do I go about displaying
the data from a particular customer in a particular place? Can I choose
the row to show based upon a key in a separate table? That would be
ideal. Any ideas? I've searched and found no answers.
Thanks,
BrianHi Brian, I'm running with the same problem.
For some reason all I see it's one of the DataTable's data...
have you figured this out yet?
Best regards,
Sebasti=E1n
On Oct 26, 8:18 pm, Brian Vallelunga <brian.vallelu...@.gmail.com>
wrote:
> I'm trying to use alocalreport in a Windows Forms application that
> uses an ado.netdataset. The trouble is that I'm trying to figure out
> how to access data within related tables. If the dataset has a table
> called Customers with two records in it, how do I go about displaying
> the data from a particular customer in a particular place? Can I choose
> the row to show based upon a key in a separate table? That would be
> ideal. Any ideas? I've searched and found no answers.
> > Thanks,
> > Brian|||I started to look into local reports and decided it was a pain for this very
reason. However, I do know what you need to do conceptually. Nothing has
changed as far as how to solve the problem in the design of the reports. A
server report can be turned into a local report (you just rename the rdl
file to rdlc). Indeed, my suggestion on how to develop is to develop inside
the report designer (even if no server you can design and preview). Then
once working bring it into you app.
Now, in RS the way you handle master detail is by sub reports. That has not
changed. For local reports you have to do the same thing. You have to tie
into an event in the sub report to take the parameter and give the sub
report the appropriate data. So, let's say that you have a dataset all
populated. The main report is tied to the data table for the master. Then
you have the sub report and you tie the subreport parameter to a field of
the master table record. In the event you then would need to filter the
appropriate data table and set the source of the subreport to that. Note
that this event will be called for each record in the master.
Hope this helps at least conceptually on what you need to do.
After seeing all the hoops I would have to go through, I decided to stay
with server based reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sebastiangomezcorrea@.gmail.com> wrote in message
news:1162385028.994774.52040@.k70g2000cwa.googlegroups.com...
Hi Brian, I'm running with the same problem.
For some reason all I see it's one of the DataTable's data...
have you figured this out yet?
Best regards,
Sebastián
On Oct 26, 8:18 pm, Brian Vallelunga <brian.vallelu...@.gmail.com>
wrote:
> I'm trying to use alocalreport in a Windows Forms application that
> uses an ado.netdataset. The trouble is that I'm trying to figure out
> how to access data within related tables. If the dataset has a table
> called Customers with two records in it, how do I go about displaying
> the data from a particular customer in a particular place? Can I choose
> the row to show based upon a key in a separate table? That would be
> ideal. Any ideas? I've searched and found no answers.
> Thanks,
> Brian|||Hey Bruce, thanks for the reply.
Even though I'm working with local reports, I have to ask... how do you
do what I'm trying with rdl reports? Is there some kind of wizzard or
something?
TIA
On Nov 1, 12:08 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I started to look into local reports and decided it was a pain for this v=ery
> reason. However, I do know what you need to do conceptually. Nothing has
> changed as far as how to solve the problem in the design of the reports. A
> server report can be turned into a local report (you just rename the rdl
> file to rdlc). Indeed, my suggestion on how to develop is to develop insi=de
> the report designer (even if no server you can design and preview). Then
> once working bring it into you app.
> Now, in RS the way you handle master detail is by sub reports. That has n=ot
> changed. For local reports you have to do the same thing. You have to tie
> into an event in the sub report to take the parameter and give the sub
> report the appropriate data. So, let's say that you have a dataset all
> populated. The main report is tied to the data table for the master. Then
> you have the sub report and you tie the subreport parameter to a field of
> the master table record. In the event you then would need to filter the
> appropriate data table and set the source of the subreport to that. Note
> that this event will be called for each record in the master.
> Hope this helps at least conceptually on what you need to do.
> After seeing all the hoops I would have to go through, I decided to stay
> with server based reports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <sebastiangomezcor...@.gmail.com> wrote in messagenews:1162385028.994774.5=2040@.k70g2000cwa.googlegroups.com...
> Hi Brian, I'm running with the same problem.
> For some reason all I see it's one of the DataTable's data...
> have you figured this out yet?
> Best regards,
> Sebasti=E1n
> On Oct 26, 8:18 pm, Brian Vallelunga <brian.vallelu...@.gmail.com>
> wrote:
>
> > I'm trying to use alocalreport in a Windows Forms application that
> > uses an ado.netdataset. The trouble is that I'm trying to figure out
> > how to access data within related tables. If the dataset has a table
> > called Customers with two records in it, how do I go about displaying
> > the data from a particular customer in a particular place? Can I choose
> > the row to show based upon a key in a separate table? That would be
> > ideal. Any ideas? I've searched and found no answers.
> > > Thanks,
> > > Brian- Hide quoted text -- Show quoted text -

Local Report Processing mode

Hi,
We have a scenario where we want to test the <a href> url generated
by parsing the <Hyperlink> element present in the rdl file
This check needs to be done without deploying the rdl file on the
report server. So we are planning to use Local processing mode of the
report view control.
I wanted to ask on whether there are any differences between the
conversion of <Hyperlink> element to <a href> when checked in local
processing mode and when checked in remote processing mode (i.e when
the conversion is done by report server by using reporting server web
services).
Thanks in advancewhat do you mean by "test the <a href>?
do you want to validate that the URL works fine before deploying the report?
the local processing mode of the report viewer can't use an RDL file. you
have to convert it to RDLC. but you also have to execute the query in your
code.
the report viewer just render the report and can't execute the query
statements.
but...
you can validate the hyperlink objects in the RDL file
directly, if the hyperlink is hardcoded. (you can simply use the XML
Document object model to do this)
another option is to publish the report in report server, then execute the
report by code and retrieve the URLS generated in the HTML content to
validate them.
hope this will help you.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> Hi,
> We have a scenario where we want to test the <a href> url generated
> by parsing the <Hyperlink> element present in the rdl file
> This check needs to be done without deploying the rdl file on the
> report server. So we are planning to use Local processing mode of the
> report view control.
> I wanted to ask on whether there are any differences between the
> conversion of <Hyperlink> element to <a href> when checked in local
> processing mode and when checked in remote processing mode (i.e when
> the conversion is done by report server by using reporting server web
> services).
> Thanks in advance
>|||Thanks for the reply.
I want to validate 2 things with the Hyperlink element which would
contain complex expressions and calls to custom assemblies.
1. Whether the rdl file deploys correctly
2. Whether the url generated is right
This needs to be done without any interaction with the report server.
Hence we wanted to try out local report processing mode. Can you
please guide whether I will be able to validate the above mentioned
scenarios using local processing mode ?
For validating the second scenario I would need to generate an event
of clicking the hyperlink. Is that possible in local report processing
mode ?
I will convert the rdl file to rdlc file. As only <Hyperlink>
scenarios needs to be test I would create a rdl file which contains
only <Hyperlink> element. Renaming this rdl file to rdlc would work as
the schema for both are same. right ?
On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> what do you mean by "test the <a href>?
> do you want to validate that the URL works fine before deploying thereport?
> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> have to convert it to RDLC. but you also have to execute the query in your
> code.
> thereportviewer just render thereportand can't execute the query
> statements.
> but...
> you can validate the hyperlink objects in the RDL file
> directly, if the hyperlink is hardcoded. (you can simply use the XML
> Document object model to do this)
> another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> validate them.
> hope this will help you.
> "Amit" <amits...@.gmail.com> wrote in message
> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > Hi,
> > We have a scenario where we want to test the <a href> url generated
> > by parsing the <Hyperlink> element present in the rdl file
> > This check needs to be done without deploying the rdl file on the
> >reportserver. So we are planning to useLocalprocessingmodeof the
> >reportview control.
> > I wanted to ask on whether there are any differences between the
> > conversion of <Hyperlink> element to <a href> when checked inlocal
> >processingmodeand when checked in remoteprocessingmode(i.e when
> > the conversion is done byreportserver by using reporting server web
> > services).
> > Thanks in advance|||All the above testing scenarios should be done programmatically.
On Jun 24, 6:47 pm, Amit <amits...@.gmail.com> wrote:
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with thereportserver.
> Hence we wanted to try outlocalreportprocessingmode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios usinglocalprocessingmode?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible inlocalreportprocessingmode?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> > what do you mean by "test the <a href>?
> > do you want to validate that the URL works fine before deploying thereport?
> > thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> > have to convert it to RDLC. but you also have to execute the query in your
> > code.
> > thereportviewer just render thereportand can't execute the query
> > statements.
> > but...
> > you can validate the hyperlink objects in the RDL file
> > directly, if the hyperlink is hardcoded. (you can simply use the XML
> > Document object model to do this)
> > another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> > validate them.
> > hope this will help you.
> > "Amit" <amits...@.gmail.com> wrote in message
> >news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > > Hi,
> > > We have a scenario where we want to test the <a href> url generated
> > > by parsing the <Hyperlink> element present in the rdl file
> > > This check needs to be done without deploying the rdl file on the
> > >reportserver. So we are planning to useLocalprocessingmodeof the
> > >reportview control.
> > > I wanted to ask on whether there are any differences between the
> > > conversion of <Hyperlink> element to <a href> when checked inlocal
> > >processingmodeand when checked in remoteprocessingmode(i.e when
> > > the conversion is done byreportserver by using reporting server web
> > > services).
> > > Thanks in advance|||converting an RDL file to RDLC + code based dataset execution could be
possible, but complicated regarding your development constraints.
also, testing a report should be done 1 time only, after this you can't test
all the cases (I mean you can't test all the possible resultsets coming from
the database)
So, I recommend to spread your code in 2:
1. predeploy testing
2. deploy
the step 1 can be done by deploying the report in a test report server or an
hidden folder in RS. when you publish a report the publish process returns
the warnings and other errors found in the report. (so you can stop the
process here if there is warning, and if there is errors the report is not
deployed)
When this step pass the deployment, you can now execute the report a first
time and scan the resulting HTML content by code.
so you can retrieve all the <a href statements and verify by code if these
links works fine (using the webrequest object in .NET)
and finally, remove the tested report from report server.
now the report is approved for deployment and can be added in your
deployment process.
converting an RDL report to RDLC can be complex because you have to extract
the SQL queries and connections from the report, create and populate a
dataset on the fly and execute the report on the fly. what's appends if
there is parameters?
you can't simulate a direct "click" event on an hyperlink in any scenario.
you can just extract and test the generated HTML content.
but can you explain who creates the reports and how?
because Visual Studio can validate the deployment himself and can "compile"
the report to identify warnings and errors.
also, can you explain how the hyperlinks are created in the reports?
does it's hardcoded (fixed) links? or does the links come from a database?
or does the links is a formula result? (a concatenation of something like:
"http://myserver/myfolder/mypage.aspx?id=" & Datasetfield.Value)
Jerome.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182692843.900480.295280@.e16g2000pri.googlegroups.com...
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with the report server.
> Hence we wanted to try out local report processing mode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios using local processing mode ?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible in local report processing
> mode ?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
>> what do you mean by "test the <a href>?
>> do you want to validate that the URL works fine before deploying
>> thereport?
>> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
>> have to convert it to RDLC. but you also have to execute the query in
>> your
>> code.
>> thereportviewer just render thereportand can't execute the query
>> statements.
>> but...
>> you can validate the hyperlink objects in the RDL file
>> directly, if the hyperlink is hardcoded. (you can simply use the XML
>> Document object model to do this)
>> another option is to publish thereportinreportserver, then execute
>> thereportby code and retrieve the URLS generated in the HTML content to
>> validate them.
>> hope this will help you.
>> "Amit" <amits...@.gmail.com> wrote in message
>> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
>> > Hi,
>> > We have a scenario where we want to test the <a href> url generated
>> > by parsing the <Hyperlink> element present in the rdl file
>> > This check needs to be done without deploying the rdl file on the
>> >reportserver. So we are planning to useLocalprocessingmodeof the
>> >reportview control.
>> > I wanted to ask on whether there are any differences between the
>> > conversion of <Hyperlink> element to <a href> when checked inlocal
>> >processingmodeand when checked in remoteprocessingmode(i.e when
>> > the conversion is done byreportserver by using reporting server web
>> > services).
>> > Thanks in advance
>

Local report pdf export

I have found several questions and remarks about the pdf export in local mode. The big problem is that the export to pdf option in local mode is useless when compression is not supported.

My questions:

1.) When (VS 2005? date?) will pdf compression in local mode be supported?
2.) Is it possible to compress the result of the LocalReport.Render method with custom code?
3.) It seems like a small adjustment to use the server mode compression code also in local mode. Is it part of a MS strategy to force the use of server mode?

Thanx,
Arjan

I don't know of any plans to support PDF compression in local mode.

It is always possible to post-process the result of an export however you want, including compression.

|||Do you know of any .net components that can compress a PDF document?|||

I know of no .NET compression libraries off the top of my head that can compress the PDF and maintain the correct page stream. However, you can shell out to a command-line tool to do the recompress:

http://www.pdftk.com

Just be aware that this software is GPL-based so check with your legal department before incorporating binaries or source into any solution.

Thanks, Donovan

|||

I acutally came across pdftk, and it does do the job.

However, it has no hooks into it, so to get it to work as a component would take a lot of work on our part.

But I can't find anything that does the trick, so I guess I might end up shelling out to pdftk and just hoping it works. But of course that is not ideal.