Import Charts

Hello NG!
I want to import AccessXP reports with charts. Is there any possibility to do this?
In the report designer error message callt object is not supportet.
Michael HerrmannsBOL contains a topic on the supported access report features during import:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_building_v1_5x2r.asp
At the end of the "report controls" section it states: "For example, if an
Access report contains an OWC Chart control, it will not be converted when
the report is imported. The control must be added manually after the report
is imported." I.e. you have to re-create the charts with the Reporting
Services chart control.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Herrmanns" <m.herrmanns@.fme.de> wrote in message
news:8c74690.0409130133.48f12c8b@.posting.google.com...
> Hello NG!
> I want to import AccessXP reports with charts. Is there any possibility to
do this?
> In the report designer error message callt object is not supportet.
> Michael Herrmanns|||Thanks Roberts.
Next time I better rtm.
greeting
Michael

Import Access Reports

I had been successfully importing Access reports into SQL Reporting Services.
Now all of sudden when I go to the Project menu to select the Import option,
it's no longer there. I can't find it anywhere now. The only thing that I've
done since I was able to import is, load XPsp2. Am I missing something? Any
suggestions?Please see the following KB article:
Some programs seem to stop working after you install Windows XP Service Pack
2
http://support.microsoft.com/default.aspx?kbid=842242
You may have encountered this situation.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Huey" <Huey@.discussions.microsoft.com> wrote in message
news:A712782F-CC81-453C-92A3-E4FA99FEC197@.microsoft.com...
> I had been successfully importing Access reports into SQL Reporting
Services.
> Now all of sudden when I go to the Project menu to select the Import
option,
> it's no longer there. I can't find it anywhere now. The only thing that
I've
> done since I was able to import is, load XPsp2. Am I missing something?
Any
> suggestions?

Import Access Report

I need to import Access Reports to Reporting Service on fly using VB.NET code. How can I do that? I know how to do that using Report designer but it is not going to work because we have to convert 500 reports. Any help will be highly appreciated.

I'm in the same boat. I have tried various report-to-xml export options but I get nothing but errors trying to get a functioning xml report working in Visual web developer. Sure hope someone can chime in on this subject. Zero help from Microsoft.

Import access report

Hello,
I want to import access report into sql reporting, but i dont have the
option in the project menu "Import Reports "-->"Microsoft Access...".
I'm working on windows 2000 and i have installed Sql reporting server SP1.
Any Idea ?
Thank you for your help !James,
It's not in the Report menu, it's in the solution explorer.
In your report project, rightclick Reports folder and choose Import
Reports..
Jon Jahren
"James" <James@.discussions.microsoft.com> wrote in message
news:8E3F7A8A-4940-4B91-8337-D537CFF928FF@.microsoft.com...
> Hello,
> I want to import access report into sql reporting, but i dont have the
> option in the project menu "Import Reports "-->"Microsoft Access...".
> I'm working on windows 2000 and i have installed Sql reporting server SP1.
> Any Idea ?
> Thank you for your help !
>|||Thank you for your answer Jon, but the problem was that i had Access 2000 and
the option to import Access Report is available only with at least access
2002 !!!
I did an update and now it's working fine.

Import & Export

Hi,
I'm using Reporting Services and MOM 2005.
How can I import existing reports to Visual Studio for design mode?I means to import all the reports and not one by one
Also, is it possible in Visual Studio to configure each report to a
different TargetFolder in the same project?
"×¢×?×?×?" wrote:
> Hi,
> I'm using Reporting Services and MOM 2005.
> How can I import existing reports to Visual Studio for design mode?|||Hi,
I try to upload my report to the reporting services using
PublishSampleReports.rss
I try to upload to a subfolder parentFolder="All SQL Report/performance"
but I ger an error message,
How can I do that ?
"×¢×?×?×?" wrote:
> I means to import all the reports and not one by one
> Also, is it possible in Visual Studio to configure each report to a
> different TargetFolder in the same project?
> "×¢×?×?×?" wrote:
> > Hi,
> >
> > I'm using Reporting Services and MOM 2005.
> > How can I import existing reports to Visual Studio for design mode?|||What error message are you getting?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"'" <@.discussions.microsoft.com> wrote in message
news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> Hi,
> I try to upload my report to the reporting services using
> PublishSampleReports.rss
> I try to upload to a subfolder parentFolder="All SQL Report/performance"
> but I ger an error message,
> How can I do that ?
> "'" wrote:
>> I means to import all the reports and not one by one
>> Also, is it possible in Visual Studio to configure each report to a
>> different TargetFolder in the same project?
>> "'" wrote:
>> > Hi,
>> >
>> > I'm using Reporting Services and MOM 2005.
>> > How can I import existing reports to Visual Studio for design mode?|||The error message:
C:\Reporting>rs -i PublishSampleReports.rss -s
http://momreporting/reportserver/
-v parentFolder="Microsoft Operations Manager Reporting/idanl"
System.Web.Services.Protocols.SoapException: The name of the item 'Microsoft
Ope
rations Manager Reporting/idanl' is not valid. The name must be less than
260 ch
aracters long, must not start with slash; other restrictions apply. Check
the do
cumentation for complete set of restrictions. -->
Microsoft.ReportingServices.D
iagnostics.Utilities.InvalidItemNameException: The name of the item
'Microsoft O
perations Manager Reporting/idanl' is not valid. The name must be less than
260
characters long, must not start with slash; other restrictions apply. Check
the
documentation for complete set of restrictions.
"Jeff A. Stucker" wrote:
> What error message are you getting?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "'" <@.discussions.microsoft.com> wrote in message
> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> > Hi,
> > I try to upload my report to the reporting services using
> > PublishSampleReports.rss
> > I try to upload to a subfolder parentFolder="All SQL Report/performance"
> > but I ger an error message,
> > How can I do that ?
> >
> > "'" wrote:
> >
> >> I means to import all the reports and not one by one
> >>
> >> Also, is it possible in Visual Studio to configure each report to a
> >> different TargetFolder in the same project?
> >>
> >> "'" wrote:
> >>
> >> > Hi,
> >> >
> >> > I'm using Reporting Services and MOM 2005.
> >> > How can I import existing reports to Visual Studio for design mode?
>
>|||Sorry I can't help you on the RSS issue.
But I can answer the question about Visual Studio. Unfortunately, at this
time there is a one-to-one mapping between project and folder. I set up a
VS solution with multiple projects -- one for each folder I need to publish
to.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"'" <@.discussions.microsoft.com> wrote in message
news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
> The error message:
> C:\Reporting>rs -i PublishSampleReports.rss -s
> http://momreporting/reportserver/
> -v parentFolder="Microsoft Operations Manager Reporting/idanl"
> System.Web.Services.Protocols.SoapException: The name of the item
> 'Microsoft
> Ope
> rations Manager Reporting/idanl' is not valid. The name must be less than
> 260 ch
> aracters long, must not start with slash; other restrictions apply. Check
> the do
> cumentation for complete set of restrictions. -->
> Microsoft.ReportingServices.D
> iagnostics.Utilities.InvalidItemNameException: The name of the item
> 'Microsoft O
> perations Manager Reporting/idanl' is not valid. The name must be less
> than
> 260
> characters long, must not start with slash; other restrictions apply.
> Check
> the
> documentation for complete set of restrictions.
> "Jeff A. Stucker" wrote:
>> What error message are you getting?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "'" <@.discussions.microsoft.com> wrote in message
>> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
>> > Hi,
>> > I try to upload my report to the reporting services using
>> > PublishSampleReports.rss
>> > I try to upload to a subfolder parentFolder="All SQL
>> > Report/performance"
>> > but I ger an error message,
>> > How can I do that ?
>> >
>> > "'" wrote:
>> >
>> >> I means to import all the reports and not one by one
>> >>
>> >> Also, is it possible in Visual Studio to configure each report to a
>> >> different TargetFolder in the same project?
>> >>
>> >> "'" wrote:
>> >>
>> >> > Hi,
>> >> >
>> >> > I'm using Reporting Services and MOM 2005.
>> >> > How can I import existing reports to Visual Studio for design mode?
>>|||Hi Jeff
I succeed to solve the problem with the path problem by run this command
without the http://momreporting/reportserver/
But while I import the report to the reporting services I get in all the
report a new text box to enter user name & password, why ?
Thanks and have a happy new years
Idan
"Jeff A. Stucker" wrote:
> Sorry I can't help you on the RSS issue.
> But I can answer the question about Visual Studio. Unfortunately, at this
> time there is a one-to-one mapping between project and folder. I set up a
> VS solution with multiple projects -- one for each folder I need to publish
> to.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "'" <@.discussions.microsoft.com> wrote in message
> news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
> > The error message:
> >
> > C:\Reporting>rs -i PublishSampleReports.rss -s
> > http://momreporting/reportserver/
> > -v parentFolder="Microsoft Operations Manager Reporting/idanl"
> > System.Web.Services.Protocols.SoapException: The name of the item
> > 'Microsoft
> > Ope
> > rations Manager Reporting/idanl' is not valid. The name must be less than
> > 260 ch
> > aracters long, must not start with slash; other restrictions apply. Check
> > the do
> > cumentation for complete set of restrictions. -->
> > Microsoft.ReportingServices.D
> > iagnostics.Utilities.InvalidItemNameException: The name of the item
> > 'Microsoft O
> > perations Manager Reporting/idanl' is not valid. The name must be less
> > than
> > 260
> > characters long, must not start with slash; other restrictions apply.
> > Check
> > the
> > documentation for complete set of restrictions.
> >
> > "Jeff A. Stucker" wrote:
> >
> >> What error message are you getting?
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "'" <@.discussions.microsoft.com> wrote in message
> >> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> >> > Hi,
> >> > I try to upload my report to the reporting services using
> >> > PublishSampleReports.rss
> >> > I try to upload to a subfolder parentFolder="All SQL
> >> > Report/performance"
> >> > but I ger an error message,
> >> > How can I do that ?
> >> >
> >> > "'" wrote:
> >> >
> >> >> I means to import all the reports and not one by one
> >> >>
> >> >> Also, is it possible in Visual Studio to configure each report to a
> >> >> different TargetFolder in the same project?
> >> >>
> >> >> "'" wrote:
> >> >>
> >> >> > Hi,
> >> >> >
> >> >> > I'm using Reporting Services and MOM 2005.
> >> >> > How can I import existing reports to Visual Studio for design mode?
> >>
> >>
> >>
>
>|||Check the report permissions in Report Manager (http://<server>/Reports)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"'" <@.discussions.microsoft.com> wrote in message
news:5DE0A914-146E-46B9-AF6A-F77127BE5A47@.microsoft.com...
> Hi Jeff
> I succeed to solve the problem with the path problem by run this command
> without the http://momreporting/reportserver/
> But while I import the report to the reporting services I get in all the
> report a new text box to enter user name & password, why ?
> Thanks and have a happy new years
> Idan
>
> "Jeff A. Stucker" wrote:
>> Sorry I can't help you on the RSS issue.
>> But I can answer the question about Visual Studio. Unfortunately, at
>> this
>> time there is a one-to-one mapping between project and folder. I set up
>> a
>> VS solution with multiple projects -- one for each folder I need to
>> publish
>> to.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "'" <@.discussions.microsoft.com> wrote in message
>> news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
>> > The error message:
>> >
>> > C:\Reporting>rs -i PublishSampleReports.rss -s
>> > http://momreporting/reportserver/
>> > -v parentFolder="Microsoft Operations Manager Reporting/idanl"
>> > System.Web.Services.Protocols.SoapException: The name of the item
>> > 'Microsoft
>> > Ope
>> > rations Manager Reporting/idanl' is not valid. The name must be less
>> > than
>> > 260 ch
>> > aracters long, must not start with slash; other restrictions apply.
>> > Check
>> > the do
>> > cumentation for complete set of restrictions. -->
>> > Microsoft.ReportingServices.D
>> > iagnostics.Utilities.InvalidItemNameException: The name of the item
>> > 'Microsoft O
>> > perations Manager Reporting/idanl' is not valid. The name must be less
>> > than
>> > 260
>> > characters long, must not start with slash; other restrictions apply.
>> > Check
>> > the
>> > documentation for complete set of restrictions.
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> What error message are you getting?
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "'" <@.discussions.microsoft.com> wrote in message
>> >> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
>> >> > Hi,
>> >> > I try to upload my report to the reporting services using
>> >> > PublishSampleReports.rss
>> >> > I try to upload to a subfolder parentFolder="All SQL
>> >> > Report/performance"
>> >> > but I ger an error message,
>> >> > How can I do that ?
>> >> >
>> >> > "'" wrote:
>> >> >
>> >> >> I means to import all the reports and not one by one
>> >> >>
>> >> >> Also, is it possible in Visual Studio to configure each report to a
>> >> >> different TargetFolder in the same project?
>> >> >>
>> >> >> "'" wrote:
>> >> >>
>> >> >> > Hi,
>> >> >> >
>> >> >> > I'm using Reporting Services and MOM 2005.
>> >> >> > How can I import existing reports to Visual Studio for design
>> >> >> > mode?
>> >>
>> >>
>> >>
>>|||Thanks jeff
I know I can change the report permission under each report,
but if I have a lot of report I need to change it each one, Why the import
process cause this ?
"Jeff A. Stucker" wrote:
> Check the report permissions in Report Manager (http://<server>/Reports)
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "'" <@.discussions.microsoft.com> wrote in message
> news:5DE0A914-146E-46B9-AF6A-F77127BE5A47@.microsoft.com...
> > Hi Jeff
> > I succeed to solve the problem with the path problem by run this command
> > without the http://momreporting/reportserver/
> >
> > But while I import the report to the reporting services I get in all the
> > report a new text box to enter user name & password, why ?
> >
> > Thanks and have a happy new years
> >
> > Idan
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Sorry I can't help you on the RSS issue.
> >>
> >> But I can answer the question about Visual Studio. Unfortunately, at
> >> this
> >> time there is a one-to-one mapping between project and folder. I set up
> >> a
> >> VS solution with multiple projects -- one for each folder I need to
> >> publish
> >> to.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "'" <@.discussions.microsoft.com> wrote in message
> >> news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
> >> > The error message:
> >> >
> >> > C:\Reporting>rs -i PublishSampleReports.rss -s
> >> > http://momreporting/reportserver/
> >> > -v parentFolder="Microsoft Operations Manager Reporting/idanl"
> >> > System.Web.Services.Protocols.SoapException: The name of the item
> >> > 'Microsoft
> >> > Ope
> >> > rations Manager Reporting/idanl' is not valid. The name must be less
> >> > than
> >> > 260 ch
> >> > aracters long, must not start with slash; other restrictions apply.
> >> > Check
> >> > the do
> >> > cumentation for complete set of restrictions. -->
> >> > Microsoft.ReportingServices.D
> >> > iagnostics.Utilities.InvalidItemNameException: The name of the item
> >> > 'Microsoft O
> >> > perations Manager Reporting/idanl' is not valid. The name must be less
> >> > than
> >> > 260
> >> > characters long, must not start with slash; other restrictions apply.
> >> > Check
> >> > the
> >> > documentation for complete set of restrictions.
> >> >
> >> > "Jeff A. Stucker" wrote:
> >> >
> >> >> What error message are you getting?
> >> >>
> >> >> --
> >> >> Cheers,
> >> >>
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "'" <@.discussions.microsoft.com> wrote in message
> >> >> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> >> >> > Hi,
> >> >> > I try to upload my report to the reporting services using
> >> >> > PublishSampleReports.rss
> >> >> > I try to upload to a subfolder parentFolder="All SQL
> >> >> > Report/performance"
> >> >> > but I ger an error message,
> >> >> > How can I do that ?
> >> >> >
> >> >> > "'" wrote:
> >> >> >
> >> >> >> I means to import all the reports and not one by one
> >> >> >>
> >> >> >> Also, is it possible in Visual Studio to configure each report to a
> >> >> >> different TargetFolder in the same project?
> >> >> >>
> >> >> >> "'" wrote:
> >> >> >>
> >> >> >> > Hi,
> >> >> >> >
> >> >> >> > I'm using Reporting Services and MOM 2005.
> >> >> >> > How can I import existing reports to Visual Studio for design
> >> >> >> > mode?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>