Crystal Report Issues

hi,
I want to align the Subreport to the left. By default It is displaying the data in the right side of the main report. Is it feasible to align this to the left?.
Thanks
Vadivelan.plz. reply soon|||Assuming you have the subreport box on the left of the main report, wouldn't this depend on the alignment of the data within the subreport itself?

Crystal Report Doubt(Subreport)

Hi,
I have inserted a Sub-Report into a Main Report. My Sub-Report is placed in the middle of the main report i.e there are Text objects in the main report placed in such a way that some of the Text objects of the main report are on top of the Sub-Report and some others are at the bottom of the Sub-Report. When I populate the sub-report and the main report with data...

I have 2 scenarios :

Scenario 1 :
If my Sub-Report has very less data(say only one Row) then, I want the Text objects of the main report to move up, without leaving any gap/space that I allocated for my Sub-Report.


Scenario 2 :
If my Sub-Report has more data(say 20 Rows) then, I want the Text objects of the main report to scroll/move down .

I have tried using the "Can Grow" option in the Format section of the subreport, but it is not working properly, ie if there are more rows then the rows of the subreport are overlaping with the rows/Text Objects that I placed in the Main Report and the rows of the sub-report are moving to the right.

Awaiting for ur reply.Hi,
You have to set can grow for the sub report. Put your text in a new section below subreport. For example if your sub report is in details section then you can create one more details section and put your required text in this new section. and use fit to section.

bye

Crystal report - using sub report

i am using a sub report in my main report. I am able to count/ total a field using the Running total within that subreport which match the criteria of selection. i am passing a parameter from my main report say Issue number to subreport.

For each issue no passed i am totalling and writing in the report - one row per issue no ( with different columns like January, Feb, March,...)

Problem: At the end of the report i want the Verticle total of each coulmn say total in January, Feb, March,...I am not able to do this.

Is there a way to do this?

In the sub report i use Formula field in running total as i need to pick up only those records in the database which match the selection criteria provided. I tried other options like Sum of a field,..but no success.

let me know if any one of you have answer. THANKSdo you use grouping in the report(Jan, Feb, Mar...)?|||NO.

I have formula fields to calculate the First and the last day of each of the months using the current date. Using these i check the date in the record to count that record whether that should fall in Jan or Feb or march in the sub report.

Data comes from 2 seperate db tables. Issueno table(main report) and Tickets table (sub report)
Only Selected Issue no is passed as parameter to the sub report to do the above calculation (count no of tickets with date in Jan or Feb or Mar..).
Sub Report footer has these running total fields with the formula to count the tickets.

Report looks like this:

Issue# Rec in Jan Recs..Feb RecMarch Recs..April Total
5 0 1 2 0 3
12 2 0 7 2 11
14 0 2 0 4 6
17 11 4 0 0 15
24 0 7 1 0 8
======================================
GTotal ?? ?? ?? ?? ??
========================================
Or is there a way to count the figures in each column at the end of the Report?

(Data: First Row:- Issue no=5, Jan=0, Feb=1, March=2, Apr=0, Total=3)|||Your bottom line is to count the tickets on january, february..., i im right?

If that is you case, try this... add running total field(january) and the type of summary is count. Then in "evaluate", click the formula option and type this

month({ticket.date})=1

This means fo the month of january...

Add the another running total field for the month of february and so for...

Sorry, im slow in english so i cant understand yor question clearly.|||Your English: Not a problem at all. Thanks for the Feedback.

My problem in Short:
I am trying to Grand Total a DERIVED Field/Column like Jan, Feb, Mar...SO there is no Month field as such to Grand Total. All this calculation is done ina Sub report using the Formula field to determine in which coulmn (jan/feb/..) the record falls and accordingly counted in that month. For every issue no passed from main report as a parameter to subreport all the attached tickets to that Issue no are validated and if the selection criteria matched then counted.
Only vertical total of a devived field like Jan/feb/.. is a problem

Crystal Report - subreport - old data (PLEASE HELP !)

**Note - I'm developing with version 6.0 of Crystal Reports

I am adding a simple subreport to an existing report.
The existing report runs perfect with no problems.
It was when I added the subreport that the problem began.

The MAIN report retrieves from a stored procedure.
The subreport is linked from a field on the MAIN report to a table on the dB.

The first time I run the report, the report runs fine and displays data for the 1st parameters chosen from the screen. (pauses for a second - appears to be hitting the dB)

The second time I run the report, the report runs fine and displays data for the 2nd parameters chosen from the screen. (pauses for a second - appears to be hitting the dB)

The third time I run the report, the report runs, BUT displays the parameters chosen from the second run(old data). (doesn't pause at all, the report appears quickly - is not hitting the dB to run the stored procedure to refresh the data with new parameters chosen from the screen.)

I've tried setting cache to zero in the code and I've tried adding a field to the report which shows the surrent server time. Nothing has worked.

Is this a cache problem ? - i'm thinking maybe so, since the report runs correctly TWICE then suddenly not.
ANY suggestions about how to fix this ?? What other possible things can I try that might clear the cache ?

thanks !!!!
~JackiOpen the Report; Goto File and uncheck the option "Save Data with Reports"

Crystal Equivalent in SQL 2K5?

I have an existing Crystal report that contains a subreport which lists
items across the page rather than down. The subreport has a Header and
Detail section, which are both supressed, and a footer section that is
visible. In the Header section, a field is defined with the following
expression:
WhilePrintingRecords;
global stringvar strItems;
strItems :=""
The Detail section has a field defined with the following expression:
WhilePrintingRecords;
global stringvar strItems;
strItems := strItems + ToText({uspGetItems;1.ItemID}, 0, "") + ", "
The Footer section has a field defined with the following expression:
WhilePrintingRecords;
global stringvar strItems;
If Len(strItems) > 1 Then
strItems := Left(strItems, Len(strItems) - 2)
Is there a way to do this in a SQL report?
Any feedback would be appreciated.
Thanks.You could do something like this in a data set in SQL
Declare @.a varchar(1000)
Select @.a = ''
select @.a =@.A + ISNULL(NAME + ', ','') FROM Production.Product
Select @.a as myList
You'd need to take off the last , ...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jason.pileski@.pacourts.us" wrote:
> I have an existing Crystal report that contains a subreport which lists
> items across the page rather than down. The subreport has a Header and
> Detail section, which are both supressed, and a footer section that is
> visible. In the Header section, a field is defined with the following
> expression:
> WhilePrintingRecords;
> global stringvar strItems;
> strItems :=""
> The Detail section has a field defined with the following expression:
> WhilePrintingRecords;
> global stringvar strItems;
> strItems := strItems + ToText({uspGetItems;1.ItemID}, 0, "") + ", "
> The Footer section has a field defined with the following expression:
> WhilePrintingRecords;
> global stringvar strItems;
> If Len(strItems) > 1 Then
> strItems := Left(strItems, Len(strItems) - 2)
> Is there a way to do this in a SQL report?
> Any feedback would be appreciated.
> Thanks.
>