Crystal V9 Range selection

Hi all,

I have installed SP3. whilst in the development environment, I have created a simple report that just lists everything from a single table. This works fine.

I then introduced a range parameter on one of my fields. then go to preview and enter a valid range, but the results still show all records???

Cant believe this is a enuine bug, as it's pretty fundemental. What am I doing wrong?What datatype it is? I tried with date range. It works fine.|||the field type is a character string and the database is an Access 2000 one.

The values are 2 characters like:

LA LB LC LD LE ......and so on.

when I enter a start of LB and and end LD for instane, it returns All|||check ur selection formula.|||I have now removed all parameter fields and will walk you through what I am doing.

I have the field explorer open and have right clicked on the parameter fields and selected new.

this displays a create parameter field dialog box I then enter a value in the name and propting text values leaving value type as string. I change options to range values then press the button set default values. I ensure that the table is correct and then set the browse field with the column from the table that I want to filter on. Then in the left hand pane it displays all values relating to that column. I press the >> button to make all values the default I then set the order to alphabetical ascending i then press ok. it goes back to the previous dialog and I leave allow editing of default values checked and press ok.

My parameter field now exists in the field explorer window under parameters. I drag this to the report header, and press preview I'm them prompted for a start and end of range which I enter, I then press ok, and then I'm returned all values.

???:confused:|||Everythings looks correct.

The last step is, you have to write the record selection formula.

Goto Report menu, select "SelectFourmula" and then "Record..."

This will opens the edit formula window.

Here select your database field and then give in condition which will be suitable for range values and then select ur parameter field.
This looks like

{table.column} in {?parameter}

now save and close this.

Refrsh the report|||Ah....thx the manual doesn't mention the last bit. It works now.

Crystal Reports Version Selection

I have ten users who need to access a single server operating crystal. Currently looking at around 200 reports max being generated (not per day). I was wondering what the latest version available to me would be suitable which can manage atleast 10 concurrently. Also does MSDE come with it and is it sufficient to handle this small solution. Have searched the net but not exactly sure what Im looking for.

CheersSearch here
http://support.businessobjects.com/

Crystal reports across multiple pages

Using crystal reports, I want to display many fields from the database. All the fields does not fit in single page, even with maximum page length. If I have some 30 fields, is it possible to display first 20 fields in page 1 and remaining fields in page 2? And continue the same in page 3/4, 5/6 etc? :confused:Yes. You can format the page layout to do so. Add the 20 fields in page one. Add a New section (i.e. page) then add the remaining 10 fields.

Hope This helps,
Vinny P|||Thanks for the response. :wave:
But, while adding the section, I could not see any option to add the page. There are options to add report header, page header, group header, footers etc, but not for adding the page itself. :confused:
Can you make it more clear?|||I think what shashidharkr had in mind was being able to display very wide reports, one data row on the line, spanning multiple pages horizontally. The answer is "no". You cannot create wider reports than your printer driver supports. This is one of the most annoying limitations of the Crystal Reports. If your printer driver supports A2 landscape, you are lucky, but when displaying and printing this report on another machine or printer, the report will be truncated to whatever other printer driver supports.

The only exception is the crosstab object that can span itself to multiple pages. So there is a tricky workaround to use a hidden crosstab to span a usual report:
http://support.businessobjects.com/library/kbase/articles/c2014205.asp
But it comes with severe limitations (only first page will be spanned, the export to excel will be ruined etc).

For myself, I choose A3-landscape for wide reports. A3 is supported by most printer drivers. For extra-wide reports, I use A2-landscape. On client machine, the report gets truncated on the screen but export to excel will still export all fields.|||wapper,
You got my problem right! ;)

It is really surprising to know that crystal report has such a serious limitation. :o I need to create wide report, which spans across more than one page and thousands of rows of data. Even the workaround suggested by you may not be of much help, as I have many rows of data.

I think it makes no sense to limit the report width based on the paper sizes! If the report is wider, it should span to next page. I understand other reporting tools like cognos has such feature.

Any clue, if crystal report is going to fix this in future releases atleast? I hope this is in Seagate's agends. However, if we want to voice our concern, where can this be raised?|||I think it makes no sense to limit the report width based on the paper sizes! If the report is wider, it should span to next page. I understand other reporting tools like cognos has such feature.

The problem is, Crystal uses windows forms to compose the layout of the report. Forms are related to printer driver. You can experiment with creating custom forms (Control panel-Printers-File-Server properties-Forms) but custom forms are for one computer only, and IIRC there was also a limitation that you cannot create larger forms than some value, can't remember what exactly the limit was.

Any clue, if crystal report is going to fix this in future releases atleast? I hope this is in Seagate's agends. However, if we want to voice our concern, where can this be raised?

If you find such place, please let me know :) I got toooons of stuff to complain about Crystal.|||wapper
Thanks again for the response.

You can experiment with ....
Unfortunately, I can't spend more time on this :) . I have to look for some feasible workarounds. :ehh: I strongly feel that Seagate should resolve this problem. Being widely used report tool, such a major drawback should be addressed immediately. :rolleyes: Still I can't digest that Crystal imposes such a serious limitation on it's users! :(

Just to draw analogy, page width should be independent of paper size as in excel. Irrespective of the width, if paper width is less, excel prints in next page.

I got toooons of stuff to complain about Crystal.
Can the moderators or any others help on this?|||This problem has always been around and it is still not fixed in CR XI. Guess it is some kind of fundamental feature that can't be changed easily. Of course Crystal guys are aware of it because people have been crying for ages but still no solution, only workarounds.

You can try different support options in their web if you want to yell at someone. BTW there is also bunch of forums there. I don't know if those are actually monitored by Crystal.sql

crystal reports 10 incompatibility with single quotes in SP

My SP has this code but apparently Crystal Reports doesn't know how to
interpret the quotes in @.query:
fetch next from c2 into @.person_Id, @.full_name, @.charge, @.encounters_id
while @.@.FETCH_STATUS = 0
begin
select @.query = 'insert into #results_table ' +
'select ''' + @.person_ID + ''',''' + @.full_name + ''',''' +
cast(@.charge as varchar(10)) + ''', sum(paidAmt),sum(adjustedAmt), 0, 0' +
' from PAYMENTLINEITEMS where encounterID in ' + @.encounters_id
exec (@.query)
fetch next from c2 into @.person_Id, @.full_name, @.charge, @.encounters_id
end
For some reason, I can't see the fields on the crystal report if I use this
code (excluding the Fetch in the loop). When I comment this, then I can see
them. The reason I'm using it is because I can't use @.encounters_id (
consists of '(12,14,15)' ) in the regular Insert. So I need to do it like
this.
Any help is appreciated.This code is part of a stored procedure in SQL Server, right?
I know Crystal does some strange (and annoying) things with how it views
database objects, but I can't see how it would have any knowledge of this
piece of code. Crystal, as far as I know, only sees the data structure(s)
that your query returns and should be unaffected by this.
Have you confirmed that the stored procedure itself is able to execute by
running it in query analyzer?
"VMI" <vonchi_m AT yahoo DOT com> wrote in message
news:%23l6htoQVGHA.5288@.TK2MSFTNGP14.phx.gbl...
> My SP has this code but apparently Crystal Reports doesn't know how to
> interpret the quotes in @.query:
> fetch next from c2 into @.person_Id, @.full_name, @.charge, @.encounters_id
> while @.@.FETCH_STATUS = 0
> begin
> select @.query = 'insert into #results_table ' +
> 'select ''' + @.person_ID + ''',''' + @.full_name + ''',''' +
> cast(@.charge as varchar(10)) + ''', sum(paidAmt),sum(adjustedAmt), 0, 0' +
> ' from PAYMENTLINEITEMS where encounterID in ' + @.encounters_id
> exec (@.query)
> fetch next from c2 into @.person_Id, @.full_name, @.charge,
@.encounters_id
> end
> For some reason, I can't see the fields on the crystal report if I use
this
> code (excluding the Fetch in the loop). When I comment this, then I can
see
> them. The reason I'm using it is because I can't use @.encounters_id (
> consists of '(12,14,15)' ) in the regular Insert. So I need to do it like
> this.
> Any help is appreciated.
>|||Yes, the code is part of a stored procedure.
I do get a resultset when I run it, but I did notice now that the "Query
batch completed with errors." I had seen it before and I went through all
the messages and never saw any red text. I assumed that if I saw the result
set of the last Select statement, everything was fine. The problem was that
set nocount was off. I switched it to On and now I can see clearly that the
procedure found errors with the data being processed.
thanks again.
"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:%23R8aftQVGHA.4952@.TK2MSFTNGP09.phx.gbl...
> This code is part of a stored procedure in SQL Server, right?
> I know Crystal does some strange (and annoying) things with how it views
> database objects, but I can't see how it would have any knowledge of this
> piece of code. Crystal, as far as I know, only sees the data structure(s)
> that your query returns and should be unaffected by this.
> Have you confirmed that the stored procedure itself is able to execute by
> running it in query analyzer?
> "VMI" <vonchi_m AT yahoo DOT com> wrote in message
> news:%23l6htoQVGHA.5288@.TK2MSFTNGP14.phx.gbl...
> @.encounters_id
> this
> see
>|||The problem was the last names with quotes (O'neill, O'Sullivan, etc...)
Thanks for the help.
"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:%23R8aftQVGHA.4952@.TK2MSFTNGP09.phx.gbl...
> This code is part of a stored procedure in SQL Server, right?
> I know Crystal does some strange (and annoying) things with how it views
> database objects, but I can't see how it would have any knowledge of this
> piece of code. Crystal, as far as I know, only sees the data structure(s)
> that your query returns and should be unaffected by this.
> Have you confirmed that the stored procedure itself is able to execute by
> running it in query analyzer?
> "VMI" <vonchi_m AT yahoo DOT com> wrote in message
> news:%23l6htoQVGHA.5288@.TK2MSFTNGP14.phx.gbl...
> @.encounters_id
> this
> see
>|||VMI (vonchi_m AT yahoo DOT com) writes:
> My SP has this code but apparently Crystal Reports doesn't know how to
> interpret the quotes in @.query:
> fetch next from c2 into @.person_Id, @.full_name, @.charge, @.encounters_id
> while @.@.FETCH_STATUS = 0
> begin
> select @.query = 'insert into #results_table ' +
> 'select ''' + @.person_ID + ''',''' + @.full_name + ''',''' +
> cast(@.charge as varchar(10)) + ''', sum(paidAmt),sum(adjustedAmt), 0, 0' +
> ' from PAYMENTLINEITEMS where encounterID in ' + @.encounters_id
> exec (@.query)
> fetch next from c2 into @.person_Id, @.full_name, @.charge, >
@.encounters_id
> end
> For some reason, I can't see the fields on the crystal report if I use
> this code (excluding the Fetch in the loop). When I comment this, then I
> can see them. The reason I'm using it is because I can't use
> @.encounters_id ( consists of '(12,14,15)' ) in the regular Insert. So I
> need to do it like this.
No you don't! There is no need to use EXEC to handle comma-separated
list. Use a table-valued function that unpacks the list to a table.
The you don't need the dynamic SQL, and don't have to worry about
O'Neill.
See http://www.sommarskog.se/arrays-in-...ist-of-integers
for an example.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx