Search results

Ok Okay ..I will upload the chart ..currently I am now caught up in other works hence I will upload in 1 hour

T Thank you so much

Hi ..I have attached my database.

Ohh ...Thank you ..Now I got it :) .

Hi , The issue I asked there is completely different , it was about rounding of the data label's value (actual : 13.07456234% , needed : 13.1%) The issue I have asked here is how to make combo chart - 1 clustered bar for inspected qty & 1 line graph (line graph should show the percentage...

I live in India & I just came to office , opened the website to see my posts & Whoa!!! Anyway ….Honestly I didn't quite got the joke and for sure I will use correct grammar in my next posts :).

Dear all , I have made a line chart in my report & the values are in percentage , I have rounded the decimal point in my query(source data for chart) But still the chart is showing all the digits , please help me solve this .(to round off to only 1 decimal).

Thank you sir .It is solved

I have created a button to my report to send a mail by attaching the report in pdf format .it was working good .but all of a sudden it is showing this error? does anyone help me solve this? Error message : Cannot find object 'l1'. Arguments:3, Day wise Summary type wise, PDFFormat(*.pdf)...

SQL: SELECT DISTINCTROW [Master Table].[Date of Entry], Sum([Master Table].[Inspected Qty]) AS [Sum Of Inspected Qty], Sum([Master Table].[Rework Qty]) AS [Sum Of Rework Qty], Count(*) AS [Count Of Master Table] FROM [Master Table] GROUP BY [Master Table].[Date of Entry];

Thank you for your help ..I have now made the query with months as grouping ...could you please advice me on the chart issue also??(I have attached the database)

Happy birthday to you...

Can anyone please help me in this regard?

Dear all , I have a table which has the data of daily rework qty of 5 different categories(types) , I need two modifications to complete this so please help me: 1. I have a query which summarizes the data day wise , but I need an extra query which summarizes the same in month wise.(month by...

Thank you sir. I will note the tip & use the same in next projects.

Sir ..sorry I forgot to add the formula ..here it is =[Sum Of Rework Qty]/[Sum Of Inspected Qty]

Dear all , I have made a report in which to check the percentage I have entered a formula , hence if there is 0 in both the fields obviously the formula is giving #Num! error. Is there any way to replace this with 0 whenever this error occurs??

Hello sir thank you. I Will try & let you know the result.

Hello sir , I am very sorry , I was not in town hence I couldn't answer to your questions. My requirement is like this : While entering kaizen details I give unique names to it for index purpose like for production department it would be PRD-01 , PRD-02 and for calibration department CD-01,CD-02...

Yes Sir it is exactly as you described...