Failed to Open Rowset Error in Crystal Reports

hello all,

i have developed a desktop application(software) inwhich used Crystal Reports 9. I am using Microsoft Developement Environment 2003 (Visual Studio 2003).The reports in this software runs well on my own system where i developed the software but when I install this software on the computer(client computer), the report does not open when the Generate Report button is clicked. This button click event fills the data using a simple query from databse(SQL Server 2000) and this error is displayed:

Failed to open Rowset.

The .Net Framework 1.1 is installed on the client computer before the software is installed and run.

I also include some merge modules in the setup of the project that I make. These merge modules are:

Crystal_Database_Access_enu2003.msm

Crystal_regwiz2003.msn

Crystal_Database_Access2003.msm

Crystal_managed2003.msm

Please help me to resolve this problem so that on the client computer the reports are displayed and data is shown.

Thanks in advance

hello all again,

I posted this problem yesterday and got no reply yet.

please help me solve this problem. I am in great need of this reporting software but don't know what is missing or wrong which is creating problem

Thanks all of you!

|||

Hi,

I have the exact problem. If some one can reply it will be great.

Thanx.

|||This sounds like a Crystal Reports issue. This forum is for questions regarding SQL Server Reporting Services.

Failed to connect to database server

hi
I am trying to do create two SQLExpress connections (via sqlexpress instances) in two different machines through (ArcCatalog) a GIS software.
I am able to connect to Server B(per say) from Server A but I am not able to connect to Server A from B. A and B are in differnet machines.
Are there any setting in A which i am missing to enable so that A doesnt allow any connections to it. I checked the Protocols for SQLExpress and TCP/IP is enabled.
any help is appreciated!!

~N

What is the connection string? and error message when you connect A from B?

Most common issue is firewall. i.e. the TCP port is firewalled on A.

Facts with infinite measures

Hello!

I was wondering if there exists convenient ways to handel infinite measures in SSAS.

In my exmple there are facts describing software licenses. Normally, licenses grant the right for a specific amount of installations. However, as for something like a site or enterprise license, the allowed number of installations is unlimited.

Of course this can workarounded by a separate measure counting those unlimited licenses but it adds more complexity and inconveniance to analysis.

Thanks in advance for ideas,

Regards, Alex

Sorry - but I couldn't understand from your description what exactly you need, and what would "infinite measures" solve.|||

Hello Mosha,

I will do my very best to make it more clear.

Here is an example source table "Licenses" from the data warehouse:

DimOwner | DimSoftware | [Allowed Installations] | [Allowed Unlimited]

Department1 | MySoftware | 10 | false

Department2 | MySoftware | null | true

What ever might happen in the cube, as a result a user wants to analyse the available licenses in PivotTables that look like the following.

Analyzing on company level:

DimSoftware | Allowed Installations

MySoftware | <infinite> (some symbol)

With added DimOwner dimension:

DimOwner | DimSoftware | [Allowed Installations]

Department1 | MySoftware | 10

Department2 | MySoftware | <infinite> (some symbol)

Possible solution I currently can imagin:

DimOwner | DimSoftware | [Allowed Installations] | [Unlimited license]

Department1 | MySoftware | 10 | 0

Department2 | MySoftware | empty | 1

But doing so would double quite a lot of measures I currently have and therefore add complexity to analysis that I would like to hide from users.

Best regards, Alex

|||

OK, I see. I think the best solution is to have that additional measure indicator of unlimited licences. You can define it as boolean or integer and choose aggregation function MAX. Since this measure will ever get only one of two values, the AS will automatically compress it down to 1 bit per record. So overhead on partition size should be minimal. You then will hide both Allowed Installations and Unlimited license measures from the user, and create the following calculated measure:

CREATE Installations = IIF ( Measures.[Unlimited license], -1, Measures.[Allowed Installations] );

Format_String(Measures.Installations) = ';I\nf\i\nite;;'

Basically, I mark infinite number of installations with -1, and then use formatting to display it as "Infinite" to the end user.

HTH,

Mosha.

|||

Thanks a lot! Nice trick with the MAX and Format_string :)

Best regards,

Alex

|||

Tiny addition: Excel 2k7 prefers the following notation of Format_String for some reason:

Format_String(Measures.Installations) = ';"Infinite";;'

Extraction software

Hi,
I need an extraction software that needs to be capable of capturing a table
(or tables) displayed on the web and converting it to a file as a list of
records with
comma separated values. The records will be converted to insert commands
after the cleansing process. The software will be used for the data
warehousing and mining project I have at UNF.
Thank you,
Mihaela
Google on "screen scraper" and you should get lots of information on these
kinds of products/techniques.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Mihaela O" <MihaelaO@.discussions.microsoft.com> wrote in message
news:65926D4C-DF67-4129-877B-544D138A62FB@.microsoft.com...
> Hi,
> I need an extraction software that needs to be capable of capturing a
table
> (or tables) displayed on the web and converting it to a file as a list of
> records with
> comma separated values. The records will be converted to insert commands
> after the cleansing process. The software will be used for the data
> warehousing and mining project I have at UNF.
> Thank you,
> Mihaela
>

Extraction software

Hi,
I need an extraction software that needs to be capable of capturing a table
(or tables) displayed on the web and converting it to a file as a list of
records with
comma separated values. The records will be converted to insert commands
after the cleansing process. The software will be used for the data
warehousing and mining project I have at UNF.
Thank you,
MihaelaGoogle on "screen scraper" and you should get lots of information on these
kinds of products/techniques.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Mihaela O" <MihaelaO@.discussions.microsoft.com> wrote in message
news:65926D4C-DF67-4129-877B-544D138A62FB@.microsoft.com...
> Hi,
> I need an extraction software that needs to be capable of capturing a
table
> (or tables) displayed on the web and converting it to a file as a list of
> records with
> comma separated values. The records will be converted to insert commands
> after the cleansing process. The software will be used for the data
> warehousing and mining project I have at UNF.
> Thank you,
> Mihaela
>