Drawing error when rendering report in PDF

Hi
We had run SQL Server Report Services Service PAck2 and after installing that we are not able to open reports in PDF format. it gives drawing error .

Any help in this regard is appreciated.What the exact error message ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Hi Jens
The exact error message would be "A Drawing Error Occured"

As I had told we are having SQL Server 2000, SQL Server 2000 Reporting Services. Somebody in the forum suggested to install service pack2 which we did for earlier another issue where it was printing extra pages in both Excel and PDF. So after installing sp2 the PDF got messed up.

Any help in this regard is appreciated

Thanks|||

Hi,

This is probably an error in SP2, you can get a fix from Microsoft by contacting them on the mentioned ways here: http://support.microsoft.com/kb/912424/en-us

This is a PDF Error, probably a ressources not reachable or an out-of-memory error.

http://support.microsoft.com/kb/912424/en-us

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Hi
Thanks Jens the link helped us solve the issue.There is another related issue which if you could show us a little direction in solving it. Here is the issue

We are working on SQL Server Reporting Services 2000. We designed a

report and exported the same into excel. The original report has lets

say one page information, then before printing when we see print

preview it shows up an extra blank page and similarly if the there are

two pages in the report ,in the preview we are seeing 4 pages ie two

extra blank pages. Any help to solve this issue would be appreciated.

The same thing we are exporting in PDF format also and here to same

issue.

We are in need of a solution. It would be of great help if you could help us in getting a solution to this issue.
We have SQL Server 2000 and SQL Server 2000 Reporting services and Microsoft Office 2003

Thanks
|||Thats a really common problem. You defined the report margins to big. If the report exceeds the page format it will break the report to multiple pages. So make sure that the visible area of your report (and the additional borders) does not exceed the format specified on the report properties. Sizing the report will let you keep your report on one page per report page. Its something like playing around with the margins and sizes to fit all your data on one page.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Drag columns around?

Hello,

I am a complete newbie to CR and am evaluating CR-XI. I have a requirement to create user-customizable reports - i.e. reports where the user can move columns around to get a layout he/she likes for printing. For example, if there were 5 fields in the report:

Column1 Column2 Column3 Column4 Column5

and the user wanted to print the report with the field order:-

Column1 Column2 Column5 Column3 Column4

is it possible for the user to be able to drag the columns around? Being an amateur, could someone please list the steps I need to go thru to achieve this? Is this possible programatically - via VB6/VB.Net and if so could someone direct/show me some detailed code for this?

Apart from what I described above, the bigger requirement is to create reports at run-time from scratch. I need to create an application that will accept SQL queries from the user, parse it, run it, and display the resultant recordset as a CR. Could someone please direct/show me some code on how to do it - I am a beginner and so will need as much help as possibe.

I use Delphi 7/.Net but am pretty sure I will be able to convert VB to Delphi.

I very much appreciate any help I can get.

Thanks,
VrijeshSee if you find solution at the suppoet section of this site
www.BusinessObjects.comsql

DPI of PDF

Is there a way to increase the dpi of the actual pdf itself when exported
from the .NET IDE? Currently Adobe Acrobat reports the dpi of the pdf as 72
dpi. I need it to be at least 300 dpi.Sandy,
The PDF extension supports additional device settings (DpiX and DpiY) which
allows you to change the PDF resolution. Please look at the "PDF Device
information settings" topics in the RS documentation.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"sandy" <sandy@.discussions.microsoft.com> wrote in message
news:1AB58DD1-609D-4235-95D6-F8C5F277A641@.microsoft.com...
> Is there a way to increase the dpi of the actual pdf itself when exported
> from the .NET IDE? Currently Adobe Acrobat reports the dpi of the pdf as
72
> dpi. I need it to be at least 300 dpi.|||Before I posted, I read the documentation regarding device settings specific
to pdf. I saw where I can change the dpi, but the documentation also states
that the default is 300 dpi. If this is the case, why are the pdf's at a
lower resolution than expected?
"Teo Lachev [MVP]" wrote:
> Sandy,
> The PDF extension supports additional device settings (DpiX and DpiY) which
> allows you to change the PDF resolution. Please look at the "PDF Device
> information settings" topics in the RS documentation.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "sandy" <sandy@.discussions.microsoft.com> wrote in message
> news:1AB58DD1-609D-4235-95D6-F8C5F277A641@.microsoft.com...
> > Is there a way to increase the dpi of the actual pdf itself when exported
> > from the .NET IDE? Currently Adobe Acrobat reports the dpi of the pdf as
> 72
> > dpi. I need it to be at least 300 dpi.
>
>

DPE Error running on report Server

We created a DPE to pull data off a Web Service to be used as a datasource in
the reports we create. We created and added the code group to the
rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
name to the Data section of the RSReportServer.config file. The report works
correctly in debug designer mode but we receive the following error when
trying to run the report through the report manager or report server.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
Get Online Help
Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.Check the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We created a DPE to pull data off a Web Service to be used as a datasource in
> the reports we create. We created and added the code group to the
> rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
> name to the Data section of the RSReportServer.config file. The report works
> correctly in debug designer mode but we receive the following error when
> trying to run the report through the report manager or report server.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
> Get Online Help
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
>

DPE Error on Report Server

We have created a DPE that returns data from a Web Services and uses it as
the datasource in the reports. We have changed the config files and added
the code group also added the name to the data section of the
rsreportserver.config file. We have strong named the dll and added it to the
GAC. The report runs fine in debug designer mode but will not run through
the report server or report manager. We get the following error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
An attempt has been made to use a data extension 'ISIS WS Data' that is not
registered for this report server. (rsDataExtensionNotFound) Get Online HelpCheck the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We have created a DPE that returns data from a Web Services and uses it as
> the datasource in the reports. We have changed the config files and added
> the code group also added the name to the data section of the
> rsreportserver.config file. We have strong named the dll and added it to the
> GAC. The report runs fine in debug designer mode but will not run through
> the report server or report manager. We get the following error.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> An attempt has been made to use a data extension 'ISIS WS Data' that is not
> registered for this report server. (rsDataExtensionNotFound) Get Online Help
>|||I did all that I'm now getting a 401 unauthorized error.
"Jerry" wrote:
> Check the documentation about how to deploy a similar DPE.
> [WebService Data Processing Extension]
> http://www.rdlcomponents.com/DTE/default.aspx
> Thanks
> Jerry
> "Deb Taylor" wrote:
> > We have created a DPE that returns data from a Web Services and uses it as
> > the datasource in the reports. We have changed the config files and added
> > the code group also added the name to the data section of the
> > rsreportserver.config file. We have strong named the dll and added it to the
> > GAC. The report runs fine in debug designer mode but will not run through
> > the report server or report manager. We get the following error.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> >|||Generally this error message means you need to log on (enter a valid user ID
and password) somewhere first. If you have just entered these and then
immediately see a 401 error, it means that one or both of your user ID and
password were invalid for whatever reason (entered incorrectly, user ID
suspended etc.).
Jerry
--
[Call a WebService from SQL Server 2000]
www.rdlcomponents.com
"Deb Taylor" wrote:
> I did all that I'm now getting a 401 unauthorized error.
> "Jerry" wrote:
> > Check the documentation about how to deploy a similar DPE.
> >
> > [WebService Data Processing Extension]
> > http://www.rdlcomponents.com/DTE/default.aspx
> >
> > Thanks
> > Jerry
> >
> > "Deb Taylor" wrote:
> >
> > > We have created a DPE that returns data from a Web Services and uses it as
> > > the datasource in the reports. We have changed the config files and added
> > > the code group also added the name to the data section of the
> > > rsreportserver.config file. We have strong named the dll and added it to the
> > > GAC. The report runs fine in debug designer mode but will not run through
> > > the report server or report manager. We get the following error.
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> > >

Downloading data from our Informix server

Our entire sales database sits on an Informix server and users run their reports directly to this server.

Because of the volume of data - upwards of 7 million rows in some tables we are finding performance is becoming an issue. We realise that Informix is not the best for running queries and so are looking to replicate to a SQL server and use that as a reporting server.

My chosen method is DTS using ODBC which works fine. However due to the sheer volume of data to be downloaded each night (over a 512K wan link) we only want to download changed data.

Is there any way we can get SQL2000 to download only change data - i.e a differential download or something? We don't have a unique field in the table (for whatever reason) such as sales date or transaction ID (shops might upload old / back-dated transactions for example due to a systems failure).

If I do have to download all the data every night is my method the most efficient or is there some other approach I could use?

Ultimatly the aim here is to relieve the Informix server of the reporting overhead so any alternative ideas are welcome!

Many thanksHi
The normal way of doing this sort of thing would be replication - this would give you your "differential downlaod".
I am not sure what one can do repl wise between informix & mssql but would be worth checking it out...
Des
(otherwise can use tracking tables which record max id last copied & copy only from there each day - use vars in DTS package, seeded by values in the tracking tables)|||Which version of informix are you running - believe it or not informix is very good at running queries, so I would first check to see if either the queries are not optimized correctly, check for poor database design and also look at the onconfig file to make sure the server itself has the appropriate settings.

To solve the transfer issue - probably you best method is to dump the data and use sql server to bulk copy (bcp) or bulk insert the data. You can use some identifier within Informix such as a date/time stamp to find the changed records - however, I go back to there is probably something either designed poorly or misconfigured on your informix box that is causing this poor performance.

Download and create a Report Project from a Report Server

Before I start coding ...

Is there any existing software/trick/hack to create a Report Project from the DataSources and Folders/Reports on a Report Server, i.e. the inverse of Deployment?

Would there be anybody interested in such a thing, and, if not, why not?

I don't think there's any way to create a report project from the report server, but you can get the actual RDL files from the server.

Go to your Report Manager. (http://ServerName/Reports)
Drill through to the report you want the definition of.
Click on the properties tab.
Click on General from the options on the left.
Under the 'Report Definition' section, click 'Edit'.
This will prompt you to download the RDL file.
You can then add this to your report project that you already have created.

Hope this helps.

Jarret

Don't send report if it has no data

Hi All,
I have the standard version of SQL Server installed.
I have setup a few reports that will be automatically sent to some out
clients on a daily basis via a normal email-based subscription in reporting
services.
On some days, these reports are blank i.e. no rows returned in the dataset.
I am wondering if it is possible for the report to not be sent if a
situation exists where the report is blank
Thanks
SanjeevIf you have access to the sql server agent and can write a quick query that
will let you know if the data is going to be available it is possible. Each
subscription creates a sql server job in the sql server agent. The job
basically fires a stored procedure that executes the event (get params->run
report->render->mail or save...). The sql server jobs are saved with GUID
names that link back to the report like below. So look in the catalog and
find the report link to the scheduleID or Subscription ID. That ID will
link with the sql server job. Edit the job and have it do some if logic.
IF (there are results in this quick query) THEN trigger the event ELSE
(return 0, dbsendmail an error or however you want to handle it). This is
the basic idea of it. Let me know if you need any more help/detail.
FROM dbo.Catalog INNER JOIN
dbo.ReportSchedule ON dbo.Catalog.ItemID = dbo.ReportSchedule.ReportID INNER
JOIN
dbo.Schedule ON dbo.ReportSchedule.ScheduleID = dbo.Schedule.ScheduleID
Michael Abair
Programmer / Analyst
Chicos FAS Inc.
"Sanjeev Rampersad" <sanjeev@.sqr.com> wrote in message
news:O7miaQq9GHA.3960@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I have the standard version of SQL Server installed.
> I have setup a few reports that will be automatically sent to some out
> clients on a daily basis via a normal email-based subscription in
> reporting services.
> On some days, these reports are blank i.e. no rows returned in the
> dataset.
> I am wondering if it is possible for the report to not be sent if a
> situation exists where the report is blank
> Thanks
> Sanjeev
>|||Hi Michael,
Works like a charm.
Thanks a million
Sanjeev
"Michael Abair" <michael.abair@.chicos.com> wrote in message
news:%23Xgxept9GHA.4708@.TK2MSFTNGP05.phx.gbl...
> If you have access to the sql server agent and can write a quick query
> that will let you know if the data is going to be available it is
> possible. Each subscription creates a sql server job in the sql server
> agent. The job basically fires a stored procedure that executes the event
> (get params->run report->render->mail or save...). The sql server jobs
> are saved with GUID names that link back to the report like below. So
> look in the catalog and find the report link to the scheduleID or
> Subscription ID. That ID will link with the sql server job. Edit the job
> and have it do some if logic. IF (there are results in this quick query)
> THEN trigger the event ELSE (return 0, dbsendmail an error or however you
> want to handle it). This is the basic idea of it. Let me know if you
> need any more help/detail.
>
> FROM dbo.Catalog INNER JOIN
> dbo.ReportSchedule ON dbo.Catalog.ItemID = dbo.ReportSchedule.ReportID
> INNER JOIN
> dbo.Schedule ON dbo.ReportSchedule.ScheduleID = dbo.Schedule.ScheduleID
>
> --
> Michael Abair
> Programmer / Analyst
> Chicos FAS Inc.
> "Sanjeev Rampersad" <sanjeev@.sqr.com> wrote in message
> news:O7miaQq9GHA.3960@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have the standard version of SQL Server installed.
>> I have setup a few reports that will be automatically sent to some out
>> clients on a daily basis via a normal email-based subscription in
>> reporting services.
>> On some days, these reports are blank i.e. no rows returned in the
>> dataset.
>> I am wondering if it is possible for the report to not be sent if a
>> situation exists where the report is blank
>> Thanks
>> Sanjeev
>

Dont send empty squeduled emails.

Hi
I need to squedule the sending of a report.
My customers does not want empty reports.
How can I cancel the sending of the squduled report if the result has no
rows ?
I found this but dont think it is pretty:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
Any idears ?
--
Best regards
MikaelYes, use a data-driven subscription.
Are you using Standard or Enterprise version of Reporting Services?
=-Chris
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
> Hi
> I need to squedule the sending of a report.
> My customers does not want empty reports.
> How can I cancel the sending of the squduled report if the result has no
> rows ?
> I found this but dont think it is pretty:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
> Any idears ?
> --
> Best regards
> Mikael|||Hi
We are using a standard version of Reporting Services.
Also we query a SQL2000 server for data.
Can a data-driven sunscription also be "Squedulet" so the cursomers recive
the report at a specific time ?
--
Best regards
Mikael
"Chris Conner" wrote:
> Yes, use a data-driven subscription.
> Are you using Standard or Enterprise version of Reporting Services?
> =-Chris
> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
> news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
> > Hi
> >
> > I need to squedule the sending of a report.
> > My customers does not want empty reports.
> > How can I cancel the sending of the squduled report if the result has no
> > rows ?
> >
> > I found this but dont think it is pretty:
> >
> > http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
> >
> > Any idears ?
> >
> > --
> > Best regards
> >
> > Mikael
>
>|||The standard edition does not support data-driven subscriptions. :(
You will have to come up with another way to do it.
=-Chris
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:E2C60101-F1E7-4867-9DA4-3B711DE7C83E@.microsoft.com...
> Hi
> We are using a standard version of Reporting Services.
> Also we query a SQL2000 server for data.
> Can a data-driven sunscription also be "Squedulet" so the cursomers recive
> the report at a specific time ?
> --
> Best regards
> Mikael
>
> "Chris Conner" wrote:
>> Yes, use a data-driven subscription.
>> Are you using Standard or Enterprise version of Reporting Services?
>> =-Chris
>> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
>> news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
>> > Hi
>> >
>> > I need to squedule the sending of a report.
>> > My customers does not want empty reports.
>> > How can I cancel the sending of the squduled report if the result has
>> > no
>> > rows ?
>> >
>> > I found this but dont think it is pretty:
>> >
>> > http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
>> >
>> > Any idears ?
>> >
>> > --
>> > Best regards
>> >
>> > Mikael
>>|||Thank you for trying :)
So I need to cancel the sending of a report it the result of the report is
emty.
Any idears ?
--
Best regards
Mikael
"Chris Conner" wrote:
> The standard edition does not support data-driven subscriptions. :(
> You will have to come up with another way to do it.
> =-Chris
>
> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
> news:E2C60101-F1E7-4867-9DA4-3B711DE7C83E@.microsoft.com...
> > Hi
> >
> > We are using a standard version of Reporting Services.
> > Also we query a SQL2000 server for data.
> >
> > Can a data-driven sunscription also be "Squedulet" so the cursomers recive
> > the report at a specific time ?
> >
> > --
> > Best regards
> >
> > Mikael
> >
> >
> > "Chris Conner" wrote:
> >
> >> Yes, use a data-driven subscription.
> >>
> >> Are you using Standard or Enterprise version of Reporting Services?
> >>
> >> =-Chris
> >>
> >> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
> >> news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
> >> > Hi
> >> >
> >> > I need to squedule the sending of a report.
> >> > My customers does not want empty reports.
> >> > How can I cancel the sending of the squduled report if the result has
> >> > no
> >> > rows ?
> >> >
> >> > I found this but dont think it is pretty:
> >> >
> >> > http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
> >> >
> >> > Any idears ?
> >> >
> >> > --
> >> > Best regards
> >> >
> >> > Mikael
> >>
> >>
> >>
>
>

don't see the "data driven subscriptions" button

hi all,

i built my report with BIDS, configured my datasource and report. then i deployed it. on http://localhost/reports, I to go to the Report, but under "subscriptions", I don't see the "create data driven subscriptions" button.

however, under properties/datasources of my report, I clearly configured the
"Credentials stored securely in the report server"-setting.

Did I forgot something?

Thx

Hello,

What version of SQL Server are you running? Data-driven subscriptions are only available in Enterprise edition.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Jarret

|||damn, i looked at my installation CD, and I see that it is "standard edition" that i have.
:-(

thanks anyway. now i can stop finally stop investigating.

again, I've almost lost day with these reporting services :-(

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Does VS.NET 2003 works with RS 2005?

That's it. If I have a server with RS 2005 and in my PC VS.NET.. can I design
and program reports?
Thanks
JaimeRS 2005 does not work with VS 2003. BUT, unlike RS 2000, RS 2005 comes with
a development environment if you do not have VS 2005. I.e. if you have VS
2005 then it integrates with that just like before otherwise it installs a
special version of VS that is just for developing reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jaime Stuardo" <JaimeStuardo@.discussions.microsoft.com> wrote in message
news:9D87F9D1-E19F-42EC-8313-0513F7754619@.microsoft.com...
> That's it. If I have a server with RS 2005 and in my PC VS.NET.. can I
> design
> and program reports?
> Thanks
> Jaime|||Bruce,
do you know if SQL Server /RS/VS.NET 2005 can run on the same instance
of win XP as all the same on 2000? Or are we up for separate PCs or
separate operating system images? Just curious...
Thanks
Peter|||If all you care about is RS 2005, it does not have to have SQL Server DB
2005 to run, you can run RS 2005 using a 2000 DB as the object store (which
is what I plan to do, I have much more flexibility with upgrading RS than I
do upgrading SQL Server DB). Note that this does not mean you don't have to
have the 2005 license, you do, it is just that RS 2005 can be installed with
SQL Server 2000 Database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1121894859.061617.177870@.z14g2000cwz.googlegroups.com...
> Bruce,
> do you know if SQL Server /RS/VS.NET 2005 can run on the same instance
> of win XP as all the same on 2000? Or are we up for separate PCs or
> separate operating system images? Just curious...
> Thanks
> Peter
>|||Hi Bruce,
thanks for that, it's good to know...we are just looking for the
improved charting....we can do all the character based reports
first...
Best Regards
Peter