Report Model Builder in SQL Server 2005 CTP

Will the model builder have the ability to build models against an Oracle
database? I may be missing something in the CTP but it looks like I can only
make a SQL Server database data source.Directly supported are:
- Analysis Services 2005 data sources
- SQL Server 2000 and 2005 relational data sources
At this point, other data sources (e.g. Oracle) can only be accessed through
the linked server functionality of SQL Server. We are aware that this
approach has restrictions and drawbacks and we are looking into directly
supported additional data sources natively in future releases.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:DEEE25FF-79DA-498C-8977-0EF2C631E8E0@.microsoft.com...
> Will the model builder have the ability to build models against an Oracle
> database? I may be missing something in the CTP but it looks like I can
> only
> make a SQL Server database data source.

Report Model and Aggregates

Once I build a model without selecting "create aggregrates". Can I take that model and change one decimal attribute (PCOM AMT(C2) and make that a numeric aggregate with the additional aggregrate attributes? I tried changint it to "isaggregrate" and then regenerating the attribute but there was no change. Is isaggregrate only used for new expressions?

I get the following message:

The IsAggregate property for the Attribute 'PCOM AMT' is true, but a Column binding is specified. IsAggregate cannot be true if Column is specified.

If I remove binding and rebuild I get this message.

The binding is missing for the Attribute 'PCOM AMT'. Attribute must have exactly one Column binding if Expression is not specified.

Thank you!

IsAggregate flag on entity attribute only tells the model that the attribute can be used as aggregate. Taking a column-bound attribute and marking it IsAggregate will not make it an aggregate.

What you need to do is to leave the column-bound attribute as is and create new attribute that will have an aggregate expression like this: Count(my_column_mound_attribute). Then mark this new attribute as IsAggregate.

Regenerating model will not automatically add new aggregates.

Report Model and Aggregates

Once I build a model without selecting "create aggregrates". Can I take that model and change one decimal attribute (PCOM AMT(C2) and make that a numeric aggregate with the additional aggregrate attributes? I tried changint it to "isaggregrate" and then regenerating the attribute but there was no change. Is isaggregrate only used for new expressions?

I get the following message:

The IsAggregate property for the Attribute 'PCOM AMT' is true, but a Column binding is specified. IsAggregate cannot be true if Column is specified.

If I remove binding and rebuild I get this message.

The binding is missing for the Attribute 'PCOM AMT'. Attribute must have exactly one Column binding if Expression is not specified.

Thank you!

IsAggregate flag on entity attribute only tells the model that the attribute can be used as aggregate. Taking a column-bound attribute and marking it IsAggregate will not make it an aggregate.

What you need to do is to leave the column-bound attribute as is and create new attribute that will have an aggregate expression like this: Count(my_column_mound_attribute). Then mark this new attribute as IsAggregate.

Regenerating model will not automatically add new aggregates.

Report Manager configuration

We deployed Reporting Services recently to a customer with a latest release and build. When they type in http://<server>/ReportServer, this just comes up with a screen like a navigation sreen showing folders and links to reports. What needs to be done to get the Report Manager screen showing?

It has been a while since I actually installed Reporting Services. When they go into configuration, all of the green checks are there (except for Web Service Identity, which is Red).

Thanks for any information.

Solved it...the user was not using the Virtual Directory. Sorry for the "newbie" post.

Report in CRM ?

Hi All,
I created a report for Microsoft CRM 3.0... Do I have to "deploy" it
to the CRM server in order to use it in CRM or only to "build" the RDL
and add it in CRM ?
Any tips on this will be very helpfull
ThanksRDL is all XML, I dont really think "building" does much
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170335048.873329.127820@.s48g2000cws.googlegroups.com...
> Hi All,
> I created a report for Microsoft CRM 3.0... Do I have to "deploy" it
> to the CRM server in order to use it in CRM or only to "build" the RDL
> and add it in CRM ?
> Any tips on this will be very helpfull
> Thanks
>

Report help please...

Hey guys,

Im kind of new to crystal, well enough to be dangerous anyway... but I have a report that I am trying to build. let me give you a little background on what the database is like so you have an idea of what Im trying to do. I am reporting against a SQL database that is our CRM system, which we track calls in. so you open a ticket, and then there are journal entries that are linked to that object in another table.

so what i want to do is display the open calls for a particular company, and the last two journal entries.

what i have so far, is everythign but the last two journal entries. i can get it to display all of them, but i only want the last two.. otherwise the report is way to big. i was thinking there must be a "TOP" type function or somethign kind of like in sql, where i could say only top 2 or something like that.. any help would be good... thanks!Have you tried this:

"SELECT TOP 2 * FROM YourTable ORDER BY OneField Desc"

I think this SQL will extract last 2 items.|||I have thought about doing that, but not really sure where to put it... i mean there are so many spots in crystal to put formulas... do i put it right on the field? on the section of the report? or where? right now im trying to use the suppress function with a formula, thinking it should work.. but its not... either it suppresses everythign or nothing... i cant get it to work if the formula condition is met, which the help files says that it should work like that...

im trying

{mytable.datecolumn} < Last7Days

figured ok if it is less then the last 7 days then suppress it... but that doesnt seam to work..|||I have thought about doing that, but not really sure where to put it...

I use Vb code to execute SQL. Have you tried SQL Expression Fields on CR?

Report from 2 tables

Hi Guys,

I am trying to build a report that will present data from 2 sql tables. Here is the scenario:

I have 2 Tbales:

1. TimeSlots - has SlotID and Time columns

2. Reserv - has SlotID, Name, Comments, Date

I am trying to build a report that will show all SlotID's from TimeSlots for a certain Day. The report should show all Time slots regardles if there is a reservation for that TimeSlot, also the Name and Comments for the Time Slot that is reserved.

The idea is that if a time slot is not reserved it should still print on the report which will then be given to the user who will manually pencil in the data should a pop up reservation occurs.

For Example:

SlotID Time Name Comments

1 6:00

2 6:15 Sven Employee

3 7:00 Randy Employee

4 7:15

Please help as i am lost!

regards

SD

You should be able to build your query something like the following:

SELECT ts.SlotID, ts.Time, res.Name, res.Comments, res.Date

FROM TimeSlots ts

LEFT OUTER JOIN Reserve res

ON ts.SlotID = res.SlotID

This will return all records in the TimeSlots table with any corresponding Reserve records based on the SlotID fields. The main thing to ensure is to uniquely identify any fields that may have duplicate names and returning duplicate field names via a subquery will throw a SQL error (just in case you weren't aware of this). You should be able to just pull the necessary fields onto your report from here.

Hope this helps.

|||

For those of you intrested, I used an Union query and build a report that groups the data on SotID!

Regards

SD