Report Designer using Report Model as data source

can we use Report Designer to build reports off a Model?See my replies to the post RS.exe Script utility and Forms Authentication
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:2C2DD0D5-F184-46ED-9311-9DCA8602B1D5@.microsoft.com...
> can we use Report Designer to build reports off a Model?
>

Report Designer crashes when accessing Access DB via ODBC

Hi:
I am trying to build a report off of a stand alone MS Access 2000 database. I can create the Data Source using the "Driver do Microsoft Access" driver, version 4.00.6019.00.
When I go to create the query to create the Dataset, I right click to add a table, I can see the table list and check the table I want to use. It is at this point the Visual Studio crashes, closes and send off the error report to Microsoft.
What's up? Why is this happening? I can write reports to my heart's content using an IBM ODBC driver against our DB2 database on an AS/400. One would think that writing reports using all MS products this should go very smooth.
Thanks in advance.
Bruce.Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
work with Access?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> Hi:
> I am trying to build a report off of a stand alone MS Access 2000
database. I can create the Data Source using the "Driver do Microsoft
Access" driver, version 4.00.6019.00.
> When I go to create the query to create the Dataset, I right click to add
a table, I can see the table list and check the table I want to use. It is
at this point the Visual Studio crashes, closes and send off the error
report to Microsoft.
> What's up? Why is this happening? I can write reports to my heart's
content using an IBM ODBC driver against our DB2 database on an AS/400. One
would think that writing reports using all MS products this should go very
smooth.
> Thanks in advance.
> Bruce.|||Hi Robert:
Thanks. That did the trick.
I had been using the ODBC connection that caused VS to crash for the last year with Crystal Reports with no issues. Curious...
Thanks again.
Bruce.
"Robert Bruckner [MSFT]" wrote:
> Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
> work with Access?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
> in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> > Hi:
> >
> > I am trying to build a report off of a stand alone MS Access 2000
> database. I can create the Data Source using the "Driver do Microsoft
> Access" driver, version 4.00.6019.00.
> >
> > When I go to create the query to create the Dataset, I right click to add
> a table, I can see the table list and check the table I want to use. It is
> at this point the Visual Studio crashes, closes and send off the error
> report to Microsoft.
> >
> > What's up? Why is this happening? I can write reports to my heart's
> content using an IBM ODBC driver against our DB2 database on an AS/400. One
> would think that writing reports using all MS products this should go very
> smooth.
> >
> > Thanks in advance.
> >
> > Bruce.
>
>

Report data source choices

Hi all,
I'm new to Reporting Sevices, and we're currently in the early stages
of designing a Data Warehouse / Data Mart. Initially, the DW will
only be used as a data source for reports developed with Reporting
Services. My question is twofold: first, is it possible to use
Analysis Services OLAP cubes as the data source for all reports, and
if so, then what are the pros and cons for using a cube vs. a
star-schema SQL Server database that we populate ourselves? Is one
data source normally preferred over the other. The reports will
initially be focused in the financial area but could be almost
anything.
Thanks and regards,
-MarkThe current release of SQL Server Reporting Services 2000 allows you to
execute MDX queries against Analysis Services cubes. A very good MSDN
article with samples about the integration of RS 2000 and AS 2000 is
provided at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
In addition you might want to check out an example of how to do
parameterized MDX queries with RS and AS:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MarkH" <mark@.markhibberdandassociates.com> wrote in message
news:f58c5d29.0406291458.2b904284@.posting.google.com...
> Hi all,
> I'm new to Reporting Sevices, and we're currently in the early stages
> of designing a Data Warehouse / Data Mart. Initially, the DW will
> only be used as a data source for reports developed with Reporting
> Services. My question is twofold: first, is it possible to use
> Analysis Services OLAP cubes as the data source for all reports, and
> if so, then what are the pros and cons for using a cube vs. a
> star-schema SQL Server database that we populate ourselves? Is one
> data source normally preferred over the other. The reports will
> initially be focused in the financial area but could be almost
> anything.
> Thanks and regards,
> -Mark

report data source

hi all...

i made report depeand on a relationship between 2 tables

ok

my problem now ...

i want to make a report depeand on a relationship between 2 tables but i will handle the tables name at run time
so them will change from time to time

please ... i wait ...Create a stored procedure having that code and design the report using that sp.
At the front end supply table names to sp

Report consuing a SSIS package

Has anyone had success in getting a report to generate by using an SSIS
package as it's data source? If so - can you share how you got it to work -
a couple of us who are pretty able bodied can't seem to get it to work as
Microsoft reports it should.Just visit this site for a very good hands on
http://blogs.msdn.com/bimusings/archive/2006/07/19/671743.aspx and ofcourse
MSDN for configuration as well.
I have tried it, its working fine.
Amarnath
"Joe" wrote:
> Has anyone had success in getting a report to generate by using an SSIS
> package as it's data source? If so - can you share how you got it to work -
> a couple of us who are pretty able bodied can't seem to get it to work as
> Microsoft reports it should.
>

Report Builder: Filter drop down list unspecified

I have a report model which functioned correctly until I copied the project
over to another server and changed the data source for it. I can still build
a report that returns the correct data, but when I add a filter to the report
data, the ddl for the filter never loads the data and says 'unspecified'.
I'm not sure what the problem could be. Any ideas? ThanksAfter doing some hunting around I found this:
One of the most commonly used features in ad-hoc reporting is filtering. To
add filters to a report, select a field, and then click the Filter button. If
the InstanceSelection attribute enables drop-down, filter values will be
automatically populated. In article
http://msdn2.microsoft.com/en-us/library/aa964121.aspx#adhocrptsol_topic5
This is not the issue asthe InstanceSelection property is properly configured.
"Jason" wrote:
> I have a report model which functioned correctly until I copied the project
> over to another server and changed the data source for it. I can still build
> a report that returns the correct data, but when I add a filter to the report
> data, the ddl for the filter never loads the data and says 'unspecified'.
> I'm not sure what the problem could be. Any ideas? Thanks

Report Builder Processing Error

Hi all,

Am having a problem processing reports using Report Builder. Have created the Data Source, DSV and Report Model and deployed them (following Report Builder walkthrough instructions in BOL). Building the report through the Report Builder app is also no problem. However when I try and process the report I always get the same error:

Report Execution Error
The Report might not be valid or the server could not process the data

Keyword not supported: 'provider'.
-
Cannot create a connection to data source 'dataSource'. (rsErrorOpeningConnection)
-
An error has occurred during report processing. (rsProcessingAborted)

Have tried building reports using several different models off several different DBs with the same results. Has anyone else seen the same?

I know that in the April CTP Report Builder was not fully functional. Just want to know if this is just a CTP glitch or something I am missing. Either way I am very impressed with what RB is going to offer the ad-hoc reporting world. Really happy that MS will be including it with Standard as well as Enterprise.

Cheers,Please ignore - my fault! Error was being thrown because I used '.' as the server name (lazy way of saying localhost) in my data source.

Everything worked as soon as I typed the full name of the server and redeployed all objects.

Apologies for time wasting.

Cheers,sql

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:

Logon failed.

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

hi there!

i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

if i have to run my report in the client workstation, i got this error msg:

Logon failed.

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

However, on my 2003 server I get the message

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
-
Logon failed.

Can you please explain how exactly to rectify this error?

Thanks

|||

Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

|||Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools. Click on Execution Account Uncheck "Specify an execution account"

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:

Logon failed.

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

hi there!

i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

if i have to run my report in the client workstation, i got this error msg:

Logon failed.

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

However, on my 2003 server I get the message

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
-
Logon failed.

Can you please explain how exactly to rectify this error?

Thanks

|||

Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

|||Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools. Click on Execution Account Uncheck "Specify an execution account"

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:

Logon failed.

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

hi there!

i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

if i have to run my report in the client workstation, i got this error msg:

Logon failed.

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

However, on my 2003 server I get the message

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
-
Logon failed.

Can you please explain how exactly to rectify this error?

Thanks

|||

Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

|||Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools. Click on Execution Account Uncheck "Specify an execution account"|||Hi CadsKiran

Thanks for u'r solution.
it worked for me :) .

Thanks
Isuru

Report Builder for DB2

Report Builder for DB2 data source will be supported?

Report Model support for DB2 will not make it into 2008.

|||Any future plan? Any third party support, you can suggest? Thank You.

Report Builder for DB2

Report Builder for DB2 data source will be supported?

Report Model support for DB2 will not make it into 2008.

|||Any future plan? Any third party support, you can suggest? Thank You.

report builder button missing

I have setup the RS on production server ( a named instance). The report
builder button is missing. I only can see new folder, new data source, upload
button on the http://servername/reports$instancename/Pages/Folder.aspx. I
have given myself all the rights in role setting.
I have searched in google. However only found something saying "by setting
the report server system property EnableReportDesignClientDownload to true".
However not found anything saying how to do that. checked every sql 2005
configuration tool. Not found anything to let you set that property.
Besides I have tried using
http://<servername>/reportserver/reportbuilder/reportbuilder.application
launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
My project due tomorrow. Please Help!! really appreciate it!!On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> I have setup the RS on production server ( a named instance). The report
> builder button is missing. I only can see new folder, new data source, upload
> button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> have given myself all the rights in role setting.
> I have searched in google. However only found something saying "by setting
> the report server system property EnableReportDesignClientDownload to true".
> However not found anything saying how to do that. checked every sql 2005
> configuration tool. Not found anything to let you set that property.
> Besides I have tried using
> http://<servername>/reportserver/reportbuilder/reportbuilder.application
> launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> My project due tomorrow. Please Help!! really appreciate it!!
Go to Site Settings from the Report Manager page. Select 'Configure
system-level role definitions'
and edit an existing system role or create a new system role that
includes the Execute Report Definitions task. Then make sure your
user ID is assigned that system role.
HTH
toolman|||That really helps. Thanks a bunch!
"toolman" wrote:
> On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> > I have setup the RS on production server ( a named instance). The report
> > builder button is missing. I only can see new folder, new data source, upload
> > button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> > have given myself all the rights in role setting.
> > I have searched in google. However only found something saying "by setting
> > the report server system property EnableReportDesignClientDownload to true".
> > However not found anything saying how to do that. checked every sql 2005
> > configuration tool. Not found anything to let you set that property.
> >
> > Besides I have tried using
> > http://<servername>/reportserver/reportbuilder/reportbuilder.application
> > launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> >
> > My project due tomorrow. Please Help!! really appreciate it!!
> Go to Site Settings from the Report Manager page. Select 'Configure
> system-level role definitions'
> and edit an existing system role or create a new system role that
> includes the Execute Report Definitions task. Then make sure your
> user ID is assigned that system role.
> HTH
> toolman
>

Report Builder and Analysis Services 2000

Hi,

Quite simple question: Is it possible to use Report Builder when using Analysis Services 2000 cubes as data source?

/SuneSounds like it will.
http://msdn.microsoft.com/SQL/2005/2005Webcasts/ReportingServicesQandA.aspx|||

Analysis Services 2000 cubes are not supported.

Report Builder -- Can your data source be an Oracle database

Hi again -- I am just trying to set up my first Report Model. We use Oracle
to store all of our data that we want to report on (we use Reporting
Services). Can I build a report model for Report Builder using an Oracle
database as the data source? When I try to create the datasource, it looks
like it can only accept a SQL Server database.
Thank you,
--
LaurieTLaurie,
Unfortunately the SQL 2005 Model Designer can only generate report model
projects from SQL Server databases.
"LaurieT" wrote:
> Hi again -- I am just trying to set up my first Report Model. We use Oracle
> to store all of our data that we want to report on (we use Reporting
> Services). Can I build a report model for Report Builder using an Oracle
> database as the data source? When I try to create the datasource, it looks
> like it can only accept a SQL Server database.
> Thank you,
> --
> LaurieT

Report based on Oracle Package

I want to use the results of a stored procedure from an Oracle package as my source for a report. But the stored procedure isn't listed on the dropdown when I try to add it, even though it's listed under "Procedures" in the server explorer with the [package name].[procedure name] format, but when I try typing that I just get a procedure does not exist message.You can do this programatically by loading the results into a dataset, and loading the dataset into the report. Cheers!|||Thakns. I'm pulling from five tables, so I guess I'd best get started.|||

I've created the dataset, and I can bind it to a grid, but I'm having trouble using it as a datasource for my report.

I used

ReportViewer2.LocalReport.DataSources.Add(New ReportDataSource("ds"))ReportViewer2.DataBind()

but then if I use =!Fields.LAST_NAME.Value in my table on my report I get a "report has no dataset" message and if I use =(!Fields.LAST_NAME.Value, "ds") I get the same.

Suggestions?

Replication/ syncronisation 2 MSSQL db - 1 linked to as400 - best way?

Hi There,

I would like to have the opinion of you experts!

I have a data on the AS400 which is my actual source.
I have a webpplication that needs this data (read only).

Linking my webapp directly to the AS400 works but is quite slow and the link could drop now and then.
To be sure and to increase response time, I want to have the data from the as400 transfered to a MSSQL db, which I can use for my webapp.

I have setup 2 MSSQL databases. The first one (A) is already linked to the AS400 source, and the second one (B) should be updated by the first one (A).

I would use db B for my webapp.

I need to find out how I can replicate/synchonise the linked database A with database B (in almost real time). Also I don't want to have a risk for when the link to the as400 drops, database B gets empried or upset in one or another way.

Now does my plan makes any sense, are there better or more efficient ways to do this?

And what would be the best way to replicate or synchronise the MSSQL databases?

Thanks,
KJWe do something similar here (production data source is AS/400, web data source is MS SQL). I use DTS to migrate data from production to the SQL Server periodically (as frequently as every 15 minutes). It is far from a perfect solution, but it allows users to bang away merrily on the reports server (MS SQL) with no effect on the production (AS/400). Developing the rules for migrating the data can be complex, however.

Other solutions (linking, direct connect via OLE DB/ODBC) provide more real-time data, but may also negatively impact the performance of the production server.

hmscott|||Did you consider to setup a linked server from MSSQL?
And, do you replace all the data or do you compare first before you migrate and just update the records changed?

I had my webapplication connected directly to the As400 (via Client Access ODBC Driver) which gives indeed real-time data but is already slow. We are now using it with 4 test users only so you can imagine what would happen when we go live with xxx users.

Cheers,
KJ