Hi. I created a query using a TRANSFORM statement that shows me the data I want to use. Now I am trying to use the results of this query in an Access report but the data in the PIVOT field "Quad" is not always the same. Since the values in the field QUAD become the field names for the report...

I am trying to create a 2nd Invoice Report in Dynamics CRM 4.0, Professional Edition running on SQL Server 2005 Standard Edition with SQL Server Reporting Services. The reason for having multiple Invoice forms rather than just modifying the original invoice is that our company is merging with another...

How can I create the HTML report using html tags on the Vb.Net application I really appriciate any sample code Thanks

I need help with transposing a table in MS Access 2003 - for a report. See attached file showing what I want the table to look like and the table format in Access. I want to change the rows (records) to be the column headers and the columns (fields) to be the rows. I have some vb experience, by sql is...

Hello experts! I've been asked to alter a database so that the client has a report which graphs the sales of several products (3 to be precise) by week. I have managed to create a crosstab qurey which shows the products down the left hand side and months across the column heads but: A can't display...

Hello Friends, In crystal subreport i'm grouping the data's in three categories. for eg: 1.City, 2.State, 3.Country. in these categories i'm displaying the data's the each category should be displayed in the new page so in section expert i choose the option New Page after. it's working...

How do I configure printers for reports for windows. The majority of the reports are through an HPLaser Jet 4 which is fine and they all work ...no problems. The problems arise for two reports that are printed using a tractor feed dot-matrix printer over a LAN file sharing network. The first report is...

I dont know how to do this : 1.Click PrintPreview button from form1 and form2 crystal report take it as parameter and show report print preview status. 2.Click Print button from form1 and straight away pop up page setup/printer select dialog box.

Hi All, We are trying to use crystal reports that is available in .Net 2.0 and we are new to crystal reports. Is it possible to create Charts/Graphs dynamically on click of a button. That is, we have report that is shown based on some filter criteria. Now on click of a button, we need to use the data...

Hi, I have successfully used the greenbar formatting VBA function to alternate detail rows. Now I have a requirement to replicate this when there is a group header present. I would like to have the group header and the detail records for that group to be shaded. Then the next group header and detail...