Search results for query: *

Hi there... I have a simple Tabbed Menu on my webpage. Each of the tabs when clicked, takes me to a div container with a form inside it. Each of the div tags has a Previous and Next to navigate between tabs. On the first tab, I enter values for firstname and lastname and then hit Next which...

Thanks LB...that sounds like a plan...I am playing around with it and notice the section does not get suppressed. Like you said, I rt click on the Details a and Format and choose Suppress(No Drill Down), then I rt click Subreport in tht section and format subreport and below Object format, i...

Thanks LB...read a lot of your posts abt tht issue here...hmm....so then whats the solution? I finally got the report working with your help, by using subreport linking and shared vars and what not. Just this one is the last issue i gotto deal with, then i can say IAM DONE:) I need to get a...

Hello there... I am using Crystal 8.5 with sql DB. on my main report, i have a SubReport1 in Details a and SubReport2 in Details b. On SubReport2, I create a Shared variable like this: whileprintingrecords; if isnull(Count ({@DateDiff})) then shared numbervar SharedItems2 := shared...

Oops...sorry, its in Subreport1, in Report Footer a

The Total is in the Subreport 2 in the Report Footer a...

Thanks Lbass...My report is laid out like this: In the Main Report, in the Details b section, SubReport1 is placed and in Details c section, SubReport2 is placed. In the Main Report, I created a BSUM Formula Field with whileprintingrecords; shared numbervar BSUM := 0; In SubReport1, I...

Thanks LBass....I did use a Subreport and got it working. So now my main report looks something like this: Process1 100 Process2 200 Process3 300 Total 600 ----------------------------- Process4 500. The Process1 to Total section is in one subreport and...

Well...turns out tht you can have only 1 main query that can pull all the data from the DB and then with formulas etc you can play around with it. Also the sql expression fields can pull only static data tht is without the where clause. So we ended yo creating a column in our table and getting...

Here's my stored proc: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE usp_spname -- Add the parameters for the stored procedure here @StartDate datetime, @EndDate datetime, @Description varchar(512), @counter int output AS BEGIN -- SET NOCOUNT ON added to prevent...

Well now I wrote a view but again view cannot accept parameters. So next option I wrote a stored procedure and from crystal, I could call the stored proc and pass values and it will return the count. Question is how do I call th stored procedure from Crystal...u prob can help me with tht:(...

Well my coworker suggested I create a view and put the joins and everything in that and let this column just pull from there and the group header name is already grouping it by mnemonic so it shud work....Now how do i create a view and make this report get data from there :(

Well the result of this query from sql gives me abt 200 records. Although I just want a count (distinct batch_id) from it which is 13 in this case: Select * from audit_batch inner join LU_Application on audit_batch.cur_workstate=LU_Application.workstate where audit_batch.useraction_id = 26 and...

Thanks for your reply. Like you said, I created a forumula field called Test and placed the condition you wrote in it. Then I saved it and placed it in the details section. The moment I do that, my report doesnt show anything. Inspite of that, I went ahead and inserted a Summary Field with a SUM...

Thanks LBass for your reply...Is there any other way to do this, maybe like a formula field? Initially my report was pulling data from 2 tables, doing simple count and calculatioms etc with it. Now I added 2 more tables and wanna somehow join the 2 like above to get a count. Is the select expert...

Hi there....newbie here trying to use Crystal Reports 8.5.... I am trying to create a new sql expression field called BatchCount in the subreport. The sql i wrote for it is: (select count(distinct batch_id) from audit_batch inner join LU_Application on...