Bug: default value showing as query based when it is not (report m

I have a report which uses a query to populate a parameter.
The default value is not queried, this is just set to "=1".
When the report is deployed, the parameter in report manager is showing as
'query based' which is wrong.
This is a pain in the ass as when I try linking to this report, I am not
able to set the value to something else.If you use a query to specify a range of parameters then it seems to show
default as 'query based' in the report manager.
What I have discovered is that if you change something to do with the
parameters on the report and redeploy, you can pick up the changes in the
linked report by repointing the linked report at the same report, this forces
some kind of refresh to occur and although very annoying, is easier than
recreating the linked report.
<despair>Thanks to MS for providing a UI of such high quality.</despair>
"adolf garlic" wrote:
> I have a report which uses a query to populate a parameter.
> The default value is not queried, this is just set to "=1".
> When the report is deployed, the parameter in report manager is showing as
> 'query based' which is wrong.
> This is a pain in the ass as when I try linking to this report, I am not
> able to set the value to something else.

BUG in Integration Services

Problem

When you have a SSIS package that contains a connection from a data source, this connection is not updated when the data source changes based on a configuration change.

Situation :

A SSIS solution contains 3 configurations : Development, Test, Production. You can create those configurations in configuration manager of the solution.

The SSIS project contains one Data source. It doesn't really matter what type but I take SQL Server. The database server in development is SQL_DEV, in test is SQL_TEST and in production is SQL_PROD. Initially they are for all configurations the same. You can specify those values by changing the active configuration and then editing the Data source.

In the SSIS package (DTSX), you can create a connection manager based on a Data source.

If you change the Data source, the connection manager is also changed. If you change the Data source by changing the active configuration, the connection manager is not being updated.

If you think this isn't a big issue think big. We have 4 configuration, 10 shared Data sources and 25 DTSX packages. That would give a maximum of 1000 settings (4 x 10 x 25). Using this method it can be reduced to 40 (4 x 10). Of course this is a theoretical but it is very common to have the destination data source re-used on all packages, which still would be 100 settings (4 x 25)

Steps to reproduce

- create a new SSIS project

- In the solution explorer, create a new Data source named TestSource.

- In the connection managers window of Package.dtsx, create a new connection from a Data source.

- Make some changes in to TestSource.ds under the Data Sources. For example change the server or the database.

- Verify that those changes are also in the package.

- in the solution explorer, right click the solution and select configuration manager

- under active solution configuration, create a new configuration named test.

- Set the copy settings from : development

- Verify that Create new project configuration is checked.

- click OK and close.

- Notice that the active configuration is now Test

- Make some changes the Testsource.ds like a different server.

- Verify that those changes are also in the package.

- Make the development configuration as active.

- Notice that the Testsource.ds contains now the original settings.

- You will notice that the connection manager still contains the "test" settings and not the development settings.

- If you create a deployment utility it will still contains the wrong values.

with regards,

Constantijn Enders

Don't use Data Sources. Just use the connection managers and use package configurations to configure them.

Browser Based Report Builder

Hi,
I am looking at building a simple browser based report builder. I would like
to provide options to move fields and add text\captions to exsisting reports
using a browser(IE)
To startwith I am looking at displaying the fields(those are present in
report) in a grid(where the user could change the order of them) and have a
report preview pane(where the user could preview the report.
Could someone please let me know how I could have a preview pane in web page
and how I could make changes to the report as soon as a user changes the
fields order in grid.
Any help\suggestions on this would be greatly appreciated.
Thanks
PonnuIf you have SS2005 then dont reinvent the wheel, it is already there as
Report Model / Report Builder which i browser based.
Amarnath
"Ponnu" wrote:
> Hi,
> I am looking at building a simple browser based report builder. I would like
> to provide options to move fields and add text\captions to exsisting reports
> using a browser(IE)
> To startwith I am looking at displaying the fields(those are present in
> report) in a grid(where the user could change the order of them) and have a
> report preview pane(where the user could preview the report.
> Could someone please let me know how I could have a preview pane in web page
> and how I could make changes to the report as soon as a user changes the
> fields order in grid.
> Any help\suggestions on this would be greatly appreciated.
> Thanks
> Ponnu
>
>|||Hi Amarnath,
I am planning to do in SSRS 2005.
I could use ReportViewer for previewing reports but I need to change the
order of columns in the reoprt once the user changes the order in the grid.
Any ideas how I could programatically change the report from vb.net to
change the order of columns?
Thanks
Ponnu
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:8A4339DA-1E37-4959-8B3C-7DED2DDE4272@.microsoft.com...
> If you have SS2005 then dont reinvent the wheel, it is already there as
> Report Model / Report Builder which i browser based.
> Amarnath
> "Ponnu" wrote:
>> Hi,
>> I am looking at building a simple browser based report builder. I would
>> like
>> to provide options to move fields and add text\captions to exsisting
>> reports
>> using a browser(IE)
>> To startwith I am looking at displaying the fields(those are present in
>> report) in a grid(where the user could change the order of them) and have
>> a
>> report preview pane(where the user could preview the report.
>> Could someone please let me know how I could have a preview pane in web
>> page
>> and how I could make changes to the report as soon as a user changes the
>> fields order in grid.
>> Any help\suggestions on this would be greatly appreciated.
>> Thanks
>> Ponnu
>>

Browser as Front-End

Hi!

I'm trying to build an app. for my parents' office. They have a small
office (5 PCs), and they currently work with a very old program that's
based on DOS. The program doesn't work well under XP, so they still use
Win 98. They had their network upgraded about a year ago. They had
Microsoft SBS 2000 installed, it includes SQL Server. I've written a
few DB's in Access before, and now I'm just learning how to use SQL.
Before I start work on their app., I have a question:

I know it's possible to create an interface that can be put on their
network and accessed via a browser. How is this done exactly?

It would be very beneficial for me, because it would mean that the new
app. would be platform independent, so that they can upgrade to XP
easily. It would also save us the cost of licensing front-end software
(e.g. Access) for each machine.

Any comments would be appreciated.

Noam Nelke, Israel.When you meant place the SQL Server on a network, you meant placing it
on a central server?

If that is the case, you can have one dedicated server for the SQL
Server and an application server where you can develop your web
application to create an Interface for this DB.
How to create the Interface?
- You can have a Web Server installed on the application server (IIS or
java based web servers) and then write your web code in any of the tons
of languages.

Hope that helps.|||Noam Nelke (NoamNelke@.gmail.com) writes:
> I'm trying to build an app. for my parents' office. They have a small
> office (5 PCs), and they currently work with a very old program that's
> based on DOS. The program doesn't work well under XP, so they still use
> Win 98. They had their network upgraded about a year ago. They had
> Microsoft SBS 2000 installed, it includes SQL Server. I've written a
> few DB's in Access before, and now I'm just learning how to use SQL.
> Before I start work on their app., I have a question:
> I know it's possible to create an interface that can be put on their
> network and accessed via a browser. How is this done exactly?

That's a question that does not have much to do with SQL Server. Most
people seem to use ASP or ASP .Net. There is also Cold Fusion out there,
and probably a few more possibilities.

> It would be very beneficial for me, because it would mean that the new
> app. would be platform independent, so that they can upgrade to XP
> easily. It would also save us the cost of licensing front-end software
> (e.g. Access) for each machine.

On the other hand, browser-based interfaces are often painful to use.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Break on Running Total

I am trying to create Packing List(s) based on an individual sales order.

Each Packing List page must be based upon the number of square feet.

I have set up a detail line with
Pieces, Width, Length and a running total of square feet (Pieces*width*length)

When the Running Total Square Feet > 400 then I need to go to a new page and reset the Running Total Square Feet and continue to print the remaining detail, until it again reaches 400 square feet.

I'm close, but I am having trouble. Can anyone help?

Note: Its MAS 90, if that makes a difference.What did you try and what problem are you facing?

Brand New to SQL and Programing

Hi Everyone

I am learning SQL using the "Trial by Fire" method.

The program is based on Pascal and SQL. The database responds to SQL statements. This is a propriety program. The operating system is NT 4.0.

<Problem>
I need to count the number of each type of EnrolStatus for this class.

<Tables Set-Up>
Table Name: Registration
Field Names: EnrolStatus
Field Names: Class_OID

The EnrolStatus is broken down into 4 groups
0=enrolled
1=finished
2=cancelled
3=No Show

The class OID is 1300

<Tried but didn't work>

SELECT * FROM REGISTRATION WHERE REGISTRATION.CLASS_OID = 1300 AND
Recordcount(*) REGISTRATION.EnrolSTATUS = 1

I am hoping someone can help me.

Forgive me if I didn't state everything with the right termsHi mlscw,

To count the number of each type of EnrolStatus of the class. You will need to use the GROUP BY clause and then take the COUNT.

select enrolstatus, count(*)
from registration
where class_oid = 1300
group by enrolstatus

HTH