Crystal Report Query design

10-11  Source: Network gathering  Views:0 

Advertisement
Hello,
I am very new to Crystal Reports and for some reason the online content for CR is abysmally low and not lucid enough in most cases.
I am designing a simple Invoice type report in CR and am using an Access database with .accdb extension.I have been able to connect the database to my CR environment but now I am not able to design a suitable Query in CR which can enable me to display the
Invoice.
I have two tables in my database-InvoiceTran and InvoiceDetail.The InvoiceTran table has a primary key under which the details are saved in the InvoiceDetail table.
What I want to be able to do in CR is to select an Invoice Number in the InvoiceTran table and then print only the related details from the InvoiceDetail table(in the Detail section of CR) along with some other fields from the InvoiceTran table.I will also
need a SUM field in the Invoice Footer.
It was very easy in Access reports in which a suitably designed query did the trick but for now I had to abandon it due to a designing problem that I ran into.
Thanks in advance,
Khalid.
You're not finding online content here because CR is (as of VS 2010) no longer part of Visual Studio as delivered. It is a separate add-on.
The forum where you're most likely to fin help with CR in VS is here:
http://scn.sap.com/community/crystal-reports-for-visual-studio/content?filterID=contentstatus%5bpublished%5d~objecttype~objecttype%5bthread%5d
Related articles
  • Crystal Report Query design 10-11

    Hello, I am very new to Crystal Reports and for some reason the online content for CR is abysmally low and not lucid enough in most cases. I am designing a simple Invoice type report in CR and am using an Access database with .accdb extension.I have

  • Partial payment Crystal report query 10-11

    Hi, I have partial payment in outgoing. So I am not able capture this thing correctly so any one can give me the Crystal report query for this thing. Regards SwapnilTry this may it will help you .. in this query i have tracked againest PO. SELECT    

  • Crystal Reports ActiveX Designer Failed to open document 11-30

    Yesterday I created a report in Visual Studio 2008 with about 20 subreports, each subreport containing a single aggregate query (i.e count or sum). I then saved the report file. Hours later when I attempted to reopen the report in Visual Studio I rec

  • Seagate Crystal Reports ActiveX Designer error '80043ac4' 10-11

    Website slows down when users are running reports. Users start getting errors when running any crystal report. After sometime main page itself stops loading and only static html is visible. Following is one of the errors users see: Seagate Crystal Re

  • Crystal Report query on top of BI Query : Exception raised in infoview 11-30

    Hi experts, I have created a crystal report query on ntop of a BI query and exported to BO.   - For the BI query without variable, the crystal report runs with success in infoview and Crystal report   -For the same BI query with a  variable, the crys

  • Crystal Reports ActiveX Designer Design and Runtime Library 11.0 11-30

    Hi to all,            I want to design the CR at runtime because depending upon the situation the SProcs return 20 or 30 or 40 columns. so am using Crystal Reports ActiveX Designer Design and Runtime Library 11.0 COM component. but i dont know how to

  • Crystal Reports ActiveX Designer Design and Runtime Library 11.5 11-30

    Hai to all,             I'm new in crystal report 11.5, my task is desig time i just create a blank report during runtime programaticaly create Fieldobject,Blob object and so on, i came to know this is the right (Crystal Reports ActiveX Designer Desi

  • Error from the seagate Crystal Reports ActiveX Designer 11-30

    Hi guys, I get the following message when I running a report application based on Web. The Message is as following: The Error Message was Error detected by database DLL from Seagate Crystal Reports ActiveX Designer Internet Explorer has encountered a

  • How to read Crystal Report file Design version programmatically 10-11

    Hi, I am working on a project where I need the read Crystal file header and extract information that which designer was used to create the (Crystal) report. This will help me do some specific task if the version of the crystal used is very old (say o

  • Crystal Report Query 10-11

    How will i implement a query like this in Crystal Report?. select * from a where a.id not exist (select b.id from b where a.id = b.id)Enter the statement in the designer, or write a stored procedure that performs the query and reference that in the d

  • Sale Order Query Print layout/Crystal Report Query required 10-11

    Hi Experts, I created a Sale Order. Items included in it are service and material. (I created a BOM, bound the child material item to the parent service item. Moreover child item will have unit price where as parent item will not have unit price) I n

  • HTML View Error in Crystal Report 2008 Designer 10-11

    Hi,    I am getting an Error when i am trying to see the HTML Preview on the Crystal Report Designer. but, It is working Properly From CMC. I was getting the following Error. "Failed to access the HTML Server Page Contact your system administrator an

  • How to parse crystal report query prompt value via url parameters 10-11

    HI All, I am creating a employee detail report in crystal report. The recordset is huge and i have created a parameter prompts in the query and thinking to parse the prompt value via url parameters. Not sure why i still could not make it works. for e

  • Crystal Report Query taking too much time 10-11

    Hi, We are developing one report based on SQL Server 2008 in Crystal Report. There are around 50,000 valid combination in database. Based on dynamic filter we need to bring few records in report. Since these filters are at report level, and crystal r

  • BEx Report / query designer 11-30

    Hi, I have created a query BEx Query designer.  how can i see that output in the report. how Query designer and report designer are relatedd? Sri Edited by: Sridhar Shankaran on Jul 14, 2010 9:29 AM Please search the forum Edited by: Pravender on Jul

  • Hiding hierarchy level in Report (Query Designer) 11-30

    Hallo Experts, I am working on a hierarchy structure. I use the activate Hierarchy Display in the Query Designer. I try to expand my query till level "2". But I actually want only the 2 level report and the 1st level should be hidden. Can anyone

  • How to use a Crystal Reports Query as datasourc in an other Cristal Report 10-11

    Hi I would like to read a File in a CR Report, change some data and use the output as datasource  in an other Criystal Reports Report. Is ist possible to use a Crystal Reports Report as datasource for an other Crystal Reports Report? Thomas Edited by

  • Optional Parameter in Crystal Report XI designer 10-11

    Hi, Is there a way to have parameter as optional in Crystal Reports XI ? I am okay to have the parameter shown but I dont want it to be mandatory.In CR XI the only way to make a parameter optional is to assign it a default value. For example: If it i

  • Crystal Report Query Advice 11-30

    Dear Guru,      Please find below, two queries which I have to show simultaneously in Crystal Reports. Showing Sales and Incoming of the said month. Incoming are irrespective invoice (i.e. invoice from previous months as long as the Incoming is in th

  • Two problmes between  Crystal Reports 2008 and Bex Query 10-11

    Hi Gurus. I have two problems with Crystal Reports 2008 when It obtains data from a Bex Query (SAP MDX query connection). 1)     I have defined some Parameters Fields using the follow options: Type: String List of Values: Dynamic Value Options Level1