Recent content by jrcol12357

Thank you for that response. I have done just that in other reports. Usally in upper left I will include a OnDemand subreport to display all details. I was just hoping that maybe in this version (2008) this have could have been added.

Version 2008, Is there a way to drill down all of a report? I have a report with many groups showing only totals of different columns. Currently the user will need to select each group and drilldown for the detail information of each group, or run another report that shows all the details. I'm...

CR XI, I have a report that includes 127 columns and is to be setup as excel data only export. I'm getting my data from two different data sources in which I'm not allowed to access with one view. So I have joined the two views together by an id number (outer join) in Crystal. My performance on...

Using CR XI. I have some reports that are using a font size of 6 due to the number of columns required for a report. The paper size is Legal and orientation is landscape. When the report runs and viewed in BO viewer, it displays as expected at 100%. The users are required to change to 150% or...

Using CR XI. I have some reports that are using a font size of 6 due to the number of columns required for a report. The paper size is Legal and orientation is landscape. When the report runs and viewed in BO viewer, it displays as expected at 100%. The users are required to change to 150% or...

CR XI, I can't find any information on error messages. A list of error messages and what they mean would be a nice to have. The message is like "Database Vendor Code: <vendor code number" Looking at the CRXI User guide I see no information or searching the web. Can anyone lead me in the right...

Thank you for the information. I have been using CR since version 8?(long time). And have not seen this done.

Using CR XI. I would like to have the ability to keep my grouping visible as a user progress's through a report. Normally with multiple groups when a lower group is select one looses the previous and current groups. This is what I would like to appear. Example; GH1 Divisional Mgr sum...

CRXI: I have created a Sort Parameter for four columns and a default parameter value. When I open this report it ask for a parameter even though the default value is in the prompt. How can I open this report and run without this prompt? I would like the user to first see the results before...

Thank you, I'll try it out

CR XI, I need to layout a report that will have multiple fees and fee names. My customer wishes to display the information horizontally. Each record would bring back a different amount of names and fees. Example 1st loan may have 5 fees and 5 fee names, the next loan could have 10 fees and 10...

I found this works best in giving a 4th quarter date range for the previous year. if currentdate in Calendar1stQtr then {VW_RPT_P688_UNION_d.DISBURSEMENT_DATE} in (dateadd("m", -3, ((date(year(currentdate), month(currentdate),01)-1)))+2 to dateadd("m", -1, ((date(year(currentdate)...

Thank you, will give it a shot.

Using CRXI I wish to report on the previous quarter. How do I handle the 4th quarter of last year when the report is run in 1st quarter of the new year? I belive what I have will not look at the previous calendar 4th quarter. if currentdate in Calendar1stQtr then...

To pull in your view select Database/ Set Database Location/ Create New Connection Make your connection (server, user, password) choose View Folder select the view required. ex VW_RPT_TestData. Your report will now have the data from the view. You can still do all the other requirements you...