Page break and grouping question

Hi,
I have to make a report that shows 2 tables one above the other.
The both tables have grouping values, and I want in each page to
display the both tables so I'm making a page break in each group/
table.
The problem is that the both tables goes to separate pages...what I
want is a full page break after the second table is filled up
It looks simple, but I don't know how!
Something like this
---
table 1
record 1, record 2
table 2
record 1, record 2
---
->Break in the end
->Next page
---
table 1
record 1, record 2
table 2
record 1, record 2
---
Thanks for your help,Sorry, I forgot to say that the two tables have different datasets.
Thanks for your help.

Padding identity column values with zeros

Hi Guys

Is there an easy way to pad identity column values with zeros to the left (0001, 0010,0100, etc) or I will just have to format them before displaying

George

This works for me a lot of times.

REPLICATE('0', 4-len(cast(id as char(4))) + cast(id as char(4))

|||

You could use an expression like:

right(replicate('0', 8) + cast($identity as varchar), 8)

-- or

right(replicate('0', 8) + cast(identitycol as varchar), 8)

You could either use a computed column or a view with the expression. Alternatively, you could simply do these type of operations on the client side.

Package variables "disappear" from job properties

Creating a SQL Agent job to run a package works just fine. On the Step Properties, Set values tab, I can add variables and the values I want for them, no problem. The job runs just fine. If I want to go edit the values however, they're always gone.

Is there some security setting that hides the variables and their values which is on by default?

GregsListAcct wrote:

Creating a SQL Agent job to run a package works just fine. On the Step Properties, Set values tab, I can add variables and the values I want for them, no problem. The job runs just fine. If I want to go edit the values however, they're always gone.

Is there some security setting that hides the variables and their values which is on by default?

Greg,

I don't know the answer to this but regardless, you should stop using the SSIS sub-system and just call teh package usinng the command-line sub-system instead.

There is an article at wiki.sqlis.com that explains the rationale behind this but the site is down so i can't link to it. Basically you don't get any diagnostic info out of the SSIS sub-system.

-Jamie

Package configuration - registry entry problems

I want to access a registry entry in a package configuration but am having problems. I am looking for some example values for the "Registry Entry" field in the Package Configuration Wizard.

The test is a simple one, fill a variable with a registry value and present it in message box. I have tried a number of different values but can't seem to get the right one. Here are somethat I tried:

Software\\MyCompany\\ImportExport\\ServerName\\Value
Software\\MyCompany\\ImportExport\\ServerName

HKEY_CURRENT_USER\\Software\\MyCompany\\ImportExport\\ServerName
HKEY_CURRENT_USER\\Software\\MyCompany\\ImportExport\\ServerName\\Value

Software\MyCompany\ImportExport\ServerName\Value
Software\MyCompany\ImportExport\ServerName

HKEY_LOCAL_MACHINE\Software\MyCompany\ImportExport\ServerName
HKEY_LOCAL_MACHINE\Software\MyCompany\ImportExport\ServerName\Value

HKEY_CURRENT_USER\Software\MyCompany\ImportExport\ServerName\Value
HKEY_CURRENT_USER\Software\MyCompany\ImportExport\ServerName

HKEY_CURRENT_USER\Software\MyCompany\ImportExport
Software\MyCompany\ImportExport

HKEY_CURRENT_USER\\Software\\MyCompany\\ImportExport
Software\\MyCompany\\ImportExport

jcl,

I just realized you have double posted this question. I have already replied in the other thread. Here is what I replied:

--

cj See if you can find the answer here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=187656&SiteID=1

|||

Sorry. I still cannot read the registry entry.

In the registry:

HKEY_CURRENT_USER\Software\MyCompany\MyPackageConfiguration

then I have a string value called:

MyParameter1

and the value data is set to:

MyTestValue

I want to see MyTestValue. What do I put in the Package Configuration Wizard text box? These did not work:

HKEY_CURRENT_USER\Software\MyCompany\MyPackageConfiguration\MyParameter1\Value

HKCU\Software\MyCompany\MyPackageConfiguration\MyParameter1\Value

\Software\MyCompany\MyPackageConfiguration\MyParameter1\Value

Software\MyCompany\MyPackageConfiguration\MyParameter1\Value

Software\MyCompany\MyPackageConfiguration\MyParameter1

\Software\MyCompany\MyPackageConfiguration\MyParameter1

HKCU\Software\MyCompany\MyPackageConfiguration\MyParameter1

HKEY_CURRENT_USER\Software\MyCompany\MyPackageConfiguration\MyParameter1

overlapped point labels

Hi, i've a stacked column chart and the values are show overlapped.
I've tried auto and all positions, but its always overlapped, someone know
how to avoid this ?
Thanks in advanceAnyone install SP2 yet? Any problems or issues?
Thanks,
Fredrick