Search results for query: *

I have created a report with multiple data fields, no category fields or series fields. THe data fields are sums and distinct counts. I would like the y axis titles to be the names form the data fields. I am using SQL 2008 as a backend and BIDS to do the report. If i was in Crystal doing this...

that is awesome, make sense. If i made another column tbl_financePeriods.dtm_financePeriodEnd it should work if i do this? Select tbl_financePeriods.dtm_FinancePeriod, Sum(tbl_hrs.int_hrs) As TotalHours From tbl_hrs Inner Join tbl_financePeriods On...

How do i join the two tables and not lose some of the tbl_hrs values that don't exactly match the finance periods?

I am using SQL 2008 and am new to it. I want to group a table tbl_hrs which has two fields: dtm_tcdate and int_hrs However i want to group by financial periods (13 per yr). I was thinking the easiest long term solution would be to create another table: tbl_fincanceperiods that held these dates...

I have built an Access 2010 database with the data in a SQL Server (2008) called WH. It will be used for a project that is phased in over time. There is a main form (frm_Check_Incidents) that pulls in data from another SQL server (Brown) with a list of incidents. The users are going to phase...

Awesome Duane, it worked! I learned something today!

Access did all the alias work for me. I made sure the alias's were the same as in the relationship window. I did join by the right field. I am using linked tables? What is a linked view, sorry for my ignorance but what/how?

I have a report i am creating useing Access 2010 and my data is on a SQL 2008 R2 backend. The main table for the report tbl_CB_or_CA has multiple lookups in it, they are: CB_or_CA_Method_ID CB_or_CA_Source_ID CB_or_CA_Target_ID These are the IDs that link to the field LookupID in another table...

It worked! Thanks! You rock! I had to use this format =[CB_or_CA_Method_Combo].[Column](1)

Thanks again MaZeWorX, our network just went down and so i will check it later. Makes sense to me.

Thanks MazeWorX So in my case I would put Forms![MyForm]![CB_or_CA_Method_Combo] Do i need a (0) here so the calculated field can pull the right value from the combo (like "phone","email") not the IDs (like 1-4)?

I have a subform where the last field is a concatenated combination of all the fields so the user can copy all of it to paste it into another db (only possible solution). I am using Access 2010, the data is on a SQL 2008 back end. I have been able to concatenate the fields except the combos...

Thanks. i may have neglected to mention the report needs to be self sufficient, I don't want to have to import it into access every night manually. If the report will need to use an odbc connection doesn't the CMS of Crystal Enterprise need the same ODBC connection as i need the report to run in...

I am using Crystal Reports 2008, and i have a report that i need export its results and then pull those results into another report. Normally i would just use a subreport but i have so much data that i need to export the results and pull them in so its not too slow. I will be using crystal...

I see that Ken Hamady replied to a similar post i did with the answer: To do this in XI you would need to use a SQL Command that returned two columns like this: Facility / Facility A Facility / Facility B Department / Department A Department / Department B Then you only need two parameters, the...

Would it still be okay if each column lined up so for example the Vehicle names were in the column, and then Depot Name, Client NameX etc? if so can't you use a table to do this?

It may be your margins, i would try shrinking the vertical size too much and see if it all stays on one page. If it does then you know you just need to tweak the height.

You could also create a formula that is a combination of the name and department and then group by that formula.

Can you give some examples of the groups/sorts in the report? Can you make your sort into a group and move it up the levels of groups?

What version of Crystal are you using. Could it be the margins? If your margins are too big it won't fit.