crystal report -sorting issue

I am new to crystal reporting
Ii have an existing report with Job Numbers, Job Description and Total fields, The report works fine with the right sorting and groping in the Crystal report viewer.
But once loaded in the ASP page it stops sorting and grouping in the asp page - companys brower page.
Any suggestions on what must have gone wrong.
Thanks in advance

SandyTry checking in the
Menu File / Options / Database tab / Perrform Grouping On Server|||Hi Sandy, saw a very similar post somewhere else, this sounds odd, if it sorts correctly in CR, it should sort in ASP the same, you may want to have a web person check to make sure something is not sorting your report once it gets to the page. Sorry I am not much help...|||Try checking in the
Menu File / Options / Database tab / Perrform Grouping On Server

hi

done the changes-- but how would it reflect in my asp page

thanks

sandy|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.

what amount sub reports there're in your main report?
what amount records show your report?|||are you playing with SQLQueryString property?
or modifying 'Order By' statement in asp.

what amount sub reports there're in your main report?
what amount records show your report?

NO there is no subreports in my report - its a simple report - with fields like job, description and amount. - with a total and a grand total in the end. the report is coming to from the viewer though an asp page. Its sorted in the
report but when it has sort in the asp page ... it refuses to do the same. but when i click on the job field it sorts by descending and with one more click to goes to ascending. Now i want a default ascending as in the report.
I am a newbie in asp..
If you can please help

sandy

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.
>