Page break & Service Pack !

Can anyone let me know how I check which Service Pack I do have in SQL
Server Reporting Services.
The second problem is in the reporting services I can see all the pages but
when I export in to PDF I can see proper page break, any idea what's the
problem.
ThanksOn Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Can anyone let me know how I check which Service Pack I do have in SQL
> Server Reporting Services.
> The second problem is in the reporting services I can see all the pages but
> when I export in to PDF I can see proper page break, any idea what's the
> problem.
> Thanks
The first answer is as follows:
SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
('edition') AS SQLServerEdition
To get version specs check this link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
For the second question, if I'm understanding you correctly, the
interface has no page breaks by default. it all appears as a single
page. The PDF renderer breaks it up into pages.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Is that version gave me SQL Server Reporting Services.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
>> Can anyone let me know how I check which Service Pack I do have in SQL
>> Server Reporting Services.
>> The second problem is in the reporting services I can see all the pages
>> but
>> when I export in to PDF I can see proper page break, any idea what's the
>> problem.
>> Thanks
>
> The first answer is as follows:
> SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> ('edition') AS SQLServerEdition
> To get version specs check this link.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> For the second question, if I'm understanding you correctly, the
> interface has no page breaks by default. it all appears as a single
> page. The PDF renderer breaks it up into pages.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Oct 15, 8:46 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Is that version gave me SQL Server Reporting Services.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> > On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> >> Can anyone let me know how I check which Service Pack I do have in SQL
> >> Server Reporting Services.
> >> The second problem is in the reporting services I can see all the pages
> >> but
> >> when I export in to PDF I can see proper page break, any idea what's the
> >> problem.
> >> Thanks
> > The first answer is as follows:
> > SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> > SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> > ('edition') AS SQLServerEdition
> > To get version specs check this link.
> >http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> > For the second question, if I'm understanding you correctly, the
> > interface has no page breaks by default. it all appears as a single
> > page. The PDF renderer breaks it up into pages.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If I understand you correctly, generally speaking, the service pack
level of SQL Server is the same as for SSRS/Reporting Services that
you are running. Hope this clarifies it further.
Regards,
Enrique Martinez
Sr. Software Consultant

Page break

Hello,

I'm using SQL 2005 reporting services.

I habe table with two group.

Group A and Group B.

I set Page break at start and at end for each group in order each group will be in the new page.

it is not working and I'm getting group A and B in the same page

Do you have visibility properties set on the groups? If so, pagebreaks will be ignored.|||

I know this problem but no, I have no visibility set.

I currently change from table to list and it seemse to work fine but still..

I have group A header and footer and also for group B

My problem is that the first header from group A is in the same page with first header from Group B

Also last record in the Group B in the same page with the footer from group A.

Aslo I have a problem with document map. I create a document map from group A and group B and if the content is not in a differed pages the document map build successfuly but the link is not correct

Page brakes after top group item

I just started with reporting services.
I created report that has two groujping items in the table. Everything works
fine just I always get second row for the top level group on the second
page. This doesn't make any sense to me
1) I am using HTML rending and I don't need all this pages
2) the top group item has only one detailed item and second has about 8
items they all can fit on one page even if viewed in collapsed state
3) There are no any forced page breaks for any table items and for table
itself.
Any ideas how to solve the problem?
ShimonSorry
I just figure out that it looks like that only in preview but on the site it
looks fine.
Thanks,
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eeQ3XrQeEHA.2376@.tk2msftngp13.phx.gbl...
> I just started with reporting services.
> I created report that has two groujping items in the table. Everything
works
> fine just I always get second row for the top level group on the second
> page. This doesn't make any sense to me
> 1) I am using HTML rending and I don't need all this pages
> 2) the top group item has only one detailed item and second has about 8
> items they all can fit on one page even if viewed in collapsed state
> 3) There are no any forced page breaks for any table items and for table
> itself.
> Any ideas how to solve the problem?
> Shimon
>

package path referenced an object that cannot be found

I am running Final Relase of 2005 version 9.00.1399. I built an Integration Services package saved it closed up, came in the next day opened the project and I get 46 Warnings and the message on all of them is similar:

"Warning loading Package.dtsx: The package path referenced an object that cannot be found: "\Package\Truncate Temp Table.Properties[Connection]". This occurs when an attempt is made to resolve a package path to an object that cannot be found."

The problem is that I had an Execute SQL Task that I named Truncate Temp Table for a while, but subsequently changed the name before I saved it at the end of the day. So the task called Truncate Temp Table doesn't exist anymore and it is still trying to find its properties. I have tried running Clean, Build, and Rebuild.

How do I get the package path to refresh with the current package design?

Thanks!

Hi,

If you got this solved I'd love to know how you did it! I am having the same problem!

Thanks,

PMR

|||

Hi..

Try regenerate the package id of your SSIS package, and save it...

ref : http://support.microsoft.com/?kbid=906564

|||

Hi KamiNoChikara,

I don't know if this will help or not, but version 9.00.1399 is not the latest version. SP1 addressed a host of SSIS issues, and is available at http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en.

Hope this helps,
Andy

|||

KamiNoChikara wrote:

I am running Final Relase of 2005 version 9.00.1399. I built an Integration Services package saved it closed up, came in the next day opened the project and I get 46 Warnings and the message on all of them is similar:

"Warning loading Package.dtsx: The package path referenced an object that cannot be found: "\Package\Truncate Temp Table.Properties[Connection]". This occurs when an attempt is made to resolve a package path to an object that cannot be found."

The problem is that I had an Execute SQL Task that I named Truncate Temp Table for a while, but subsequently changed the name before I saved it at the end of the day. So the task called Truncate Temp Table doesn't exist anymore and it is still trying to find its properties. I have tried running Clean, Build, and Rebuild.

How do I get the package path to refresh with the current package design?

Thanks!

My guess is that you have something external to the package that is referencing this path. Are you using configurations by any chance?

-Jamie

package path referenced an object that cannot be found

I am running Final Relase of 2005 version 9.00.1399. I built an Integration Services package saved it closed up, came in the next day opened the project and I get 46 Warnings and the message on all of them is similar:

"Warning loading Package.dtsx: The package path referenced an object that cannot be found: "\Package\Truncate Temp Table.Properties[Connection]". This occurs when an attempt is made to resolve a package path to an object that cannot be found."

The problem is that I had an Execute SQL Task that I named Truncate Temp Table for a while, but subsequently changed the name before I saved it at the end of the day. So the task called Truncate Temp Table doesn't exist anymore and it is still trying to find its properties. I have tried running Clean, Build, and Rebuild.

How do I get the package path to refresh with the current package design?

Thanks!

Hi,

If you got this solved I'd love to know how you did it! I am having the same problem!

Thanks,

PMR

|||

Hi..

Try regenerate the package id of your SSIS package, and save it...

ref : http://support.microsoft.com/?kbid=906564

|||

Hi KamiNoChikara,

I don't know if this will help or not, but version 9.00.1399 is not the latest version. SP1 addressed a host of SSIS issues, and is available at http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en.

Hope this helps,
Andy

|||

KamiNoChikara wrote:

I am running Final Relase of 2005 version 9.00.1399. I built an Integration Services package saved it closed up, came in the next day opened the project and I get 46 Warnings and the message on all of them is similar:

"Warning loading Package.dtsx: The package path referenced an object that cannot be found: "\Package\Truncate Temp Table.Properties[Connection]". This occurs when an attempt is made to resolve a package path to an object that cannot be found."

The problem is that I had an Execute SQL Task that I named Truncate Temp Table for a while, but subsequently changed the name before I saved it at the end of the day. So the task called Truncate Temp Table doesn't exist anymore and it is still trying to find its properties. I have tried running Clean, Build, and Rebuild.

How do I get the package path to refresh with the current package design?

Thanks!

My guess is that you have something external to the package that is referencing this path. Are you using configurations by any chance?

-Jamie

Package execution failed but no error (SQL2005)

I made an Integration Services Package which runs well if I start it manually
(also from SQL server Management Studio).
Now I have created a new job for the SQL server agent which need to run my
package.
After starting the job, it ends after a few seconds:
"The package execution failed" is the only message there is.
I assume it has something to do with security but for the test I am logged
in as a domain administrator which has all rights to all databases.
Can someone give some clues about how to solve this?
Thanks
Two possibilities come to my mind:
1- SQL Server run under its own account; so you should check the permission
for this account on both Windows and SQL-Server side (for example, does this
account has an explicit access to the database?)
2- You are using things like a network drive (Z:\Repertory\...) instead of
an UNC file name (\\Server\Repertory\...) which are specific to the login
account and unknown to other accounts.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Frans" <Frans@.discussions.microsoft.com> wrote in message
news:6EBD9795-92BA-435C-BCC7-CFEBDC6EAF2F@.microsoft.com...
>I made an Integration Services Package which runs well if I start it
>manually
> (also from SQL server Management Studio).
> Now I have created a new job for the SQL server agent which need to run my
> package.
> After starting the job, it ends after a few seconds:
> "The package execution failed" is the only message there is.
> I assume it has something to do with security but for the test I am logged
> in as a domain administrator which has all rights to all databases.
> Can someone give some clues about how to solve this?
> Thanks

Package execution failed but no error (SQL2005)

I made an Integration Services Package which runs well if I start it manuall
y
(also from SQL server Management Studio).
Now I have created a new job for the SQL server agent which need to run my
package.
After starting the job, it ends after a few seconds:
"The package execution failed" is the only message there is.
I assume it has something to do with security but for the test I am logged
in as a domain administrator which has all rights to all databases.
Can someone give some clues about how to solve this?
ThanksTwo possibilities come to my mind:
1- SQL Server run under its own account; so you should check the permission
for this account on both Windows and SQL-Server side (for example, does this
account has an explicit access to the database?)
2- You are using things like a network drive (Z:\Repertory\...) instead of
an UNC file name (\\Server\Repertory\...) which are specific to the login
account and unknown to other accounts.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Frans" <Frans@.discussions.microsoft.com> wrote in message
news:6EBD9795-92BA-435C-BCC7-CFEBDC6EAF2F@.microsoft.com...
>I made an Integration Services Package which runs well if I start it
>manually
> (also from SQL server Management Studio).
> Now I have created a new job for the SQL server agent which need to run my
> package.
> After starting the job, it ends after a few seconds:
> "The package execution failed" is the only message there is.
> I assume it has something to do with security but for the test I am logged
> in as a domain administrator which has all rights to all databases.
> Can someone give some clues about how to solve this?
> Thanks

Package executing error

I wrote package using Integration Services and tried execute it on Visual Studio 2003 (Visual Basic). Package was loaded, but execute method has failed without any error messages. When I tried to run it on Visual Studio 2005, execution was successful.

Codes:

Dim App As DTSLib.IDTSApplication90 = New DTSLib.Application

Dim p As DTSLib.IDTSPackage90 = App.LoadPackage("d:\temp\Package.dtsx", True, Nothing)

p.Execute()

What can be the reason of the trouble?

Thanks,

Alexander

Only one .NET runtime can live in one process. Visual Studio 2003 uses .NET 1.1, and SSIS requires .NET 2.0 - so SSIS fails if the process has already loaded .NET 1.1.

You can use config file to change the .NET version used by applications developed with .NET 1.1 and force them to use .NET 2.0, but it will break Visual Studio debugging.

So it is highly recommended to use Visual Studio 2005. In Visual Studio 2005 you can also use managed API for SSIS - in Microsoft.SqlServer.ManagedDTS assembly, which is more convinient than using interop from DTSLib.

OWC in Windows 98 connect to Analysis Services 2005

Is there a posibility to make OWC installed in Windows 98 connect to Analysis Services 2005?

The thing is we cannot install the OLE DB Provider 9.0 for Analysis Services 2005, because it needs Windows Installer 3.1, and we really need to connect OWC to 2005, because we could do it with Analysis Services 2000.

How can we do?

Thanks in advance.

If you want to use OWC, you must have the OLEDB provider 9.0 for Analysis Services. OWC executes on the client and uses OLEDB to talk to the SSAS server.

Unfortunately the only options I can think of if you cannot get the OLEDB provider installed is to either upgrade the client or to look at using something other than OWC. Some of the commercial "thin client" solutions would probably work. Mosha has a list on his site at www.mosha.com/msolap .

Overwriting text control

Hello,
Is it possible to overwrite a text control in reporting services, so
that I can add two additional properties to it? If possible, do you
have any links/point to resources?
Thanks
/Peterdo you talk about a parameter related textbox?
yes you can... if you develop your own report access interface or if you use
the reportviewer control.
directly in reportserver, you can't
from where you want to add properties in the textbox?
do you want to open a report with some parameters predefined and send in the
URL?
"Peter" <ptrlsn@.gmail.com> wrote in message
news:1178650584.307210.221870@.p77g2000hsh.googlegroups.com...
> Hello,
> Is it possible to overwrite a text control in reporting services, so
> that I can add two additional properties to it? If possible, do you
> have any links/point to resources?
>
> Thanks
> /Peter
>|||On 9 Maj, 04:44, "Jeje" <willg...@.hotmail.com> wrote:
> do you talk about a parameter related textbox?
> yes you can... if you develop your own report access interface or if you use
> the reportviewer control.
> directly in reportserver, you can't
> from where you want to add properties in the textbox?
> do you want to open a report with some parameters predefined and send in the
> URL?
Thanks for the reply
The text in the text box should be retrieved from an external
application based on a property-value that it will pass to said
external application. It will connect to the external app through a
COM connector.
Is this possible programmatically? For example by overwriting the text
control and give it one or two extra properties?
/Peter

Overriding repeating totals from non-referenced slicer dimension

I've run across what appears to be a change in the default behavior of Analysis Services from 2000 to 2005. My question is how to get the default behavior to revert to the AS 2000 method.

If you have a cube with multiple measure groups or multiple linked cubes, queries that try to slice a measure using a dimension that is not related to the measure result in the total amount for any other slicers being repeated across the "invalid" slicer.

For example, the following query slices the reseller amount by calendar year and employee department. The results are as expected. Only the Sales department has any totals for the measure and all other departments return null.

SELECT { [Employee].[Employee Department].[All Employees].CHILDREN } ON COLUMNS ,{ DESCENDANTS( [Date].[Calendar].[All Periods], [Date].[Calendar].[Calendar Year] ) } ON ROWS FROM [Adventure Works] WHERE ( [Measures].[Reseller Sales Amount] );

The next query is identical, except it using the Internet Sales Amount measure, which comes from a measure group that does not have a link to the Employee dimension. The result is the total amount for internet sales is displayed across all employee departments. In AS 2000, the results would have been null or empty.

SELECT { [Employee].[Employee Department].[All Employees].CHILDREN } ON COLUMNS ,{ DESCENDANTS( [Date].[Calendar].[All Periods], [Date].[Calendar].[Calendar Year] ) } ON ROWS FROM [Adventure Works] WHERE ( [Measures].[Internet Sales Amount] );

At one level I can agree with the change, but non-the-less, it is a change in the default behavior, and users hate it. Is ther any way to revert this behavior back to the AS 2000 approach?

Thanks!

What you are running into is the fact that AS2K5 now applies ValidMeasure() automatically. You can revert back to AS2K behavior by setting the "IgnoreUnrelatedDimensions" property associated with your measure group to "False".

HTH,

- Steve

|||

Steve,

Many thanks! I knew it would be something simple, but was getting tired of looking...

Overlay lines on x axis

I need to overlay the bar lines on a chart in reporting services. I
have actual and budget numbers that need to be displayed, but they
need to be overlayed, not side by side as the column chart does by
default. Any ideas on how to do this?
Thanks,
JoshDid you look at this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c229b25c-b2dc-41ac-923d-decbb253dc6e&sloc=en-us
It is possible to combine column and line charts. However, this is not
possible for bar and line charts.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Josh Harris" <joshua_c_harris@.hotmail.com> wrote in message
news:eda768cf.0411241126.4e25fb10@.posting.google.com...
> I need to overlay the bar lines on a chart in reporting services. I
> have actual and budget numbers that need to be displayed, but they
> need to be overlayed, not side by side as the column chart does by
> default. Any ideas on how to do this?
> Thanks,
> Josh