Cubes and .Net applications

What are the pros and cons of accessing the data in a cube through a visual studio 2005 .net application?Are you referring to a .NET 2.0 application (since Visual Studio 2005 is a development environment) - if so, that's rather an abstract question? Could you provide more specifics of the application usage scenarios you have in mind?|||Yes, I am referring to a .NET 2.0 application. Normally, our .NET application uses a webservice to runs sqls to retrieve data for reports in the application. I would like to know what is involved in retrieving data from the cube using a webservice. Is it more involved? Are there any benefits or risks to using a cube to retrieve data for a report in a .NET application versus just using DB2 databases? We currently retrieve our data from DB2 databases.

cube process through .net coding in vb language

hai everyone,

we make a lot of cube in the anlaytics server ,we want process the cube in the .net coding using vb language,if any body have a code for that then plz reply me.

Hi there,

I think what you're looking for is AMO. You can have a read here

C

Cube meta data on a web page

How do I access AS database meta data (cubes + properties) from an
asp.net page?
Hans
There are several approaches you could use.
If you are looking for documentation, then nightly you could run the OLAP
Scribe utility (which generates a .doc file) -- and the link to the .doc
file from your asp.net application. That will give you pretty extensive
documentation.
http://www.microsoft.com/downloads/d...DisplayLang=en
If all you want is populate a list, then your asp.net application can use
OLAP Schema Rowsets, see Books On line for information on the topic.
As a third approach, if you know the database you want to connect to, then
you could use the Catalog object which is exposed via ADOMD.NET (see the
ADOMD.NET documentation on how to do that).
http://www.microsoft.com/downloads/d...DisplayLang=en
Hope that helps.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"hansiman" <han@.sen.se> wrote in message
news:eq7au0hopksiglbe7s893v1uu3a3n1f5ui@.4ax.com...
> How do I access AS database meta data (cubes + properties) from an
> asp.net page?
> Hans

Cube meta data on a web page

How do I access AS database meta data (cubes + properties) from an
asp.net page?
HansThere are several approaches you could use.
If you are looking for documentation, then nightly you could run the OLAP
Scribe utility (which generates a .doc file) -- and the link to the .doc
file from your asp.net application. That will give you pretty extensive
documentation.
http://www.microsoft.com/downloads/...&DisplayLang=en
If all you want is populate a list, then your asp.net application can use
OLAP Schema Rowsets, see Books On line for information on the topic.
As a third approach, if you know the database you want to connect to, then
you could use the Catalog object which is exposed via ADOMD.NET (see the
ADOMD.NET documentation on how to do that).
http://www.microsoft.com/downloads/...&DisplayLang=en
Hope that helps.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"hansiman" <han@.sen.se> wrote in message
news:eq7au0hopksiglbe7s893v1uu3a3n1f5ui@.
4ax.com...
> How do I access AS database meta data (cubes + properties) from an
> asp.net page?
> Hans

CS1595: 'Sanghi.Global' is defined in multiple

hi when i try to run my c#.net web application i m getting following
error
if any one know the solution pls let me know
Compiler Error Message: *CS1595: 'Sanghi.Global' is defined in multiple
places; using definition from
'c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
ASP. NETFiles\sanghiweb\3cb18c71\212986e7\ass
embly\dl2\0730bee1\0028ca9a_b915
c501\sanghiweb.DLL'
*Source Error:*
Line 26:
Line 27:
[System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()]
Line 28: public class Global_asax : Sanghi.Global {
Line 29:
Line 30: private static bool __initialized = false;I think you posted in the wrong newsgroup.
Anyways, clear the temporary internet files and try.
"Mahesh" wrote:

> hi when i try to run my c#.net web application i m getting following
> error
> if any one know the solution pls let me know
> Compiler Error Message: *CS1595: 'Sanghi.Global' is defined in multiple
> places; using definition from
> 'c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
> ASP. NETFiles\sanghiweb\3cb18c71\212986e7\ass
embly\dl2\0730bee1\0028ca9a_b9
15c501\sanghiweb.DLL'
> *Source Error:*
> Line 26:
> Line 27:
> [System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()]
> Line 28: public class Global_asax : Sanghi.Global {
> Line 29:
> Line 30: private static bool __initialized = false;
>

Crytarl Report with Dabase access

dear all ,

i use crystal report from dot net 2003 (i use dotnet version architect).
with database access.

and i have problem to set parameter for query access in crystal report.

if i use database mssqlserver 2000 in crystal report i just select store procedure and the parameter for store precedure will otomatically add in crystal report.

sampel query store procedure like this

select * from tblcustomer
where CustName = @.custName

the parameter @.CustName otomatically add in crystal report.

how to implament that if i use database access.
so i can send a value for @.Custname from my applicationAs i have worked for VB.net so i'll how i used to send parameter value externally
first u need to define
Dim pv As New CrystalDecisions.Shared.ParameterValues
Dim pdv As New CrystalDecisions.Shared.ParameterDiscreteValue

pdv.Value = EntityCode
pv.Add(pdvScriptCode1)

RptViewer.DataDefinition.ParameterFields("@.Customer").ApplyCurrentValues(pv)

thats it...
Try it out n tell me the result whther its working......

Crystl32.ocx with vb .net

Hi all,

I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx.
I installed this control into .net but I don't how can I pass the parameter which I'm writing into textbox to report that contains stored procedure as a data source.

== Some code with Crystl32.ocx that I'm using to call the report:

With cr2
.ReportFileName = Application.StartupPath + "\klient_info.rpt"
.RetrieveDataFiles()
.DiscardSavedData = True
.ParameterFields(1) = "@.KlientID;" & TextBox2.Text & ";False"
.WindowState = crptMaximized
.Action = 0

End With

With the code above I'm passing into crytal report @.klientID - what I'm writting into textbox2. But the problem is that I don't want crystal report to prompt again for inserting input parameter.

Thanks,
ProBani.With the code above I'm passing into crytal report @.klientID - what I'm writting into textbox2. But the problem is that I don't want crystal report to prompt again for inserting input parameter.

are you sure that you only have one input parameter and that it is ParameterFields(1). My guess is that Crystal either expect another paramter or that the one your inputting isn't correct. That's why you get prompted to input another param.

Crystl32 ocx vanished ???

Hi. I'm puzzled. I can't reference to CR from within VB6. I have both
VB6 and VS.Net installed on my machine, and from VB.NET I can insert
the component Crystal Reports (which sets a refernce to C:\Program
Files\Common Files\Crystal
Decisions\1.0\Managed\CrystalDecisions.CrystalReports.Engine.dll which
is version 9.1.3300.0. However, from within VB6 I can't set any
reference to this dll.

I have not really used Crystal Reports from VB6 before, so I don't know
how to do it. I know for sure that it is possible to do it, though, so
I'm trying.

The client does not want to use .Net (actually, some of the machines
this little utility program will be installed on are running Win98), so
I need to use VB6.

I searched my drive for any OCX ressembling Crystal, and I couldn't
find anything. When I tried to reference the above-mentioned dll, VB6
says "Can't add a reference to the specified file". I thought that
maybe when I installed VS6 I forgot to install Crystal as an option,
but no, Crystal is not even mentioned in the installation routine.

Please tell me, how can I start producing a report from VB6 ?

>From within VB6/References I can only see (under "C") the dlls from

C:\Program Files\Common Files\Crystal Decisions\1.0\Managed\, which I
can't use. In other words, I can't find any CR COM object....

>From VB6/Components/Insertable Objects I only see Crystal Analysis

Common Controls 1.0. In VB6/Components/Controls and
VB6/Components/Designers, nothing.
I tried to browse my drive for anything ressembling CR, to no avail.
Please help...

Thank you very much, Alex.That is because the CR that is bundled with .NET is a lite version of CR. Not to mention that is is the .NET compatible version and should give the errors when trying to reference from a VB6 project. You need the Full version of CR so it will be available in either development environment.|||Yes, thank you, Rob, but it's still confusing: VB6 did not come with a crystl32.ocx (of some version, whatever that might have been) ? I do *NOT* want to necessarily use the .NET version - the old (vb6) version would do jut fine, in this particular case..

Thanks again for you time.
Alex.|||If you are using vb6 there still may be something you can do. On the VB6 CD there is a old version of the CR ocx. I think its Crystal.ocx or Crystal32.ocx version 4.6. I dont think its that powerful but if your only needing something basic it may help.

crystalreportviewer in .NET different language?

When i show a report in a crystalreportviewer control,it appears those buttons,each with tool tips,also that "Main Report" text,can all this be modified ,to right something else?
for example in a aplication for countries that not use english,especially in europe,it should be all texts in different languages,so changing those texts.can this be modified?

Many thanks.Hi Jassie,

Did you solve that problem?

if yes, How?

I have the same problem,|||You may try this:

http://marian.ideaz.sk/crystal/

CrystalReportViewer check for guest login

Hi all

I have added crystalreportviewer using ASP .net (VB .net)

I was able to view the report when I run the web page on
my server. Everything seems fine on the server.

However, if I access the crystal report on a client machine,
it will prompt for guest login and password to the server machine.

I am using anonymous access for my IIS setting.
I can access the rest of the .net webpage without any problem.
However, when I enter the webpage with the crystalreportviewer,
it will prompt for guest password.

Even after I have keyed in the guest password, mutiple prompts appear again. The server event log show this error -
The server was unable to logon the Windows NT account 'IUSR_Machinename' due to the following error: Logon failure: unknown user name or bad password. The data is the error code.

After canceling the prompt a few times, it will show the page with
the report and its data but the sort tree and reportviewer
functions bar on top will show all weird marking. :(

For testing, I have tried adding just a crystalreportviewer object
on a empty webpage. I did not link the crystalreportviewer to
any .rpt file and the same prompt appear. Its seems that the
crystalreportviewer object need to be authenticated on the server
when accessing from the client machine.

I am using MS studio 2003 and IIS 5.1 on XP professional server.

Please help advice.

Thanks.
DerekHi all,

I have found the solution myself.

Give access rights to this folder
C:\Program Files\Microsoft Visual Studio .NET 2003\Crystal Reports

to the IUSR_<MACHINENAME> anonymous account.

This is because all the .net dll for crystal report is installed in
this folder. Hence the correct access should be provided to this
folder.

Regards,
Derek

CrystalReportViewer and ASP.Net

Hi Sir
I am Asad, software developer. I am working in ASP.Net2005 with VB.Net 2005 and using CR.Net 2005. I having some problems.
Whenever i click some button on crystalreportviewer's toolbar, the page bocomes empty. Report becomes invisible.
I got ur address from Code Project while searching abt reports problem.

Plz help Me.

Regards
Asad NaeemDid you find an answer to your problem? I believe I have the same problem - I put together a CRViewer project using VB.net (2003). When reports are displayed with crosstabs, there is nothing there. I also get an error when the report has drill down group level code (for header display)i.e, "DrillDownGroupLevel=0" the remaining text does not appear to be part of the formula. All of these reports work fine using Crystal (10) on our server, which is where they are created. The reports are saved with data, so it's not a databse issue at all. Drill down is OKed in the properties of the viewer, so that's not an issue..

Is this some sort of versioning problem? Any tips on finding the source of the problem would be appreciated.|||Hi...
Yes i found the solution. Infact the buttons of the toolbar are server side controls. I have applied the condition in the Page_Load i.e,
if Not PostBack() then .... End If.
The scenerio was:::
I have used the typed report (report bidded with typed dataset)
When i click the button the page starts rendering and and dataset and everything becoes empty and due to the condition the dataset did not fill again that is why reports becmes invisible. I found the solution which
i have used cache for this purpose. At the time of loading the page, i saved the dataset in the cache with the time duration of 10 mins. Whenever i click any toolbar button the data is retrieved from the cached every time before 10 mins paases. After 10 mins page again retrieves the data from the database otherwise it retrieves the data from the cache. In this way dataset is never empty.

Contacts
00923334471758
usan807@.hotmail.com
asad.naeem@.gmail.com
anuab_lg@.yahoo.co.uk

Regards
Asad Naeem|||Sounds like yours was a bit different than mine - one thing I have found - If I recreate the report using the Crystal designer in VB.Net (2003), than the crosstab(s) shows. If I open the original report in the (VB) designer, it looks OK (you see the crosstabs, headings etc. in the designer), but even if I do a save as, there is no data when the report is viewed, so it looks like it's at least somewhat related to the fact that the original crosstab reports were created in CR10. I don't know enough about this yet, but I wouldn't think that should be the case. Am I wrong on that?

I've seen other people have had similar problems, but most of the questions have gone unanswered. Others have indicated that things go blank when they do something that requires the screen to be redrawn - could the problem have anything to do with Windows.Drawing routines that might be treated differently from one version to another?