Showing posts with label controls. Show all posts
Showing posts with label controls. Show all posts

Wednesday, March 28, 2012

How to assign different identity ranges to publisher and subscribers?

Hello,
There is a @.identity_range parameter, which controls the identity
range size initially allocated both to the publisher and to
subscribers in sql server 2005 merge replication. I need to assign
different identity ranges for publisher and subscribers. Is it
possible to achieve it? The @.pub_identity_range parameter does not
seem to work.
Thanks you,
Jawad
You can do it manually using checkident or using the create publication
wizard (see the article properties dialog, its in the identity range
management section).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JDee" <jawwad.ali@.gmail.com> wrote in message
news:1174476685.219315.29270@.n59g2000hsh.googlegro ups.com...
> Hello,
> There is a @.identity_range parameter, which controls the identity
> range size initially allocated both to the publisher and to
> subscribers in sql server 2005 merge replication. I need to assign
> different identity ranges for publisher and subscribers. Is it
> possible to achieve it? The @.pub_identity_range parameter does not
> seem to work.
> Thanks you,
> Jawad
>

Friday, March 9, 2012

How to Add Crystal Reports 9 into VB 6 Project

Hi! All!

I can't add Crystal Report 9 into VB 6 Project.

I already Create Crystal Report 9 and I try to add Crystal Reports controls into VB 6 application Project -- > components & reference also.

What are all the controls(dll or ocx) to be added in VB application components & reference for import Crystal Reports 9 into VB 6 Application.

Can any one tell me how to add Crystal Reports 9 into VB 6.

Thanks

- RajaExtracted from --> http://www.mahipalreddy.com/cr/crcodes1.htm
'Code by Mahipal Padigela
'Add a Command button to your Form(Form1)
'Add a Form(Form2) to the project and add a 'Crystal Report Viewer Control 9' from Project-->Components to it.
'Reference 'Crystal Reports 9 ActiveX Designer Run Time Library' from Project-->References
'Replace "C:\myCRReport.rpt" with your CR Report file path
'Replace the value of strSelectionfrm variable with your selection formula
'Paste the following in to the code window of your form

Private Sub Command1_Click()
Dim crApp As CRAXDRT.Application
Dim Report As CRAXDRT.Report
Dim strSelectionfrm As String
Set crApp = New CRAXDRT.Application
Set Report = crApp.OpenReport("C:\myCRReport.rpt")

'You don't need the next line of code if you are using a MS Access databse, but if you are using
'any other databse then Crystal reports expects you to pass Logon credentials before opening the report. So replace the
'DSN name, Databse name, user name, password with yours. Though the next line of code is passing Logon info to
'only the first table in the Tables array of the report, in theory, it should work fine as crystal passes the same info to any other
'tables in the report.For more info on passing Logon credentials to each and every table in the main report as well as all subreports,
'please refer to my article programmatically exporting Crystal Reports to PDF and other formats

Report.Database.Tables(1).SetLogOnInfo "DSN name", "Databse name", "user name", "password"

'Replace the value of strSelectionfrm variable with your selection formula
strSelectionfrm = "{Expected_Sales.Dept}='Analyst Group' and {Expected_Sales.Qtr}='Qtr1'"
Report.RecordSelectionFormula = strSelectionfrm
Report.DiscardSavedData
Form2.CRViewer91.ReportSource = Report
Form2.CRViewer91.ViewReport
Form2.Show
End Sub|||Tq for reply.

I already add Crystal Reports controls in Project components & also Reference.

But still I can't add Crystal Report into my VB 6 Project.

I attach with screen shots for adding components & references for Crystal Reports 9 controls.

http://www.dev-archive.com/forum/attachment.php?attachmentid=&stc=1

After add these controls we can directly add crystal report from Project Menu (like Add Crystal Report).

Is it true or not?

If it is true there is no more option to add Crystal Report in Project Menu.

I can't use Crystal Reports coding like

Dim crApp As CRAXDRT.Application
Dim Report As CRAXDRT.Report
Dim strSelectionfrm As String
Set crApp = New CRAXDRT.Application
Set Report = crApp.OpenReport("C:\myCRReport.rpt")

in my Project.

Can you please tell me what's wrong in my project.

Is Crystal Reports 9 Problems or VB 6 Problems?

Thanks.

- Raja|||either you i havent understood exactly what you are trying to ask,
but if no,
then you can just add .rpt file of the Crystal Reports,like this..
right click Project in solution Explorer, Add->File-> and just choose your .rpt file. VB6 will attatch the .rpt file as .dsr file.and you can directly use its relative path,by creating instance of that .dsr file.thats it.|||Tq for reply.

I already add .rpt file into my VB project. But it is saved as in module(Not in .dsr file).

Is any other crystal controls needed to add in VB Project?

I can try to Reinstall Crystl Reports 9 & add controls into VB Project again.

Still I can't find out any other controls related to Crystal Report Designer or Viewer in my VB tool box controls.

What I need to change for add Crystal Reports 9 into my VB project?

Can anyone send more details about these problem.

Thanks.

- Raja

Wednesday, March 7, 2012

How to Add an event to CRI controls

Hi all,

I am trying to develop a CustomReportItem similar to Matrix control. Is it possible to add some "OnClick" sort of events to a section of this CRI (As a drilldown button of matrix control allows to expand the respective column).

Please help me if there can be any solution.

I think it not possible to do that.

Report is web page , is not the application window.

sort the date, you can add a sort report parameters,

different parameters, show different matrix.

|||

Are you asking about design time or runtime?

While the CRI runtime control can generate drillthrough actions based on an image map, currently you cannot fully simulate the matrix group toggle behavior. You would rather need to work around it with report drillthrough actions and encoding the toggle state in parameter values.

-- Robert

|||

Hi Robert,

Thanks for ur response

I am asking it for runtime. How can I encode the toggle state in parameter values and how will it help to solve my problem? Please explain, as I am new to this tool.

|||

For every toggle icon, you could use a boolean report parameter to encode its state (e.g. expanded = true, collapsed = false). Another option is to encode the state of multiple toggles into an integer parameter (by using it as a bitfield) or maybe as string parameter.

For the CRI runtime control you would need to pass the parameter values as custom property values so that you can see the current toggle state (i.e. report parameter values) from within your CRI runtime code. Then you would need to draw the toggle icons as part of the image generated by the CRI runtime control. In addition you need to generate an image map over the toggle icon with a drillthrough action that drills to the same report with a report parameter value that has the opposite value of the currently drawn toggle state.

For example, if there is only one toggle and the toggle icon drawn is shown as expanded (with a report parameter representation as =True), you would add an image map area with a drillthrough action that passes the report parameter with the boolean value =False.

-- Robert