Search results for query: *

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

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

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

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

CRXI - Having trouble using this Formula box. I can't find any documentation on this topic. I would like to base my sort order on two different criteria. But I'm not able to include Report Fields or current formulas.

Using CR XI. I have a Group 1 Header I want to suppress based on the results displayed in the Group 1 Footer. I return a value in the footer, if this value is greater than zero I want to display the group information. I have sub groups GH2 that is breaking up my information that I wish to...

CR XI - I have a Cross Tabs fields I wish to label base on nulls or a value. I'n not able to come up with the correct statement. I keep rounding up, for example 0.125 returns 0.130, .075 returns .080. Current formula: if isnull ({VW_RPT_10659_UNION.GOLDSTAR_DIFF_AMT}) then 'Non - Goldstar' else...

I keep getting returns from TLE ??? I also tried NOT IN WHERE M.MTG_SK_SEQ = MP.MTG_SK_SEQ AND M.LENDER_SK_SEQ = L.LENDER_SK_SEQ AND M.LENDER_SK_SEQ = L2.LENDER_SK_SEQ AND L.LENDER_SK_SEQ =LO.LENDER_SK_SEQ AND LO.LENDER_SK_SEQ = LA.LENDER_SK_SEQ AND L.EXP_DATE IS NULL AND...

Crystal XI: I have a view in which I return nulls with 'N' NVL(L.RETAIL_WHLSALE_TYPE,'N') BUS_CHAN. Works great returns information I want. I can not get nulls 'N' to pull up in my report. Using this (If {?Bus Chan} = "*" then {VW_RPT_p142.BUS_CHAN} = {VW_RPT_p142.BUS_CHAN} else...

I would like to display a date range in my report that the user has selected in the parameter to begin the report. Example: {VW_BROKER_CLOSING_MASTER.DISBURSEMENT_DATE} in {?Disbursement Date} User selects April 1, 2007 - May 31,2007 for the range. Those dates are what I want to show. If I set...

Can I save a field that will return 1mg of information to a file? This report could bring back 50 rows and I would like to save each separate field instance. Example: table.name, table.address, table.lotainfo table.name, table.address, table.lotainfo table.name, table.address, table.lotainfo...

This place uses a lot of stored functions. I want to make an a new report but have a different date range than what the original view pulls in from a existing stored function on dates. Instead of making a new stored function is there a way to use the existing function but limit it return for...

I'm bringing a subreport numbervar and using it in a main report formula. It works fine, I haveing trouble clearing and refiguring for the next group below. I have add section(s) below to clear formula but I can't to get the proper solution for the next group. SubReport: whileprintingrecords...